← Prev in month
← Prev in thread
DAYS360 third parameter should be Logical
Hi,
ODFF defines
6.10.7 DAYS360
Syntax: DAYS360( DateParam StartDate ; DateParam EndDate [ ; Integer Method = 0 ] )
Constraints: 0 <= Method <= 1
Semantics: If method is 0, it uses the National Association of
Securities Dealers (NASD) method, also known as the U.S.
method. If the method is 1, the European method is used.
LibreOffice Calc and Microsoft Excel and Gnumeric evaluate the Method
parameter as Logical (i.e. all values != 0 evaluate to TRUE). This
function should be specified as
Syntax: DAYS360( DateParam StartDate ; DateParam EndDate [ ; Logical Method = FALSE() ] )
Semantics: If method is FALSE(), it uses the National Association of
Securities Dealers (NASD) method, also known as the U.S.
method. If the method is TRUE(), the European method is used.
and the contraints be removed.
Eike
--
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A
Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/
Care about Free Software, support the FSFE https://fsfe.org/support/?erack
← Prev in month
← Prev in thread