Log in to AnswerLog in to Follow
2018-06-14 06-18-49
Pedro Domingues
Champion
111Views
5Comments
[Advanced Excel] Generate Excel with Functions
Question
Reactive
Forge
excel-png
Service icon
Advanced Excel
Forge component by Carlos Freitas
Application Type
Traditional Web, Reactive

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

0
0
25 Nov 2020
2022-07-06 03-36-19
Hanno
mvp_badge
MVP

Hi Pedro

Did you perhaps set the CellType parameter to "function"?

Hanno

0
0
26 Nov 2020
2022-07-06 03-36-19
Hanno
mvp_badge
MVP

Hi Pedro

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.

Hanno

0
0
26 Nov 2020

Hi Hanno,

I really appreciate your help!

Cheers,

0
0
26 Nov 2020

Guys I have the same issue need help

0
0
31 Jan

Hi,

For the CellType, please use "formula" instead of "function".

It can work for me.


0
0
25 Mar
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.