poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 48140] New: Cannot get a numeric value from a text cell
Date Thu, 05 Nov 2009 16:42:57 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=48140

           Summary: Cannot get a numeric value from a text cell
           Product: POI
           Version: 3.5-FINAL
          Platform: PC
        OS/Version: Windows Vista
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: michel.jung89@gmail.com


Created an attachment (id=24490)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24490)
The file I try to read

I have a column with a lot of numbers (for instance 1253323, 275527, ... ) and
try to get them using getNumericCellValue(). It throws an exception for each
row:

java.lang.IllegalStateException: Cannot get a numeric value from a text cell

Of course I already checked for the correct value:

Could not convert "2844922" from row 575: java.lang.IllegalStateException:
Cannot get a numeric value from a text cell


There is no problem with getNumericCellValue() in other two rows where I have
values like 0.50625, 0.75, 50 .

I've already tried to set the cell's format to "numeric" (or however it's
called in the english excel). No success.

I hope it's not my fault...

-- 
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


Mime
View raw message