On Sunday 30 January 2005 14:09, G. Roderick Singleton wrote: > On Sun, 2005-01-30 at 13:27 +0100, Michel Franckart wrote: > > This bug was already present in 1.1.3. > > > > I generate a macro that inserts the date with format '31 dÃcembre 1999' > > (Insert > Fields > Other ...). > > When I launch that macro in another document, the date is replaced by a > > figure e.g. '38382.56' ! > > > > Not very important. > > > > Many thanks for your attention and, of course, for that beautiful OOo. > > > > A layman. > > > > THe default format for a Calc cell is number not date. Please fix your > macro so that it sets the cell format properly. By not doing so you get > the result you have. > Sorry, the question was not clear.
- I am working in text documents (.sxw) ; - The macro is a recorded one ; - It is meant to automatically insert the date of the day (fixed) into a document (letter). Additionally : - The 'bug' occurs when I launch the macro in a n_e_w document, not when I relaunch it inside the document where it was created. Also strangely, the figure (e.g. '38382.56') transforms into the right date format if, somewhere else in my document, I perform the same date insert manually ! Kind regards. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
