Feedback by UserVoice

Daniel Smith

My feedback

  1. 2 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
    Daniel Smith commented  · 

    Excel has complex numbers and matrix operations, but not complex matrices. Although any complex matrix operation can be broken down into real matrix operations, this approach results in a complicated and unmaintainable spreadsheet.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    info needed  ·  Yigal Edery responded

    Thanks for the feedback!

    Can you comment on whether you expect this to basically import all the lines as text to column A, or if you have some other expectation?

    Also, I’m assuming people refer here to the file/open path, and not to the Data/From-Text or New-Query/From-Text path.

    An error occurred while saving the comment
    Daniel Smith commented  · 

    I have implemented a "general format" button in an addin to restore sanity to csv file I open. Scientific format is rarely a good choice.

    Daniel Smith supported this idea  · 
  5. 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
    Daniel Smith commented  · 

    Yes, when I see 21:33.0 my brain says this is some time after 9 Oclock, but excel has unhelpfully hidden the hours from me, so I actually have no idea what the time is WHY IS IT LIKE THIS???????

    Daniel Smith supported this idea  · 
  6. 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
    Daniel Smith commented  · 

    Agreed, myself and many other people in my office have had to write our own vba functions so that we can convert between binary, decimal and hex without the crazily small maximum decimal value of 511. These is no excuse for this, as conversions without this limit are all present in VBA and the most it could do to existing spreadsheets would be to turn erroneous values into valid numbers.

    Daniel Smith supported this idea  · 
  7. 6 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 feedback. This is an area we are actively looking at for our future planning. Pease continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    An error occurred while saving the comment
    Daniel Smith commented  · 

    yes. I would really like this. I gave regularly been asked by Great idea. I am occasionally asked by colleagues if there is any way to zoom a scatter chart, but sadly due to our security settings at work there is no good method, even with vba

    An error occurred while saving the comment
    Daniel Smith commented  · 

    yes. I would really like this. I gave regularly been asked by collegues if there is any way to zoom a scatter chart, but sadly due to our security settings at work there is no good method, even with vba

    Daniel Smith supported this idea  · 
  8. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Great idea. I am regularly frustrated that logical AND OR and NOT do not work in array formula , forcing unwieldy nested IFs. Also the complex operations such as improduct di not work which means that a simple set of complex operations has to be spread out over multiple cells instead of calculated in on array formula.

  9. 811 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]

    An error occurred while saving the comment
    Daniel Smith commented  · 

    The main use of this is in charts, where it is currently impossible to (via formulas only) create a single x/y series where some values do not plot and do not have a line drawn spanning them (if the x/y chart has lines connecting points). The only current way to do this is to have a cell that is completely blank, and the presence of a formula in the cell currently makes that impossible.

    More generally, it would be very useful to have a value that a formula could return that:
    Does not evaluate as zero (messing up column averages etc)
    Is not an error (messing up column sums)
    Is not text, so does not violate checks for numbers e.g. when setting up a power pivot table.
    This null function would achieve this.

    An error occurred while saving the comment
    Daniel Smith commented  · 

    When plotting values on an xy chart with lines joining points , a completely blank cell in the y column causes a gap in the drawn line. This can be very useful, for instance when plotting a set of shapes or a map. However there is no way of making a formula in the cell cause a gap because the cell is then not completely empty. Suggestion is to fix this by providing a new worksheet function which returns a value which looks like an empty cell to the chart plotting logic.

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

    We’ll send you updates on this idea

    This is great feedback. We are looking into the details of this. Please continue to vote on feature ideas which will increase their likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

    Daniel Smith supported this idea  · 
  11. 19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Daniel Smith supported this idea  · 

Feedback and Knowledge Base