2009/10/13 Peter Hillier-Brook <[email protected]>: > Guy Voets wrote: >> >> 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, > > I was referring to the 'Table' entry on the main Menu bar. The one that on > Linux and Windows has 'File', 'Edit', 'View' ..., 'Table' values. > > Peter HB
Thanks Peter, I overlooked that one, and I suppose it would also solve the OP's problem... -- Guy --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
