Issue 577 - Excel to OpenOffice conversion ERR:520
Summary: Excel to OpenOffice conversion ERR:520
Status: CLOSED DUPLICATE of issue 3879
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 619
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords: ms_interoperability
: 5036 5622 6762 (view as issue list)
Depends on:
Blocks:
 
Reported: 2001-03-21 01:54 UTC by issues@www
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description issues@www 2001-03-21 01:54:13 UTC 
Ex: ROUND(-PMT($C8/12;C19;C23;;0);4)

In a formula, if there is two semicolums without information between
OpenOffice give an error ERR:520.

Lotus 123 and Ms Excel for Win32 support it.
What about OpenOffice ???
Comment 1 oc 2001-03-21 09:15:24 UTC 
Missing parameter in the middle of the parameterlist are not supported by 
OpenOffice => missing feature
Comment 2 falko.tesch 2001-04-09 15:16:01 UTC 
Will continue work on this isssue asap.
Comment 3 Unknown 2001-11-08 23:05:52 UTC 
changing QA contact from bugs@ to issues@
Comment 4 oc 2002-05-21 09:00:21 UTC 
*** Issue 5036 has been marked as a duplicate of this issue. ***
Comment 5 daniel.rentz 2002-06-07 07:33:50 UTC 
*** Issue 5622 has been marked as a duplicate of this issue. ***
Comment 6 daniel.rentz 2002-08-06 12:13:15 UTC 
*** Issue 6762 has been marked as a duplicate of this issue. ***
Comment 7 falko.tesch 2003-10-06 10:33:00 UTC 
Does it make sense to implement this?
And is it needed for Excel interoperability?
Comment 8 daniel.rentz 2003-10-06 10:39:47 UTC 
Eike's area.
Comment 9 utomo99 2003-10-06 11:16:13 UTC 
Adding ms_interoperability keyword. 
In my opinion we need to support this, to reduce problem when user
move from MSo to OOo
Comment 10 ooo 2003-10-06 11:45:47 UTC 
We will need it for interoperability, but I don't think we will have
time to implement it for 2.0. However, if anybody would like to help,
a list of how missing arguments act in all functions of the main
competitive product would be the first we need. Many times a missing
argument will be substituted by the value 0 or an empty string, but it
may also be another value in some cases, or may cause entire different
behavior of a function.

Adding keyword needhelp for this.
Comment 11 ooo 2003-10-06 11:47:40 UTC 
Platform, OS, target Later.
Comment 12 ooo 2003-12-12 13:37:17 UTC 
dupe


*** This issue has been marked as a duplicate of 3879 ***
Comment 13 ooo 2003-12-12 13:37:56 UTC 
Close dupe.
Comment 14 lohmaier 2005-08-20 17:25:49 UTC 
duplicate doesn't needhelp anymore..