On Mon, Feb 11, 2013 at 4:25 PM, Hagar Delest <hagar.del...@laposte.net> wrote: > Le 11/02/2013 21:40, Rob Weir a écrit : > >> Again, you are looking for the "one true answer" and declaring that >> other answers are wrong. > > > No. Even if my personal inclination is for the undefined result, I can > understand the value 1. > But let the user decide and just warn him that he's facing a corner case > that requests his attention. > That's all. >
Maybe we should have spellchecker give a error for "their" because it is often confused with "there" ? Another example: When entering a number, a percentage sign multiplies the number by 0.01. This usually works fine, e.g., 5% is automatically translated into 0.05. But if you enter =5% % it will enter the value 0.0005. My guess is this feature is more often the result of a mistake than an intentional user input. There are dozens of such weird things in spreadsheets. I could imagine a special mode for giving warnings about things like this, but in normal operations I don't think we should distract the user about things that are not errors. And I certainly don't think we should treat all of these items as errors, at least not by default. Now back to the spell checking mode. In some spell checkers they are smart enough to give an error for "their". That is because they are *sensitive to the context*. They look at the context and can detect whether the word is misused in that context. I think we've all seen tools that do this. Personally, I find the, annoying since they given many false-positive error message. But treating "their" as an error in all cases? That is to give false-positives in almost all cases. That doesn't make sense to me. -Rob > Hagar
