it looks like evaluation of tables names is not yet supported. Can you create a new bug in Bugzilla and attach sample workbook and Java code that results in exception?
Yegor On Thu, Aug 2, 2012 at 10:44 AM, saritha suram <[email protected]> wrote: > Hi, > I am working on a XSSF excel sheet, whose values are to be read and > displayed on the UI. > The cells in the sheet are evaluated using formulas and they also use "table > names" in them. > POI is unable to evaluate the formulas where there occurs a table name and > am getting the below error: > > Formula is : IF(ValidationCheck=FALSE,IF(HAOption="Yes",Table28[[#This > Row],[/ DAG]]*calcNumDAGs,TotDBDiskSpaceReq*numMBXServers),"--") > > Error is: Exception in thread "main" > org.apache.poi.ss.formula.FormulaParseException: Specified named range > 'Table28' does not exist in the current workbook. > > Any help would be greatly appreciated. > > Thanks in advance, > Saritha > > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Apache-POI-not-able-to-evaluate-table-names-in-the-Excel-Sheet-tp5710583.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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
