Libre office 3.6.4 Calc sorts column labels into data

answered 2012-09-16 12:38:14 +0200

Jean-Baptiste FAURE
957 ● 6 ● 15

Known bug: https://bugs.freedesktop.org/show_bug.cgi?id=54160 Workaround:

1. do not select the entire sheet but only the columns you want to sort.
2. all sorted columns must have a header if one column has a header

answered 2012-09-16 08:38:24 +0200

jeffmcneill
1

I've got the same problem. I know how to use sort, but it is broken. I just moved from OpenOffice.org over to Libre Office. I think I made a mistake. I'm using LO 3.6.1.2.

answered 2012-09-12 02:25:44 +0200

ehansen
408 ● 3 ● 9
http://www.rosetta.no/

I am pretty sure this is a bug.

Checking "Range contains column labels" makes it possible to use those labels in the drop down of which columns we want to sort by.

But there is no reason that the column label row should be sorted in with the regular rows.

answered 2012-09-06 21:06:44 +0200

RobC
1

I experience this same issue on 3.6.0.4 for Windows. I don't understand the other answer offered. Isn't the top-most row of the selection used as the column label? Either way, my column labels are in row 1 and it does not matter if I select a range of cells or select all. The column labels are still sorted into the data.

answered 2012-09-01 10:16:26 +0200

vsfoote
314 ● 1 ● 2 ● 10

updated 2012-09-01 11:10:10 +0200

Make the Select All (<ctl>+A) selection first, and then in Calc menus select the Data -> Sort -> Options -- "Range contains column labels" check box.

Here is the key: Column labels are not limited to Row 1, just the first row of the selected range of cells.

So, within a spreadsheet "Range contains column labels" for sorting is determined when working with a selected Ranges of cells, and again is independently determined when using the Select All. They use the same options checkbox for Column labels, but function differently, e.g. Select All is a unique set, but multiple ranges of selected cells can be sorted (and need to identify if they have column labels).

Within a spreadsheet, once set the Select All setting is statefull and remembered. But as you establish additional selected ranges you need to set sort option if "Range contains column labels" for each new range. And each spreadsheet can have multiple working ranges defined and saved with it.

The "Contains column labels" for each range of cells and the Select All case can be independently toggled.

Column label value is unchecked by default for a new spreadsheet, for the Select All case, and for each new range. Have to be careful about what range of cells or if Select All is selected for the sort operation.