Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

my libreoffice table won't sort

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
dwcronin
Asked:
dwcronin
  • 5
  • 3
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
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
 
dwcroninAuthor Commented:
Dave Baldwin: Please tell me which date has the single quote.  I don't see it.
0
 
Dave BaldwinFixer of ProblemsCommented:
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!

 
Dave BaldwinFixer of ProblemsCommented:
Why did you only give me a 'C' grade for finding your problem?
0
 
dwcroninAuthor Commented:
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
 
Dave BaldwinFixer of ProblemsCommented:
Oh, ok.  Maybe we'll get you a laser pointer...
0
 
dwcroninAuthor Commented:
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
 
Dave BaldwinFixer of ProblemsCommented:
Don't worry about then...
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now