First time here? Check out the FAQ!
asked 2012-05-23 06:56:07 +0200
In Clac.. how do I set it up so there is no 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?
answered 2012-05-23 07:30:31 +0200luyu
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-23 06:56:07 +0200
Seen: 1,085 times
Last updated: May 23 '12