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/. 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 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 -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 To: "users@global.libreoffice.org" Subject: [libreoffice-users] Writer: Sorting in a Table Date sent: Sat, 7 Jul 2018 19:42:05 + > 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 SETI109415144.657574 | EINSTEIN141194470.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
Re: [libreoffice-users] Writer: Sorting in a Table
Your suggestions have solved my problem. From: Brian Barker Sent: Saturday, July 7, 2018 3:50 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer: Sorting in a Table At 19:42 07/07/2018 +, Ted Zimmer wrote: >Microsoft Word allows sorting in a table by date, ... Microsoft Word is apparently readily available. If you prefer it, why not use it? >... but apparently LO Writer does not. This is not apparent to me. >Am I correct? I think not. >Is there a way to do it? Yup - but there are so many unknowns you will have to suck it and see. o Do you have Tools | Options... | LibreOffice Writer | Table | Input in tables | Number recognition ticked? This will affect whether data entered is interpreted as genuine dates and not just as text. Try this option if others fail for you. o Have you given relevant table cells Date number formats? o Do you have dates expressed in logical formats, such as day - month - year or year - month - day, or the (illogical) USian standard month - day - year? This may affect your ability to sort dates expressed as text, but probably not if they have been properly formatted. o What separators are you using: spaces, hyphens, dots, virgules (slashes), ...? o Is your locale set appropriately for the date format you are using? o Go to Table | Sort... . Experiment with Alphanumeric or Numeric according to what data your table cells contain. Something should work. I trust this helps. Brian Barker -- 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 -- 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
Re: [libreoffice-users] Writer: Sorting in a Table
Thank you. I'll try what you suggest, but I will become more wary about posing questions that would be considered dumb. From: Brian Barker Sent: Saturday, July 7, 2018 3:50 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer: Sorting in a Table At 19:42 07/07/2018 +, Ted Zimmer wrote: >Microsoft Word allows sorting in a table by date, ... Microsoft Word is apparently readily available. If you prefer it, why not use it? >... but apparently LO Writer does not. This is not apparent to me. >Am I correct? I think not. >Is there a way to do it? Yup - but there are so many unknowns you will have to suck it and see. o Do you have Tools | Options... | LibreOffice Writer | Table | Input in tables | Number recognition ticked? This will affect whether data entered is interpreted as genuine dates and not just as text. Try this option if others fail for you. o Have you given relevant table cells Date number formats? o Do you have dates expressed in logical formats, such as day - month - year or year - month - day, or the (illogical) USian standard month - day - year? This may affect your ability to sort dates expressed as text, but probably not if they have been properly formatted. o What separators are you using: spaces, hyphens, dots, virgules (slashes), ...? o Is your locale set appropriately for the date format you are using? o Go to Table | Sort... . Experiment with Alphanumeric or Numeric according to what data your table cells contain. Something should work. I trust this helps. Brian Barker -- 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 -- 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
Re: [libreoffice-users] Writer: Sorting in a Table
Thank you. I installed the extension, and it works, but it lacks the ability to sort dates in the format Month/Day/Year. Asking it to sort 05/24/2008 and 10/24/2008 ascending would yield 10/24/2008 then 05/24/2008 because it just sorts numerically. I realize that our typical date format Month/Day/Year is not very logical, but I'm wondering if there's an extension for Writer that would accommodate it. Thanks again. From: bo.siltb...@gmail.com on behalf of Bo Siltberg Sent: Saturday, July 7, 2018 3:27 PM To: Ted Zimmer Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Writer: Sorting in a Table Install the extension sortwritertable which can sort tables. Tools -> Extension Manager... 2018-07-07 21:42 GMT+02:00 Ted Zimmer mailto:zimpr...@hotmail.com>>: 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<mailto:users%2bunsubscr...@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 -- 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
[libreoffice-users] Writer: Sorting in a Table
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