Re: [libreoffice-design] Proposal needed for tab "Options" of "Sort..." dialog in Calc

This was briefly discussed on the Telegram channel.

JD:
Re: Regina’s mail on sort options on lo-design:
I would probably go with a three-entry dropdown-menu labeled "sorting method" 
and move the option downward, above.

Two caveats:
- The dialog currently uses checkboxes for all options, even the ones that have 
additional controls. I would usually expect that there is a default null option 
in the dropdown that serves as indicator of the option being deactivated. If we 
would keep the checkbox-first style, we could  keep "alphanumeric" as the 
default and have a 2-entry menu for the kind of natural sorting we want.
- I have a hard time coming up with good labels for the options: the meaning of 
"Integer" and "double" would be hard to guess and I must admit I have not fully 
understood how they differ by reading the spec.

ER:
TBH, since that checkbox in the UI right now makes no sense, it can't hurt to 
have three options that don't make that much sense.... 👻

We probably get more discussed with a ticket on Bugzilla. If you could do that 
it wasn't me who is the OP :-)


On 11.09.25 7:10 PM, Regina Henschel wrote:
> Hi Design-team,
>
> ODF has the attribute table:embedded-number-behavior of the <table:sort> element 
> [1]. It has the values `alpha-numeric`, `double` and `integer`.
>
> LibreOffice has the checkbox `Enable natural sort` on tab `Options` of the 
> `Sort...` dialog in menu `Data` in Calc [2].
>
> When it is checked, LibreOffice sorts in a way, that corresponds to the ODF 
> value `double`. If it is not checked, LibreOffice sorts in a way, that 
> corresponds to the ODF value `alpha-numeric`.
>
> I'm going to implement the missing value `integer` of this attribute.
>
> With my implementation, there are three possible sorting types then, and 
> therefore a checkbox no longer fits as a control element.
>
> Please give me a suggestion on how to change the dialog.
>
> [1] https://docs.oasis-open.org/office/OpenDocument/v1.4/cs01/part3-schema/ 
> OpenDocument-v1.4-cs01-part3-schema.html#attribute-table_embedded-number-behavior
> [2] https://opengrok.libreoffice.org/xref/core/sc/source/ui/dbgui/tpsort.cxx
>
> https://opengrok.libreoffice.org/xref/core/sc/uiconfig/scalc/ui/sortoptionspage.ui
>
> Kind regards,
> Regina

--
Dr. Heiko Tietze, UX-Architect and UI-Designer
Tel: +49 30 5557992-63 | Mail: heiko.tietze@documentfoundation.org
The Document Foundation, Winterfeldtstraße 52, 10781 Berlin, DE
Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: https://www.documentfoundation.org/imprint


--
To unsubscribe e-mail to: design+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/design/
Privacy Policy: https://www.documentfoundation.org/privacy