← Prev in month ← Prev in thread

DAYS360 third parameter should be Logical

From
Eike Rathke <>
Date
2016-05-27T11:25:55+00:00
ID
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