Hi All,
I have been using Open Office Calc for a number of years without issue, however, having carried out the update process to V4.1.4. this morning I have an issue with a simple cell calculation of =A1*A2 returning ERR:509. I have tried re entering the formula without success.
This is affecting all of my spreadsheets going back almost 10 years.
Any ideas, words of guidance would be appreciated.
Regards,
John
[Solved] Issues with Calc post 4.1.4. update today
[Solved] Issues with Calc post 4.1.4. update today
Last edited by Hagar Delest on Fri Nov 10, 2017 12:00 am, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Open Office 4.1.4 Windows 10
Re: Issues with Calc post 4.1.4. update today
I've just tried and it works correctly for me. Try /View /Value Highlighting and check that the operands are numeric. (Blue for numbers, black for text, green for a formula)
Please try the attached file.
Please try the attached file.
- Attachments
-
- Sample.ods
- (7.72 KiB) Downloaded 121 times
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Issues with Calc post 4.1.4. update today
Hello,
Thank you for the quick response, I have the same results as your attached file. Instead of the sum of the calculation appearing in the destination cell I have ERR:509. I am loathed to uninstall the entire suite and reinstall but I obviously will if that is the only resolution. The question of course is why the error after many years of faultless operation.
Regards,
John
Thank you for the quick response, I have the same results as your attached file. Instead of the sum of the calculation appearing in the destination cell I have ERR:509. I am loathed to uninstall the entire suite and reinstall but I obviously will if that is the only resolution. The question of course is why the error after many years of faultless operation.
Regards,
John
Open Office 4.1.4 Windows 10
Re: Issues with Calc post 4.1.4. update today
I would start by renaming your OpenOffice user profile. Error 509 means "Missing Operator" which suggests that something is wrong with your keyboard or locale selection in OpenOffice.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Issues with Calc post 4.1.4. update today
Re-install of OpenOffice does nothting.
Either you reset your user profile or you install the successor of OpenOffice which is https://libreoffice.org/
Either you reset your user profile or you install the successor of OpenOffice which is https://libreoffice.org/
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: Issues with Calc post 4.1.4. update today
Resolution achieved. I created a new spreadsheet containing a simple formula i.e. =A1*A2 and it worked with nominal values of 10 and 20 in A1 and A2,
Then i reopened my main spreadsheet which had the problem and where before I had cells with ERR:509 I now have the correct calculation.
All's well that ends well etc. etc.
Thanks for your help
Cheers,
John
Then i reopened my main spreadsheet which had the problem and where before I had cells with ERR:509 I now have the correct calculation.
All's well that ends well etc. etc.
Thanks for your help
Cheers,
John
Open Office 4.1.4 Windows 10