# XSSFFormulaEvaluator evaluate() method

Suba Muru

Greenhorn

Posts: 2

posted 3 years ago

Hi all,

I am using the 'evaluate' method of XSSFFormulaEvaluator. I need to know if this method will evaluate all the formula, if any, of the referenced cells as well.

To simplify my question:

I have a cell C1 which references A1 and B1. A1 in turn contains a formula referring to some other sheet of the same workbook, likewise B1 also has a formula,for eg, vlookup of some other sheet. In that case, if I call the evaluate method on C1, will that in turn evaluate the values of A1 and B1,and give me the resulting value of C1 based on these calculated values of A1 and B1?

Thanks for any inputs.

I am using the 'evaluate' method of XSSFFormulaEvaluator. I need to know if this method will evaluate all the formula, if any, of the referenced cells as well.

To simplify my question:

I have a cell C1 which references A1 and B1. A1 in turn contains a formula referring to some other sheet of the same workbook, likewise B1 also has a formula,for eg, vlookup of some other sheet. In that case, if I call the evaluate method on C1, will that in turn evaluate the values of A1 and B1,and give me the resulting value of C1 based on these calculated values of A1 and B1?

Thanks for any inputs.

Ulf Dittmer

Rancher

Posts: 42967

73

posted 3 years ago

That should be easy to test by creating a small spreadsheet and writing a few lines of POI code, no?

Suba Muru

Greenhorn

Posts: 2