Bug 87476 - EDITING: "Validity..." functional to unprotected cells when sheet is protected
Summary: EDITING: "Validity..." functional to unprotected cells when sheet is protected
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
Reported: 2014-12-19 02:40 UTC by Patrick
Modified: 2020-10-07 11:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

test file (13.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-12-19 13:34 UTC, raal

Note You need to log in before you can comment on or make changes to this bug.
Description Patrick 2014-12-19 02:40:15 UTC
I have a worksheet with some cells left unprotected for user input.
I apply a "Whole numbers >> valid range" validation to some of theses fields, for example, and protect the sheet.

"Validity..." feature is still accessible to user change whatever he wants. This provides him with the ability to bypass validation.

It occurs apparently with any unprotected cell, not being restricted to whole numbers validation.
Comment 1 raal 2014-12-19 13:32:45 UTC
I can confirm with LO 4.3.4, win7
Comment 2 raal 2014-12-19 13:34:22 UTC
Created attachment 111046 [details]
test file
Comment 3 QA Administrators 2015-12-20 16:18:58 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2017-01-03 19:50:22 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2019-12-03 14:27:39 UTC Comment hidden (obsolete)
Comment 6 NISZ LibreOffice Team 2020-10-07 11:13:30 UTC
Still happens, values can be entered to validated cells on locked sheet in:

Version: (x64)
Build ID: 1cd7e2a4042b92123d8c94ef10b2e8baf7cfaafa
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL