ERR 509

Discuss the spreadsheet application

ERR 509

Postby DPARK » Wed Feb 13, 2019 9:04 pm

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
win 10 office v4.1.6
DPARK
 
Posts: 4
Joined: Wed Feb 13, 2019 8:55 pm

Re: ERR 509

Postby Zizi64 » Wed Feb 13, 2019 9:42 pm

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.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7988
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: ERR 509

Postby DPARK » Wed Feb 13, 2019 10:02 pm

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.
win 10 office v4.1.6
DPARK
 
Posts: 4
Joined: Wed Feb 13, 2019 8:55 pm

Re: ERR 509

Postby Zizi64 » Wed Feb 13, 2019 10:11 pm

Please show us at least the formula ...
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7988
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: ERR 509

Postby RusselB » Wed Feb 13, 2019 10:20 pm

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.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5104
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: ERR 509

Postby DPARK » Thu Feb 14, 2019 5:56 pm

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.
win 10 office v4.1.6
DPARK
 
Posts: 4
Joined: Wed Feb 13, 2019 8:55 pm

Re: ERR 509

Postby RoryOF » Thu Feb 14, 2019 7:01 pm

Please upload a small sample file so that we can analyse what may be wrong. Otherwise you are wasting your time and ours.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28986
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ERR 509

Postby DPARK » Thu Feb 14, 2019 7:18 pm

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
win 10 office v4.1.6
DPARK
 
Posts: 4
Joined: Wed Feb 13, 2019 8:55 pm

Re: ERR 509

Postby Zizi64 » Thu Feb 14, 2019 9:28 pm

=sum()

Your sample formula have not any parameters. What will be summarized?
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7988
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests