Apache OpenOffice (AOO) Bugzilla – Issue 95742
Import of SXC is broken in connection with function ADDRESS
Last modified: 2008-11-03 11:25:30 UTC
The automatic conversion of the function ADRESS from old syntax to new syntax does not recognize, if conversion has already been done and stored. Try this: (1) New spreadsheet document (2) Enter =ADDRESS(1;1;1;1;"Sheet1") in any cell (3) This results in: Sheet1.$A$1 (4) Save document as SXC (5) Close and reopen document (6) Formula has been changed to: =ADDRESS(1;1;1;1;1;"Sheet1") (7) This results in: Err:504 The problem is caused by the automatic conversion of the function ADRESS from old syntax to new syntax. Old syntax: ADDRESS(Row; Column; Abs; "Sheet") New syntax: ADDRESS(Row; Column; Abs; A1; "Sheet") Parameter A1 has been added to the new syntax for interoperation with competitor´s spreadsheet and for introduction of R1C1-references, that is coming up. When opening documents, Calc must recognize old syntax an convert it to new syntax by adding the additional parameter. However, when the formula already has been stored with new syntax, no additional parameter must be added. Works fine as long as you stick to ODF. But when opening SXC, Calc would add an additional parameter to the function, every time you open the document. By opening, saving and reopening an SXC document 10 times you will get: =ADDRESS(1;1;1;1;1;1;1;1;1;1;1;1;1;1;"Sheet1") This brakes the possibility to use SXC file format with OOo 3.0. Was no problem with 2.4.1 --> regression.
Changing from unconfirmed to new
Actually this is a duplicate of 2 issues, issue 95312 and issue 95381. Using 95312 as .sxc is involved. *** This issue has been marked as a duplicate of 95312 ***
Closing dup.