To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103626 Issue #|103626 Summary|Function failure with new type of URL reference Component|Spreadsheet Version|OOo 3.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|villeroy
------- Additional comments from [email protected] Sat Jul 18 19:22:09 +0000 2009 ------- =SUMIF('file://path/doc.ods'#SheetX.A1:A99;X1) => Err:504 I'd say this is a P2 issue if SUMIF is the only function where the new shit fails. Other users complain that INDIRECT fails completely with the new link type, which is "natural" because there is not hidden sheet anymore. INDIRECT has been used by quite a few users with CELL("filename") for references with relative paths. --------------------------------------------------------------------- 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]
