You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2007/03/25 18:39:12 UTC
DO NOT REPLY [Bug 41943] New: - data formats that contains spaces e.g. "# ##0" wrongly interpreted by excel
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41943>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41943
Summary: data formats that contains spaces e.g. "# ##0" wrongly
interpreted by excel
Product: POI
Version: 3.0-dev
Platform: All
OS/Version: All
Status: NEW
Severity: major
Priority: P2
Component: HSSF
AssignedTo: poi-dev@jakarta.apache.org
ReportedBy: marek@lewczuk.com
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).
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/