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
Data Validiation - Protection
Data Validiation - Protection
- Attachments
-
- Example 123.xlsx
- (8.91 KiB) Downloaded 65 times
OpenOffice 4.1.2 on windows 10
Re: Data Validiation - Protection
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