[opensuse-factory] TW LibreOffice Calc
Hello List TW LibreOffice Calc : with todays TW upgrade , the calc still cannot handle formula : =SUM($E$9:E864)-SUM($J$9:J864) ............ regards -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
On Fri, 2016-02-12 at 12:51 +0200, ellanios82 wrote:
Hello List
TW LibreOffice Calc : with todays TW upgrade , the calc still cannot handle formula :
=SUM($E$9:E864)-SUM($J$9:J864)
Did you report this as a proper bug yet or only here on the list? This list? If you reported it as a bug, the progress of it should be visible in the bug tracker. Cheers, Dominique -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Op vrijdag 12 februari 2016 12:51:51 CET schreef ellanios82:
Hello List
TW LibreOffice Calc : with todays TW upgrade , the calc still cannot handle formula :
=SUM($E$9:E864)-SUM($J$9:J864)
............
regards
With my locale ( in LO ) set to dutch, the formula results in a #NAAM! error. When I change the formula to dutch ( /SUM/SOM/) syntax, it works. When setting all language settings for LO to US English, the formula works. This on up to date TW. -- Gertjan Lettink, a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
On 02/12/2016 02:31 PM, Knurpht - Gertjan Lettink wrote:
Op vrijdag 12 februari 2016 12:51:51 CET schreef ellanios82:
Hello List
TW LibreOffice Calc : with todays TW upgrade , the calc still cannot handle formula :
=SUM($E$9:E864)-SUM($J$9:J864)
............
regards With my locale ( in LO ) set to dutch, the formula results in a #NAAM! error. When I change the formula to dutch ( /SUM/SOM/) syntax, it works. When setting all language settings for LO to US English, the formula works. This on up to date TW.
I get error shown as : #VALUE! - am not so lucky on my uptodate TW all language settings for LO to US English , still get error : have tried Locale Greece but still get#VALUE! & see warning : " Because the current formula separator settings conflict with the locale, the formula separators have been reset to their default values" btw OpenOffice works OK without #VALUE! complaints .......... regards -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Am Freitag, 12. Februar 2016, 15:06:26 CET schrieb ellanios82:
TW LibreOffice Calc : with todays TW upgrade ,
the calc still cannot handle formula :
=SUM($E$9:E864)-SUM($J$9:J864)
............
regards
With my locale ( in LO ) set to dutch, the formula results in a #NAAM! error. When I change the formula to dutch ( /SUM/SOM/) syntax, it works. When setting all language settings for LO to US English, the formula works. This on up to date TW.
I get error shown as : #VALUE!
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? -- 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
On 02/12/2016 04:14 PM, Andreas Mahel wrote:
TW LibreOffice Calc : with todays TW upgrade ,
the calc still cannot handle formula :
=SUM($E$9:E864)-SUM($J$9:J864)
............
regards
With my locale ( in LO ) set to dutch, the formula results in a #NAAM! error. When I change the formula to dutch ( /SUM/SOM/) syntax, it works. When setting all language settings for LO to US English, the formula works. This on up to date TW. I get error shown as : #VALUE! Did you check if any of the cells in the range used (E9:E864 and J9:J864)
Am Freitag, 12. Februar 2016, 15:06:26 CET schrieb ellanios82: 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. ....... thanks regards -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
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
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
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 ;-) -- Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch openSUSE Member, fsfe fellowship GPG KEY : D5C9B751C4653227 irc: tigerfoot -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
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
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
Op vrijdag 12 februari 2016 12:51:51 CET schreef ellanios82:
Hello List
TW LibreOffice Calc : with todays TW upgrade , the calc still cannot handle formula :
=SUM($E$9:E864)-SUM($J$9:J864)
............
regards What's more: if I set all LO settings to Greek, fill the E column and the J
column with numbers, then copy the exact formula to some place, it works as posted.
-- Gertjan Lettink, a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
On 02/12/2016 02:45 PM, Knurpht - Gertjan Lettink wrote:
Op vrijdag 12 februari 2016 12:51:51 CET schreef ellanios82:
Hello List
TW LibreOffice Calc : with todays TW upgrade , the calc still cannot handle formula :
=SUM($E$9:E864)-SUM($J$9:J864)
............
regards What's more: if I set all LO settings to Greek, fill the E column and the J
column with numbers, then copy the exact formula to some place, it works as posted.
........... hmm . . . ah . . . if i were so lucky [ but am not ] , but for me works OK with OpenOffice thanks regards -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
ellanios82 [12.02.2016 11:51]:
Hello List
TW LibreOffice Calc : with todays TW upgrade , the calc still cannot handle formula :
=SUM($E$9:E864)-SUM($J$9:J864)
............
regards
Hello ellanios82, I just switched to openSUSE Leap 42.1 (from openSUSE 13.2). I opened LO Calc, copied your formula to A1 and got "NAME?". So I checked (in Tools -> Options -> LibreOffice Calc -> Formula) the entry "Use English function names", and at once the "NAME?" changed to "0". I hope I have the menu entries named correctly, since I use German language, and those titles are my own translations ;) When entering some numbers in E and J column, the result was correct each time. So I can't subscribe to your "cannot handle", since for me the formula is handled well :) Regards, Werner --
On 02/12/2016 04:46 PM, Werner Flamme wrote:
ellanios82 [12.02.2016 11:51]:
Hello List
TW LibreOffice Calc : with todays TW upgrade , the calc still cannot handle formula :
=SUM($E$9:E864)-SUM($J$9:J864)
............
regards
Hello ellanios82,
I just switched to openSUSE Leap 42.1 (from openSUSE 13.2).
I opened LO Calc, copied your formula to A1 and got "NAME?". So I checked (in Tools -> Options -> LibreOffice Calc -> Formula) the entry "Use English function names", and at once the "NAME?" changed to "0". I hope I have the menu entries named correctly, since I use German language, and those titles are my own translations ;)
When entering some numbers in E and J column, the result was correct each time. So I can't subscribe to your "cannot handle", since for me the formula is handled well :)
Regards, Werner
......... Thanks Werner - have tried your kind suggestions , but for me , in TW am still getting #VALUE! error .......... regards -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
participants (7)
-
Andreas Mahel -
Bruno Friedmann -
Dominique Leuenberger / DimStar -
ellanios82 -
Knurpht - Gertjan Lettink -
Robert Munteanu -
Werner Flamme