Bug 53106 - unable to read value as seen in a cell.
Summary: unable to read value as seen in a cell.
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.7-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2012-04-19 10:42 UTC by rupesh
Modified: 2012-04-19 11:12 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description rupesh 2012-04-19 10:42:25 UTC
        I have a cell, formatted as Category :custom and type : is 0000000000
     suppose i put value 15.6 in cell it shows me 0000000016
     as the cell is formatted that OK.
               But if I read that cell Its type shows Numeric not formula type.
     so its give me Out put 15.6 , but as I expect it should be 0000000016.   
     Is it possible to read that cell with Out put as 0000000016 ?
     If yes how can i read it.
     Please help.

Comment 1 Nick Burch 2012-04-19 11:12:54 UTC
This is all exactly as expected

Use things like DataFormatter if you want to get back a String that looks as your number is formatted in Excel