Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | ADDRESS adds quote around sheet, not only filename, breaks reference to other file (ADDRESS and INDIRECT functions not adaptable) | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | uluer <kaya.uluer> | ||||||
Component: | programming | Assignee: | kla <thomas.klarhoefer> | ||||||
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> | ||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | issues, lohmaier, nesshof, niklas.nebel, rb.henschel | ||||||
Version: | OOO300m9 | Keywords: | oooqa, regression | ||||||
Target Milestone: | 3.4.0 | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
uluer
2008-12-03 19:56:45 UTC
The error is already in ADDRESS. It seems that OOo3 has a different way for ADDRESS to set the apostrophe, if the last parameter contains a file name. Copy both attached files into the same directory. Open target.ods in OOo2.4 to see that it works. Then open it in OOo3.0. The formulas generate wrong references. Created attachment 58487 [details]
File which is called from the "target"-document
Created attachment 58488 [details]
Handling of file name in parameter has changed
probably the behaviour has changed in OOo 3.0 Now we need at least 5 parameters. The documentation is also wrong for OOo 3.0 openoffice.org help {F1} > adress > spreadsheet functions > example: ADDRESS(1; 1; 2; "Sheet2") returns the following: Sheet2.A$1 should be: ADDRESS(1; 1; 2; 1; "Sheet2") returns the following: Sheet2.A$1 confirmed, flagging as regression, not only windows affected, updated summary. As described: when referencing another document in the table-parameter, the address function in OOo 3.x adds the quotes at inappropriate places. It includes the sheetname in the quoted part, which is not what other formulas expect. In addition, this is different from previous versions that did not add quotes at all (the user had to specify them). regression as this breaks documents that try to use indirect in combination with address function to reference data from other files. Even if it would add the quotes at the correct places, it would break formulas that use CONCATENATE or similar that provide the quotes as it was necessary in previous versions of OOo. as a name like ''file:///tmp/bug.ods''#Table1.A1 (i.e. double-quoted filename) will not be accepted by INDIRECT either. Grabbing issue. Might be worth nominating this as 3.2 stopper on releases@ooo Code change reviewed. In cws calc66: changeset dceeb0488213 http://hg.services.openoffice.org/cws/calc66/changeset/dceeb0488213 M sc/inc/compiler.hxx M sc/source/core/tool/address.cxx M sc/source/core/tool/compiler.cxx M sc/source/core/tool/interpr1.cxx You can observe the progress and possible integration date of CWS calc66 at http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fcalc66 Reassigning to QA for verification. Seen ok in cws calc66 -> verified |