[libreoffice-users] spreadsheet not calculating correctly

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.

Now, if I set B5 to 0, D5 changes to 33520 (at last correct!), and if I 
^Z to undo the change, D5 remains showing 33520. Likewise, changing C5 
makes D5 update correctly, or indeed if I retype the SUM() expression. 
(The only way of getting the wrong result back is to reload the 
spreadsheet from disk)

So, I have a spreadsheet showing a wrong calculation result. Thankfully, 
0 was a pretty obvious error.

Any thoughts?



(This is LO 4.4.4.3 on Mint 17)


The relevant row from the contents.xml file contains:

<table:table-row table:style-name="ro1"><table:table-cell 
table:number-columns-repeated="2"/><table:table-cell 
table:style-name="ce2" office:value-type="float" office:value="33520" 
calcext:value-type="float"><text:p>33520</text:p></table:table-cell><table:table-cell 
table:style-name="ce2" table:formula="of:=SUM([.B5:.C5])" 
office:value-type="float" office:value="0" 
calcext:value-type="float"><text:p>0</text:p></table:table-cell><table:table-cell 
table:number-columns-repeated="1020"/></table:table-row>



--
Mike Scott (unet2 <at> [deletethis] scottsonline.org.uk)
Harlow Essex England

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted