Page 1 of 1

ERR 509

PostPosted: Wed Feb 13, 2019 9:04 pm
by DPARK
I have in the last couple of days updated to 4.1.6, now a spread sheet that I use for household stuff is showing err 509 in all the cells that have any kind of formula. I looked at the formula list and there is now nothing in it that there was before

Re: ERR 509

PostPosted: Wed Feb 13, 2019 9:42 pm
by Zizi64
From the help:

509 Missing operator
Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing.


Please upload your sample file here.

Re: ERR 509

PostPosted: Wed Feb 13, 2019 10:02 pm
by DPARK
Ive just checked the Formula list again and there isn't anything showing in it. The list of all the different formula isn't there anymore. I click on a cell with a formula and the formula is there but showing err509.

Re: ERR 509

PostPosted: Wed Feb 13, 2019 10:11 pm
by Zizi64
Please show us at least the formula ...

Re: ERR 509

PostPosted: Wed Feb 13, 2019 10:20 pm
by RusselB
Also remember that the formula you are looking at might not have a mistake, but a formula that is referenced could have the mistake.... it can take a while to locate which formula has the error if you have a lot of formulas that reference other formulas.

Re: ERR 509

PostPosted: Thu Feb 14, 2019 5:56 pm
by DPARK
The formula are all simple stuff =sum() etc and have been working ok for quite a few years as ive had the spreadsheet a while. the problem occurred once I up graded to 4.1.6.

Re: ERR 509

PostPosted: Thu Feb 14, 2019 7:01 pm
by RoryOF
Please upload a small sample file so that we can analyse what may be wrong. Otherwise you are wasting your time and ours.

Re: ERR 509

PostPosted: Thu Feb 14, 2019 7:18 pm
by DPARK
Thank you for your time, I opened the file in another spreadsheet prog and all the formula work it is something to do with the update itself

Re: ERR 509

PostPosted: Thu Feb 14, 2019 9:28 pm
by Zizi64
=sum()

Your sample formula have not any parameters. What will be summarized?