Folks, The problem was that the initial spread sheet was in *.csv format. When I edited it to get the 24 hr option (and other things) and saved it back to the output file in *.csv format, the time was in AM/PM format w/o the pop up screen appearing.
If I first saved it to a *.sxc format and re-saved to *.csv, the option was available. It would be neat if the pop up screen was available on the *.csv -> *.csv formating. Preferably I would rather the "Save cell contents as shown" was the default. Bob Stanfield > Robert Stanfield wrote: >> Folks, >> >> How do I output from OO V 3.2 time in 24 hour format to a text or csv >> file? >> >> Specifically, I need to be able to output to a *.csv file time in 24 hr >> format for later sorting. (I have a need to simply sort a text file in a >> variety of ways, time being one of them.) > > First Format the column(cells) to Time 00:00. Sort the rows on the time > column. File> Save-As for File type select Text CVS (.cvs). Before it > saves the file a dialog pops-up that says Export of text files. Near > the bottom is a check box that says Save cell contents as shown. Check > that and you should see the same format and sorting as the spreadsheet. > >> This was possible in past version, but something happened recently that >> prevents this. I find it disturbing that Open Office programmers have >> taken upon themselves to make these kinds of decisions on behalf of >> users. >> If this is an option, the user must be given an obvious option to opt >> out. > > Sees to still be available but not as one option. > >> For the record, I would also like to suggest that an option to format >> date >> as YY/MM/DD or YYYY/MM/DD would be valuable. (It sorts simply.) > > Standard ISO 8601 is available at Format> Cells> Numbers> Date, you have > to scroll down to see it but its there. > > HTH > Andy > > --------------------------------------------------------------------- > To unsubscribe, e-mail: discuss-unsubscr...@openoffice.org > For additional commands, e-mail: discuss-h...@openoffice.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscr...@openoffice.org For additional commands, e-mail: discuss-h...@openoffice.org
