Do HSSF & XSSF support in-memory formula evaluation?
I understand that POI HSSF & XSSF components allow one to create and read excel files. They do not support in-memory formula evaluation. In other words, in order to find the SUM of a range, one has to create an Excel file, launch Excel to read the file and calculate the SUM, then save the file. When POI reads the file back, it can access the calculated SUM.
Is my understanding correct?
Thanks in advance.
Re: Do HSSF & XSSF support in-memory formula evaluation?
As the documentation for formula's clearly states:
"The code currently provides implementations for all the arithmatic operators. It also provides implementations for approx. 140 built in functions in Excel."
Also, Excel does not store the reuslts of a formula. That would make no sense.