Disable spell check for all Calc but leave on for all Writer docs?

[alwhaley]

Most of what I enter into a spreadsheet is garbage according to the spell checker and that makes sense because I don’t type English sentences into spreadsheets. Sadly, I cannot find a way to disable spell check for all Calc docs and leave it on for all Writer docs where the norm for me is the written word. When I go (in Calc) to “Tools->Options->Languages and Locales->Writing Aids->Options->Check Spelling as you type” and turn it off, then in Writer I find it’s off there too; it’s the same global option.

This is one of the many places where the philosophy of Libre Office that everything (e.g. calc, writer, etc.) is just one big program with flavors causes headaches. If there was a section of options just for Calc that included spell check on/off that would be helpful.

There are a lot of comments about turning spell check off for a range of cells or for one document, but I don’t want to go changing options every time I create a new doc. I want it off for all Calc and on for all Writer documents.

Have I missed something? And if not, where do I input a feature request?

tnx
Al

[JohnSUN]

Hi @alwhaley and welcome!
Are you talking about Automatic Spell Checking?

Is Shift+F7 a bad option? I am also irritated by the red lines in Calc, they seem to hint that I am an illiterate idiot… When this starts to irritate me (almost immediately), I press two buttons…

[alwhaley]

I didn’t see the entry under Tools->Automatic Spell Checking or the shortcut Sh-F7. That does ease the pain. I do still hope for a separated global option someday, but that helps a lot.

[Lupp]

@alwhaley

This is one of the many places where the philosophy of Libre Office that everything (e.g. calc, writer, etc.) is just one big program with flavors causes headaches.

???
If you are fond of the disadvantages of MS Ofice, you can install LibreOffice shared, but create as many user profiles for special cases (“Sessions”) and have every setting there the way you want it for the special purpose.
I personally use a second profile not containing macros. This just to avoid very special problems in very special cases.
"C:\Program Files\LibreOffice\program\soffice.exe" -env:UserInstallation=file:///C:/Users/MYUSERNAME/AppData/Roaming/LibreOffice/clean
does the trick.
The one problem with this is that MS was unable to create resisable windowlets for the settings of the needed links at lhe end of lifetime of Win 10. Still like under Win 3.11. Incredible!
They should headhunt one or other of the DocumentFoundation volunteer developers.

(Site admin: Let me decide myself, please, what to post. I got a “too similar” again when I converted an answer to a comment without changing the content.)

[Regina]

@alwhaley

Have I missed something? And if not, where do I input a feature request?

The feature request exists already: tdf#43789

Start with a new spreadsheet document. There set the language to “none” in the Default style. Save this spreadsheet as your default template. That does not help for existing documents, but for new ones.
Of cause you can do the same trick for existing documents. Then when you save and reopen it later, the text still will not be checked, because language “none” has no spellchecker.

[alwhaley]

Nice - I’ll do that