DO NOT REPLY [Bug 48404] in getting 3-D formula gives 2-D formula

[bu...@apache.org]

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

--- Comment #1 from Josh Micich <jo...@gildedtree.com> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org