[Libreoffice-bugs] [Bug 70551] WEEKS() function uses ISO weeknum and is not locale-dependent, which is not explained in the Help

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=70551

--- Comment #12 from Rafael Lima <rafael.palma.l...@gmail.com> ---
As of LO 7.4, indeed the WEEKS function is not locale dependent. It uses
NullDate as reference regardless of the locale [1].

The NullDate in LibreOffice is Dec 30 1899 [2].

[1]
https://opengrok.libreoffice.org/xref/core/scaddins/source/datefunc/datefunc.cxx?r=5e5138db#465
[2]
https://opengrok.libreoffice.org/xref/core/offapi/com/sun/star/util/NumberFormatSettings.idl?r=2b383d19

To check the NullDate, run:

Sub GetNullDate
    Dim aDate as Variant
    aDate = Thiscomponent.NullDate
    MsgBox aDate.Day & "/" & aDate.Month & "/" & aDate.Year
End Sub

-- 
You are receiving this mail because:
You are the assignee for the bug.