Ask Your Question

Cannot sort table in libreoffice [closed]

asked 2019-01-02 01:45:42 +0200

cosmikron gravatar image

updated 2019-01-02 01:47:08 +0200

I've been using libreoffice for several years and suddenly I cannot sort a table created in a libreoffice document. When I attempt to effect a sort operation, I receive cannot sort selection error message. I select the entire document with select all command and sort in ascending order by rows. I've attempted to isolate the problem in the table by selecting different parts of the table thinking there is something wrong with a cell. This technique proved to be inconclusive since sometimes I received the error when sorting parts of the table and sometimes I didn't. I've tried copying the entire document into a new document, but same error occurs.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by ebot
close date 2019-01-24 06:33:36.201493


Which OS and LO_Version do you use?

ebot gravatar imageebot ( 2019-01-02 08:38:42 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-01-02 19:15:14 +0200

cosmikron gravatar image

updated 2019-01-23 22:58:55 +0200

I have sorted this table many times without receiving this error: cannot sort selection
All my successful and currently unsuccessful sorts were done with the appropriate cells/rows/columns marked by selecting the top row of cells and then choosing the Select All under the File Menu. This operation always marks the entire table currently and in the past. I'm sure there's a user error on my side, but I haven't recently done anything recently related to the table except to add some additional rows. The table is about 45 pages. Thinking I was selecting something outside the table between cells, I checked for open spaces between the cell rows and there were none.


Added additional information about my table sorting problem with solution found below dtd 10/23/2019: I found my problem by sorting blocks of the table until I found the row that was preventing me from sorting the table. It turns out that I had inadvertently split a cell in one row making this row of cells have three columns instead of the two columns found in all other rows of the table.

edit flag offensive delete link more

answered 2019-01-02 08:36:27 +0200

ebot gravatar image

If you want to sort the table, you must also mark the table and not the document.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2019-01-02 01:45:42 +0200

Seen: 75 times

Last updated: Jan 23