Bug 71170

Per ISO-8601, the year that's used with the Week Number isn't always the same as the Gregorian calendar year for the specific date.  In particular, when a week straddles two years, it is considered to be part of whichever year the majority of the week's days fall under.  As an example, the week that contains Saturday, January 1, 2000 is Week 52 of 1999, because every other day of that week falls in 1999.  Conversely, the week that contains Monday, December 31, 2000 is Week 1 of 2001 because the rest of that week falls in 2001.   

Currently, there is no easy way to reliably get the year corresponding to the week number (e.g., "1999" for January 1, 2000, and "2001" for December 31, 2000).  Proposed solution: add a WEEKNUM_YEAR function that returns the year corresponding to WEEKNUM.  The WEEKNUM_YEAR function should take a second parameter that lets you adjust the results based on whether you want the week to begin on a Sunday or a Monday, just like WEEKNUM does.  

Likewise, I suspect that there's no way to format a Date so that January 1, 2000 will display as "1999-W52-7" and December 31, 2000 will display as "2001-W01-1": YYYY produces the Gregorian year, not the "week-number year".  

Note that ISO-8601 assumes that week numbers will never be mixed with ordinal days (e.g., December 31, 2000 is day 366 of 2000) or months when displaying the date, and that including a week number in the date's formatting code therefore implies that the year will be presented as the week-number year instead of the Gregorian year.  For full compliance with the ISO-8601 standard, LibreOffice should probably do the same: if week-number formatting is included, then YY and YYYY should present the week number's year instead of the Gregorian year.  However, there should probably be some means of overriding this behavior, letting the user explicitly ask for either the Gregorian year or the week number's year as he sees fit.  But I'm not sure how that would be handled.