No shaving off leading zeroes, no assuming I want a formula unless I explicitly prepend the cell with an = (or whatever the syntax is). If I want a string that starts with a hyphen, it’s just a string that starts with a hyphen. If I open a CSV or TSV file and save a copy without doing anything to it, it should be identical to the original down to hashing the same.
But I’d also like the nice auto-filtering capabilities that excel has, where there’s a dropdown on each column for sorting and searching.
Does such a program exist?
Prepend every cell entry that you want to be left alone with a single quote. i.e. an apostrophe, not a lone double-quote mark.
Alternatively, most word processors come with a table creator that may allow you to create something that behaves how you need. It’s been a while since I did anything quite so complex, so maybe the (un)helpful features have been ported across to those tables too.
But as at least one other comment says, those features are often autocorrect rules and they can be disabled.