On Thu, 10 Feb 2011, John Francis wrote:
When I read numbers with org.apache.poi.ss.usermodel.DataFormatter (from poi-src-3.7-20101029.zip) which are shown as formatted with Format code General I get them returned in decimal format, even when they are shown as Integers. i.e. the old 12 being passed back as 12.0. I tracked the problem down to what is returned as the cell.getCellStyle().getDataFormatString() in the private Format getFormat(Cell cell) of the DataFormatter class. This returns "GENERAL" not "General" for some reason (OpenOffice seems to have changed it)
Any chance you could create a new bug in bugzilla, and upload one of these problematic files? We'll want to use a file like that in any future bugfix
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
