12 Feb
2016
12 Feb
'16
19:58
On 02/12/2016 06:10 PM, Andreas Mahel wrote: > 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 - thank you Andreas , when i have some extra time i'll have a look-see - at first consideration , i feel that data & formula which have worked OK for years :: when a zypper upgrade a couple of weeks ago started to produce problems, and While OpenOffice works on the same data producing the complaint-free results that LibreOffice produced until a couple of weeks ago, then , i am inclined to the idea that it is the zypper upgrade that introduced the probs. Further : this happens with several spreadsheets : thus reinforcing suspicion that Data validity is not the basic suspect. - so , big deal , these are just my household accounts BUT , for some enterprise using LibreOffice for mission-critical work , such happenings could be alarming. ......... regards -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org