Thank you for your help. Just to be clear: If I type in the formula as "=SUM((Total_Cost!Jan):(Total_Cost!Apr_))" I get the right result in Excel but an exception if i try to parse it wit POI.
With comma in stead of colon i receive an Err:508 in Excel. if I only type "=Total_Cost!Jan" it works in Excel but the POI throws an exception. I can send you the file if you want... (Excel in my case is LibreOffice Calculater on Ubuntu but I've tried it also with MS Excel today -> same result.) -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Parse-intersecting-name-ranges-tp5712565p5712575.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]
