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)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Paste-Special Cell-Validity
  Show dependency treegraph
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:
Regression By:


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"


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.
LO on Windows Vista