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 <v...@scottsonline.org.uk>: > 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+unsubscr...@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 > -- To unsubscribe e-mail to: users+unsubscr...@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