Libreoffice Calc cannot turn off AutoInput

When using Calc to store text data, it is very annoying to have Calc “autocorrect” your text. For example, it is impossible to have the first two letters capitalized when the third letter is lowercase. Unchecking Tools – Cell Contents – AutoInput did not correct this behavior in Libreoffice Neither did setting Format Cell to Text. Guess I’ll have to use Microsoft Excel! (well, GNUmeric actually)