How can I turn off ALL automatic formatting?

[INeedHelp]

In Calc … how do I set it up so there is no automatic formatting of any kind … I DO NOT want it to auto set dates or turn http::// into hyperlinks. .I just want everything to be text and stay that way … I am going mad trying to get this to work … I can select a cell and go “Format/Clear Cell Formatting” but as soon as I hit tab or enter it will re-format it to all sorta of unwanted rubbish.

I have done a crtl+a right clicked and gone “format cells” and set it to TEXT … but it will still auto format http::// and dates and other crap

There MUST be a way to simply remove ALL the formatting in this application so you are just entering text values?

[luyu]

Tools → AutoCorrect options
Uncheck every setting under Options and Localized Options tab. Uncheck also both Autoinclude options under Exceptions tab if you don’t need that feature.

If you’re using more than one language for your documents, select them from “Replacements and exceptions for language:” box at the top of AutoCorrect window and repeat the procedure.

If you don’t want some value to be formatted as date, start typing it with single quote (’). For more, take a look at Disable Date Formatting in Calc.