Bug 168899 - [UI] Sort Option new strings (natural sort)
Summary: [UI] Sort Option new strings (natural sort)
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
26.2.0.0 alpha0+ master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-10-16 13:57 UTC by Olivier Hallot
Modified: 2025-10-31 21:47 UTC (History)
3 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 Olivier Hallot 2025-10-16 13:57:47 UTC
Ref: bug161948, bug#168687.

After a second read with a translator hat and seeking to catch the topic I suggest

1)
"Use decimal number as a whole"
Should perhaps be
"Recognize decimal numbers"
and the tooltip
"Decimal numbers are recognized. Example:..."

2)
"Split in integer and fractions"
should perhaps be
"ignore decimal separator in numbers"

Note: long tooltips should go to extended tips.

Note2: Help page to update, once finalized.
Comment 1 Heiko Tietze 2025-10-17 06:58:17 UTC
Abstaining from the discussion about the labels.

But: Users who have been used "Natural Sort" might be annoyed by the renaming. Would be nice to give a clue in the tooltip like "... (was: 'Natural Sort')" (and maybe drop this amendment in the major release after the next).
Comment 2 Eyal Rozenberg 2025-10-17 09:23:29 UTC
> "Split in integer and fractions"

This is grammatically invalid. Generally,  'split' takes either a direct object, or an indirect object via 'into'. The only (?) exception is the idiom "split [something] in half".

> "Recognize decimal numbers"

The term 'decimal' also denotes a number in base-10 rather than base-16 (hexadecimal) or base-8 (octal). So "Recognize decimal fractions" or "Recognize fractional decimal numbers" 

We could also think of bringing the two options closer together in phrasing to emphasize the difference:

* " 12.34 is a fraction"
* " 12.34 are two numbers" 

and relegate the the phrase "base-10 fractional numbers" to the tooltips.
Comment 3 Regina Henschel 2025-10-31 21:47:33 UTC
(In reply to Heiko Tietze from comment #1)
> But: Users who have been used "Natural Sort" might be annoyed by the
> renaming. Would be nice to give a clue in the tooltip like "... (was:
> 'Natural Sort')" (and maybe drop this amendment in the major release after
> the next).

As the current implementation has the same check box as previous, I suggest we stay with the old label "Enable natural sort". So only new is, that the user now can choose between two kinds of "natural sort", whereas previously it was automatically that one, that is named "double" in file markup.

(In reply to Olivier Hallot from comment #0)
> Ref: bug161948, bug#168687.
> 1)
> "Use decimal number as a whole"
> Should perhaps be
> "Recognize decimal numbers"

Agree

> and the tooltip
> "Decimal numbers are recognized. Example:..."

The tooltip start "Decimal numbers are recognized" is the same content as the label "Recognize decimal numbers", so superfluous. Have only "Example: A.14, A1.2, A1.2, A10 (with dot as separator)" in the tooltip?  

> 
> 2)
> "Split in integer and fractions"
> should perhaps be
> "ignore decimal separator in numbers"

Start with uppercase "Ignore". Besides that, it is OK for me.

Perhaps here too only the example in the tooltip?

> 
> Note: long tooltips should go to extended tips.

Which texts do you suggest for the two extended tips?