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

Thanks, Brian (amongst other for making me feel like an idiot).  You are
right it is not so different, only a matter of knowing where to look.  I
was expecting to find a menu item as in Writer where I could set the
language, but on reflection the way it is in Calc is sensible.

Graham


On 5 February 2014 10:22, Brian Barker <b.m.barker@btinternet.com> wrote:

> 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

-- 
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