poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Laubach Shawn Contr OC-ALC/PSB <Shawn.Laub...@tinker.af.mil>
Subject RE: non-built-in date format
Date Wed, 03 Mar 2004 16:07:50 GMT
Yes.  If you look at
http://jakarta.apache.org/poi/hssf/quick-guide.html#DataFormats you can see
an example of setting a style of custom formats.

-----Original Message-----
From: Karl-Heinz Zengerle [mailto:karl-heinz.zengerle@sawag.com] 
Sent: Wednesday, March 03, 2004 9:34 AM
To: 'POI Users List'
Subject: AW: non-built-in date format

Hi Tim.

Unfortunately we can't assume that. We import Excel files in a variable
way to database table and also export them in a variable way. Thus we
can't know where which datatype comes (resulting in a special format in
Excel).

But I've the following idea:
Is it possible to query that special format (Let's say an empty cell
will be formatted like this) and use that queried format for another
cell?

Regards,	Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: Tim Wilkins [mailto:timw@mediatel.co.uk] 
Gesendet: Mittwoch, 3. März 2004 16:07
An: POI Users List
Betreff: Re: non-built-in date format

In Excel use the "Custom Format" option under the cell properties (I'm 
assuming you are using a template to specify format). You can create 
your own custom date formats there.

I managed to get your format working in my spreadsheet by doing this :)

Karl-Heinz Zengerle wrote:

> Hi world.
>
> How can I output a date in the format "dd.MM.yyyy" to a cell? 
> According to the documentation this isn't a built-in-format.
>
> With another format it's already running fine but I'm sure that users 
> don't want to see that notation.
>
> MfG
>
> Karl-Heinz Zengerle
>
> ___________________________________________________
>
> */More than competence in Document Management/**/
> /*___________________________________________________
>
> SAW AG
> Waldmünchenerstr. 12
> 81549 München
> Tel.: ++49-89-68088368
> Fax: ++49-89-68088389
> www.sawag.com <http://www.sawag.com>
>
> 	
>
> ___________________________________________________
>



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message