Debian Wheezy fresh install, LibreOffice 3.5.4.2
Please help!!
Say I want to add up cells A1, A2 and A3.
When I click the “Sum” formula button (when I’m in cell A4) I get this content:
=SUMIFNAA1:A3CHOOSE
With the result “#NAME?”
What’s happening? Thanks!
What do you get if you just type
“=sum(A1:A3)”
or
“=A1+A2+A3”
(without quotation marks) into cell A4?
I just tried with the very same old version in Debian Wheezy and didn’t have any problem. Make sure your hardware isn’t bit-rotting …
Great question!
If I type “=SUM(A1:A3)” then the cell autocorrects (or is that “autoincorrects”?) to
“=SUM;(A1:A3)”
with the result:
Err:508
If I type “=A1+A2+A3”
Then I get the result “6” which I’d expect! (A1=1,A2=2 and A3=3)
Okay, so being completely mystified I updated LibreOffice from Debian Wheezy backports, and it works now. The catch is that I still don’t know why. (Thanks to Nicd on #libreoffice IRC!)