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 46689] Numeric cell value problem
Date Wed, 11 Feb 2009 07:40:38 GMT

--- Comment #2 from Attila Szabo <kisuf@inf.elte.hu>  2009-02-10 23:40:37 PST ---
Unfortunately, the excel file that contains the problematic numbers are out of
my control as it is an input for the program. I do store ids as strings inside
my system, but no idea how to access a numeric cell input other than using
HSSFCell.getNumericCellValue() to achieve the desired 'what you see is what you
get'. (I tried to access the cell as a String but it only supported what was in
the javadoc: got an exception.)

My sweetest dream is a HSSFCell.getLongCellValue() that returns a long (maybe
rounds floating point numbers to avoid further problems). While you're working
on it ;) I will contvert the id column on the problematic rows to string by
hand in Excel (probably by exporting it to CSV to enforce string conversion, I
don't know yet. I've already tried to change the cell's type from number to
string - well let's say that Excel doesn't do the job for me).

Thanks for your answer!

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

View raw message