Thanks, Dominik! On Wed, Dec 9, 2015 at 12:15 PM, Dominik Stadler <[email protected]> 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 <[email protected]> > 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 > > [email protected] <[email protected]> > > www.PennyMacUSA.com <http://www.pennymacusa.com/> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 [email protected] <[email protected]> www.PennyMacUSA.com <http://www.pennymacusa.com/>
