Description: The default sorting order in Calc is often left to right (sort columns) which is very unnatural: usually columns in tables represent categories and not objects. Steps to Reproduce: 1. Create a spreadsheet with several columns of data. The first column and the first row must contain text data, other values can be text or numerical. 2. Select the table and click Sort. 3. Click Options. 4. Look at the default sorting order in the bottom of the options tab. Actual Results: Different sorting orders depending on contents. Expected Results: Top to bottom (sort rows) always. Reproducible: Always User Profile Reset: No Additional Info: Version: 6.4.1.2 (x64) Build ID: 4d224e95b98b138af42a64d84056446d09082932 CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded
Created attachment 158258 [details] Select a1:m11 and try to sort.
(note: meant is sheet 'Source data'.A1:M11) The default on an anonymous range, whether to sort by rows or by columns, depends on the dimension of the selection. If it is wider than tall then by columns is preselected, otherwise by rows. This usually makes sense. Once a different direction was selected that setting is remembered for the (one) range. If there are more than one such anonymous ranges used on a sheet then it would help to define a database range (menu Data -> Define Range...) and have "Contains column labels" activated under its Options, which again is the default for a database range.
(In reply to Eike Rathke from comment #2) > (note: meant is sheet 'Source data'.A1:M11) > > The default on an anonymous range, whether to sort by rows or by columns, > depends on the dimension of the selection. If it is wider than tall then by > columns is preselected, otherwise by rows. This usually makes sense. Once a > different direction was selected that setting is remembered for the (one) > range. If there are more than one such anonymous ranges used on a sheet then > it would help to define a database range (menu Data -> Define Range...) and > have "Contains column labels" activated under its Options, which again is > the default for a database range. It would be better to allow permanent fixing of this option.
Fix what? As said, an anonymous sort range behaves as described and by definition is *temporary* (until another anonymous range is used). A *defined* database range permanently remembers the data in columns direction.
Yep, let's close