Feedback by UserVoice

Emre Poyraz

My feedback

  1. 195 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion, thanks David! And thanks to other people who took the time to clarify/comment on this one. There’s definitely room to tighten this experience up in a number of places. We’re getting a lot of traffic on the site, so please keep voting for the things you care about most to help us do a great job of prioritizing.

    Best,
    John [MS XL]

    Emre Poyraz commented  · 

    Hello, I agree with you all. Conditional formatting with formulas is quite a mess.

    I think the main problem is this: there is a conflict between APPLIES TO and SELECTION. Excel is trying to choose one row less then our selection and apply the formula accordingly, but messes up.

    Compounding this problem: When you have a table in Excel, the first CTRL+A selects the table WITHOUT the header. The second CTRL+A selects the table WITH the header. This makes it more difficult for Excel to decide where to apply the formula to.

    I have to manually change this everytime I use conditional formatting with formulas (Manage Rules). Check the first row in Applies to and change to formula accordingly (interestingly, it works well after the first change).

    I believe this can and should be fixed.

    PS: If you dont want the arrow to point to new cells using arrow keys, press F2.

    Cheers.

  2. 6,287 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wow.

    Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

    Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

    We’ll provide updates as we progress on this feature request.

    Thanks!

    Ashvini Sharma
    Lead Program Manager
    Excel

    Emre Poyraz commented  · 

    hello,

    I dont think Python should replace Excel functions. Excel functions are very mature and popular.

    But how about having a Python based macro ability for excel? This could be an add-on. Python modules for Excel are not good enough to replace VBA.

Feedback and Knowledge Base