This worked on OpenOffice Calc 2.4.1 running on Ubuntu 8.04 (Hardy Heron). (It is worth having a look through the other tickboxes here as there were several other things I wanted to untick, like fractionifying fractions and making URLs into links. Doing this should prevent OpenOffice from making any of the changes listed in the ‘Replace’ list. I clicked on each item that I didn’t want OpenOffice to ‘fix’ for me and clicked ‘Delete’ to remove the entry.Īlternatively, one can go to ‘Tools -> Autocorrect…’, select the ‘Options’ tab and uncheck the box next to ‘Use replacement table’. This tab allows you to define exceptions to the rules you set elsewhere in AutoCorrect. This gives a big list of all the auto-corrections OpenOffice will make. To turn off this behaviour, I went to ‘Tools -> Autocorrect…’ and selected the ‘Replace’ tab. Ctrl-z would erase the entire entry, rather than revert the copyright symbol to the string I typed in the first place. Unfortunately, every time I entered ‘Latin (C)’, the ‘(C)’ would get changed to a copyright symbol. To turn off the suggestions in Calc follow these instructions. Recently, I wanted to include a string like this: It is the most actively developed free and open-source office suite, with approximately 50 times the development activity of Apache OpenOffice, the other major. The option for auto complete in OpenOffice Calc is in different location as in Writer.

Openoffice calc turn off autocorrect