Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

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.


On 5 February 2014 10:22, Brian Barker <> 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

 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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.