On Sat, Feb 13, 2016 at 12:52 AM, ellanios82
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 ;-)
Might I add that this really deserves a LO bug report? https://wiki.documentfoundation.org/QA/BugReport Thanks, Robert
- 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
-- http://robert.muntea.nu/ -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org