Feedback by UserVoice

Roy

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

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

    We’ll send you updates on this idea

    Roy shared this idea  · 
  3. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy commented  · 

    INDEX() and MATCH() may do so, but those of us who like VLOOKUP() would love this functionality RESTORED to it. Yes, it used to have that, well, not explicitly linked to Tables, but now that Excel has settled on Tables as the base here, using column NAMES needs brought back.

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

    We’ll send you updates on this idea

    Roy commented  · 

    It could even allow entry of a cell address instead of a value for when you need a precise cell value, but clicking on it and copying it would require moving to an awkward place or losing a selection that might be obnoxious to reselect. Of course, that might allow one to sniff out info on a hidden sheet too, so that'd need taken into account.

    Roy 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

    Roy supported this idea  · 
    Roy commented  · 

    Actually, it looks like any format, other than date/time, standard or custom, which applies SOLELY to numbers (i.e.: as if one does not expect anything other than 0-9 and appropriate extras like . or , or ^ or $ or / or... well, you see the idea) will get these results. Any formatting expecting non-numeric character entry such as "Text" changes the + to an = and keeps the detail.

    Interestingly, an entry like " +++11000/12 " gives an equal sign on pressing Enter: =++916.666666666667 . Pressing F2, then Enter does the usual dropping of the leading + (so once gets =+916..., twice gets =916...) but once the = is present it remains forever, even though the detail of the original calculation was lost intantly (i.e.: it never had, say, =++11000/12).

    Sadly, the technique of using the +'s is TAUGHT to lots of folks...

    It would be nice indeed if they tightened this up. But in a way that keeps it for all those trained to use the +'s and for all that legacy work.

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

    We’ll send you updates on this idea

    Roy commented  · 

    The SUM in the status bar is -2. NOT 2.

    BUT, since it shows no coloration, AND the format has no character-based negative value indicator (a hyphen, parentheses around a negative number, what-have-you...), just the color to indicate a negative value with, it looks like +2. But it's really the proper -2.

    So, a suggestion to make, rather than just a report of a sort-of-bug, might be to ask for the status bar to not just be nice and show the sum in all the glory the cells format allows EXCEPT color choices, but rather to include all possible number formatting that the cell might have.So for them to definitely add color to the status bar sum reported.

    That'd be nice anyway. Who needs all that gray everywhere??? Scroll bars could be another color so they stand out in the gray background, Zoom could, the menu's, errr..., I mean ribbon's titles could...

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

    We’ll send you updates on this idea

    Roy shared this idea  · 
  8. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy commented  · 

    Lord yes. Nothing should ever be destructive like that. Especially that tight little world.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy commented  · 

    It has it already.

    Do you mean "inline" (as you type) spellcheck like in Word?

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

    We’ll send you updates on this idea

    Roy commented  · 

    Yes, or on the context menu. Click it and anything sleected is "=TRIM()'ed" inside and out.

    Have the button available too and clicking IT gives options (Left only, Right only, Inside only, 2 of 3, or all 3).

    That way full functionality is available in the button, and the normal (you know, MY normal...) available on the context menu for quick, regular use.

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

    We’ll send you updates on this idea

    Roy commented  · 

    I'm with Amy. Nowhere in my world do I need obnoxious little details annoying me when it would be incredibly easy for them to be fixed.

    On a less personal level, in the real world a printer gets a new knife for cutting pages and puts at least some degree of thought into "Is this knife suitable? Is it cheap trash about to destroy the machine when it shatters in use? Etc." before putting it in. He even knows he has no way of knowing. But if the knife is dull colored, has a bit of rust on it, and looks a wee not perfect in the chamfered edge along its back, he's sending it back to the source with complaints. Because all he actually can see is it's not bright and shiny and the chamfer is not perfectly pretty all along the back edge. People do the same with spreadsheets. Even when grudgingly accepting them in the end, seeing a couple little hyperlinks with text not the same size as all the others makes them WORRY (in caps in their heads) "what other little details were skipped" by a lazy spreadsheet creator?

    And grudging acceptance or not, you have to work hard to get miserable unimportant details to not be regarded as indicative of formula failures rampant throughout. And your reputation as a spreadsheet creator is forever dented.

    And it's annoying. Such a little thing, this little bug... oh, um, "feature."

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy shared this idea  · 
  15. 120 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy commented  · 

    We have "styles" so why not use the same kind of code for setting up Page Setup "styles" we can select for a worksheet or file, then modify as and if needed on a worksheet? Or select several tabs, then apply the Page Setup "style" all at once. With maybe an "Apply To Chosen Worksheets" button in case the setup isn't in our previously defined styles? (You know, so you don't have to do the whole silly "Open Page Setup, Make a change, Save (applying it across select sheets), then change it back and Save again" routine that we have to apply to so many things?)

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

    We’ll send you updates on this idea

    Roy commented  · 

    @Franz: Sorry, one last clarification. If your colleague then changed the code, perhaps to "TTT", he would type precisely that, T-T-T, and Excel would store it internally (using my example below) as "uuu" and when he sent it back to you, you would never see either of those: it would show as "ddd" to you. Each of you is using abbreviations that make sense to you (or presumably you'd've chosen a different language version of Excel). So each of you USE and SEE logical language-appropriate codes while Excel really stores it however makes best sense to Microsoft. Everybody wins.

    Roy commented  · 

    @Franz: Then we ARE talking about the same thing. I am not predicating anything on the Windows language version or settings. Solely the language used in the user's copy of Excel. So YOU use an English language version and use a date code of literally "dddd" which makes perfect sense to you because "d" = "day" fits your English language expectations. It works perfectly. You send it to a colleague who uses a German language version of Excel because, presumably, he prefers German. What HE sees when he looks at your date code is "TTTT" (i.e.: he does NOT see the "dddd" you typed in). That makes immediate sense to him and eases his understanding of the code and happiness with the spreadsheet. What neither of you know, or care about, is that when you typed that "dddd" in your spreadsheet, Excel really saved it as, say, "uuuu". But that is completely INTERNAL to Excel: neither of you will ever see "uuuu". YOU see it rendered for English Excell as "dddd" and your colleague sees it rendered for German Excel as "TTTT". Notice that this is utterly independent of your Windows language version/settings: even though your Windows is in Italian and uses Italian date settings, you will NEVER see "gggg" because this only involves Excel and ITS settings, not the Windows language and settings. All done here though.

    Roy commented  · 

    @Franz: Yes, the operating system does impact how things come up, etc. But I thought you were looking for the actual formulas used by people to show things in the formula using language appropriate symbols. I use English Excel and would not find using "T" in any way intuitive the way I do find using "d" for "day." But more so, if I share (or create for) a worksheet with a, say, German individual or company, I will desperately want to use "d" but will equally desperately want the German user to see "T" when using or evaluating the spreadsheet. If Excel used some underlying code that we never see, it could present "d" to me (opening it with English Excel) yet, without missing a beat or making any change at all, present "T" to the German user using his German Excel. But it looks like I missed your point in the suggestion. Still, I'd like to see it so work can be directly shared much more easily. And a worker in, say, Malaysia, could create a useful spreadsheet for me without ever learning more English than needed for negotiating the contract to produce it.

    Roy supported this idea  · 
    Roy commented  · 

    It seems like a simple abstraction. Excel would use a set of codes only it has access to for the actual saved version of any such format. Excel would (does?) check for language default when starting (could offer options here) and show codes in the formulas displayed according to the language appropriate abbreviations. For instance, the "gggg" displayed to the Italian default language user, and used by that user, but the actual saved formula would be whatever (say "!!!!" for all it matters. A German user might see "TTTT" while I might see "dddd". In fact, ALL language related matters in formulas could be done this way. Or if they already are, then this could be slipped into that functionality.

  18. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy supported this idea  · 

Feedback and Knowledge Base