Hi All:

Did some tracing have not had the time to write code to verify this yet. Does anybody knows what type of ptg in the ptg list returned by the frec.getParsedExpression() is that causes the sheet reference lookup? That would help pinpoint my trace.

I did some tracing, unfortunately the ptg list returned by frec.getParsedExpression() appears to be an aggregated type of ptg. Where ptg.toForumlaString() is defined to be an abstract, leaving it to the child classes to implement. Since ptg list is designed to be aggregated, it becomes difficult to identify which children of ptg is involved in making the inter-sheet reference. Notable call sequence as follows:

FormulaParser.toFormulaString(,) Calls and results...
ptgs[i].toFormulaString(book)

Upon random browsing though various children of ptgs there are several references to hssf.model.Workbook.getSheetReferences(). Is this it? If so I have inspected the hssf.model.Workbook then ExternSheetRecord is really the records I need to get to make the hssf.model.Workbook work with FormulaParser? All of these are just speculation. Please let me know to confirm or correct me if I am going awry. Thanks.


Andy Chien

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to