Permanently and globally stop openoffice calc from autocorrecting 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:

1. Put an apostrophe (') before the string, telling Calc that the data following should be treated as a string;
2. As already mentioned: use formatting to set the cell content to "text".

Depending on the user's needs, Solution 2 could be set to be the default:

• change the "Default" style to text format (Menu Format -> Styles and Formatting -> right-click on Default -> Modify -> Numbers Tab),
• save that spreadsheet as template,
• and (optionally) set that customized template as 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.