Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2014-09-22 02:36:55 +0200

ROSt52 gravatar image

First of all be assured sorting works. I sort often on an XP machine and sometimes on MacBookPro using in both cases LibO 4.2.6.2

I don't know if you are using names for each column and if you have gaps in your table. Therefore what follows should be on the safe side to ensure it works for you as well.

Writer Table:
- select the entire table
- Table > sort > key 1 is checked by default > select column 2 > select key type: numeric > select order: descending > click OK

Calc Table:
- select entire table
- Data > sort > sort key 1: select your 2nd column > select descending . click OK

If this doesn't work, I assume you have a mismatch of formats, this means that some of the number you see are not only looking like number but are in text format. In this case, make sure that all number like looking cell contents are formated as numbers.

I also recommend to read the free of charge manual, which you can download from here: http://www.libreoffice.org/get-help/documentation/

First of all be assured sorting works. I sort often on an XP machine and sometimes on MacBookPro using in both cases LibO 4.2.6.2

I don't know if you are using names for each column and if you have gaps in your table. Therefore what follows should be on the safe side to ensure it works for you as well.

Writer Table:
- select the entire table
- Table > sort > key 1 is checked by default > select column 2 > select key type: numeric > select order: descending > click OK

Calc Table:
- select the entire table
- Data > sort > sort key 1: select your 2nd column > select descending . > click OK

If this doesn't work, I assume you have a mismatch of formats, this means that some of the number you see are not only looking like number but are in text format. In this case, make sure that all number like looking cell contents are formated as numbers.

I also recommend to read the free of charge manual, which you can download from here: http://www.libreoffice.org/get-help/documentation/