Even if I turn all writing aids off in the preferences, Calc applies unwanted autocorrection to text typed into cells, as you leave the cell. For example if I make a new Calc worksheet, and enter aff. maxmima into a cell, on leaving the cell, this gets changed to aff. Maxima presumably due to use of a rule that the first letter after a period should be a capital letter. (In fact, the period here denotes an abbreviation, so the rule is inappropriate). The real problem is that there is apparently no way to turn this rule off in the preferences, at least that I can see. (I don't want ANY such autocorrection rules being applied in Calc spreadsheets, thank you). Again, [lease note that this happens even after turning off ALL writing aids preferences. This issue happens in safe mode. It has been present in the last few releases at least.
P.S. This in on a Mac with macOS 10.13.6, in case that matters.
Hi Ralph, I am under Windows 7. When an autocorrection was just applied and I dont want of it, I use Ctrl+z at the correction time, before to type a new character. This would work by typing cmd M+z on a Mac. An other option is, since this is an autocorrection option, is to desactive it in: Tools > Autocorect Options > Options Tab: Desactive "Capitalize firs letter of every sentence". But this also desactive it in Writer. So active this option when you use Writer. Does this help you?
Using "Tools > Autocorect Options > Options Tab" does indeed stop this behaviour. However, this still seems to be a bug to me. Surely the Tools Menu should only apply to the current document? Global settings which affect all documents, as opposed to operating on the current document, surely ought to belong in the Preferences rather than the Tools menu? That's certainly how most other programs work, anyway. I never even considered looking in the Tools menu to turn this off.
I could be a request for enhancement but not a bug.