ASF Bugzilla – Attachment 23155 Details for
Bug 41478
HSSFDataFormat builtin values are wrong
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
Please apply the proposed patch
HSSFDataFormat-patch.txt (text/plain), 3.14 KB, created by
Dmitriy Kumshayev
on 2009-01-21 21:43:22 UTC
(
hide
)
Description:
Please apply the proposed patch
Filename:
MIME Type:
Creator:
Dmitriy Kumshayev
Created:
2009-01-21 21:43:22 UTC
Size:
3.14 KB
patch
obsolete
>### Eclipse Workspace Patch 1.0 >#P poi >Index: src/java/org/apache/poi/hssf/usermodel/HSSFDataFormat.java >=================================================================== >--- src/java/org/apache/poi/hssf/usermodel/HSSFDataFormat.java (revision 736562) >+++ src/java/org/apache/poi/hssf/usermodel/HSSFDataFormat.java (working copy) >@@ -41,10 +41,10 @@ > * 2, "0.00"<br> > * 3, "#,##0"<br> > * 4, "#,##0.00"<br> >- * 5, "($#,##0_);($#,##0)"<br> >- * 6, "($#,##0_);[Red]($#,##0)"<br> >- * 7, "($#,##0.00);($#,##0.00)"<br> >- * 8, "($#,##0.00_);[Red]($#,##0.00)"<br> >+ * 5, "_($#,##0_);($#,##0)"<br> >+ * 6, "_($#,##0_);[Red]($#,##0)"<br> >+ * 7, "_($#,##0.00);($#,##0.00)"<br> >+ * 8, "_($#,##0.00_);[Red]($#,##0.00)"<br> > * 9, "0%"<br> > * 0xa, "0.00%"<br> > * 0xb, "0.00E+00"<br> >@@ -61,10 +61,10 @@ > * 0x16, "m/d/yy h:mm"<br> > *<P> > * // 0x17 - 0x24 reserved for international and undocumented >- * 0x25, "(#,##0_);(#,##0)"<P> >- * 0x26, "(#,##0_);[Red](#,##0)"<P> >- * 0x27, "(#,##0.00_);(#,##0.00)"<P> >- * 0x28, "(#,##0.00_);[Red](#,##0.00)"<P> >+ * 0x25, "_(#,##0_);(#,##0)"<P> >+ * 0x26, "_(#,##0_);[Red](#,##0)"<P> >+ * 0x27, "_(#,##0.00_);(#,##0.00)"<P> >+ * 0x28, "_(#,##0.00_);[Red](#,##0.00)"<P> > * 0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"<P> > * 0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"<P> > * 0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"<P> >@@ -120,10 +120,10 @@ > builtinFormats.add( 2, "0.00" ); > builtinFormats.add( 3, "#,##0" ); > builtinFormats.add( 4, "#,##0.00" ); >- builtinFormats.add( 5, "($#,##0_);($#,##0)" ); >- builtinFormats.add( 6, "($#,##0_);[Red]($#,##0)" ); >- builtinFormats.add( 7, "($#,##0.00);($#,##0.00)" ); >- builtinFormats.add( 8, "($#,##0.00_);[Red]($#,##0.00)" ); >+ builtinFormats.add( 5, "_($#,##0_);($#,##0)" ); >+ builtinFormats.add( 6, "_($#,##0_);[Red]($#,##0)" ); >+ builtinFormats.add( 7, "_($#,##0.00);($#,##0.00)" ); >+ builtinFormats.add( 8, "_($#,##0.00_);[Red]($#,##0.00)" ); > builtinFormats.add( 9, "0%" ); > builtinFormats.add( 0xa, "0.00%" ); > builtinFormats.add( 0xb, "0.00E+00" ); >@@ -156,10 +156,10 @@ > builtinFormats.add( 0x24, "0x24" ); > > // 0x17 - 0x24 reserved for international and undocumented >- builtinFormats.add( 0x25, "(#,##0_);(#,##0)" ); >- builtinFormats.add( 0x26, "(#,##0_);[Red](#,##0)" ); >- builtinFormats.add( 0x27, "(#,##0.00_);(#,##0.00)" ); >- builtinFormats.add( 0x28, "(#,##0.00_);[Red](#,##0.00)" ); >+ builtinFormats.add( 0x25, "_(#,##0_);(#,##0)" ); >+ builtinFormats.add( 0x26, "_(#,##0_);[Red](#,##0)" ); >+ builtinFormats.add( 0x27, "_(#,##0.00_);(#,##0.00)" ); >+ builtinFormats.add( 0x28, "_(#,##0.00_);[Red](#,##0.00)" ); > builtinFormats.add( 0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)" ); > builtinFormats.add( 0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)" ); > builtinFormats.add( 0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)" );
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 41478
: 23155