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.
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: 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