Feedback by UserVoice

Eckhard

My feedback

  1. 1,028 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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

    Eckhard supported this idea  · 
    Eckhard commented  · 

    "by desgin" is a euphemistic paraphrase of the fact that you [Microsoft] yourself do not believe in the high value and importance of the Structured Tables (→ ST) - or did not recognize them.
    The productivity of Excel increases massively if you [Microsoft] would consistently support the possibilities of ST.

    Here are a few examples of shortcomings (-) and errors (--):
    - Data Validation does not refer to the columns of a table, but only to the "normal" coordinates.
    (annoying workaround: Range name Lastname=StructuredTable[LastName])

    Fix column (e.g. $C3* $D3) and copy to the right (Ctrl + R) must be very laborious to formulate in ST:
    =StructuredTable[@[Price]:[Price]] * StructuredTable[@[Quantity]:[Quantity]]
    $C3 → StructuredTable[@[Price]:[Price]]
    $D3 → StructuredTable[@[Quantity]:[Quantity]]
    Proposal: StructuredTable[@@Price]

    -- Conditional format leads to crashes when applied within a ST

    -- Formats (especially styles) are not reliably pulled along when the ST is extended downwards.

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

    We’ll send you updates on this idea

    Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

    Eckhard supported this idea  · 
    Eckhard commented  · 

    Errors (--) and deficits (-)
    -- Conditional format causes crashes when applied within a structured table.
    - Applies to" allows the specification of name ranges, but converts the named range to coordinates.
    The loss of the Named Area is very annoying because you can no longer model efficiently. - In contrast, the reference to the named area remains the same during data validation.
    - Styles (Custom styles) are very helpful for the systematic formatting of Excel. However, they are missing in the "Conditional Format" function. There, the benefit would also be very great.

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

    We’ll send you updates on this idea

    Eckhard supported this idea  · 
  4. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Eckhard supported this idea  · 

Feedback and Knowledge Base