Bug 127856 - Pushing More... in language selection in Calc Status bar leads to Language settings instead of cell properties
Summary: Pushing More... in language selection in Calc Status bar leads to Language se...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected
Depends on:
Blocks: Statusbar
  Show dependency treegraph
Reported: 2019-09-29 08:48 UTC by andis.lazdins
Modified: 2020-08-14 19:17 UTC (History)
9 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description andis.lazdins 2019-09-29 08:48:07 UTC
In Libreoffice Calc pushing More... in language selection in Status bar leads to Language settings from Tools > Options menu instead of Format > Cells menu as should be (e.g. it works in Writer).

Steps to Reproduce:
1. Open or create Calc file
2. In Status bar push on Language selection
3. Push More...

Actual Results:
Language settings from Tools > Options appears to select interface language.

Expected Results:
Cell properties from Format > Cells > Font should appear to select language of text in selected cells.

Reproducible: Always

User Profile Reset: No

Additional Info:
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: lv-LV (en_GB.UTF-8); UI-Language: en-US

The same appears in Version
Comment 1 Xisco Faulí 2019-09-30 11:05:25 UTC
The current behaviour was implemented in https://cgit.freedesktop.org/libreoffice/core/commit/?id=6db709ba79fec6f75dd7385ce57c65a62fc2254e

@UX Team, what's your opinion on this ??
Comment 2 Heiko Tietze 2019-10-01 08:15:01 UTC
Looks like cell language is not the same as text language since I can set both independently. Eike, could you please add some wisdom here?
Comment 3 Eike Rathke 2019-10-01 12:22:54 UTC
The font language is a text attribute and affects spell-checking and the like.
The number format language (locale) affects only the number format.

The status bar setting the global document language (like choosing "[None]") or More... raising the Tools -> Options -> Language Settings -> Languages dialog IMHO is completely wrong.
Changing "Default Languages for Documents" there leads to setting all cells' default font language (if not set differently already).
Changing "Language Of","Locale setting" there leads to setting all cells' default number format locale (if not set differently already).
The status bar language displays the global Western "Default Languages for Documents", also when changed it's updated only after some other action.

However, according to the tooltip ("Text Language. ... character or paragraph language") picking a language from the context menu should attribute the font language of the selected cell(s), and More... should raise the Format -> Cells (Ctrl+1) dialog with tab Font.
Comment 4 Thomas Lendo 2019-10-02 20:17:45 UTC
I support a change so that it opens Format > Cells dialog in font tab similar to the behavior in Writer.

It seems in general that the language identification needs some love in Calc like Bug 76750, Bug 34142, Bug 63558 and Bug 121700.
Comment 5 Cor Nouws 2019-10-03 12:02:30 UTC
It looks as if my friend @hcastro missed the difference when making the [more] button work.
Changing the behavior to be in line with Writer is, esp after previous comments, a nobrainer to me :)
Comment 6 Henry Castro 2019-10-03 16:27:18 UTC

>> Changing the behavior to be in line with Writer is, esp after previous comments

Yes, I did with Online to send same data on uno:Commands but it is not. I will fix the desktop version, without affecting the Online :)
Comment 7 Timur 2019-10-25 09:06:56 UTC
I was looking for the explanation in bug 100136 and arrived here. Now with Eike's explanation, I get it. But we should have language and consequences (like spelling and hyphenation) explained in Help, best after this bug is resolved. 
Lesson learned is that bug 113911 was wrongfully set to New without UX eval. Logic is not "I reproduce" but "Yes, there's a reason it should be changed".
What's missing here now is a clear "expected" situation, Heiko please write it, using Eike's comment and Thomas' bugs.
Comment 8 Heiko Tietze 2019-11-01 11:30:09 UTC
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).

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.
Comment 9 Henry Castro 2020-01-15 12:49:56 UTC

I am sorry, fixing this bug, I have tasks assigned to Online, so Please if there is another member to take the bug, I will appreciate :)
Comment 10 Xisco Faulí 2020-01-22 09:13:48 UTC
Hi Caolán,
I thought you might be interested in this issue