876 votes141 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Lead Program Manager
Data validation does not prevent wiping out everything in a cell simply by pressing the delete key or copying and pasting from another cell, even if Ignore Blanks is unchecked.
No warnings, it just happens!!!
Yet another "BUG" mess that needs to be fixed.
Only a protected worksheet or VBA code can prevent this and most companies don't want macro enabled worksheets. Not out of fear brought on by the malicious code warnings or because they think the code you've written may be doing bad things, but just the administrative nightmare for the IT department to manage which ones there going to allow to be run.
If you're lucky and the error checking rules haven't been turned off out of frustration you may get a little green triangle that's designed to confuse the average user, i.e. department head, when they hover over it and up pops a vague message designed for programmers. They're not going to think that it's something they've done wrong, nor should they. They're going to call you to come and fix it and when you explain you can't, it's part of how excel works, they won't believe you and you end up turning of the little green triangles and now you're caught in an infinite loop with the understanding of what it must feel like to be a computer with a dodgy programmer.Anonymous commented
If you go to control.cs in "referencesource.microsoft.com" which is part of the source code for C# and has been made available for all to read by Microsoft, read line 9801 which is part of the comments for the PaintWithErrorHandling function.
This may give you some insight as to what at least one Microsoft coder thinks' of their user's (our) coding ability and why our requests here may simply be ignored.
But just in case, I vote yes to this feature (bug fix) also.
Apologies in advance if I've broken any TOS here.
110 votes15 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →