You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Karl-Heinz Zengerle <ka...@sawag.com> on 2004/03/03 15:31:10 UTC

non-built-in date format

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

___________________________________________________

AW: non-built-in date format

Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
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

Re: non-built-in date format

Posted by Tim Wilkins <ti...@mediatel.co.uk>.
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