[Libreoffice-ux-advise] [Bug 127856] Pushing More... in language selection in Calc Status bar leads to Language settings instead of cell properties

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127856

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|needsUXEval                 |
                 CC|libreoffice-ux-advise at lists |heiko.tietze at documentfounda
                   |.freedesktop.org            |tion.org

--- Comment #8 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
Issue: "More..." in content menu at language panel in the status bar leads to
Tools > Options > Language unlike Writer that goes to the character dialog
(would be Cell in case of Calc).

Related topics: In bug 76750 a main menu item is requested to change the
language, bug 34142 deals with document, sheet, and cell wide language settings
like Writer has, summary of bug 63558 is about auto detection in Draw but deals
with the same as 34142, and bug 121700 is a duplicate of this but talking about
paragraphs and characters.

Technically, the language (locale) affects both text (spell-checking,
hyphenation etc) and numbers (separators, currency etc.). Users compare Calc
with Writer and might expect only text being affected, which is supported by
the item "None (do not check spelling)". In other scenarios the user wants to
change the number format or currency in the sheet.

Tools -> Options -> Language Settings changes the whole document (and newly
created), switching the language per content menu at the status bar affects the
current document, and Format > Cells: Font applies to the selection.
The status bar shows the document language and not the actual cell.
There are settings for Numbers and Font in the cells property dialog so a cell
can have two languages (locales).

Proposal: 
1. We split the status bar into number format and text language. Having
"(English (USA)" twice is not perfectly clear to the user and maybe we should
use "English (USA)" and "$1.234,00"
2. "More..." opens Format > Cell: Font and :Number respectively.
3. The context menu root entries apply to the selection.
4. We add another context menu entry "Set language for the document >" with the
current content and functionality (like Writer has this for the paragraph). 
5. We add the same structure to the main menu at Tools > Language and (5b)
consequently another entry with Numbers.

This goes way too far and we better exclude the numbers configuration. Meaning,
the context menu just alters Format>Cell>Font and not the locale. So ignore #1
and 5b.

6. The language of the currently active cell is used for the status bar text.

-- 
You are receiving this mail because:
You are on the CC list for the bug.