Bug 41943

Summary: data formats that contains spaces e.g. "# ##0" wrongly interpreted by excel
Product: POI Reporter: Marek Lewczuk <marek>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WORKSFORME    
Severity: major    
Priority: P2    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: All   
OS: All   

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.