https://issues.apache.org/bugzilla/show_bug.cgi?id=39998
--- Comment #4 from Himanshu <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
