Error 509 in Calc
Error 509 in Calc
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.
I have downloaded the latest version, uninstalled my previous version and re-installed. But to No Avail.
OpenOffice 4.1.1
Windows Vista
Windows Vista
Re: Error 509 in Calc
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
=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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Error 509 in Calc
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.
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
Re: Error 509 in Calc
Whatever i put in the cells, I get Error 509
Where are the error codes, I don't have help files.
Where are the error codes, I don't have help files.
OpenOffice 4.1.1
Windows Vista
Windows Vista
Re: Error 509 in Calc
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.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Error 509 in Calc
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
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
Re: Error 509 in Calc
I will try everything you suggest but
I downloaded from sourceforge.net!
I downloaded from sourceforge.net!
OpenOffice 4.1.1
Windows Vista
Windows Vista
Re: Error 509 in Calc
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.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice