https://issues.apache.org/bugzilla/show_bug.cgi?id=48404
--- Comment #1 from Josh Micich <[email protected]> 2009-12-17 12:20:24 UTC --- This feature (multi-sheet 3D references) is not yet supported by POI. Incidentally, the syntax of your formula looks wrong. My Excel(win, 2007) seems to require "SUM(Sheet1:Sheet3!A1:B1)". There are three aspects that will need fixing: 1 - Rendering 2 - Parsing 3 - Evaluation I'm not sure if you care about 2 or 3. The rendering fix will probably involve ExternSheetNameResolver.prependSheetName() and perhaps some code in LinkTable. The parsing fix may be a little more difficult with all the existing complexity regarding distinguishing sheet names, defined names, function names and cell names. This will probably affect FormulaParser and LinkTable.checkExternSheet(int) I'm not sure about the evaluation fix. It may be simple because it seems like multi-sheet references are nowhere near as usable as single sheet ones. Besides the aggregate functions (sum, stdev, etc) do you know of any other function or operator which can use multi-sheet references? Contributions always welcome. -- 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]
