Support Board
Date/Time: Mon, 13 Jan 2025 09:38:59 +0000
Spurious TRUEs in the New Spreadsheets version
View Count: 1010
| [2015-05-06 05:22:08] |
| Sawtooth - Posts: 4149 |
|
I am experiencing occasional spurious TRUEs in some cells where the formula clearly should produce FALSE. I can clear the bogus TRUE by entering that particular cell's edit mode, then clicking OK. I cannot clear the cell by Reload and Recalculate, nor Recalculate, nor unchecking/checking Auto-Calculate. It appears there is no recalc unless the edit mode is entered. The example cell is in row 96. This is the formula in that cell: =AC96>=MAX(AC97:INDIRECT("AC"+TEXT(ROW()+$H$15,"0"))) Please advise. |
| [2015-05-06 19:47:31] |
| |
|
We will look into this.
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 |
| [2015-05-06 23:26:43] |
| Jeffrey - Posts: 2194 |
|
This should be fixed in the next release.
|
| [2017-04-13 03:09:28] |
| Sawtooth - Posts: 4149 |
|
I am experiencing another case of spurious TRUEs. Cell M9 shows 1, but the Details do not show the same. There are other spurious TRUEs in L9, L11, M11. Please advise. |
Private File Private File |
| [2017-04-19 16:37:53] |
| Jeffrey - Posts: 2194 |
|
Since the issue does not occur when simply loading the static spreadsheet, it must be an issue that only occurs with a specific series of updates. Without knowing what those specific updates were, it's near impossible for us to track down the issue. If you are able to reliably repeat the issue by manually changing cell values, let us know the sequence of changes. Or if you can repeat the issue with a specific replay, we will need your chartbook, the data file for the chart being replayed, and the details of the replay. |
To post a message in this thread, you need to log in with your Sierra Chart account: