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