Re: Formula Parsing and XSSFEvaluationWorkbook

[Blake Watson]

Thanks, Dominik!

On Wed, Dec 9, 2015 at 12:15 PM, Dominik Stadler 
wrote:

> I don't think there is something fully ready-made as no-one seems to
> have needed this yet.
>
> I would probably start with an EvaluationWorkbook and retrieve the
> list of Ptgs via the FormulaParser, then you'll need to look through
> these and handle any Ref-type-Ptg to find out which Cell(s) it
> references.
>
> XSSFEvaluationWorkbook.create(wb);
> Ptg[] ptgs = FormulaParser.parse(formula, fpb, formulaType, sheetIndex);
>
> Dominik.
>
> On Wed, Dec 9, 2015 at 6:59 PM, Blake Watson 
> wrote:
> > I'm trying to provide a tracing/debugging feature and need to be able to
> > say what cells a particular formula-cell depends on.
> >
> > POI makes this rather challenging, or so it seems. The methods in
> > XSSFEvaluationWorkbook seem provide the function, but it also seems that
> > you're not supposed to use this.
> >
> > I don't want to build an Excel formula parser, that's why I use POI. So
> > what do I do?
> > --
> >
> > *Blake Watson*
> >
> > *PNMAC*
> > Application Development Manager
> > 5898 Condor Drive
> > Moorpark, CA 93021
> > (805) 330.4911 x7742
> > blake.wat...@pnmac.com 
> > www.PennyMacUSA.com 
>
> -
> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> For additional commands, e-mail: user-h...@poi.apache.org
>
>


-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com 
www.PennyMacUSA.com 

Re: Formula Parsing and XSSFEvaluationWorkbook

[Dominik Stadler]

I don't think there is something fully ready-made as no-one seems to
have needed this yet.

I would probably start with an EvaluationWorkbook and retrieve the
list of Ptgs via the FormulaParser, then you'll need to look through
these and handle any Ref-type-Ptg to find out which Cell(s) it
references.

XSSFEvaluationWorkbook.create(wb);
Ptg[] ptgs = FormulaParser.parse(formula, fpb, formulaType, sheetIndex);

Dominik.

On Wed, Dec 9, 2015 at 6:59 PM, Blake Watson  wrote:
> I'm trying to provide a tracing/debugging feature and need to be able to
> say what cells a particular formula-cell depends on.
>
> POI makes this rather challenging, or so it seems. The methods in
> XSSFEvaluationWorkbook seem provide the function, but it also seems that
> you're not supposed to use this.
>
> I don't want to build an Excel formula parser, that's why I use POI. So
> what do I do?
> --
>
> *Blake Watson*
>
> *PNMAC*
> Application Development Manager
> 5898 Condor Drive
> Moorpark, CA 93021
> (805) 330.4911 x7742
> blake.wat...@pnmac.com 
> www.PennyMacUSA.com 

-
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org