[Solved] Replaced computer, all formulas produce Err:509

Issues installing under the Mac OSX - X11 - Aqua
Post Reply
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

[Solved] Replaced computer, all formulas produce Err:509

Post by vaplec »

Hi!
I finally got myself a new MacBook Air (2017), changed HD to larger and had El Capitán installed (as previously) MacOS X 10.11.6. I have been using OpenOffice for years and am very happy with it. I have made sure Mac would accept it on the new computer, and Writer works fine so far.

But Calc give my formulas an error 509 in all those columns in my book-keeping file!!!
What must I do? (I'm not terribly good at these techy things!)

Cheers!
Christine
Last edited by MrProgrammer on Tue Jul 06, 2021 6:06 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] since a reinstall eliminated the problem
OpenOffice 4.1.8 on MacOS 10.11.6
Bidouille
Volunteer
Posts: 574
Joined: Mon Nov 19, 2007 10:58 am
Location: France

Re: Change of Mac, Calc doesn't work

Post by Bidouille »

Hello Christine,
Save our time, could you please post the formula?
Even better, upload the spreadsheet if it doesn't contain confidential information.
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

The formula is simple (and no, can't upload confidential information)
=sum(E128-F128+D127)
=sum(W1:W14)

/Christine
OpenOffice 4.1.8 on MacOS 10.11.6
Bidouille
Volunteer
Posts: 574
Joined: Mon Nov 19, 2007 10:58 am
Location: France

Re: Change of Mac, Calc doesn't work

Post by Bidouille »

Code: Select all

=sum(E128-F128+D127)
No sense, why use SUM?
Just enough with:

Code: Select all

=E128-F128+D127
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

Same result, I'm afraid! Terribly frustrating. :-(
OpenOffice 4.1.8 on MacOS 10.11.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Change of Mac, Calc doesn't work

Post by RoryOF »

Start by checking your data types - turn on /View /Value Highlighting; text will show in black, formulae in green, numbers in blue.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

That's correct, but it doesn't perform
OpenOffice 4.1.8 on MacOS 10.11.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Change of Mac, Calc doesn't work

Post by RoryOF »

Can you open a new spreadsheet, and perform some simple arithmetic in it? That will help isolate the problem either to the specific spreadsheet or to the new OpenOffice installation.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

I've done a short testing sheet. Sometimes the cell is empty!
Attachments
testing calc.ods
(12.21 KiB) Downloaded 246 times
OpenOffice 4.1.8 on MacOS 10.11.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Change of Mac, Calc doesn't work

Post by RoryOF »

IN a16, b16, c16 change =a1:A14 TO =SUM(a1:a14) and similarly for B16, C16; all should then be OK. The error in A16 (etc) propagates to the lower cells.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

That is the way it was on the old laptop. I just checked, as it is still intact. On the test sheet, there is no difference when I change it back to SUM (or summa, in Swedish).
I did back-up and transferred all my files from the old to new new laptop. On the old one, it worked just fine...
OpenOffice 4.1.8 on MacOS 10.11.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Change of Mac, Calc doesn't work

Post by RoryOF »

In your sample file I surrounded the cells invoking the ranges (A1:A14 etc) with =SUM() and all was well.

Have you remembered to prefix the SUM (or SUMMA) with = (equals sign)?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

Yes, as is shown in my test sheet.
OpenOffice 4.1.8 on MacOS 10.11.6
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

Sorry, in the test sheet I had changed it to = only, as suggested. But when I do use SUM I click the Sigma sign and it turns out without the SUM! Why?
Should i update McOS? AOO available for Mac?
OpenOffice 4.1.8 on MacOS 10.11.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Change of Mac, Calc doesn't work

Post by RoryOF »

Attached is your sample file, with ranges modified to use SUM; if you locale is Swedish, you might need to change SUM to SUMMA.
Attachments
testing calc_modified.ods
(10.13 KiB) Downloaded 236 times
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

And when I open it, it looks just the same as before: Err:509...
OpenOffice 4.1.8 on MacOS 10.11.6
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

Should I perhaps delete and reinstall AOO????
OpenOffice 4.1.8 on MacOS 10.11.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Change of Mac, Calc doesn't work

Post by RoryOF »

Have you changed the SUM to SUMMA?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

Yes. I have tried various formulae:
=summa(E3:E15) and =SUM(E3:E15) When hitting the Sigma sign, it only comes out as = and the cell says Err:509
=E3:E15 When I hit the = sign, the cell is blank (only shows in the upper row, don't know what it's called)

So incomprehensible!
OpenOffice 4.1.8 on MacOS 10.11.6
Bidouille
Volunteer
Posts: 574
Joined: Mon Nov 19, 2007 10:58 am
Location: France

Re: Change of Mac, Calc doesn't work

Post by Bidouille »

Strange that functions are in lowercase.
Provide a screenshot to get what you see.
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

Here's what it looks like.
Attachments
bokf.tiff
bokf.tiff (31.24 KiB) Viewed 7836 times
OpenOffice 4.1.8 on MacOS 10.11.6
vaplec
Posts: 13
Joined: Wed Jun 30, 2021 1:22 pm

Re: Change of Mac, Calc doesn't work

Post by vaplec »

Hi again,

As no-one seemed to have a clue as to what had happened, I deleted AOO and then reinstalled. Now it is working!
I also assume that the formula =SUM(A12:A18) is necessary when more than two cells are involved, but if the operation is simple it works with just =
My book-keeping file looks normal again! :D

So thanks for your efforts, at least I know where to turn for expert advice.

Cheers!
Christine
Attachments
testing calc 2.ods
(14.84 KiB) Downloaded 221 times
OpenOffice 4.1.8 on MacOS 10.11.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Change of Mac, Calc doesn't work

Post by RoryOF »

Sum is best used when there is a contiguous range: =SUM(A1:A5) is clearer than =A1+A2+A3+A4+A5; besides, if typing a long sequence one can sometimes omit a term.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply