Solved

my libreoffice table won't sort

Posted on 2014-01-26
8
383 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
  • 5
  • 3
8 Comments
 
LVL 82

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 82

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
 
LVL 82

Expert Comment

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

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

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 82

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 82

Expert Comment

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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In  today’s increasingly digital world, managed service providers (MSPs) fight for their customers’ attention, looking for ways to make them stay and purchase more services. One way to encourage that behavior is to develop a dependable brand of prod…
We have come a long way with backup and data protection — from backing up to floppies, external drives, CDs, Blu-ray, flash drives, SSD drives, and now to the cloud.
Viewers will learn how to apply various conditional formatting in Excel 2013.
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.

706 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now