On Ubuntu 15.04 (Tested on win 8, no problem), since installation of 5.0.0.5 (upgrading from v4), all operators (https://help.libreoffice.org/Calc/Operators_in_Calc) return an error. For example : =3+2 --> Err :509 =IF(3=3;"vrai";"faux") --> Err :508 If I use "Functions" instead of operators, it's ok : =SUM(3;3) --> 6 =IF(EXACT(3;3);"vrai";"faux") --> vrai Easy to reproduce : just use an operator in a formula in a cell. It was ok with previous version of Libreoffice. Same problem on 2 different PC (Desktop and Laptop) No problem on laptop with Win 8
Libreoffice was installed using ppa:libreoffice/ppa
Hi Thomas, Thanks for your report. I cannot reproduce this problem on Ubuntu 32 bits, Can you maybe attach a test file? Maybe it's a problem with you user profile https://wiki.documentfoundation.org/UserProfile Cheers, Cor
Created attachment 117770 [details] Bug example
Hi Cor, Thank you to look at this problem. My Ubuntu is 64 bits. I try to delete my user profile to use a brand new one : same problem. I just attached an example file. Sincerly, Tom
Thanks for the sample document. Let's see if someone else can confirm the issue. Ciao - Cor
I have solved the problem by deleting and reinstalling Libreoffice. The problem was certainly with the update from v4. For information, I do : sudo apt-get remove libreoffice* sudo apt-get autoremove (not necessary?) sudo apt-get install libreoffice sudo apt-get install libreoffice-l10n-fr (for french version) And now everything right. Sorry for this "NOTABUG"
thanks for reporting and closing!