Exactly. Total_Cost!Jan and Total_Cost!Apr_ refer both to only one cell so it
should be equal to something like SUM(A1:A35).
Nevertheless I have tried your suggestion but it results in an Err:508. Even
if I type only "=Total_Cost!Jan" in a cell it results in a similar
exception:
Exception in thread "main" org.apache.poi.ss.formula.FormulaParseException:
Unused input [Jan] after attempting to parse the formula [Total_Cost Jan]
at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1573)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:176)
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Parse-intersecting-name-ranges-tp5712565p5712572.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
