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]

Reply via email to