Return-Path: Delivered-To: apmail-poi-commits-archive@minotaur.apache.org Received: (qmail 81548 invoked from network); 10 Sep 2009 14:02:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Sep 2009 14:02:41 -0000 Received: (qmail 29812 invoked by uid 500); 10 Sep 2009 14:02:41 -0000 Delivered-To: apmail-poi-commits-archive@poi.apache.org Received: (qmail 29776 invoked by uid 500); 10 Sep 2009 14:02:41 -0000 Mailing-List: contact commits-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@poi.apache.org Delivered-To: mailing list commits@poi.apache.org Received: (qmail 29767 invoked by uid 99); 10 Sep 2009 14:02:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Sep 2009 14:02:41 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Sep 2009 14:02:37 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id DFFC023888E7; Thu, 10 Sep 2009 14:02:16 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r813449 - /poi/trunk/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java Date: Thu, 10 Sep 2009 14:02:16 -0000 To: commits@poi.apache.org From: yegor@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20090910140216.DFFC023888E7@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org 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"
* 3, "#,##0"
* 4, "#,##0.00"
- * 5, "($#,##0_);($#,##0)"
- * 6, "($#,##0_);[Red]($#,##0)"
- * 7, "($#,##0.00);($#,##0.00)"
- * 8, "($#,##0.00_);[Red]($#,##0.00)"
+ * 5, "$#,##0_);($#,##0)"
+ * 6, "$#,##0_);[Red]($#,##0)"
+ * 7, "$#,##0.00);($#,##0.00)"
+ * 8, "$#,##0.00_);[Red]($#,##0.00)"
* 9, "0%"
* 0xa, "0.00%"
* 0xb, "0.00E+00"
@@ -50,10 +50,10 @@ * 0x16, "m/d/yy h:mm"
*

* // 0x17 - 0x24 reserved for international and undocumented - * 0x25, "(#,##0_);(#,##0)"
- * 0x26, "(#,##0_);[Red](#,##0)"
- * 0x27, "(#,##0.00_);(#,##0.00)"
- * 0x28, "(#,##0.00_);[Red](#,##0.00)"
+ * 0x25, "#,##0_);(#,##0)"
+ * 0x26, "#,##0_);[Red](#,##0)"
+ * 0x27, "#,##0.00_);(#,##0.00)"
+ * 0x28, "#,##0.00_);[Red](#,##0.00)"
* 0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"
* 0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"
* 0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"
@@ -67,6 +67,9 @@ *

* * @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