Java org.apache.poi.ss.usermodel FormulaEvaluator fields, constructors, methods, implement or subclass

Example usage for Java org.apache.poi.ss.usermodel FormulaEvaluator fields, constructors, methods, implement or subclass

Introduction

In this page you can find the methods, fields and constructors for org.apache.poi.ss.usermodel FormulaEvaluator.

The text is from its open source code.

void	clearAllCachedResultValues() Should be called whenever there are changes to input cells in the evaluated workbook.
CellValue	evaluate(Cell cell) If cell contains a formula, the formula is evaluated and returned, else the CellValue simply copies the appropriate cell value from the cell and also its cell type.
void	evaluateAll() Loops over all cells in all sheets of the associated workbook.
CellType	evaluateFormulaCell(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.
Cell	evaluateInCell(Cell cell) If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula.
void	notifySetFormula(Cell cell) Should be called to tell the cell value cache that the specified (value or formula) cell has changed.
void	setupReferencedWorkbooks(Map workbooks) Sets up the Formula Evaluator to be able to reference and resolve links to other workbooks, eg [Test.xls]Sheet1!A1.