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.
Created attachment 185465 [details] Spreadsheet with German Document language, individual cells makred as wrong
Created attachment 185466 [details] Context menu in offending cell, option to mark as German word, English suggestions
Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 186296 [details] This sample document exhibited the described behavior, but does not when I open it now.
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
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.
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
(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?
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
Closing as resolved.