When I type "15:45" or "21/12" openoffice Calc changes it to "15:45:00" and "21-12-2011".
How do I disable this globally and permanently?
I know you can use "Format cell..." and then select text, but I never ever want it to autocorrect dates/time.
This seems to be one of the most-disputed features of OOo.Calc. Calc needs to know whether to treat input as number or as text. It defaults to number, since it's main purpose is calculating stuff.
Up to now, AFAIK there are only two methods to preserve the literal string:
Depending on the user's needs, Solution 2 could be set to be the default:
Of course, this has the disadvantage that every input will be treated as text, not as a number, in spreadsheets based on that template. So, a solution may be to prepare such a "text" spreadsheet as template, but not as default template. < EDIT >: another approach consists in creating an additional cell style with "text" formatting (see above). This reduces the effort required to toggle between numbers and text to changing the cell style. < / EDIT > I fear that's all available at the moment.
Go to format, then to cells, then change the options to what you want them to be. Although it may not completely stop autoformatting, it will work tons better than any other option such as formatting to "text".