Hi Shawn. Which chapter do you mean? Before I was posting this question I was already looking quite carefully at all these examples. Now with even 3 times looking at it I still can't see it.
Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Laubach Shawn Contr OC-ALC/PSB [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 3. M�rz 2004 17:08 An: POI Users List Betreff: RE: non-built-in date format 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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
