Excel to PDF conversion error if Sheet has Formula

[tcballelos]

Good Day!

I am getting an error while converting excel file to PDF, the sheet has a formula like below:

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

and it brings me to the error: parsing "[" - Unterminated [] set. Error in calculating cell E13 in Worksheet Cover Page

Kindly help what to do with this. thanks!

[Betsy.jiang]

Hi,

Thanks for your inquiry.
After converting a file with the formulas "=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)" and "=TRIM(LEFT(SUBSTITUTE(MID(CELL("filename",A1), FIND("[",CELL("filename",A1))+1,255),".xl",REPT(" ",255)),255))" , I didn't encounter any issue.
To help us solve your issue quickly, please provide your input Excel and the code you were using.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi,

Greetings from E-iceblue.
Has your issue been resolved? Could you please give us some feedback at your convenience?

Sincerely,
Betsy
E-iceblue support team

[tcballelos]

Hello!

Thanks already resolved.

[Betsy.jiang]

Hi,

Thanks for your feedback.
Any question, welcome to get it back to us.

Sincerely,
Betsy
E-iceblue support team