Permanently and globally stop openoffice calc from autocorrecting dates/time
Fresh3 days ago
Mar 15, 20267619 viewsConfidence Score0%
0%
Problem
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.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Permanently and globally stop openoffice calc from autocorrecting dates/time
Low Risk
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 prese…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix