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 --