Download it now!
Bug 97188 - Cannot set spell-check language in Calc; therefore, spell-check does not work at all
Summary: Cannot set spell-check language in Calc; therefore, spell-check does not work...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-16 16:25 UTC by Gabriel Staples
Modified: 2016-01-16 18:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Spell-check work-around and bug--see paragraph 2 (111.92 KB, application/pdf)
2016-01-16 16:25 UTC, Gabriel Staples
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabriel Staples 2016-01-16 16:25:25 UTC
Created attachment 122000 [details]
Spell-check work-around and bug--see paragraph 2

Spell check in Calc does not work *at all* (without a special work-around), simply because one cannot set the spell-check language! I marked this item as "critical" because it prevents Calc from being used in a professional environment, where spell-check is a must-have. 

Finding the work-around has taken me about 5 hrs of research time. Most people would give up long before then.

In Writer, I can go to Tools --> Language --> For all text --> English (USA), and spell-check works fine, now that I have selected the language.

In Calc, however, this option does not exist. I cannot set the language at all via the Tools --> Language menu, as the "For all text" submenu is nonexistent. 

Work-around: 
Highlight all cells (ctrl + a) → right click → Format Cells → Font → set “Western Text Font” to the language you want to use for spell-check, ex: “English (USA).” Now that you have set the language, spell-check will work when you click the spell-check button. 

Note: I have the following spell-check dictionaries installed: Arabic, English, Spanish, French, Italian, Portuguese. 

I am running Windows 8.1, so I don't know if this problem is on other OSs too.

I have attached a document ("LibreOffice Tweaks, Help, Tips, Tricks, & Notes - Gabriel - 20160116.pdf") detailing the process in paragraph 2. Note that there is also a second, lesser bug which makes "automatic spell checking" NOT retroactive to already-existing text. See the attachment, under the subparagraph 2.1.2 for more details.
Comment 1 Jean-Baptiste Faure 2016-01-16 18:18:48 UTC
There is quicker methods to find the solution, ask for help:
1/ https://ask.libreoffice.org
2/ mailto:users@global.libreoffice.org

That said to define the language, the easy way is to modify the default cell style.
Don't forget to install appropriate dictionaries.

Note: current stable and supported versions are 4.4.7 and 5.0.4. Please upgrade to be sure to not run a version with known security bugs.
https://www.libreoffice.org/about-us/security/advisories/

Closing as WorksForMe.

Best regards. JBF