Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 01:34:01 +0000
#CREF! error
View Count: 1936
| [2017-10-11 17:49:31] |
| User29926 - Posts: 92 |
|
Perhaps SC spreadsheet do not fully support a cell reference back to itself? This formula sometimes returns a !CREF error in the $H$64 cell. =IF( AND( $H$90=0,ABS(($H$56 - $H$54)) <= $H$68, SUM(ID64.SG1@3:ID64.SG1@6)) , 1, IF( OR( $J$8 <> 0 , OR ($H$90= 1,OR ($H$62= 1, $E$3 < $H$36)) ) ,0 , IF(ISBLANK($H$64), 0 ,$H$64 ) )) SC docs says this" #CREF! Unable to complete calculation due to a reliance on a circular reference. A circular reference is what happens when a cell references another cell that references back to the first cell. A cell that references itself is not considered a circular reference." The $H$64 cell references itself, so why does IF(ISBLANK($H$64), 0 ,$H$64 ) return a #CREF! error?? |
| [2017-10-11 17:54:09] |
| |
|
We will see if there is any genuine problem here.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-10-11 18:07:07] |
| User29926 - Posts: 92 |
|
Thanks, for the quick attention.
|
| [2017-10-12 13:57:03] |
| User29926 - Posts: 92 |
|
We will see if there is any genuine problem here.
Any update on this issue?Development is halted because of the #CREF! error. |
| [2017-10-12 16:37:35] |
| |
|
No update. We do not know when it will be. It is not something we can get too quickly. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2017-10-12 16:37:51
|
| [2017-10-12 17:10:34] |
| User29926 - Posts: 92 |
|
No update. We do not know when it will be.
It is not something we can get too quickly. So, what is your working suggesting for a hack/workaround to maintaining a value in a cell until more then one condition could change its value? Locking and unlocking a cell, that allows more then one condition to unlock it. Is confirmed not to be possible. V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0 Allowing a cell to recalculate itself or recalculate another cell is not available. Spreadsheet recalulate Trying to maintain a persistent cell value until one of multiple conditions changes it,requiring a cell reference of itself currently does not work either(this support request itself). I`m all out of ideas of possible hacks/workarounds to get this development completed. |
| [2017-10-12 17:51:14] |
| Sawtooth - Posts: 3993 |
|
I use a double IF statement in a Formula Column, e.g. in cell P3: =IF(setcondition,1,IF(releasecondition,0,P4)) |
| [2017-10-12 17:59:30] |
| User29926 - Posts: 92 |
|
tomgilb, So, if I understand this correctly. Instead of doing this efficiently in one cell. Use two cells and one of those cells(P4) have a hard value in it and reference that cell to fake a persistent value for (P3)? Date Time Of Last Edit: 2017-10-12 18:01:21
|
| [2017-10-12 18:50:46] |
| User29926 - Posts: 92 |
|
I`m now getting #CREF! cell errors in cells that do not even reference themselves. I have included screen shots of the cell error and the formula in it. I`m using SC version 1621, I updated a few days ago. I have other cells that are also returning this error. I was not getting any errors in these simple formula cells before the update. SC Support could you investigate this? The #CREF! may be more deep the a cell self reference problem. |
 CREF-1.PNG / V - Attached On 2017-10-12 18:48:01 UTC - Size: 2.51 KB - 242 views CREF-2.PNG / V - Attached On 2017-10-12 18:48:12 UTC - Size: 2.38 KB - 257 views |
| [2017-10-12 19:01:37] |
| Jeffrey - Posts: 2098 |
|
If a cell references another cell that has an error in it, the first cell will show that same error. For example, both of these cells will display #CREF!: A1:=A2 A2:=#CREF! You can use the Details button at the upper-right of the spreadsheet window to see which reference in a formula evaluates to an error. See Viewing Formula Expression Tree for details. |
| [2017-10-12 19:36:16] |
| Jeffrey - Posts: 2098 |
|
Looking at the formula in your first post, the self-references back to $H$64 are probably not causing the issue. My guess is that one of the other cells referenced by that formula has an error value. You can confirm this by using the Details button mentioned in the previous post. You can double-click on cell references that have an error value in the details window to jump to the referenced cell, and you can repeat this for each cell you jump-to to trace the error back to its origin.
|
| [2017-10-12 19:51:34] |
| Sawtooth - Posts: 3993 |
|
tomgilb,
The persistent variable would be in row 3 so you'd reference row 3.So, if I understand this correctly. Instead of doing this efficiently in one cell. Use two cells and one of those cells(P4) have a hard value in it and reference that cell to fake a persistent value for (P3)? The first IF latches a value and brings it to row 3 (the current bar), unless it is released with the second IF. |
| [2017-10-19 12:01:03] |
| User29926 - Posts: 92 |
|
Sorry I forgot to post back. I just reverted back to version 1619 and the errors are gone. I will just stick with this version until I have free time to test out the latest version. |
To post a message in this thread, you need to log in with your Sierra Chart account: