when write data to Excel using TEXTSPLIT function and download it, the function has be changed. {} was added before and after function.
How to avoid it?
the excel template
after write data to the excel file and download it
Hi R R
Did you hide/protect any cells in the sheet or protect the sheet itself?
I cannot find anything specific to the EPPlus library and these curly brackets.
Hanno
Thank you for your reply!
I don't hide/protect any cells and sheets.
Maybe that the Advanced Excel does not support the formula of TEXTSPILT?
Yep, probably that. This is the list of supported functions for EPPlus and TEXTSPLIT is not in that list...
https://github.com/JanKallman/EPPlus/wiki/Supported-Functions