> The text you typed in (or loaded from a CSV file) should be preserved That’s even worse, since a user assumes the cell holds what it shows. Excel, for exampl

> The text you typed in (or loaded from a CSV file) should be preserved That’s even worse, since a user assumes the cell holds what it shows. Excel, for example, auto completes entries, which is extremely useful for data entry, and for accuracy. If it only held the few characters entered, now it has to repeat exactly the same autocompletes every time it opens, and has to do so even if the data that originally caused the auto complete changes. All this is nearly algrithmically I’m-Seville without changing the document into a history. And now CSV is useless for data transfer. It’s vastly more sane to change to the data the user meant to enter, show it to the user for confirmation, and save that. That the 99.99% use case bites the remaining 1 in 10,000 is a perfectly reasonable trade off, done throughout society in uncounted ways.