To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103331 Issue #|103331 Summary|OFFSET returns Err:504 on reference to another calc fi |le Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|code Assigned to|spreadsheet Reported by|paulwolstenholme
------- Additional comments from [email protected] Sun Jul 5 08:13:25 +0000 2009 ------- The offset function used to work up to 3.0.1 but in OOo 3.1.0 it returns Err:504 whenever the reference field refers to another calc document. To replicate: 1) Create a new calc document and save it as the default name (Untitled 1.ods) on the desktop. 2) Create a second calc document. (There is no need to save it.) 3) In the second document, select cell A1 of sheet1. Use the function wizard to enter function OFFSET. Set the 'rows' field to 0 and the 'columns' field to 0. With the cursor in the 'reference' field, click the first spreadsheet and a cell (e.g. A1) within that spreadsheet. Click OK on the function wizard to enter the formula. The formula will be similar to: =OFFSET( 'file:///C:/Documents%20and%20Settings/PaulW/Desktop/Untitled%201.ods'#$Sheet1.A1; 0; 0 ) Note that the formula result is Err:504 rather than the value of the cell in the first calc document. Same result on WinXP. --------------------------------------------------------------------- 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]
