Bug 153718 - EDITING In a Calc table, the default document language setting is not honored throughout the table. Instead, some cells are set to English(USA)
Summary: EDITING In a Calc table, the default document language setting is not honored...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.5.1 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-18 22:26 UTC by Ben Opp
Modified: 2023-08-19 01:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with German Document language, individual cells makred as wrong (36.87 KB, image/png)
2023-02-18 22:30 UTC, Ben Opp
Details
Context menu in offending cell, option to mark as German word, English suggestions (72.20 KB, image/png)
2023-02-18 22:31 UTC, Ben Opp
Details
This sample document exhibited the described behavior, but does not when I open it now. (26.81 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-03-29 20:19 UTC, Ben Opp
Details
available dictionaries in spellchecking options (31.83 KB, image/png)
2023-03-29 20:31 UTC, Ben Opp
Details
clicking on document language in bottom UI panel, these are the choices available (15.99 KB, image/png)
2023-03-29 20:34 UTC, Ben Opp
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ben Opp 2023-02-18 22:26:03 UTC
Description:
My default language as per settings is German(Austria). In a table I typed, where each word contains one word, a (seemingly random) handful of - correctly spelled - German words are marked as incorrect. When double-clicking in the cell and right-clicking on the underlined word, English words are suggested instead and the option "this word is German" appears.
I take it that Calc seems to think this word is English.
I selected the entire table and clicked the language setting in the center of bottom panel to confirm the German(Austria) language, but nothing changed, several individual cells are still marked as wrong (English).

I don't use Calc a lot, trying to reproduce it, I opened several existing .ods files and found one more that had an English cell in the middle of a German document.

Steps to Reproduce:
1. Set LO default document language to German(Austria)
2. open a spreadsheet containing German language and set spellchecker language to German(Austria) for entire document
3. Check if some correctly spelled words are marked as wrong.
4. Check if suggestions are English or German

Actual Results:
Re-applying the default language manually, some random cells to not pick up the setting and remain in English

Expected Results:
When setting the document language to X (German(Austria) in my case), this should apply to the entire document without exception.


Reproducible: Sometimes


User Profile Reset: Yes

Additional Info:
I cannot tell if this is language-specific.
I copied some cells from a table in an .odt document over into the offending spreadsheet. I thought maybe they are the ones seen as English, but
a) some other cells I had manually typed are also marked wrong and
b) the original .odt doc is also set to German(Austria).

However, if cells copied over from another document were the offenders, manually setting the document language should still turn them all to default. It shouldn't be necessary to tell Calc for each cell individually that it's not English.
But how that English snuck in there in the first place is also a mystery.

German(Austria) is the default setting for my OS (Manjaro) which Lo came preinstalled on. I did not manually adjust the language setting in LO.
Comment 1 Ben Opp 2023-02-18 22:30:24 UTC
Created attachment 185465 [details]
Spreadsheet with German Document language, individual cells makred as wrong
Comment 2 Ben Opp 2023-02-18 22:31:34 UTC
Created attachment 185466 [details]
Context menu in offending cell, option to mark as German word, English suggestions
Comment 3 Buovjaga 2023-03-29 12:45:37 UTC
Please attach an example document.
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 4 Ben Opp 2023-03-29 20:19:50 UTC
Created attachment 186296 [details]
This sample document exhibited the described behavior, but does not when I open it now.
Comment 5 Ben Opp 2023-03-29 20:22:47 UTC
Uploaded the spreadsheet. I don't know if I marked the content type correctly, it's an .ods file creates with LO Calc. I also noticed something interesting in the language settings, will add screenshots
Comment 6 Ben Opp 2023-03-29 20:31:20 UTC
Created attachment 186297 [details]
available dictionaries in spellchecking options

All German dictionaries are installed (Austria, Germany, Switzerland, Luxemburg, Liechtenstein, Belgium) but are missing from the list.
Comment 7 Ben Opp 2023-03-29 20:34:28 UTC
Created attachment 186298 [details]
clicking on document language in bottom UI panel, these are the choices available

4 more German dictionaries and English(USA) dictionary are installed, but not available for selecting.
There is a mismatch between the installed dictionaries and the ones I can set as document language
Comment 8 Buovjaga 2023-08-18 06:24:04 UTC
(In reply to Ben Opp from comment #4)
> Created attachment 186296 [details]
> This sample document exhibited the described behavior, but does not when I
> open it now.

So you don't see the problem anymore? I see German (Austria) as the language in the cells.

(In reply to Ben Opp from comment #7)
> Created attachment 186298 [details]
> clicking on document language in bottom UI panel, these are the choices
> available
> 
> 4 more German dictionaries and English(USA) dictionary are installed, but
> not available for selecting.
> There is a mismatch between the installed dictionaries and the ones I can
> set as document language

What if you click Mehr... and select from there?
Comment 9 Ben Opp 2023-08-18 20:46:06 UTC
If I re-open this exact document (i.e. the version downloaded from here, and also my local original) in my current LO Version: 7.5.5.2, the problem is gone.
I hope it just somehow fixed itself between this release and 7.4.5.1
Comment 10 Ben Opp 2023-08-18 20:46:59 UTC
Closing as resolved.