Bug 96709

Summary:	EDITING: Calc copy Valitidy is not easy/clear, explicit option in Paste special is missing
Product:	LibreOffice	Reporter:	burnuser2
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	cno
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=115081
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108479, 108988

Description burnuser2 2015-12-24 12:23:54 UTC

In Excel there are 2 solutions to copy a (changed) Data => Validity

1.) In Data => Validity: checkbox "Apply these changes to all other cells with the same settings"

https://support.office.com/en-nz/article/Apply-data-validation-to-cells-c743a24a-bc48-41f1-bd92-95b6aeeb73c9

2.) Copy + Paste Special: Validation


In LibreOffice:

1.) Validity: ... no "copy to all" option
2.) Paste Special: ... no Validity option

Copy Validity with "Paste Special: Formats" is possible, but:
a) not obvious and not logical
b) not OK if someone don't want to copy the cell-format also

So, at least the second option as separate item (Paste Special: Validity) would be very useful!

Comment 1 Cor Nouws 2015-12-24 15:37:53 UTC

Thanks brunuser for the report. 
I set it to new.

Comment 2 burnuser2 2017-01-08 10:08:47 UTC

Bug is still present. No changes in bug behavior.
Testsystem:
LO 5.2.3.3 on Windows Vista