poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: DO NOT REPLY [Bug 49612] New: problem in reading Named cells
Date Mon, 19 Jul 2010 08:01:34 GMT

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 bugzilla@apache.org 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: dev@poi.apache.org
>         ReportedBy: ranvijayps@gmail.com
> 
> 
> 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: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
> 
> 
> 

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message