Am Freitag, 12. Februar 2016, 16:29:53 CET schrieb ellanios82:
Did you check if any of the cells in the range used (E9:E864 and J9:J864) possibly contain a formula that returns a #VALUE error?
- thanks : do not believe so :
am using similar to
=SUM($E$9:E864)-SUM($J$9:J864)
on many household accounts pages , to keep running balance for groceries , utility bills etcetera , and most pages are much shorter than row 864 , and , guess it must be a LibreOffice thing , for the reason that OpenOffice works OK and has no problem keeping 'running account balance' when opening the very same spreadsheet which LibreOffice cannot handle.
I agree that it looks like LO Calc does handle something differently than OO Calc. However, it is most likely not the formula you sent, but rather located in the data it is trying to sum up. First thing i would do to narrow it down would be to try what the result is for the part formulas =SUM($E$9:E864) and =SUM($J$9:J864) To see if the issue is in the E column, in the J column, or if both sums by themselves provide proper numbers, and only the subtraction goes berserk (that would be a very interesting case then, of course). And then: this is not about belief, but about checking if the cells which are to be summed up really contain proper data - all 1732 of them. Best regards, Andreas -- Time flies like an arrow. Fruit flies like a banana. -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org