Err: 509

Discuss the spreadsheet application

Err: 509

Postby SquintKid » Sat Nov 07, 2009 7:49 pm

I've been promoting OOo to many people who are reluctant to spend all the money for Windows. But now new sheets are giving me formula errors Err: 509!

What do I do about this! It is only with new sheets. If I open an Excel file, no problem with formulas. But this is not the case with all the users that do not have EXCEL!
SquintKid
 
Posts: 2
Joined: Sat Nov 07, 2009 7:46 pm

Re: Err: 509

Postby FJCC » Sat Nov 07, 2009 8:17 pm

It is hard to say what the problem is without more information. Can you give an example of a formula that is giving this error? Does the error appear for all formulas, or just some? Could you upload a file? You can use the Upload Attachment tab that is just below the area where you type a response.
AOO 3.4 or 4.0 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 3672
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Err: 509

Postby SquintKid » Sat Nov 07, 2009 8:47 pm

FJCC wrote:It is hard to say what the problem is without more information. Can you give an example of a formula that is giving this error? Does the error appear for all formulas, or just some? Could you upload a file? You can use the Upload Attachment tab that is just below the area where you type a response.


=IF(C53>0,C53-C52,0)

If I replace the "," with a ";" it works. But that does not make for a smooth transition for other people who choose OOo instead of MS Excel.
OpenOffice 3.1 on MacOS 10.6
SquintKid
 
Posts: 2
Joined: Sat Nov 07, 2009 7:46 pm

Re: Err: 509

Postby keme » Sat Nov 07, 2009 9:15 pm

IIRC, the official builds of OOo have always used semicolons for separator. Some third party builds offer the "enhancement" of using commas, to look more like Excel.

Also, when opening Excel files, the transition to semicolons has never been an issue.

The issue arises when users come from Excel to Calc, need to enter formulas with functions, and use the period (dot) as the decimal separatot. (Roughly half of the world uses comma for decimal separator, and for those countries, Excel also provides the semicolon for parameter separation within functions.)

For those having the issue, the change will not be a great transition. Most people will get used to it in virtually no time.
OOo 3.3.0 and Apache OOo 3.4.1/4.0.0, on Ms Windows 7 and Mac OS-X.
User avatar
keme
Volunteer
 
Posts: 1601
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Err: 509

Postby FJCC » Sat Nov 07, 2009 9:16 pm

SquintKid wrote:If I replace the "," with a ";" it works. But that does not make for a smooth transition for other people who choose OOo instead of MS Excel.

I don't understand your reasoning. OOo uses a semicolon to separate the arguments of a function. You can't just put in a comma and expect it to work. If the file is exported to the xls format the export filter will deal with changing the semicolons to commas. If you feel it is absolutely necessary to use commas, I think one of the alternate version of OOo does use commas, but that is only a vague memory.
AOO 3.4 or 4.0 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 3672
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Err: 509

Postby Villeroy » Sat Nov 07, 2009 10:07 pm

My Excel uses semicolons as argument separator just like OOo does. In Excel it is a matter of the installed language version. My Excel is German, uses comma as decimal separator and thus it has to be another list separator.

http://go-oo.org is a derivate of OOo which uses semicolon or comma depending on the current locale setting (every installation of OOo supports all number format locales).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot], tim mortimore and 13 guests