The default depends on the locale but this is easily overridden by the setting under > ‘Format Cells…’ > ‘Numbers’. The date format actually used by Cells to display correctly represented date values is independent of the recognition patterns. It will, unfortunately, also allow for “2-digit-years” but you won’t worry. If “5” was not recognised as the 15th day of november 2014, e.g., you may add there “ Y/M/D” (the semicolon only delimiting this pattern from preceding ones) and next time recognition will work. If a date formatted as a text entered or imported is not recognised by your LibO Calc you have to add a recognition pattern via ‘Tools’ > ‘Options’ > ‘Language Settings’ > ‘Languages’ > ‘Language of’ > ‘Date acceptance patterns’. If dates are entered (or read from a csv in most cases) they originally are strings, unfortunately, and need recognition by an automated process for conversion. (Let us see one row of such a csv to get more detailed advice.) Never enter dates via keyboerd explicitly as text.ĭon’t work on dates by text (string) manipulation during/in advance of import. How this will reliably work may depend on details of the csv you get them from. Make sure you always import dates as numeric values.
If you want to get the “dates-and-their-formats” problem actually solved:
0 kommentar(er)
