Thank you. I had not realized that I could set the numeric format to date in the form MM/DD/YYYY. When I do that and then sort using the regular numeric sort function (not the extension), it seems to work fine. Thanks to you and everyone for the help. ________________________________ From: Michael D. Setzer II <msetze...@gmail.com> Sent: Saturday, July 7, 2018 11:01 PM To: Ted Zimmer; users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer: Sorting in a Table
Did a test with the extention. Pasted 7 columns of a spreadsheet I have with a date column as the 7th column with paste special as html format. The sort extention then does sort the date field by the month, but if you highlight the date column, and set the numeric format to yy-mm-dd or yyyy-mm-dd, then the sort operation works correctly. After the sort, one can then reset the format to whatever one wants. Not sure if it works with other setups, but that does seem to work fine. On 7 Jul 2018 at 19:42, Ted Zimmer wrote: From: Ted Zimmer <zimpr...@hotmail.com> To: "users@global.libreoffice.org" <users@global.libreoffice.org> Subject: [libreoffice-users] Writer: Sorting in a Table Date sent: Sat, 7 Jul 2018 19:42:05 +0000 > Microsoft Word allows sorting in a table by date, but apparently LO Writer > does not. Am I correct? Is there a way to do it? > Ted > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65598715.744551 | ABC 16613838.513356 SETI 109415144.657574 | EINSTEIN 141194470.499240 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
