Error 509 in Calc

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
hugillr
Posts: 4
Joined: Mon Aug 25, 2014 2:27 pm

Error 509 in Calc

Post by hugillr »

I have been getting ERR 509 in Calc whenever I use a formula, I can't even use SUM or A1+A2
I have downloaded the latest version, uninstalled my previous version and re-installed. But to No Avail.
OpenOffice 4.1.1
Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Error 509 in Calc

Post by Villeroy »

Enter 1 in A1, 2 in A2

=A1+A2 in any other cell returns 3
=SUM(A1:A2) returns 3
=SUM(A1;A2) returns 3
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
hugillr
Posts: 4
Joined: Mon Aug 25, 2014 2:27 pm

Re: Error 509 in Calc

Post by hugillr »

When I do that I get ERR:509 not the answer
OpenOffice 4.1.1
Windows Vista
User avatar
RoryOF
Moderator
Posts: 35251
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Error 509 in Calc

Post by RoryOF »

Why not look it up in the help file, under Error codes?

Villeroy has given you correct syntax for the simple expressions you say you can't use. Copy and Paste these into Calc and tell us if they don't work.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
hugillr
Posts: 4
Joined: Mon Aug 25, 2014 2:27 pm

Re: Error 509 in Calc

Post by hugillr »

Whatever i put in the cells, I get Error 509

Where are the error codes, I don't have help files.
OpenOffice 4.1.1
Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Error 509 in Calc

Post by Villeroy »

You downloaded the software from one of these "warez" sites?
https://openoffice.org is the home of this product. The downloads come from sourceforge.net.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
RoryOF
Moderator
Posts: 35251
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Error 509 in Calc

Post by RoryOF »

Then that is the answer. There is something drastically wrong with your OpenOffice installation.
I suggest you remove the existing installation and do a fresh download.
Download only from
http://www.openoffice.org/download
which will redirect you to SourceForge where the files are stored. Your download will start in about 5 seconds - no need to click on anything.

If you are in doubt about the integrity of the download, you can check it using the methods set out in this
http://www.openoffice.org/download/checksums.html
 Edit: You should also run an antivirus and malware scan using latest definitions - this is urgent! 
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
hugillr
Posts: 4
Joined: Mon Aug 25, 2014 2:27 pm

Re: Error 509 in Calc

Post by hugillr »

I will try everything you suggest but
I downloaded from sourceforge.net!
OpenOffice 4.1.1
Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Error 509 in Calc

Post by Villeroy »

Verify the integrity of your download.
Uninstall the program.
Remove any user profile folders with OpenOffice in the name in folder %APPDATA%
Deactivate all anti virus (go offline if this scares you)
Run the verified installer.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply