Iterate over cell, grab raw formula string, modify and write back.
Something like this:
for(Cell cell : row){
XSSFCell xcell = (XSSFCell)cell;
CTCellFormula f = xcell.getCTCell().getF();
if(f != null){
String sval = f.getStringValue();
sval = sval.replace("Table28[[#ThisRow]",
"[row, column]");
f.setStringValue(sval);
}
Yegor
}
On Thu, Aug 2, 2012 at 1:47 PM, saritha suram <[email protected]> wrote:
> Hi,
>
> If POI does not support the evaluation of table names, then as a work
> around, is there any way to convert or replace the table name reference in
> the formula to [ row, column] combination and then evaluate the formula??
>
> Thanks,
> Saritha
>
>
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-not-able-to-evaluate-table-names-in-the-Excel-Sheet-tp5710583p5710585.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
