8

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**)

asked

Benjamin Griggs

0 answers