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)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Spell-Checking Sheet
  Show dependency treegraph
 
Reported: 2014-10-13 16:27 UTC by Warren Block
Modified: 2023-09-07 22:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

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 4.3.2.2 on Windows 7 and 4.2.5.2 on FreeBSD 10-STABLE.
Comment 1 Cor Nouws 2014-10-13 17:34:09 UTC
Hi Warren,

I cannot reproduce this in 4.3.3.1 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!
Cor
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 https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg

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

Ubuntu 14.10 64-bit Version: 4.5.0.0.alpha0+
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-3.3.0.4
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: 6.5.0.0.alpha0+
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
Comment 11 QA Administrators 2021-12-05 04:59:00 UTC Comment hidden (obsolete)
Comment 12 Kira Tubo 2023-09-07 22:56:56 UTC
Reproduced in both current stable and daily master builds.

Version: 7.6.0.3 (X86_64) / LibreOffice Community
Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265
CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9a37652b79001bf5208841b9221dee851b9b6d0f
CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded