Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.