Issue 95742 - Import of SXC is broken in connection with function ADDRESS
Summary: Import of SXC is broken in connection with function ADDRESS
Status: CLOSED DUPLICATE of issue 95312
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2008-11-01 15:56 UTC by Stefan Weigel
Modified: 2008-11-03 11:25 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Stefan Weigel 2008-11-01 15:56:10 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.
Comment 1 Stefan Weigel 2008-11-03 08:37:24 UTC
Changing from unconfirmed to new
Comment 2 ooo 2008-11-03 11:25:00 UTC
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 ***
Comment 3 ooo 2008-11-03 11:25:30 UTC
Closing dup.