4 ms·
It really bugs me when computers try to figure out what you mean. What I mean is what I typed, and if I typed it incorrectly, I would delete it and type it agai
by thesuitonym 2y ago
It really bugs me when computers try to figure out what you mean. What I mean is what I typed, and if I typed it incorrectly, I would delete it and type it again.
- ryandrake 2y agoIt's probably the most pervasive and irritating recent (last two decades) trend in all of computing. "Did you mean?" NO IF I MEANT THAT I WOULD HAVE TYPED IT. "It looks like you are..." NO. "Are you sure?" YES. Computers need to stop second guessing users.
- FeteCommuniste 2y agoI don't mind hints as much but what really sours me on a program is when it simply makes automatic edits to what I typed.
- SamBam 2y agoWhat do you mean when you type in '"1/2" + 1'? Unless you just want to keep that text as plain text, it's going to be doing some interpreting.
- DiggyJohnson 2y agoDevil’s devil’s advocate here for better interpretations: - 1.5 - CONV_ERR: invalid operator for type TEXT
- jayd16 2y agoThe answer is 1/21, clearly. I guess what it should do is give a green squiggly if the implicit conversions are suspicious.
- realo 2y agoI cannot imagine any programming language interpret "1/2" as a day and month in that specific context. It takes a very special mindset to do that, maybe the kind that comes from a junior MBA manager, for example ... and even then I find that farfetched. It sounds more like one of those things that is observed, but some manager decided it is not high priority enough to fix right away. And then technical debt raises its ugly head.
- hnlmorg 2y ago“1/2” is a string. So “1/2”+1 is either an error because of datetype mismatch (which is terrible UX for a spreadsheet or going to mean one of the following to scenarios: Date plus a day “1/2” concatenates with “1” The latter is wrong, the former, while unexpected, does kind of make the most sense here.
- SAI_Peregrinus 2y agoExcel allows bare strings, so `"1/2" + 1` is a string with embedded quotation marks. So that's a third option for what to do.
- hnlmorg 2y agoTrue. And that would probably make the most sense too. A very good point you’ve made there :)
- dmurray 2y agoWhy would you favour "date plus a day" rather than "number plus a number"? I agree Excel has to guess, and in isolation guessing that "1/2" should be parsed a date is not a terrible choice, and that parsing the individual components separately is simpler and more predictable than using the full context that it's about to be added to a number. But evaluating to 1.5 would raise few eyebrows.
- hnlmorg 2y ago> Why would you favour "date plus a day" rather than "number plus a number"? Date is a number though. It’s only when we print them in a human readable way that they become anything else. Whereas 1/2 is an expression.
- fragmede 2y agoHaven't seen "1/21" as an answer yet
- thesuitonym 2y agoIf I type in 1/2, that means 1 divided by 2, or 0.5. If I then type +1, that means add 1. 1/2 I should never mean any kind of date, unless I'm entering it into a field that has already been declared a date field, or I have written that, then declared the field to be a date field.
- post-it 2y agoI think most people that enter `1/2` in a spreadsheet do indeed mean `January 2nd` and not `0.5`. In the wider world of people using spreadsheets, dates are certainly more common than fractions.
- lawn 2y agoIn Sweden we don't use that numbering scheme and instead use Day/Month Year (which makes more sense as it goes from smaller to larger).
- brassattax 2y agoIt would be interesting to know if your Excel correctly interprets 1/2 as 1st February based on your international settings.
- dreghgh 2y agoSpoiler: it does.
- niij 2y agoI think it's just what you're used to. If counting from smallest to largest was inherently better, then a dozen would look like 21, not 12. Little vs Big Endian, I suppose.
- lawn 2y agoThe issue is when you do Month/Day/Year, then you lose consistency. Both Year/Month/Day or Day/Month/Year are more logical.