Return-Path: X-Original-To: apmail-poi-user-archive@www.apache.org Delivered-To: apmail-poi-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8C7F37DD2 for ; Wed, 14 Dec 2011 01:48:19 +0000 (UTC) Received: (qmail 75954 invoked by uid 500); 14 Dec 2011 01:48:19 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 75932 invoked by uid 500); 14 Dec 2011 01:48:19 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Delivered-To: moderator for user@poi.apache.org Received: (qmail 73031 invoked by uid 99); 14 Dec 2011 01:41:28 -0000 X-ASF-Spam-Status: No, hits=4.7 required=5.0 tests=FREEMAIL_FORGED_REPLYTO,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 14919.41451.bm@omp1020.access.mail.sp2.yahoo.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1323826855; bh=ROWMYgNvuC/JbX7xHiu/yD1cekStnX+OlwdwrtrSkf0=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=iZz+zwjG47AyaExcRtP05d/qc4Vt3aS16OkMUNyMOJj+vIWQOxwKHCkrlVplZpJ8Pn2sVLp8WSmczz4a1mQZS+qq5N9uxHmyj6gOwmhO8vBLeOnnS5UeqAIv0FG9+6ksDMofblJMnUxfPVZWrwXE9Cdi21g4K+L2kes++7xe6Hw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=cz/8LjFjIl+zthd7dpStfwakDKYtT0p6KEtI9f5DyEMfaYvFO+TVrDyXBt4cUtTuUQ5BiXawI0Qlx6OpxKPOH+NEBTzF6KAyUKIb27Nv9QuLzpGu27li/uK1PGbCDJ6KChloJvYWKJhdsqYWrCER60kxgOFWIdhD27PId0JN7TE=; X-YMail-OSG: FZZzD.cVM1n36XDHJlyYWtcEmVUjiZBCX5el1W_VnlmQ3aB 9Zj.sZGCzcF9VAY6PHQ4gSFqSLG2rlm7tvsZ7eWPdMMYpo28YJdntTOoz0Af iuBy3SYvyFTM_EgmaUzqEb6KBxiMurRQlAh69Yq7aIvK4AiEVWGyuRPL63Es vmxcBM.OVIbeGxqsDDwwL.C_xeeigH3p5XoIU9DVsIB2amGj1NbOucCBntQL fZ3Psryuh3HVTTSZDS_K4FRPgif4.Q5NrszYvLGSB_ezB0_OhKZJA.UgwIQs abM0iLFr1c__xE9KO_SWkmJA5GDbHzCY1f8itBksFcJoaMVw9sHQnYfD_nrT AJqieOE3XxXRVSsCXzLuo41UPNxq_d76pTJTl1BuNziKVXtIg_tufl2zLvfP KcWYr4io9vxbdb4t9O6ydYdwY3Ap5ylN_hFDGpdnUp5xGHR3VfnHBTqg- X-Mailer: YahooMailWebService/0.8.115.331698 Message-ID: <1323826855.11589.YahooMailNeo@web180308.mail.gq1.yahoo.com> Date: Tue, 13 Dec 2011 17:40:55 -0800 (PST) From: Dhiresh Reply-To: Dhiresh Subject: DataFormat To: "user@poi.apache.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-732766476-1323826855=:11589" X-Virus-Checked: Checked by ClamAV on apache.org --0-732766476-1323826855=:11589 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0A=A0I have couple of questions regarding=A0 Data formats=0A=A0=0A=A0Fo= r a=A0 double value - I use=A0 - style.setDataFormat(df.getFormat("0"));=0A= =A0=0A=A0A positive double comes out fine but a negative double e.g. -432.4= 4444 does not format to -432=0A=A0=0AWhat is the format to represent a nega= tive double number?=0A=A0=0AI would like to know about percent as well.=A0 = I am using=A0 - style.setDataFormat(df.getFormat("0.0%")); =0Athat works we= ll for positive percentage but not for negative.=0A=A0=0AI would appreciate= any help.=0A=A0=0AThanks,=0A=A0=0ADhiresh --0-732766476-1323826855=:11589--