[Solved] Issues with Calc post 4.1.4. update today

Discuss the spreadsheet application

[Solved] Issues with Calc post 4.1.4. update today

Postby John C-P » Wed Nov 08, 2017 3:05 pm

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
Last edited by Hagar Delest on Fri Nov 10, 2017 12:00 am, edited 1 time in total.
Reason: tagged [Solved].
Open Office 4.1.4 Windows 10
John C-P
 
Posts: 3
Joined: Wed Nov 08, 2017 2:56 pm

Re: Issues with Calc post 4.1.4. update today

Postby RoryOF » Wed Nov 08, 2017 3:14 pm

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.
Attachments
Sample.ods
(7.72 KiB) Downloaded 31 times
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29753
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Issues with Calc post 4.1.4. update today

Postby John C-P » Wed Nov 08, 2017 3:36 pm

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
Open Office 4.1.4 Windows 10
John C-P
 
Posts: 3
Joined: Wed Nov 08, 2017 2:56 pm

Re: Issues with Calc post 4.1.4. update today

Postby RoryOF » Wed Nov 08, 2017 3:43 pm

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.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29753
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Issues with Calc post 4.1.4. update today

Postby Villeroy » Wed Nov 08, 2017 3:45 pm

Re-install of OpenOffice does nothting.
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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27296
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Issues with Calc post 4.1.4. update today

Postby John C-P » Wed Nov 08, 2017 3:57 pm

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
Open Office 4.1.4 Windows 10
John C-P
 
Posts: 3
Joined: Wed Nov 08, 2017 2:56 pm


Return to Calc

Who is online

Users browsing this forum: appletreasures, TheoKondak and 26 guests