Re: [libreoffice-users] Writer: Sorting in a Table

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 <msetzerii@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 <zimprint@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+unsubscribe@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:mikes@guam.net
 mailto:msetzerii@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+unsubscribe@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