More on my erroneous spreadsheet. I see what's going on, if not why.
I've removed rows and columns, so my spreadsheet is now
A1: blank
B1: 33520
C1 =sum(a1:b1)
Looking in the content.xml file, cell C1 contains the following:
table:formula="of:=SUM([.A1:.B1])" office:value-type="flo
On 10/07/15 08:18, Cley Faye wrote:
This is looking like an issue that will not be found easily. Simply
opening your file, the result is correct: D5 initially show 33520.
Out of curiosity, I tried opening it in gnumeric, same result. Only
google drive *preview* show the 0 in D5. Interestingly en
Do you have a sample file with this error?
Using an older version (4.4.1.2) I can't seem to reproduce this behavior.
--
Cley Faye
http://cleyfaye.net
2015-07-09 15:01 GMT+02:00 Mike Scott :
> An oddity that's popped up, but I can't repeat the effect in another
> spreadsheet.
>
> My spreadsheet
An oddity that's popped up, but I can't repeat the effect in another
spreadsheet.
My spreadsheet (freshly loaded) has 3 particular cells:
B5 completely empty
C5 33520
D5 =SUM(B5:C5)
D5 currently wrongly displays 0, and F9/recalculate doesn't change this.