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

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