Issue 93048 - mid(cell(find))) formula does not import accurately
Summary: mid(cell(find))) formula does not import accurately
Status: REOPENED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.4.1
Hardware: All Windows XP
: P3 Normal with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 108237 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-08-23 14:17 UTC by stoopidme
Modified: 2017-01-13 17:00 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 3.4.1
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description stoopidme 2008-08-23 14:17:41 UTC 
The Excel formula

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

does not import correctly and must be manually edited to be converted to

=MID(CELL("filename");FIND("$";CELL("filename"))+1;255).

Reporter had to manually change the commas to semi-colons and the right bracket 
to the dollar symbol.
Comment 1 Edwin Sharp 2013-03-08 13:51:20 UTC 
Only ] --> $ is necessary by the user on Rev. 1400866.
The import does change original commas to semi-colons.
However, ] is not allowed in file name.
Comment 2 stoopidme 2013-03-13 22:48:56 UTC 
This bug is NOT resolved. The formula is a valid Excel formula used to get the name of the current tab. It has nothing to do with the filename.

Please reopen.
Comment 3 Edwin Sharp 2013-03-14 05:55:51 UTC 
Reopened as requested by the originator.
Comment 4 oooforum (fr) 2017-01-13 17:00:41 UTC 
*** Issue 108237 has been marked as a duplicate of this issue. ***