Excel Exporter: Ability to set a column as a Formula - Mendix Forum

Excel Exporter: Ability to set a column as a Formula

9

It would be fantastic if I could set a column to be calculated as a formula inside Excel. At present, we would have to manually perform this calculation in a non-persistent entity which is cumbersome. This article says it would be easy: 

https://www.baeldung.com/java-apache-poi-set-formulas 

 

I would imagine something along the lines of Retrieve Type: Formula and then a text box would appear where you input a string for the desired formula. (i.e. set column I to = (D x H x G)/100)

Screenshot 2023-10-25 at 12.08.57 PM.png

 

 

asked
0 answers