RE: [office-comment] DAYS360 third parameter should be Logical

["Dennis E. Hamilton" <dennis.hamilton@acm.org>]

I provided the following cases in an OpenDocument Spreadsheet (.ods) file and obtained these results in all of Apache OpenOffice 4.1.2, LibreOffice 5.0.0, and Microsoft Excel 2016:

 	330 =DAYS360(DATE(2015; 2; 28); DATE(2016;1;31))
	330 =DAYS360(DATE(2015; 2; 28); DATE(2016;1;31);0)
	330 =DAYS360(DATE(2015; 2; 28); DATE(2016;1;31);FALSE())
	332 =DAYS360(DATE(2015; 2; 28); DATE(2016;1;31);1) 
	332 =DAYS360(DATE(2015; 2; 28); DATE(2016;1;31);TRUE())
	332 =DAYS360(DATE(2015; 2; 28); DATE(2016;1;31);2)
	332 =DAYS360(DATE(2015; 2; 28); DATE(2016;1;31);-20)

The proposal to change the optional parameter to Logical with default of FALSE() will not impact interoperability so long as the rule for conversion of NUMBER to LOGICAL is retained in the specification.

This change should not impact existing OpenDocument Spreadsheet instances or ODF down-version implementations of DAYS360.  It also prevents a future breaking change where values different than 0 and 1 are given special interpretation.

I personally see nothing objectionable in Eike's proposal.  I have not consulted the Apache OpenOffice Project.  I will do so by forwarding of this comment.  

 - Dennis

> -----Original Message-----
> From: Eike Rathke [mailto:erack@redhat.com]
> Sent: Friday, May 27, 2016 04:26
> To: office-comment@lists.oasis-open.org
> Subject: [office-comment] 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