To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101467 Issue #|101467 Summary|Unable to import Excel Offset() formula returning a re |ference Component|Spreadsheet Version|OOo 3.1 RC2 Platform|Unknown URL|http://user.services.openoffice.org/en/forum/viewtopic |.php?f=9&t=18227 OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|eberry
------- Additional comments from [email protected] Fri May 1 04:51:07 +0000 2009 ------- If I put this (simplified) formula in a .xlsx document: =AVERAGE(B2:OFFSET(B2, 0, 0)) In Excel 2007 this works fine, but Calc 3.1 RC2 reports this: Err:509 Error: Operator Missing And improperly changes the formula to: =AVERAGE(B2:B2(B2; 0; 0)) The problem might be due to Excel's Offset returning a reference while calc returns a value. See: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=18227 See the attached sample .xlsx file for an example where this formula isn't imported/translated correctly. --------------------------------------------------------------------- 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]
