2
1
Is there a way to disable the spell checker in OpenOffice Calc (or LibreOffice Calc) without disabling it for the other programs in the office suite?
I would prefer to just disable it for a range of cells. If that is not possible, disabling it for the entire spreadsheet would be acceptable.
I seem to remember a trick that involved changing the language for the cells to be one without spellchecking, but I do not recall the details of that trick, or if it possible with current versions. Regardless, all solutions are welcome.
RockPaperLizard
Posted 2015-12-11T22:19:22.970
Reputation: 5 415
1Sorry, had to remove my answer since it didn't work (spelling marks removed when editing a cell, but they appeared again after disabling / enabling spell checking completely....) – tohuwawohu – 2015-12-12T17:20:58.657
Spell check is a global function that cannot be disabled for a single application or file. This has led to some bug reports, for example Issue 124396 - Auto-correct interfers with numeric evaluation
– Lyrl – 2015-12-14T15:27:04.290@Lyrl Thanks. That's quite a functionality deficit. There used to be a technique, I believe it involved changing the language of the text, that would prevent spell-checking on any block of text. A generous user here posted an answer involving this technique, but chose to delete that answer because his method didn't quite work (sorry, I can't see deleted posts). I wonder if such a technique still exists, but requires a little more tweaking. – RockPaperLizard – 2015-12-14T20:17:22.247
Amo's answer bumped this to the main page. A potential workaround occurred to me. You could look at using a macro that is either incorporated into each workbook via the standard template, or run at startup of Calc. It would deselect spell checking. Another macro would reselect it at closing, or the other office applications could have a similar macro at startup that selects it. – fixer1234 – 2018-03-06T06:00:58.003
@fixer1234 Interesting idea. I don't recall anymore.., does the macro functionality require JRE? – RockPaperLizard – 2018-03-06T07:00:50.917
I have no idea. Since switching to LO, I haven't needed to do any macros. – fixer1234 – 2018-03-06T07:36:03.643