You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ye...@apache.org on 2009/09/10 16:02:16 UTC
svn commit: r813449 -
/poi/trunk/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java
Author: yegor
Date: Thu Sep 10 14:02:16 2009
New Revision: 813449
URL: http://svn.apache.org/viewvc?rev=813449&view=rev
Log:
built-in positive formats don't need starting '(', see bugzilla 47770
Modified:
poi/trunk/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java
Modified: poi/trunk/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java?rev=813449&r1=813448&r2=813449&view=diff
==============================================================================
--- poi/trunk/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java (original)
+++ poi/trunk/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java Thu Sep 10 14:02:16 2009
@@ -30,10 +30,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/>
@@ -50,10 +50,10 @@
* 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 @@
* <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 @@
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 @@
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);_(*\"-\"??_);_(@_)");
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org