Bug 43093

Summary: Area3DEval in formulas always refers to current sheet
Product: POI Reporter: apache
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: major CC: apache
Priority: P2 Keywords: PatchAvailable
Version: 3.0-FINAL   
Target Milestone: ---   
Hardware: All   
OS: All   
Attachments: WinZip file with example for Unit Test & Code Snippet of patch
The Patch!

Description apache 2007-08-11 11:51:59 UTC
References to areas in other Sheets (so called Area3DEval's) are resolved from
the current Sheet instead of the referenced Sheet.
I have a 4-line patch for this to the following Method...
HSSFFormulaEvaluator.internalEvaluate(...)
I have also coded an example program.
Comment 1 apache 2007-08-11 12:10:45 UTC
Created attachment 20648 [details]
WinZip file with example for Unit Test & Code Snippet of patch

Sorry I don't have access to Subversion,
so please find the 4 lines marked DL
in the enclosed Java Source Snippet.
The patch is thoroughly tested.
Comment 2 apache 2007-08-12 01:56:12 UTC
Created attachment 20650 [details]
The Patch!
Comment 3 Nick Burch 2007-08-15 06:58:16 UTC
Thanks for that, fix and testcase committed to svn