CALC unable to autocomplete date series yyyy/mm/dd?
I need to track some dated numbers across many years and figured I could do a simple sheet per year, 2000, 2001, 2002, etc with the calendar dates 365 cells vertically down column A, 2000/01/01, 2000/01/02, 2000/01/03, etc.
Formatted column A to Date YYYY/MM/DD
Filled in the first three cells, tried to autocomplete and LO goes
2000/01/04 2000/01/05 ... 2000/01/31 2000/01/32 2000/01/33 ... 2000/01/125 ... 2000/01/365
Not quite working as intended, I think.
Autocompleting the date series seems to only work in the default dd/mm/yy format, but as my brain is not wired with the American date format, that is not really desirable to me. But, I suppose I will be forced to go that route and then afterwards, after having built all the years, reformat the date columns.
What format is "YYYY/MM/DD"? ISO 8601 doesn't mention that. Did you try with a proper YYYY-MM-DD?
(Anyway, your data looks to be text, not date, which makes cell formatting irrelevant. If it contained proper dates, then formatting YYYY/MM/DD would still produce what you wanted.)
Please read what a date is: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017888_715980110 and note that formatting a cell to your notion of a date doesn't influence in any way the date recognition algorithm of LibreOffice.
No, it does not conform to ISO 8601, but sometimes one has no control over the format.
I have a data acquisition device that produces CSV data files with dates in YYYY/MM/DD format and until sometime last fall Calc accepted the dates without any problem. Ever since the change (Calc update?) I struggle every week to get my Calc spreadsheet to correctly interpret the weekly thousand-plus data entries.
...but OP stated, he manually added the first few cells and my urgent advice (to prevent these endless date format questions here): Regardless how you have (date-) formatted your cells, use
YYYY-MM-DDwhen it comes to enter a date