Issues with POI3.1 Final Version.
one excel sheet is being created in java code. In the code we are creating
the cells and writing formulas in it. With Poi2.5 the formula gets
evaluated and the result is displayed. But when we use Poi 3.1 then we have
to use HSSFFormulaEvaluator.evaluateFormulaCell() to evaluate the formulas.
However, the project in which I am working used POI 2.5 and it had manual
formula at that time..
formula =
"if("+getCellName(ROW_TOTAL_OPP,currentCellIndex)+"=0,0,(1-("+getCellName(RO
W_EX_TOTAL,currentCellIndex)+"/"+getCellName(ROW_TOTAL_OPP,currentCellIndex)
+")))";
cell.setCellFormula(formula);
This creates problem with 3.1 version, that's why I went back to version 3.0
I hope it clarifies the situation well, and hope to hear some answer from
the community now.
Regards,
-----Original Message-----
From: Ulf Dittmer [mailto:[EMAIL PROTECTED]
Sent: Monday, November 03, 2008 9:20 AM
To: POI Users List
Subject: Re: Unable to construct record instance
I would question the requirement to use an obsolete
version if a newer version exists that is
API-compatible and apparently fixes a bug you're
running into.
Ulf
--- Awais Bajwa <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am using POI-3.0-r2
>
> And getting the following error at :
>
> HSSFWorkbook workBook2 = new HSSFWorkbook
(fileSystem);
>
> org.apache.poi.hssf.record.RecordFormatException:
> Unable to construct record instance
>
> However with POI-3.1 it works fine
>
> But I have to use POI-3.0-r2
>
> Any idea>???
>
> Awais
---------------------------------------------------------------------
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]
