Guy Voets wrote:
2009/10/12 AG <[email protected]>:
Peter Hillier-Brook wrote:
Erling Larsen wrote:
I have a writer-document made up with a table.
In one column i write the date in Swedish format (Y-M-D) or Danish
(D-M-Y) e.g. today is 091009 in both.
My problem is, that the leading zero disappears.
I have tried different formatting, but with no luck.
Can somebody help??
I hope I haven't misunderstood your question, but have you set the number
format in your table to 'Date' and the layout you require? I've just created
a table with number format set to 'Date' and format code set to "DD-MM-YY"
and "YY-MM-DD" and leading zeros are preserved in both cases. This is of
course with OO.o 3.1.1 under Windows. It's also the same with Linux.
Peter HB
Ditto here with Debian running OOo3.1.1. Interesting thing is that when I
do this when document is saved as a *.odt extension, DD-MM-YY and MM-DD-YY
both throw back the following formatting: DD/MM/YY and MM/DD/YY But - when
YY-MM-DD is used, the formatting is retained as YY-MM-DD. This doesn't
happen when the same document is then saved as a Win XP *.doc format and
edited. Is this OOo's approach to trying to preserve as much of the default
MS Word formatting as possible, so will over-ride the ODT formatting rules
in favor of the MS formatting?
Anyway, bottom line. The date formatting seems to work here too.
Hello,
Here on a Mac with 3.1.1, I don't see where I can define a date format
in a Writer Table...
I don't know Macs, but I would expect that you have a menu bar and that
an analogue of the 'Table' entry is available. Somewhere under that menu
should be "Number format...", or an identifiable equivalent.
Peter HB
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
