How did I trigger a missing hyphenation banner about 'cy-GB', and what to do about it?

[PeterMMorgan]

I am working on a spreadsheet, mostly of text, in Writer. At some point in the last few days, when I first opened the file, I get a banner at the top of my file that says: 'Missing hyphenation data: Please install the hyphenation package for locale “cy-GB”."

There’s also a ‘learn more’ button at the far right of the banner to click, which provides a web page of a long list of various LO support files, none of which, after tedious searching as well as using the Find function in my browser, is ‘cy-GB’. I’m guessing the ‘GB’ is for Great Britain… maybe. I’m working in Canadian and US English, so I’m wondering:

1. What triggered the flag?
2. How I might find the trigger, and
3. What, if anything, I can do about the banner if I can’t find ‘cy-GB’.

Thanks.

Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 12; OS: macOS 14.5; UI render: default; VCL: osx
Locale: en-CA (en_CA.UTF-8); UI: en-US
Calc: threaded ; Format saved: .odt

[ajlittoz]

cy-GB is the code for Welsh language.

You may have pasted some formatted text which was so tagged. Or you may have some corruption in the document.

Ideally, you should spot the text sequence so that you know what pact is involved and perhaps how you imported it. But if your document is long this might be tedious. To spot occurrences:

• select the Style Inspector in the side pane
  The style inspector reports the formatting at the cursor location. The parameter to look for is locale.
• move the cursor over your text with the arrow keys and read the style inspector
  This may take a long time.

If you don’t care to identify the cause, select the whole text with Ctrl+A and either clear direct formatting (not sure if this works) or force your preferred language with Format>Paragraph, Font tab. The latter has the drawback to introduce direct formatting.

This could also originate from a wild setting in some style. Select Applied styles in the bottom menu of the style side pane. Check paragraph styles and character styles, both in their Font tab. Have a look too to Tools>Options language settings.

[Hrbrgr]

In addition to @ajlittoz
You can also switch on highlighting in the sidebar below for paragraph styles.
This will highlight all paragraphs that are the same in the same colour on the side (only in newer LibreOffice versions). A paragraph with a different colour should stand out easily.

---

Highlighting can also be switched on in character styles (also additionally to paragraph styles).

[PeterMMorgan]

Thank you both! The document was 52 pages of text in spreadsheet-type rows and columns, with a couple of typefaces on a base of Century Schoolbook. But I was able to fix the problem with the combined help of information and strategies from both of these answers! ajlittoz’s concept of the Welsh language pointed me in the right direction, and Hrbrgr’s concept of highlighting styles (it turned out to be a character style that was the culprit). Once I found one example after carefully looking at the first 13 pages, I was able to use Find & Replace (Format) to find the font and quickly change the font and style to something that wouldn’t trigger the lack of Welsh hyphenation info. Interestingly the banner is only triggered when the file is loaded. It doesn’t disappear when the problem text was fixed. So after thinking I’d found all of the problem text, I saved and closed the file, then reloaded it. No hyphenation-error banner! Whew! Thank you both SO much. Quick AND helpful!