CALC: How do I set the language for a selection of cells?

junk01 · August 29, 2018, 8:09am

I have a spreadsheet containing text in more than one language.
Is it possible to select a range of cells (a column for example) then set the language for that selection so that the spellchecker checks using the correct language for that range?

erAck · August 30, 2018, 10:21am

Use Format → Cells, Font tab, Language.

kompilainenn · August 29, 2018, 12:17pm

Select range
Select menu Format->Cells
Select language https://i.imgur.com/bgQI4zo.png

junk01 · August 30, 2018, 9:21am

Thanks for your answer. I have followed your instructions and changed the language (to French). However, when I spellcheck, the spellchecker assumes that the text is in the default language (English) so all the French words are highlighted as wrong.
I cannot find a way to get Calc to switch Spellchecker dictionary to match the Cell’s language. The French dictionary is installed and enabled in the Spelling options.
Do you have any ideas? Thanks.

erAck · August 30, 2018, 10:19am

Setting the language/locale of a cell’s number format is not connected to spell checking.

mariosv · August 30, 2018, 8:25pm

Changing the language on the Font tab of the cell format?

junk01 · August 31, 2018, 2:11pm

Thanks everyone for the comments.
As erAck and m.ariosv havew pointed out setting the “Font” language works, but not the “Numbers” language.

erAck · August 31, 2018, 4:30pm