Can I just check please, are the two sheets in the same Excel workbook? Further, the named cell does exist, ny this, I mean that the name is spelled correctly in the forumla and that there is a cell on the sheet with that exact name?
Tonight, I should have the chance to play with some code so I will see if I can replicate the problem. Yours Mark B Bugzilla from [email protected] wrote: > > https://issues.apache.org/bugzilla/show_bug.cgi?id=49612 > > Summary: problem in reading Named cells > Product: POI > Version: 3.6 > Platform: PC > OS/Version: Windows XP > Status: NEW > Severity: normal > Priority: P2 > Component: POI Overall > AssignedTo: [email protected] > ReportedBy: [email protected] > > > hi, > I have facing an issue in reading excel sheets though poi. > > within sheet1 lets A8 is denoted by some_name.when i try to read > this as 'sheet1'!some_name within sheet2 in any cell then this > > cell type changes to > > org.apache.poi.hssf.record.formula.eval.NameXEval and value > > return is null > > while 'sheet1'!A8 work fine and in this case the type of cell is > > org.apache.poi.hssf.record.formula.eval.NumberEval > > > due this all the formulas are getting fail which has > > 'sheet1'!some_name. and throws exceltion > Unexcepted eval type > > (org.apache.poi.hssf.record.formula.eval.NameXEval) > > can you plz, help me > > Thanks > ranvijay > > -- > 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] > > > -- View this message in context: http://old.nabble.com/DO-NOT-REPLY--Bug-49612--New%3A-problem-in-reading-Named-cells-tp29201508p29202268.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
