Feedback by UserVoice

Jaime Segura

My feedback

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

    We’ll send you updates on this idea

    Jaime Segura supported this idea  · 
  2. 285 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
    Jaime Segura commented  · 

    I can offer an VBA alternative (need to be copied on a module):

    Option Explicit
    Option Base 1

    Function SUMCOLS(data As Variant) As Variant
    Dim mat As Variant
    Dim rws As Long, cls As Long
    Dim i As Long, j As Long
    Dim vector As Variant

    ' transfer data from range/matrix to matrix
    mat = data

    ' in case original data was a single cell
    If Not IsArray(mat) Then
    ReDim mat(1, 1)
    mat(1, 1) = data
    End If

    ' get size of matrix
    rws = UBound(mat, 1)
    cls = UBound(mat, 2)

    ' create and fill vector
    ReDim vector(1, cls)
    For i = 1 To rws
    For j = 1 To cls
    vector(1, j) = vector(1, j) + Val(mat(i, j))
    Next j
    Next i

    ' return vector as answer
    SUMCOLS = vector

    End Function

    Jaime Segura supported this idea  · 
  3. 216 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
    Jaime Segura commented  · 

    MSCOMCTL.ocx works, but where is the calendar control?

    Jaime Segura supported this idea  · 
  4. 254 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. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

    An error occurred while saving the comment
    Jaime Segura commented  · 

    I think it would be great if it could have it's own type font and size so one can choose a monospaced one (helps a lot when building complex formulas). Also a "formatter" like on daxformat or Excelbeautifier would be useful!

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

    We’ll send you updates on this idea

    We agree that this feature would be useful for many users. The difficulty is that adding this feature would break compatibility for existing Excel users, Data models with this feature would not run in Excel 2013, 2016, or 2019. At this time, we consider compatibility to be more important than this particular feature. At some point in the future we expect to find a way to deal with this compatibility issue, but we won’t be able to address this anytime soon.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Jaime Segura supported this idea  · 
  8. 983 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex since named ranges can be dynamic, meaning that the range is calculated when the workbook is calculated.

    We’ll continue tracking votes for this suggestion.

    An error occurred while saving the comment
    Jaime Segura commented  · 

    Maybe the problem is that NAMED RANGES don't exist..... everybody thinks ranges are being named, but actually names are asigned to formulas, where in the end a range is also a formula. Therefore I think for Microsoft to apply conditional formatting to a NAME (which is a formula not a named range) might be a bit more dificult.... the only place where I've seen that Microsoft managed to assign such formulas (determining that there implicited related to a range) is on List validation

    Where I think could be more easy, could be on applying format condiitonal to ListObject (Tables) which already have structure...

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

    I think that it should go beyond names. Microsoft makes all new tools rely on table (ListObject), therefore Conditional Format should accept these "structured ranges"

    An improvement on the user interface is also needed... but I don't know how much they'll take to apply it. For instance, I'm a native spanish, and use Excel in spanish... Many years ago, I wrote a comment regarding huge errors on translation... and,,, wait, wait... till Excel v2016 where miracoulsy included the corrections I made, although they were actually facts, and shouldn't take any discussion to apply

  9. 174 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

    Best,
    John [MS XL]

    Jaime Segura supported this idea  · 
  10. 157 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 adding conditional formatting in charts!

    While we think this suggestion has merit, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments and will keep this suggestion under consideration for future development.

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

    Jaime Segura supported this idea  · 
  11. 187 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jaime Segura supported this idea  · 
  12. 215 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 post Charles! And thanx to folks for voting. Much appreciated. We definitely understand the ask and are keeping a close eye on this as it is moving up the vote charts .

    As always, please keep upvoting the things you are about most.

    Thanx,
    Prash [MS XL]

    Jaime Segura supported this idea  · 
  13. 831 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for your support for this suggestion. As some of the comments have concluded, there are a few complex technical issues and considerations that have delayed this from being implemented.

    We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future.

    One of the primary reasons for this request was to have a better way to handle formula cells in line charts, and this can be accomplished using the option to show #N/A as an empty cell. You can use the NA() function in your formulas as appropriate, and choose the option to “Show cells with #N/A as an empty cell”. To find the option for your chart, go to the Select Data dialog for the chart, and click the Hidden and Empty Cells button.

    We know there are other scenarios where a proper NULL()…

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

    Have you noticed that COUNTBLANK and ISBLANK react different with cells containing ="" ?

  14. 1,202 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]

    Jaime Segura supported this idea  · 
  15. 6,722 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

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Jaime Segura supported this idea  · 
  19. 298 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 Nick. We’ve got some related work we’re looking at soon, and we’ll be sure to carefully consider if we can get a fix in for this then. As always, more votes helps – so keep voting for the things you care about most.

    Thanks,
    John [MS XL]

    Jaime Segura supported this idea  · 
  20. 134 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jaime Segura supported this idea  · 
← Previous 1

Feedback and Knowledge Base