Solved

my libreoffice table won't sort

Posted on 2014-01-26
8
411 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

Technology Partners: 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

Suggested Solutions

Title # Comments Views Activity
Excel - Weightage 3 121
To array or not to array 11 75
Conditional formatting based on another column not containing a specific word (Excel) 5 37
If condition and Date Ranges 13 44
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Video by: Zack
Viewers will learn about using Excel in a browser with Excel Online.
Viewers will learn the basics about Excel 2013’s new Flash Fill feature.

762 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