https://issues.apache.org/bugzilla/show_bug.cgi?id=48703
--- Comment #18 from Nick Burch <[email protected]> 2012-02-10 15:03:36 UTC --- Looking at the supplied file, BiffViewer sees it as: [FORMULA] .row = 0x0000 .col = 0x0000 .xfindex= 0x000F .value = 4.0 .options = 0x0000 .alwaysCalc= false .calcOnLoad= false .shared = false .zero = 0xFC002006 Ptg[0]=org.apache.poi.ss.formula.ptg.Ref3DPtg [sheetIx=0 ! A1]R Ptg[1]=org.apache.poi.ss.formula.ptg.AttrPtg [sum ]. [/FORMULA] If you fetch the Cell Formula back in POI, you get just: SUM(Sheet2!A1) So, it looks like our handling of Ref3DPtg isn't coping with the multiple sheets case. Someone will need to fix that first, then when we can correctly handle the formula string, we can look at the evaluation. Finally, how XSSF formulas are evaluated can be sorted based on this. I've added disabled unit tests for HSSF and XSSF in r1242807, they should hopefully help someone with working on the issue -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
