Pedro Domingues
Rank: #152
17Views
3Comments
[Advanced Excel] Generate Excel with Functions
Question
Reactive
Forge
Advanced Excel
Forge component by Carlos Freitas
69
Published on 27 Aug 2019
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
on 2020-11-25
Copy link to comment
Hanno
mvp_badge
MVP
Rank: #32

Hi Pedro

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

Hanno

0
0
on 2020-11-26
Copy link to comment
Hanno
mvp_badge
MVP
Rank: #32

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
on 2020-11-26
Copy link to comment
Pedro Domingues
Rank: #152

Hi Hanno,

I really appreciate your help!

Cheers,

0
0
on 2020-11-26
Copy link to comment