https://bugs.documentfoundation.org/show_bug.cgi?id=162598
--- Comment #3 from ady <[email protected]> --- (In reply to Fred from comment #2) > If the 31st of December is in the last week of the year, WEEKNUM should say > 52 or 53, not 1. That's incorrect. Please read the Help content about this function. > > Moreover, plenty of functions have defaults to be compatible with Excel and > Docs. I have tested this in both, as well as in Calc, and the expected > result is not 1. Maybe you mean to use a different function in Calc? Perhaps WEEKNUM_EXCEL2003(), or ISOWEEKNUM(), or... Are we talking about an ods file? Or is it about an xls(x) file? Are the results different when saving and reloading with different formats? -- You are receiving this mail because: You are the assignee for the bug.
