Feedback by UserVoice

sebastienm

My feedback

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

    We’ll send you updates on this idea

    sebastienm supported this idea  · 
  2. 260 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
    sebastienm commented  · 

    (hopefully i understand the issue described by everyone's post)

    Personally, my issue is not about the expansion as i can use:
    =SUM(B5#) * NOT(COLUMN(B5#)=FALSE)
    which does expand because of the COLUMN function
    (and the "*NOT( )" always returns *TRUE = *1)
    -- same idea with rows and ROW ( )

    But when i use the intersection operator (space) to reference a single column:
    B5# B:B = intersection of the B5# array and column B:B
    =SUM(B5# B:B) * NOT(COLUMN(B5#)=FALSE)
    the B:B doesn't auto update to C:C, D:D... I do understand why: all cells of the dyn array share the same formula.

    So i guess my request would be a function that returns the reference to the column :
    TheColumn(B5#) returns B:B in the first cell, C:C in the second cell, and so on.
    In the end , i could just write:
    =SUM(B5# TheColumn(B5#) ) * NOT(COLUMN(B5#)=FALSE)
    even better:
    = SUM(B5# TheColumn(B5#) ) where TheColumn forces the horizontal expansion

    This way, it works with SUM, COUNT, ...

  3. 209 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
    sebastienm commented  · 

    yamashiro.akihito is correct: the MSCOMCTL.ocx now works with 64bit Excel.
    See picture. I'm using Office 365 64bit.
    : )

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

    We’ll send you updates on this idea

    sebastienm shared this idea  · 
  5. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    sebastienm supported this idea  · 
    An error occurred while saving the comment
    sebastienm commented  · 

    Moderator: Would it make sense to merge this request with "Total row at the top of a table" ?

    Agreed with Kenneth.

    1- Grand Total For Rows: Right now, it is always displayed in the right-most columns. Would be useful to have the ability to show it on the left side between the 'Rows' area and 'Values' area.
    2- Grand Total For Columns: Right now, it is always displayed in the bottom rows. Would be useful to have the ability to show it either:
    2a. at the top of the table between the 'Columns' area and the 'Values' area (below the header), or
    2b. above the table, between the 'Filters' area and the 'Columns' area (above the header) , with the option of re-displaying the headers.

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

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    sebastienm shared this idea  · 
  7. 9 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
    sebastienm commented  · 

    Related. Not sure this would solve the request from Michael. And maybe we are just saying the same thing:

    Problem:
    With long lists, once you scroll a bit, the Select All checkbox (or Clear All) is not visible anymore and therefore not readily accessible.

    Solution:
    It would be good to have this checkbox (or Select All/Clear All buttons) *at a static position* either right below the Search Textbox or at the bottom below the scrolling area, i.e. it would always be visible and wouldn't scroll with the other items. -- Thank you.

  8. 23 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.

    Thank you again, and please keep sharing your thoughts!
    Auston [MSFT]

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

    We’ll send you updates on this idea

    sebastienm supported this idea  · 
  11. 4 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
    sebastienm commented  · 

    Kenneth,
    Unfortunately, having the end user resize some rows each time data is refreshed in a multitude of reports is not an option. Users in Finance have been complaining about this this since the 90s; it is a widespread issue.
    I made this feature request during the development of Excel 2007; i remember clearly as it was the first time MS opened a suggestion site... which is great by the way. Thank you MS :)

    Scenarios:
    When the offending text is part of a 'group by' of a pivot table, if you use 'Wrap Text' then the row height is resized each time you refresh the pivot or each time the user change the grouping, unfortunately.
    Same with queries.
    The only time it works is when the text comes from a formula. In this case, having 'Wrap Text' doesn't trigger the resize of the cell.

    In summary, when you build a report on dynamic data, or you provide an analysis tool, the end users shouldn't have to resize or change the frame/format.

    Thank you,
    Sebastien

    An error occurred while saving the comment
    sebastienm commented  · 
  12. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    sebastienm shared this idea  · 

Feedback and Knowledge Base