Interesting observation.
have Excel run data validation for those cells if those cells contain data validation?
But that would be after the fact. DV applies to new data entry, not to existing cell values.
And implementing the "data validation" with VBA code to perform the checks defeats the purpose of having a DV feature in Excel in the first, IMHO.
-----
PS.... I suppose MSFT might justify the current behavior by arguing that DV tests
data entry, whereas paste-value pastes
values.
It is not the same as "data entry".
It is a subtle distinction.
To demonstate, in a new worksheet with no DVs, enter the formula =1+2.22E-16 into A1, copy A1, and paste-value back into A1.
Note that =A1-1=0 returns FALSE because the value in A1 is not exactly 1.
Now, copy A1 and paste into C1. Note that =C1-1=0 also returns FALSE.
So, we can
paste values that have more than 15 significant digit of precision, but we cannot enter 1.000000000000000222 (15 zeros)
as data.