DO NOT REPLY [Bug 39998] Conversion of numbers while reading through HSSF

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=39998

--- Comment #4 from Himanshu <hi...@rs-components.com> 2009-11-24 08:55:02 UTC ---
Could you please paste a sample code to get the value displayed in Excel not
what and how it is stored internally in Excel.

I believe everyone is more interested in getting the same data as they see
while opening the Excel document, not to go in the details of how Excel stores
it (Text as numeric etc..)

If we have to do all of this again on each data type, It would be unnecessary
piece of additional code that needs to be written when using apache poi
library.

for example: If I as a user created an excel file and placed "222" as a value,
what I wish from the library is to give me "222" and not "222.0" or something
else based on how excel stores it internally.

The place where I had to use this to simply read the excel file and display
them as a grid on the UI for user. Which when using Jexcel-API was displayed
correctly (I am not sure what and how they display data, but this was what most
of us are interested and expected) However when to support Excel 2007 document,
I started playing with Apache POI I am stuck at the very first moment in
reading the correct data.
(Don't you think checking each column here for cell data type and converting to
appropriate value for each column would be a pain and additional unnecessary
code.)

I do not understand why you being so ignorant in realizing the problems and
seems more interested in discarding them.

I hope you will realize the issue and will provide some sort of easy solution.

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