Not only do I have to change the formatting back to the default with a menu option, I *also* have to retype the text. But somehow, unlike most other programs I type things into, I can't use the backspace key to correct a simple typo. Unfortunately, I'm imperfect, and sometimes I type the wrong thing. I write enough code to understand that having it magically know what I meant is impossible. I really don't mind working with Calc and understanding what it's doing. Secondly, even if I retype it *with* the equals sign to specify I mean a formula, it *still* changes it to a date. I don't mind the formatting - I'm happy to place an equals in front to tell it I meant a formula. It replaces the text I typed with something else. Firstly, when I *mistakenly* type 1/4 (no apostrophe, no equals) Calc does not simply format it as a date. There are two behaviors I want to turn off. If I wanted to format text nicely or build a database I'd be using a different application. That's why I opened up Calc in the first place. Nor do I want pure text formatting - I'm trying to do math, here. No, putting an apostrophe in front is most emphatically *not* all that is required.

Openoffice calc turn off autocorrect