Bug 96709 - EDITING: Calc copy Valitidy is not easy/clear, explicit option in Paste special is missing
Summary: EDITING: Calc copy Valitidy is not easy/clear, explicit option in Paste speci...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste-Special Cell-Validity
  Show dependency tree / graph
 
Reported: 2015-12-24 12:23 UTC by burnuser2
Modified: 2020-12-15 10:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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