Ask Your Question

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

asked 2018-08-29 10:09:42 +0200

junk01 gravatar image

updated 2020-08-02 20:44:17 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-08-31 18:30:57.234304

2 Answers

Sort by » oldest newest most voted

answered 2018-08-30 12:21:20 +0200

erAck gravatar image

Use Format -> Cells, Font tab, Language.

edit flag offensive delete link more

answered 2018-08-29 14:17:51 +0200

kompilainenn gravatar image
  1. Select range

  2. Select menu Format->Cells

  3. Select language

edit flag offensive delete link more


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.

junk01 gravatar imagejunk01 ( 2018-08-30 11:21:31 +0200 )edit

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

erAck gravatar imageerAck ( 2018-08-30 12:19:23 +0200 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2018-08-30 22:25:40 +0200 )edit

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

junk01 gravatar imagejunk01 ( 2018-08-31 16:11:23 +0200 )edit

Question Tools

1 follower


Asked: 2018-08-29 10:09:42 +0200

Seen: 585 times

Last updated: Aug 30 '18