Bug 143015 - 'Text Language' field on the Status bar for Calc should display language for cell paragraph content consistent with Writer handling of paragraph or table cell, and not the global document language
Summary: 'Text Language' field on the Status bar for Calc should display language for ...
Status: RESOLVED DUPLICATE of bug 127856
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.6.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Statusbar
  Show dependency tree / graph
 
Reported: 2021-06-23 16:57 UTC by Tracey
Modified: 2023-11-27 09:40 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

Attachments
Spreadsheet with Spanish and English Words (135.73 KB, image/png)
2021-07-30 16:29 UTC, Tracey 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Tracey 2021-06-23 16:57:59 UTC 
Description:
All applicable languages should appear in the [Text Language] section of a multi-lingual spreadsheet.
I would like to be able to select a cell or range of cells and apply the applicable language from the [Text Language] for spell-checking purposes.

When working with a multi-lingual spreadsheet, <right>-clicking on the [Text Language] section only shows the default language as a choice.
    • <Only> the language of a <mono>-lingual spreadsheet ---or--- <All> the languages used in a <multi->lingual spreadsheet should appear in the [Text Language] section and no other language.
        ◦ Any need for additional languages can be added: by using the [more…] option or <select> the text and change the [format>character>font>language] from the tool bar.
          
Thanks, Tracey

Actual Results:
LibreOffice Calc – Issue with the [Text Language] section of the status bar
All applicable languages should appear in the [Text Language] section of a multi-lingual spreadsheet.
I would like to be able to select a cell or range of cells and apply the applicable language from the [Text Language] for spell-checking purposes.

When working with a multi-lingual spreadsheet, <right>-clicking on the [Text Language] section only shows the default language as a choice.
    • <Only> the language of a <mono>-lingual spreadsheet ---or--- <All> the languages used in a <multi->lingual spreadsheet should appear in the [Text Language] section and no other language.
        ◦ Any need for additional languages can be added: by using the [more…] option or <select> the text and change the [format>character>font>language] from the tool bar.

Expected Results:
available option


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 Buovjaga 2021-07-19 16:52:50 UTC 
Do you think implementing what bug 127856 is asking for would solve this for you?
Comment 2 Tracey 2021-07-30 16:29:28 UTC 
Created attachment 173980 [details]
Spreadsheet with Spanish and English Words

Scrolling thru a list of languages becomes very time consuming 8-(
I want to be able to right-click and select an applicable language from the [Text Language] box as I can in LibreOffice Writer (standard functionality is what I ([am expecting / wanting]) to do.
Thanks, Tracey
>>> Presently my work-around is to apply the language properties to 1 cell then copy the cell-format to the others 8-)
Comment 3 QA Administrators 2021-07-31 05:49:49 UTC Comment hidden (obsolete)
Comment 4 Tracey 2021-08-12 18:00:10 UTC Comment hidden (obsolete)
Comment 5 Tracey 2021-08-12 18:01:46 UTC Comment hidden (obsolete)
Comment 6 Tammy 2022-11-26 22:23:28 UTC 
I was able to reproduce the issue on: 
Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 3b0b9fcb80242abcedc01eb388a57b1016916353
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

The causal ticket may relate to bug 127856.
Comment 7 V Stuart Foote 2022-11-27 11:17:42 UTC 
Behavior of the 'Text Language' field on the Status bar for Calc should be consistent with Writer's handling of paragraph and table cell language.

We should display the text language (for spell check) and provide a list of in use, or to set additional languages, for selected Calc cell paragraph content.

The Status bar should display text language of the selected cell(s), or the cell with cursor focus.

At master against 7.5 currently, we only display the global document language with no indication of individual cell paragraph language value.

IMHO => NEW

=-testing-=
Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 651658d37bcb3f493942dd5d0b9a0d65c96f105c
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 8 Heiko Tietze 2022-11-28 09:24:18 UTC 
There should also be an option to set the language for the cell via Tools > Language.

Meanwhile a workaround might be to define two cell styles, one with font language Spanish and the other for English. Unfortunately you don't see the cell style in the statusbar, only the page style, but with the sidebar/Navigator open it shows nicely.
Comment 9 Stéphane Guillou (stragu) 2023-11-27 09:40:11 UTC 
I understand this is already covered in existing tickets:

* bug 34142: the status bar should show the cell (range)'s language, not the document's
* bug 76750: change language of cell (range) from top menu > Tools > Language
* bug 127856: the status bar's "More..." should lead to the Font tab in the Cell Format dialog. But the suggested solution applies to the whole popup and the discussion is happening there, see Eike's bug 127856 comment 3, and Heiko's bug 127856 comment 8.

Therefore, marking as duplicate of bug 127856.
Thanks all!

*** This bug has been marked as a duplicate of bug 127856 ***