Ask Your Question

Why can functions can no longer be changed?

asked 2015-05-06 19:47:08 +0200

Bayard gravatar image

updated 2015-08-27 20:30:53 +0200

Alex Kemp gravatar image

I have just upgraded to Libreoffice on Debian 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

edit retag flag offensive close merge delete


What exactly are you doing? Please described the details on how you enter a function to allow a simulation.

ROSt52 gravatar imageROSt52 ( 2015-05-07 03:26:04 +0200 )edit

If you would like to post a sanitized copy of your spreadsheet, be happy to take a look at that function change issue.

k7aay gravatar imagek7aay ( 2015-05-07 05:46:54 +0200 )edit

The goddess of karma blessed you. You can now attach the spreadsheet.

ROSt52 gravatar imageROSt52 ( 2015-05-07 12:10:34 +0200 )edit

May be virus... Or antivirus?.. Do you see this - ?

JohnSUN gravatar imageJohnSUN ( 2015-05-07 18:58:32 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-05-07 23:20:11 +0200

Bayard gravatar image

updated 2015-05-07 23:21:20 +0200

I discovered this was due to an incomplete update. Now fixed.

Thanks to everyone who replied.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-05-06 19:47:08 +0200

Seen: 40 times

Last updated: May 07 '15