|Summary:||Area3DEval in formulas always refers to current sheet|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
WinZip file with example for Unit Test & Code Snippet of 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 3 Nick Burch 2007-08-15 06:58:16 UTC
Thanks for that, fix and testcase committed to svn