Solved

my libreoffice table won't sort

Posted on 2014-01-26
8
387 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 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
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39813438
Why did you only give me a 'C' grade for finding your problem?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Customer Filter on Text file 4 36
Question to Java runtime 10 148
LARGE INDEX formula 3 73
Excel userform vba code to edit and delete 20 107
Note: This is the second blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   Every month t…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Viewers will learn how to find and create templates in Excel 2013.
Viewers will learn the basics about Excel 2013’s new Flash Fill feature.

910 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

21 Experts available now in Live!

Get 1:1 Help Now