Josh, I just submitted the patch. Please let me know if anything is out of order.
For now I choose not to code against the CRNRecords because it seemed like a more involved task than using the existing functionality of HSSFFormulaEvaluator.setupEnvironment. But I may go back to it later since using the cached values would not have the large memory footprint that you get by loading all referenced workbooks into the evaluation environment. You are right about how the names appear in the workbook > [Other Book.xls]Sheet1! Markup_Cost > and > Other Book.xls! Markup_Cost This formula parsing and function evaluation now works with the patch that was submitted. Thanks again for your direction, Steve > Hello Steve, > > This is good news. Did you avoid decoding CRNRecords (or similar > cached values)? > > I was aware of the existence of sheet-local names (vs global names), > but I hadn't investigated how they might be used in cross-workbook > references. So I guess in formulas those names would appear something > like: > [Other Book.xls]Sheet1! Markup_Cost > and > Other Book.xls! Markup_Cost > BTW - I don't think POI supports rendering or parsing such formulas > yet. If not, we should at the very least add a disabled test case to > show the desired behaviour. > > Please go ahead and submit a patch. Junits are greatly appreciated. > If you could do this on a new bugzilla entry, that would help us track > the work a little better. > > regards, > Josh > > --------------------------------------------------------------------- > 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]
