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 <[email protected]> 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: [email protected] > 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: [email protected] 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
