Feedback by UserVoice

S. Stockton

My feedback

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    S. Stockton commented  · 

    At least Win10 has fullscreen filter mode. It defaults to "somewhat yellow", but can be made quite orange. Night Mode.

    S. Stockton supported this idea  · 
  2. 6,589 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

    An error occurred while saving the comment
    S. Stockton commented  · 

    @Roy - See also: OpenPyXL, xlwings.

    An error occurred while saving the comment
    S. Stockton commented  · 

    VBA, and even almost every VBA tutorial I've seen + almost every bit of VBA sample code I've seen, _and_ all VBA code produced by the macro recorder promote Very Bad Things. Unsafe things. Slow things, like .select() and .selection(). Things that "just barely work, given the right circumstances", and sometimes things that only seem to work. Esoteric things, that have bizarre and sometimes undocumented side-effects.

    VBA emits mostly-useless error messages. Like: "object-defined or user-defined error" when actually no error was defined, and the error arose outside of VBA code anyway.

    VBA encourages use of MsgBox(), which is Horrible, in part because whenever this is called, the entire Excel interface (in every open workbook in the same instance of Excel) becomes unresponsive. But can still bring other workbooks to the front, just not interact with them, and Excel gives no indication why. The message box produced by this call doesn't show up in Alt-Tab or on the taskbar, either. A partial solution is Application.Assistant.DoAlert(), because then at least the message box will appear in front of any workbook that you try to interact with.

    If you want to know how "easy" VBA is, read posts by Rubberduck on StackOverflow and on RubberduckVBA.

    I don't know Python well, but for the many people who have learned it for some other purpose, it's easier than dealing with the many quirks and hidden traps of VBA. Projects which bolt Python to Excel like a sidecar include: PyXLL, OpenPyXL, Python for Excel (PFE), xlWings.

    I, for one, welcome our new Python overlords, and would be in favour of building them a new house and IDE inside Excel.

    S. Stockton supported this idea  · 
  3. 157 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    39 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    S. Stockton supported this idea  · 
  4. 1,056 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    An error occurred while saving the comment
    S. Stockton commented  · 

    @{this is a shame} Similarly, why on earth must Excel continually clear the clipboard? For instance, why does "Esc" key mean not only "remove the dashed boarder around what I copied" but also "clear clipboard? An application shouldn't touch the clipboard unless instructed it to put something else on it. Dainbramage! Say I goto another program and copy something; frequently Excel decides it knows better, and thinks that in fact I didn't really want anything on the clipboard. As an unreliable workaround, I've taken to using a "clipboard manager" tool keep the last several clipboard items; every once in a while, it can't paste quite the same content as if the clipboard hadn't been cleared, but at least there's /some/ way to smack Excel around and say "No, I really did need the contents of the clipboard.". Windows 10 has a built-in clipboard manager, but I can't rely on it always being available (usually due to Group Policy).

    The lack of separate Undo stacks for each Excel document also is …unfortunate… because running ALMOST any VBA will destroy the entire Undo history for the whole application.

    I'd like an optional Undo Actions palette, like PhotoShop — preferably with mini preview of the affected area — where I can click any point in the list to jump backward or forward in history without having to step through each intermediate stage.

    S. Stockton supported this idea  · 
  5. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  6. 547 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  7. 541 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  8. 684 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  9. 1,152 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  10. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  11. 180 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    S. Stockton commented  · 

    Look for the Excel-DNA XFunctions Add-in. It's on GitHub, giving you XLOOKUP and XMATCH. Last I checked, it's syntax matches previous syntax from Microsoft's beta testing period The Excel blog article 811376 has the current syntax, and a request to update the XFunctions add-in to match the latest syntax already exists (just need somebody to submit a patch on GitHub).

    An error occurred while saving the comment
    S. Stockton commented  · 

    Excel-DNA on GitHub has a free open-source addin that can be loaded in other Excel versions. However, Microsoft has changed the x-something functions after the 2019-10-28 update of the addin.

    https://github.com/Excel-DNA/XFunctions

  12. 100 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  13. 398 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    S. Stockton commented  · 

    From my perspective, it would be Really, Really Nice if, whenever Excel displays a window with a formula/cell-reference box, it displayed some visual indicator that (despite these looking like normal text boxes), most of the normal text-editing keystrokes DON'T WORK and will in fact ruin what's in the textbox by inserting various types of cell reference. A different issue, I know.

    But related, because, to defeat this dainbramage, you have to already know to press F2 to put a normal-looking text box into a mode that allows normal text-editing — and worse, no matter how many times you press F2, there's NO WAY to know which mode is current without either keeping track in your head of whether you've pressed F2 an even or odd number of times (and assuming you didn't accident'ly double-press at any point), or trying to do something basic like pressing an arrow key to see if the insertion point moves like it's supposed to (in any normal text box) or if the contents get increasingly clobbered by cell references with every press of the key.

    Ahem, sorry for the rant. I'm obviously bitter. Wonder if there's an UserVoice page about this… Looking now.

    (EDIT: Well, that was a brief search. The search box returns everything related to Excel, if I search for "Excel F2", and returns nothing if I search for "F2". I'll have to think of another way.)

    S. Stockton supported this idea  · 
  14. 43 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    S. Stockton commented  · 

    (ノ ゜Д ゜)ノ ︵ ┻━┻ ︵ ןǝɔxǝ ʇɟosoɹɔıɯ
    (╯°□°)╯︵ ┻━┻ ︵ ╯(°□° ╯)

    Ahem. I mean… keyboard-inaccessibility for the lose.
    Several Excel side-panels have the same issue.
    And relatedly, when the resizing the Excel window causes the Ribbon to shrink, the key-sequences needed to trigger various commands change, as well.

    Quattro Pro is still for sale; wonder how well it works these days?
    Or SoftMaker Office.
    Or even LibreOffice/OpenOffice. (^_^)

    S. Stockton supported this idea  · 
  15. 155 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    S. Stockton commented  · 

    Kenneth Barber is a steely-eyed Human Interface Guidelines man.

    S. Stockton supported this idea  · 
  16. 3,226 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!

    Eric Patterson (Program Manager – MSFT)

    An error occurred while saving the comment
    S. Stockton commented  · 

    @Ed Hayes
    You imply that when not doing either of those things in Excel, row heights and column widths will never be large enough to make scrolling…unfortunate. For row heights at least, I'd counter that Excel should at least be able to scroll per line of text (and show an 'incompletion' indicator on the edge of the cell row that's not entirely in view).

    I agree that having COVID-19 data in Excel does not imply that row heights will be taller than normal, nor does it imply a massive productivity sink.

    An error occurred while saving the comment
    S. Stockton commented  · 

    Most other spreadsheets seem to copy Excel's scrolling behaviour: no matter how tall a row is or how wide a column is, just scroll-jump one whole row or column at a time.

    I agree this is nefarious when one ore more rows or columns are very tall or very wide.

    Excel can't even scroll the document while you drag the scrollbar's "thumb" (the bit which shows how far you are into the document, and on most systems also shows how much of the document fits in the current view). Excel only completes the scroll action when you let go.

    LibreOffice and SoftMaker PlanMaker gets the second bit right, make the document scroll while you drag the thumb. The still jump-scrolls large rows/columns, though.

    I guess this means if we REALLY want to be able to scroll partly through a cell, then we need to design mockup images of our own solutions, post them, and/or get down and dirty in the open-source code of a spreadsheet like LibreOffice or OpenOffice.

    S. Stockton supported this idea  · 
  17. 606 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  18. 586 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  19. 722 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    S. Stockton supported this idea  · 
  20. 743 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 again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    S. Stockton supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base