POI doesn't provide RowDifferences/ColumnDifferences functionality out
of the box, but it does provide a formula parser so that you can
compare parsed expressions and decide whether they match.
Here is an example:
HSSFWorkbook workbook = ...;
HSSFEvaluationWorkbook fpb = HSSFEvaluationWorkbook.create(workbook);
Ptg[] ptg_d4 = FormulaParser.parse("C3+2", fpb, FormulaType.CELL, -1);
// RefPtg,IntPtg,AddPtg
Ptg[] ptg_d5 = FormulaParser.parse("C4+2", fpb, FormulaType.CELL, -1);
// RefPtg,IntPtg,AddPtg
The formula parser return tokens in the Reverse polish Notation Order,
i.e. for C3+2 it will return "C3","2","+"
See more at http://poi.apache.org/spreadsheet/formula.html
On Sun, Jan 13, 2013 at 2:06 PM, Stuart Turner <[email protected]> wrote:
> RowDifferences
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]