Issue 93048

Summary:	mid(cell(find))) formula does not import accurately
Product:	Calc	Reporter:	stoopidme <s.vanslyck>
Component:	open-import	Assignee:	AOO issues mailing list <issues>
Status:	REOPENED ---	QA Contact:
Severity:	Normal
Priority:	P3	CC:	elish, issues, paul
Version:	OOo 2.4.1
Target Milestone:	---
Hardware:	All
OS:	Windows XP
Issue Type:	DEFECT	Latest Confirmation in:	3.4.1
Developer Difficulty:	---

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. ***