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.
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.
Created attachment 20650 [details] The Patch!
Thanks for that, fix and testcase committed to svn