Bug 167965 - [Documentation] Levels of sorting in Calc
Summary: [Documentation] Levels of sorting in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sorting
  Show dependency treegraph
 
Reported: 2025-08-15 16:28 UTC by LeroyG
Modified: 2025-10-21 11:50 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description LeroyG 2025-08-15 16:28:16 UTC
Description:
Inaccurate help text in Calc Guide.

And making a search in internet gives that Calc only can sort by three criteria. This is bad propaganda.

"Remove the limitation to 3 sort entries in calc [...] Is fixed now and should be in 3.6Beta1."
https://bugs.documentfoundation.org/show_bug.cgi?id=45747#c13

Steps to Reproduce:
Source:
Calc Guide 25.2, Chapter 15 - Calc as a Database
https://books.libreoffice.org/en/CG252/CG25215-CalcAsADatabase.html#toc24

Below "Figure 9: Sort dialog", it is written:

Actual Results:
"On the Sort Criteria tab of the dialog, you can specify three levels of sorting."

Expected Results:
"On the Sort Criteria tab of the dialog, you can see three levels of sorting."


Reproducible: Always


User Profile Reset: No

Additional Info:
And once you specify the third level (Sort Key 3), you can see Sort Key 4, and so on until who know (I reached until 267, and it seems that there is more).

Version: 24.8.5.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 4; OS: Linux 6.4; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2025-08-15 22:18:02 UTC
Reproducible,
Comment 2 Regina Henschel 2025-10-20 20:43:18 UTC
Or something like this: The Sort dialog initially displays three levels of sorting. However, when "Sort Key 3" is used, the dialog is expanded and provides additional levels.
Comment 3 LeroyG 2025-10-20 22:10:38 UTC
(In reply to Regina Henschel from comment #2)
> the dialog is expanded and provides additional levels.

How many levels? I could not find. That info could be in the Help.
Comment 4 Regina Henschel 2025-10-21 00:05:14 UTC
(In reply to LeroyG from comment #3)

> How many levels? I could not find. That info could be in the Help.

In my tests I get one new level and when that is used another new level and so on. I don't know whether there is maximal count of levels. The dialog gets a scrollbar when there is not enough place to show all levels.

Why not try it out yourself?
Comment 5 LeroyG 2025-10-21 11:50:47 UTC
(In reply to Regina Henschel from comment #4)
> (In reply to LeroyG from comment #3)
> > How many levels?

[…]
> Why not try it out yourself?

(In reply to LeroyG from comment #0)
> and so on until who know (I reached until 267 […]).