To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102399 Issue #|102399 Summary|The function "INDIRECT" fails (502) Component|Spreadsheet Version|OOO310m11 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|ogattaz
------- Additional comments from ogat...@openoffice.org Sun May 31 18:06:58 +0000 2009 ------- The function "INDIRECT" fails (502) if its argument is an external reference like 'file:///path/myFile.ods'#$Sheet.A1 This issue is not the same as 41183 or 69140. Example : =SI(PreviousYear=0;0;INDIRECT( PreviousYearFilePath&"#$"&ADRESSE(LIGNE()+12;COLONNE();;1;"Liaisons") )) The function "INDIRECT" fails (502) when calculated argument is : 'file:///Users/parents/_Famille/Banques/Comptes%20BNP/2007BNP_commun.ods'#$Liaisons.$C$14 Note : The direct link in a formula works well : ='file:///Users/parents/_Famille/Banques/Comptes%20BNP/2007BNP_commun.ods'#$Liaisons.$C$14 The tutorial that I took as a reference is: http://user.services.openoffice.org/en/forum/viewtopic.php?f=75&t=3294 Olivier --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org