Re: [libreoffice-users] Setting language in LO Calc

At 09:20 05/02/2014 +0100, Graham Luffrum wrote:
> In Writer I can set a language for a specific document, other than 
> the default LO language, so that it correctly spell-checks when I type.

It's important to realise that you can do better than this: you can 
set different languages for different parts of your document, so that 
spelling checking takes place for multiple languages.  Apart from the 
default and local character formatting, language is also a character 
style property and a paragraph style property.

> I cannot see how I can do this for a spreadsheet.  To be more 
> specific the LO default language is UK English, but I write a lot in 
> Slovak.  So I have installed dictionaries for both UK English and 
> Slovak.  When I enter Slovak text in Calc it checks it only against 
> UK English.  When I use the spell checker I can change the language 
> from English to Slovak, but after each word checked it reverts back 
> to English.  Is there any way of stopping it from doing this.  I 
> realise I can change the LO default language, but don't really want to do this.

o Changing the default language at Tools | Options... | Language 
Settings | Languages | Default languages for documents may be more 
suitable then you realise: note that there is a "For the current 
document only" option.  Tick that and you won't be changing the way 
future documents behave.

o You can set the language of individual cells or of a range of 
cells.  Select the cell or range (or even an entire sheet), go to 
Format | Cells... | Font | Language (or right-click Format Cells... | 
Font | Language), and set the language there.  You can even select 
part of the text within a cell and set its language separately in the same way.

o Better still, language is a property of cell styles, so you can 
create multiple cell styles for different languages and apply these 
to relevant cells.

> Is there some reason why Calc is different from Writer in this 
> respect in not being able to set a document language?

It's perhaps not as different as you imagine.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted