diff options
| author | Yegor Kozlov <yegor@apache.org> | 2009-09-10 14:02:16 +0000 |
|---|---|---|
| committer | Yegor Kozlov <yegor@apache.org> | 2009-09-10 14:02:16 +0000 |
| commit | aeca1d2e32ad06e2f1f35c305f26d0e5cafc9ca1 (patch) | |
| tree | 0a9bc8dd49ac081baa2fa17166b2c2e31e2d9535 /src | |
| parent | 595bbb574c823b3a1c94cf7100c9b53f3c3e32d6 (diff) | |
| download | poi-aeca1d2e32ad06e2f1f35c305f26d0e5cafc9ca1.tar.gz poi-aeca1d2e32ad06e2f1f35c305f26d0e5cafc9ca1.zip | |
built-in positive formats don't need starting '(', see bugzilla 47770
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@813449 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'src')
| -rwxr-xr-x | src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java | 35 |
1 files changed, 19 insertions, 16 deletions
diff --git a/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java b/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java index 433572cb3f..fdb5c99b49 100755 --- a/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java +++ b/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java @@ -30,10 +30,10 @@ import java.util.Map; * 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/> @@ -50,10 +50,10 @@ import java.util.Map; * 0x16, "m/d/yy h:mm"<br/> *<p/> * // 0x17 - 0x24 reserved for international and undocumented - * 0x25, "(#,##0_);(#,##0)"<br/> - * 0x26, "(#,##0_);[Red](#,##0)"<br/> - * 0x27, "(#,##0.00_);(#,##0.00)"<br/> - * 0x28, "(#,##0.00_);[Red](#,##0.00)"<br/> + * 0x25, "#,##0_);(#,##0)"<br/> + * 0x26, "#,##0_);[Red](#,##0)"<br/> + * 0x27, "#,##0.00_);(#,##0.00)"<br/> + * 0x28, "#,##0.00_);[Red](#,##0.00)"<br/> * 0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"<br/> * 0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"<br/> * 0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"<br/> @@ -67,6 +67,9 @@ import java.util.Map; * <p/> * * @author Yegor Kozlov + * + * Modified 6/17/09 by Stanislav Shor - positive formats don't need starting '(' + * */ public final class BuiltinFormats { /** @@ -83,10 +86,10 @@ public final class BuiltinFormats { putFormat(m, 2, "0.00"); putFormat(m, 3, "#,##0"); putFormat(m, 4, "#,##0.00"); - putFormat(m, 5, "($#,##0_);($#,##0)"); - putFormat(m, 6, "($#,##0_);[Red]($#,##0)"); - putFormat(m, 7, "($#,##0.00);($#,##0.00)"); - putFormat(m, 8, "($#,##0.00_);[Red]($#,##0.00)"); + putFormat(m, 5, "$#,##0_);($#,##0)"); + putFormat(m, 6, "$#,##0_);[Red]($#,##0)"); + putFormat(m, 7, "$#,##0.00_);($#,##0.00)"); + putFormat(m, 8, "$#,##0.00_);[Red]($#,##0.00)"); putFormat(m, 9, "0%"); putFormat(m, 0xa, "0.00%"); putFormat(m, 0xb, "0.00E+00"); @@ -108,10 +111,10 @@ public final class BuiltinFormats { putFormat(m, i, "reserved-0x" + Integer.toHexString(i)); } - putFormat(m, 0x25, "(#,##0_);(#,##0)"); - putFormat(m, 0x26, "(#,##0_);[Red](#,##0)"); - putFormat(m, 0x27, "(#,##0.00_);(#,##0.00)"); - putFormat(m, 0x28, "(#,##0.00_);[Red](#,##0.00)"); + putFormat(m, 0x25, "#,##0_);(#,##0)"); + putFormat(m, 0x26, "#,##0_);[Red](#,##0)"); + putFormat(m, 0x27, "#,##0.00_);(#,##0.00)"); + putFormat(m, 0x28, "#,##0.00_);[Red](#,##0.00)"); putFormat(m, 0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"); putFormat(m, 0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"); putFormat(m, 0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"); |