To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108237
------- Additional comments from [email protected] Tue Jan 12 15:58:28 +0000 2010 ------- The CELL("filename") function is not compatible between Calc and Excel; the function works in both, but returns very different results for the same document: Excel: C:\Excel\[test.xls]Sheet1 Calc: 'file:///C:/Excel/test.xls'#$Sheet1 Your formula returns an error because the FIND("[",...)) fails to find any left bracket character. It would be very difficult--at best--to create a formula to extract the document file name that would work in both Calc and Excel. You can get help on the users mailing list or forum: [email protected] http://user.services.openoffice.org --------------------------------------------------------------------- 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]
