Support Board

Date/Time: Sat, 04 May 2024 12:41:56 +0000

Post From: Spreadsheet Cell Details do not match Cell Contents

[2018-04-18 15:14:28] Link To Thread - Link To Post [Go To First Post]
bradh - Posts: 854
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 - 296 views After Restart.JPG / V - Attached On 2018-04-18 15:13:44 UTC - Size: 71.24 KB - 289 views