To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95381
User er changed the following: What |Old value |New value ================================================================================ OtherIssuesDependingOnTh|95382 | is| | -------------------------------------------------------------------------------- Assigned to|spreadsheet |er -------------------------------------------------------------------------------- Ever confirmed| |1 -------------------------------------------------------------------------------- Status|UNCONFIRMED |NEW -------------------------------------------------------------------------------- OS/Version|Windows XP |All -------------------------------------------------------------------------------- Platform|PC |All -------------------------------------------------------------------------------- Target milestone|--- |OOo 3.1 -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Fri Oct 24 11:11:24 +0000 2008 ------- The new argument had to be inserted at position 4 for interoperability with other spreadsheet applications. See also http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=271 The case of Stored 2.x opened in 3.0 Err:502 =ADDRESS(3;2;;"Sheet2") should instead be transformed to Sheet2.$B$3 =ADDRESS(3;2;;1;"Sheet2") and saved again as =ADDRESS(3;2;;"Sheet2") when storing ODF 1.0/1.1 I regret that OOo2.4.x is even able to read the new ODF 1.2 formulas in namespace 'of'. It would had prevented some hassle if it wasn't and imported such formulas as text instead, as earlier versions such as OOo2.3 do. Btw, this issue does not block issue 95382, removed dependency. --------------------------------------------------------------------- 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]