Nick Lamb schrieb:
Yes, in every case more or less the same problem occurs and the same fix is necessary. The user must explicitly indicate that the data being entered or imported is meaningless text, rather than allowing the software to decide for itself.
I often was surprised - and sometimes angry - about this behaviour of Excel. It is not easy to understand by an unexperienced user. Better way would be, that the only default distinction is between text and numbers.
Hard to say, if Gnumeric should clone _this_ bad usability of Excel, or if Gnumeric should make it better (and be less compatible).
Helmut Wollmersdorfer