2009/10/13 Peter Hillier-Brook <[email protected]>: > 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
Hello Peter The Table toolbar in OOo 3.1.1 on Mac gives me the following icons: Add Table / Border Style / Border Color / Borders / Background / Join Cells / Split Cells / Optimise Align Top / Center / Bottom / Add Row / Column / Delete Row / Column / Format / Properties / Sort / Sum The Properties window has Table / Text Flow / Columns / Borders / Background I see nowhere where I could define a Date format... So I don't see how to solve Erling's (OP) problem -- Guy --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
