Feedback by UserVoice

Anonymous

My feedback

  1. 768 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Anonymous commented  · 

    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 supported this idea  · 
    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.

  2. 93 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 

Feedback and Knowledge Base