Bug 87476

Summary: EDITING: "Validity..." functional to unprotected cells when sheet is protected
Product: LibreOffice Reporter: Patrick <psvaiter>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: gordsown, raal
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=122921
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107450, 108988    
Attachments: test file

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: 7.1.0.0.alpha0+ (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
Comment 7 QA Administrators 2022-10-08 03:49:42 UTC Comment hidden (obsolete)
Comment 8 Stéphane Guillou (stragu) 2023-07-26 21:43:04 UTC
*** Bug 153996 has been marked as a duplicate of this bug. ***
Comment 9 Stéphane Guillou (stragu) 2023-07-26 22:10:34 UTC
Reproduced in OOo 3.3, so inherited.

Still the case in recent master build:

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 24d0a62bd75b9a895c419aa165da648ab18f134d
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded