I have just upgraded to Libreoffice 3.5.4.2 on Debian 3.16.0.4 amd64 and now I am unable to enter functions into my spreadsheets or change any of the existing ones without getting #NAME?, also all the functions have changed, eg =SUM(A1:A3) is now =SUMIFNAA1:A3CHOOSE
What exactly are you doing? Please described the details on how you enter a function to allow a simulation.
If you would like to post a sanitized copy of your spreadsheet, be happy to take a look at that function change issue.
The goddess of karma blessed you. You can now attach the spreadsheet.
I discovered this was due to an incomplete update. Now fixed.
Thanks to everyone who replied.