Download it now!
Bug 84968 - Protect Document/Sheet disables spell checker even for cells that are not protected
Summary: Protect Document/Sheet disables spell checker even for cells that are not pro...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Spell-Checking Sheet
  Show dependency treegraph
Reported: 2014-10-13 16:27 UTC by Warren Block
Modified: 2019-12-05 20:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Warren Block 2014-10-13 16:27:10 UTC
Enabling sheet protection disables Tools/Spelling, even on cells that are not protected.  The desired behavior would be to spell check all the unprotected cells, even on a protected sheet.  To duplicate:

Create a sheet.
Right-click a cell, choose Format Cells..., Cell Protection, uncheck Protected, choose Okay.
Select Tools/Protect Document/Sheet, do not enter a password, select Okay.
Verify that Tools/Spelling is disabled.

Enter text in the unprotected cell, try to use Tools/Spelling.

Tested on on Windows 7 and on FreeBSD 10-STABLE.
Comment 1 Cor Nouws 2014-10-13 17:34:09 UTC
Hi Warren,

I cannot reproduce this in on Ubuntu.
Are you able to check it there too?
Is it a special document? - pls attach :)
... ?
Maybe it's windows only - dunno.

Thanks for the report!
Comment 2 Warren Block 2014-10-15 00:16:26 UTC
No, this is not a special sheet.  It can be duplicated starting with a blank sheet as shown in the first message.

I don't have an easy way to test it on Ubuntu.  4.3.3 RC1 still shows the problem on Windows 7.
Comment 3 Buovjaga 2014-11-27 11:24:07 UTC
Reproduced both on Windows and Ubuntu. NEW, lowered severity per

Win 7 64-bit Version:
Build ID: b144f0ac8695dd62a2053b4e88212d0b109c9a41
TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-25_00:14:54

Ubuntu 14.10 64-bit Version:
Build ID: 6b219f012edbe069c461f4e0746898e33fa1dd49
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-25_21:56:46
Comment 4 Buovjaga 2015-01-10 19:42:33 UTC
Bug already present in 3.3.0

Ubuntu 14.10 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-
Comment 5 Cor Nouws 2015-01-11 09:48:01 UTC
Ah, now I see this indeed does not work. Sorry.
I used Tool > AutoSpelling and that does work.
Comment 6 QA Administrators 2016-01-17 20:04:28 UTC Comment hidden (obsolete)
Comment 7 Warren Block 2016-01-17 20:33:17 UTC
Yes, this bug still exists.  Tested on LibreOffice 5.0.4 on FreeBSD 10-STABLE amd64.
Comment 8 QA Administrators 2017-03-06 14:25:02 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2019-12-03 14:23:40 UTC Comment hidden (obsolete)
Comment 10 Cor Nouws 2019-12-05 20:12:13 UTC
still the same in Version:
Build ID: a81489978cb96d819044be054f7ceabc4f8eccb2
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-11-24_02:51:20
Locale: nl-NL (en_US.UTF-8); UI-Language: en-US
Calc: threaded