To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108237
                 Issue #|108237
                 Summary|Value error
               Component|Spreadsheet
                 Version|OOO320m8
                Platform|PC
                     URL|
              OS/Version|Windows XP
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|code
             Assigned to|spreadsheet
             Reported by|zxys





------- Additional comments from [email protected] Tue Jan 12 02:34:33 +0000 
2010 -------
OOO320m8 (Build:9472) using Windows Professional XPsp2

Code for showing "filename" value error.
This worked in the last Calc version 3.1.1 and in Excel 2000

=MID(CELL("filename",A1),
FIND("[",CELL("filename",A1))+1,FIND(".xls",CELL("Filename",A1))-FIND("[",CELL("filename",A1))-1)

---------------------------------------------------------------------
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]

Reply via email to