Bug 41943 - data formats that contains spaces e.g. "# ##0" wrongly interpreted by excel
Summary: data formats that contains spaces e.g. "# ##0" wrongly interpreted by excel
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: All All
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-03-25 09:39 UTC by Marek Lewczuk
Modified: 2014-07-28 18:13 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.