To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95742 Issue #|95742 Summary|Import of SXC is broken in connection with function AD |DRESS Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|sweigel
------- Additional comments from [EMAIL PROTECTED] Sat Nov 1 14:56:10 +0000 2008 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
