Comment 7 for bug 475768

Andrey (aol-nnov) wrote :

Hi, All!

I can confirm, that the bug is 100% reproducible on many builds and on both platforms. I've checked latesl libreoffice for x86 linux, openoffice 3.2.1 from gentoo portage, packages from ALTLinux 5.1 repos and OOo for Windows built by InfraResource.
I have no idea of the root cause of this bug, BUT i've just found an interim solution.

bring up OO Calc, navigate to Tools->Options->OpenOffice.org Calc->Formula. Choose "Excel A1" as formula syntax instead of "Calc A1" which is chosen by default.

Bingo.

HTH,
Andrey