[sc-issues] [Issue 95742] Import of SXC is broken in connection with function ADDRESS
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95742 User sweigel changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Mon Nov 3 08:37:24 + 2008 --- Changing from unconfirmed to new - 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]
[sc-issues] [Issue 95742] Import of SXC is broken in connection with function ADDRESS
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95742 User er changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Mon Nov 3 11:25:00 + 2008 --- 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 *** - 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]
[sc-issues] [Issue 95742] Import of SXC is broken in connection with function ADDRESS
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95742 User er changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Mon Nov 3 11:25:30 + 2008 --- Closing dup. - 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]
[sc-issues] [Issue 95742] Import of SXC is broken in connection with function ADDRESS
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 + 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]
[sc-issues] [Issue 95742] Import of SXC is broken in connection with function ADDRESS
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95742 User sweigel changed the following: What|Old value |New value Keywords| |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]
