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: [email protected]
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: [email protected]
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
