DO NOT REPLY [Bug 48703] sum spanning multiple worksheets

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=48703

--- Comment #18 from Nick Burch <ni...@alfresco.com> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org