Support Board
Date/Time: Sun, 19 Jan 2025 17:57:37 +0000
Spreadsheet Cell Details do not match Cell Contents
View Count: 674
| [2018-04-18 15:14:28] |
| ForgivingComputers.com - Posts: 987 |
|
Every once in a while, when debugging a spreadsheet, I get a result that doesn't make sense. Like an AND() function that returns a 1, when one of the operands is 0. Attached is a screen capture of cell AO7 with the formula =and(R7,AK7). (Before Close.JPG) Notice that cell AK7 is a 0 (as are all cells in column AK), so AO7 should also be 0. The Details agree, that yes, it is really 0, but the cell itself is a 1. The one is obviously incorrect, and if it is used in another formula, or as part of a color bar, for example, it is seen as a 1. If I save all and close and restart Sierra, the error goes away. See After Restart.jpg. All cells in Column A0 are 0 because column AK is all zeroes. Can anyone explain why? |
 Before Close.JPG / V - Attached On 2018-04-18 15:13:36 UTC - Size: 83.49 KB - 322 views After Restart.JPG / V - Attached On 2018-04-18 15:13:44 UTC - Size: 71.24 KB - 315 views |
| [2018-04-18 19:05:29] |
| |
|
This may already be fixed in the latest prerelease. It relates to the shifting of data in cells down as new rows are added and a problem where the cell is not getting recalculated in some cases.
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: 2018-04-18 19:05:38
|
| [2018-04-18 19:16:34] |
| Jeffrey - Posts: 2197 |
|
If you see this issue on version 1732 or later, we will require additional details.
|
To post a message in this thread, you need to log in with your Sierra Chart account: