Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | ODFF: Empty parameters in formulas | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | arkey <romeo.koeppel> | ||||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | ACCEPTED --- | QA Contact: | |||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | daniel.rentz, issues, jody, pagalmes.lists, rb.henschel, rene, vdvo | ||||||
Version: | 641 | Keywords: | ms_interoperability | ||||||
Target Milestone: | --- | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
arkey
2002-04-05 05:11:58 UTC
I'll have a look, Peter Hi Oliver, please check this for the excel import. Created in OOo 641d the formula doesn't throw any error message. Returning Err:511 indicates that a parameter is missing. Maybe import is incomplete?! ... and I see another issue. Due to this function is case sensitive it does only convert small characters. Please check what is happening in Excel and advice me if I should file an issue for that. Best regards, Peter With the hint Err:511 means parameter missing, i found out that excel can handle =CONCATENATE( "1";;"3") with empty second parameter. OpenOffice gives here the Err:511. Excel is case sensitive. the formula works only with small characters. ( lower(B3) fix this ) The Err:511 means nothing. A additional text like "Err:511, missing parameter" would help, to find out, what's wrong. Best regards, Romeo Hi Romeo,
> A additional text ... would help, to find out, what's wrong.
There is
one: Select the cell and take a look to the status bar.
Daniel
Hi Romeo, we'll check your last comment and I guess you might be right becuse I didn't found '...);;"@wincor...' yesterday. That maybe the reason why import fails with an Errr:511. Oliver will check this when he can spare some time. Unfortunally this has to fail recently because OOoCalc formulas are not yet designed for empty parameters somewhere in the middle. Only the last parameters can be left away. Best regards, Peter Hi Falko, the problem here is, that OpenOffice can't handle formulas with missing parameters inside the parameterlist. (Excel could handle it) => Enhancement FT->AMA: This is an filter issues. Please evaluate. Thx. Issues in Calc filter, so it's Kai's decision how to proceed. approved DR->ER: it's your area We need a definition list of how missing parameters are to be substituted. Most times it will be numerical 0 or textual empty string, but this is not guaranteed to be the correct substitution for every occurence. For example, the 4th parameter of VLOOKUP() is defaulted to TRUE, or the 3rd parameter of MATCH() is assumed to be 1. Additionally to optional parameters, Excel even allows required parameters to be defaulted, as long as they are explicitly specified empty. Creating such a list is a bunch of work, one has to try out what happens for every single parameter of each function. I would be pleased if someone could do that, I wouldn't like to do it myself ... => adding needhelp keyword. *** Issue 577 has been marked as a duplicate of this issue. *** same problem with a starbasic user defined function using optional arguments Laurent The ms_interoperability keyword should be added. Added keywords ms_interoperability, easy2dev; targeted to PleaseHelp. The first step, gather information about each and every parameter and how it acts if missing, can be done by anyone owning an Excel software package, just that it is a time consuming task and information is not always obvious. Note that we need a complete and comprehensive list, partial specification is not sufficient. Eike Eike: Is there any particular format that you would like to have the list in? Vaclav Vaclav, Either as simple text like CSV (comma separated values, just use semicolons instead of commas to separate fields, so commas can be used in descriptions) that can be easily imported into applications, or a OOoCalc spreadsheet ;-) using columns for fields, listing in each row: English function name; Param1 default value; Param2 default value; ...; comments and descriptions Eike *** Issue 45942 has been marked as a duplicate of this issue. *** *** Issue 47172 has been marked as a duplicate of this issue. *** We get some Excel files from other partners with the formula "=Offset(A1;;1)" - the Error511 stops all migration plans because the ms_interoperability is not given. I can not understand that this short change in the import filter (replace ";;" by ";0;") is so difficult. Guzi,
> I can not understand that this short change in the import filter (replace ";;"
> by ";0;") is so difficult.
Read the issue's comments, especially
------- Additional comments from er Mon Nov 10 05:29:20 -0700 2003 -------
and
------- Additional comments from er Thu Nov 18 04:00:47 -0700 2004 -------
Eike
Eike, I understand the need to have a parameter substitution table, but I assume nobody has the time to check each formula in Excel to create a complete list. But in this way it would never go forward with the ms_interoperability. Maybe everybody with an actual problem can report this one entry in the suggested format. The issue 47172 would be solved with : OFFSET (reference;rows default 0;columns default 0;height default 1;width default 1) Guido *** Issue 48492 has been marked as a duplicate of this issue. *** Created attachment 25935 [details]
Table with default parameters for ALL Excel functions
Feel free to play with the attached list of all functions and their default parameters. By the way: OFFSET does not always use 1 as default for the 4th and 5th parameter... Thanks, Daniel! This is f... far out GREAT! Removing help keywords, retargeting from PleaseHelp for implementation. Eike Created attachment 26048 [details]
Same list with updated LOG function
*** Issue 49562 has been marked as a duplicate of this issue. *** *** Issue 68203 has been marked as a duplicate of this issue. *** ODFF relevant. Targeting this in its entirety to OOo3.0 was overoptimistic. Retargeting to 3.1. Some general behavior and single functions in the meantime were changed, and effort will go on. For example, CONCATENATE mentioned by the original submitter and the issues that were closed as duplicates are fixed. However, it's good to keep this issue and its attached document for complete reference. cc me Reset assigne to the default "issues@openoffice.apache.org". |