| Summary: | unable to read value as seen in a cell. | ||
|---|---|---|---|
| Product: | POI | Reporter: | rupesh <r_bhujbal> |
| Component: | XSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED INVALID | ||
| Severity: | normal | ||
| Priority: | P2 | ||
| Version: | 3.7-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | All | ||
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 |
Hello 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. Thanks Rupesh