Return-Path: 
 <poi-user-return-7226-apmail-jakarta-poi-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org
Received: (qmail 37572 invoked from network); 21 Sep 2005 23:50:43 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 21 Sep 2005 23:50:43 -0000
Received: (qmail 34187 invoked by uid 500); 21 Sep 2005 23:50:42 -0000
Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org
Received: (qmail 33664 invoked by uid 500); 21 Sep 2005 23:50:41 -0000
Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:poi-user-unsubscribe@jakarta.apache.org>
List-Help: <mailto:poi-user-help@jakarta.apache.org>
List-Post: <mailto:poi-user@jakarta.apache.org>
List-Id: "POI Users List" <poi-user.jakarta.apache.org>
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
Delivered-To: mailing list poi-user@jakarta.apache.org
Received: (qmail 33650 invoked by uid 99); 21 Sep 2005 23:50:41 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Sep 2005 16:50:41 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [144.203.11.1] (HELO halon.barra.com) (144.203.11.1)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Sep 2005 16:50:47 -0700
Received: from royer.barra.com (royer [144.203.13.201])
	by halon.barra.com (8.12.10/8.12.10/(v1.1 barra.com  )) with ESMTP id
 j8LNm482015589
	for <poi-user@jakarta.apache.org>; Wed, 21 Sep 2005 16:48:04 -0700 (PDT)
Received: from rhea.win.barra.com (exchangebrk.barra.com [144.203.4.27])
	by royer.barra.com (8.11.1/8.11.1/royer.mc) with ESMTP id j8LNoHX16373
	for <poi-user@jakarta.apache.org>; Wed, 21 Sep 2005 16:50:17 -0700 (PDT)
Received: by exchangebrk.barra.com with Internet Mail Service (5.5.2653.19)
	id <M9RFMSNB>; Wed, 21 Sep 2005 16:50:17 -0700
Message-ID: <AA1E1F7FC9E1124F999E37BFA1DD34470D34B807@iris.win.barra.com>
From: Shuli Zhou/schedule <shuli.zhou@Barra.COM>
To: "'poi-user@jakarta.apache.org'" <poi-user@jakarta.apache.org>
Subject: date cell as date type instead of custom type
Date: Wed, 21 Sep 2005 16:50:07 -0700
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi,

We use the package to generate Excel files. When loading the generated files
in Excel, all date cells have custom format not date format. Even if they
look exactly the same in Excel, we have problems later using another
software to read those date cells. That software expects them to be of date
type not custom type. Is there a way to make date cell as date type using
POI?

Here is the how the cell style is set:
	short formatIx = this.dataFormat.getFormat(desc.format);
      s.setDataFormat(formatIx);

this.dataFormat is of HSSFDataFormat
s is of HSSFCellStyle.

Thanks.
Shirley

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/