|Summary:||data formats that contains spaces e.g. "# ##0" wrongly interpreted by excel|
|Product:||POI||Reporter:||Marek Lewczuk <marek>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
Description Marek Lewczuk 2007-03-25 09:39:12 UTC
Please create a numeric cell (with value set to e.g. 1232423 and style it with data format like this: # ##0 When you will open generated workbook (in MS Excel) you will see that the format has been modified to this: #\ ##0 The change cause that the number like -1232423 isn't formated as it should be, instead 1 232 423 we've got 1232 423 The problem doesn't exists when we open the workbook with Open Office Calc. I'm using MS Excel 2000 (Polish version).
Comment 1 Nick Burch 2010-06-03 12:43:51 UTC
Could you please create the same styling in Excel, and then check how POI sees this? Then, if you create that same format with POI in a new file, does it work properly in excel too?
Comment 2 Dominik Stadler 2014-07-28 18:13:57 UTC
No update for a long time, therefore resolving this bug for now, please reopen with the requested information based on an up-to-date version of poi.