12 Feb
2016
12 Feb
'16
22:52
On 02/12/2016 10:55 PM, Bruno Friedmann wrote: > On vendredi, 12 février 2016 21.58:20 h CET ellanios82 wrote: >> 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 > It is and most of the time is linked to openCL (use of gpu for rendering and formula) > You can find this option now on 5.1.0 in tools -> options -> OpenCL > > Try to desactivate the two checkbox, and see if it works better. > Depending on the gpu and driver this settings have change radically results around me ;-) - Thank you Bruno , Thank you Bruno , Thank you Bruno!! Terrific :: That was it :: all Solved :: Wonderful ........ have a good weekend regards ellan -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org