Hello,
For my client I'm trying to make an excel that includes a hyperlink, while browsing the forums I found out that I should use the =HYPERLINK() formula and change the celltype to formula:
Creating the file is no issue, I can just download it. The issue starts when I try to open it in Excel. For some reason I get an error that there are issues in the excel and after opening I get a message that they recovered my excel file and the Hyperlink formula is completely removed. I've tried to open the same file in google sheets and everything seems to be working fine in there.
Can someone please help with this issue? I also included the oml and excel in the attachments if someone wants to try themselves.
Kind regards,
Nick
I managed to solve the issue, the problem is that formulas are always stored in EN_US, in Belgium we use ';' as delimiter between our parameters but in EN_US it is supposed to be ',' .
Example below:
Hello, Nick.
I believe there is a specific action you can use to set formulas, instead of using the cell_write action. Have you tried that?