Solved

my libreoffice table won't sort

Posted on 2014-01-26
8
421 Views
Last Modified: 2014-01-31
I have a libreoffice table of books and I can't get it to sort.

I want to sort by:
1. date (YYYY-MM-DD)
2. author
3. title

How do I sort this?   I thought it was easy but it doesn't work.
listofbooks.ods
0
Comment
Question by:dwcronin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 39810630
It is easy... but you had put single quotes at the beginning of some of the Date fields.  While that will cause the cell to be formatted as 'text', that overrides the DATE formatting and changes the sorting.  Try this version.
listofbooks.ods
0
 

Author Comment

by:dwcronin
ID: 39812514
Dave Baldwin: Please tell me which date has the single quote.  I don't see it.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39812847
I removed them from the version I uploaded.  The only way to see the single quotes is in the edit bar because they don't display in the cells (which is normal behavior).  If you do a sort on column C on your original file, the ones that are out of sequence at the top of the column are the ones with the single quote.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39813438
Why did you only give me a 'C' grade for finding your problem?
0
 

Author Comment

by:dwcronin
ID: 39824398
Please tell whomever handles you grades that I've done it for the third time.  I don't use a regular mouse, I use the sensor pad on my laptop.  I was moving the mouse arrow toward the "A" and my cursor movement was AGAIN mistaken for a mouse click.  Please show this  email to whoever can change you grade.  You guys always give good answers and if you didn't, I would wait until one of you does so I wouldn't give a bad grade.  More than oneof you are always able to answer my questions.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39824761
Oh, ok.  Maybe we'll get you a laser pointer...
0
 

Author Comment

by:dwcronin
ID: 39824984
If they send me an email, like they've done before, I'll tell them to change your grade. I apologize for the error.  Like I said, a "C" is my error.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39825189
Don't worry about then...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question