> Are you doing this with a new (ie, POI created ) workbook? Do the
> sheets Table1
> and Table2 exist at the point you are doing this?
I load an Excel-document that I've created with Excel and loop through
some cells. So I get a HSSFWorkbook that contains some formulas.
> Can you show us the code you are using (simplified)? See the
> TestFormulas file
> for example of how to use sheet references.
The code for parsing and converting the formula is pretty straight forward:
Workbook wb = Workbook.createWorkbook();
FormulaParser fParser = new FormulaParser( formula, wb );
fParser.parse();
Ptg[] ptgs = fParser.getRPNPtg();
// doing something here ...
return fParser.toFormulaString( wb, ptgs );
Do I need to convert the HSSFWorkbook in a Workbook and if so, how?
Best Regards,
gerd
>
> Regards
> -
> AVik
>
>
> Quoting Gerd Mueller <[EMAIL PROTECTED]>:
>
> >
> > Hi all,
> >
> > I've got the following formula:
> >
> > SUMIF(Table1!F11:F9999,Table2!B11,Table1!Q11:Q9999)
> >
> > I read this with the FormulaParser and than convert it back to
> > a string. The result is:
> >
> > SUMIF(!F11:F9999,!B11,!Q11:Q9999)
> >
> > Is this a bug and can it be fixed easily?
> >
> > Best Regards,
> > gerd
> >
> > ________________________________________________________________
> > Gerd Mueller [EMAIL PROTECTED]
> > SMB GmbH http://www.smb-tec.com
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> >
> >
>
________________________________________________________________
Gerd Mueller [EMAIL PROTECTED]
SMB GmbH http://www.smb-tec.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
