I have created bug 50756 in ASF bugzilla with the offending file.... ---------------------------------------------------------------------------- --------------
This message is private and confidential. If you have received this message in error, please notify postmas...@his.co.uk and remove it from your system. Please carry out your own virus check before opening attachments. HISL Limited is a limited company registered in England and Wales. Registered Number: 3202995. VAT number: 729-6256-05. Registered Office: Chestnut Farm, Jill Lane, Sambourne, Redditch B96 6ES ---------------------------------------------------------------------------- -------------- -----Original Message----- From: Nick Burch [mailto:nick.bu...@alfresco.com] Sent: 10 February 2011 18:24 To: POI Users List Subject: Re: Problem with OpenOffice General/GENERAL format 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 --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
