Hi Guys,
I am generating an Excel file and i am setting the following EXCEL function as a value for Cell_Write action:
"=HYPERLINK(""URL"";""Map Location"")"
Unfortunately, this conversion is not working. When the file is generated the function is not being converted into a function itself and it's considered a string!
I have tried to perform the Worksheet_Calculate but no luck with that.
Is it possible to do this?
Cheers,
Pedro Domingues
Hi,
For the CellType, please use "formula" instead of "function".
It can work for me.
Hi Pedro
Did you perhaps set the CellType parameter to "function"?
Hanno
Just a follow-up - I tried my suggestion and it doesn't work.
I'll have to dig into the details of EPPlus to see if we can make it work.
Hi Hanno,
I really appreciate your help!
Guys I have the same issue need help
hi, i try to change the cell type into formula. but seems 'formula' data type isnt available at cell typr properties in my cell_write action. my forge is already latest version. any help to solve this issue?
Hi, Muhammad.
You need to write "formula" as a string, not just formula like you have on your screenshot.