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