About EasyMorph Tutorials & Examples Web-help

Export formula iso value


Is it possible to add a feature to export formula and not only thr value?



I had almost the same wish, and found a workaround.

1 - a Rule transformation calculated different formulas (‘It’s an expression’) based on given criteria
2 - I copied the rule transformation, gave the output column a different name, and changed all results to ‘It’s a text or number’

This worked for me.
Instead of showing the actual calculations in the second rule transformation, I put a more descriptive text to show end users how result had been calculated.



I still need the formulae in Excel as users will make change to spreadsheet and new values needs to be calculated
I am now investigating how to get formulae back in - did not want to go VBA route.