Data Validiation - Protection

Discuss the spreadsheet application
Post Reply
irfman
Posts: 37
Joined: Mon Nov 16, 2015 4:47 pm

Data Validiation - Protection

Post by irfman »

How can i achieve something like sample excel file (enclosed, pwd is abc), i.e. protect the sheet and restrict dragging of data validation cells. when i try something similar in calc, moving data validation cell overrides other.

Is there any alternative to this? thanks and regards
Attachments
Example 123.xlsx
(8.91 KiB) Downloaded 65 times
OpenOffice 4.1.2 on windows 10
irfman
Posts: 37
Joined: Mon Nov 16, 2015 4:47 pm

Re: Data Validiation - Protection

Post by irfman »

any remedies? i want to have a drop down menu with only selection option, no editing etc, problem is when i use data validation with protection the cell is locked for selection as well.
OpenOffice 4.1.2 on windows 10
Post Reply