https://bugs.documentfoundation.org/show_bug.cgi?id=164013
Bug ID: 164013
Summary: [enhancement] add data validation and format
PROTECTION option for cells/columns/rows
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
MS excel has (for several years) the option to protect format and data
validation for cells while allowing user to edit the cells, mainly choose a
data validated value. Libre calc offers no such option, therefore breaking
compatibility.
Steps to Reproduce:
1. select a cells range
2. right click --> format cells...
3. go to cell protection
4. there is no option to protect ONLY format and data validation, but allow
editing
Actual Results:
A user can break data validation or change format
Expected Results:
There should be an option to protect data validation and format, like MS excel
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: el-GR (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:24.8.3~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
