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