EXCEL Formatter: Is it possible to write formulas to cells?

[tk-wf]

We are trying to write formula strings as values to Excel cells, but when the file is opened all that appears are the formula strings and not the evaluated values.

We have tried prepending an ‘=’ to the strings but that just results in the string with an ‘=’ char prepended. Hitting ‘F2’ in a cell will immediately evaluate the cell, but that is not workable for end users.

If we modify the cell in-place with the ‘=’ character then the formula evaluates.

Any help/guidance is appreciated.

Thanks,
TK

[darshthakkar]

Please check this out, might be helpful to you @tk-wf

Can we hyperlink inside a mapper snap? Designing Pipelines

Hi Team, I was tryin to use native JS function link in order to hyperlink inside a mapper. I found that it doesn’t work, does anyone know a similar functionality or a workaround? Basically, I was trying to hyperlink an existing column “ID” and wanted to output this in an excel file. Snaps below for reference: [image] [image] Thanking in advance for your help :slight_smile: Regards, DT

[tk-wf]

Thanks @darshthakkar that is somewhat helpful.

The downside is that for us it misses the requirement of writing multiple sheets to a workbook (sans manual intervention).

It is a bit surprising that the Excel Formatter(s) cannot produce a field recognized as a Formula, though not sure if the fault lies in the SL implementation, a Java Component, or on the Excel side.

As a result of this, we are reevaluating the requirement to have the Formulas in the output, which might be the better thing anyway.

[darshthakkar]

Yes, I agree to your workaround @tk-wf.
We might be implementing it in an incorrect way on SL and I still haven’t achieved formulas on excel.