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

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

> -----Original Message-----
> From: Dennis E. Hamilton [mailto:dennis.hamilton@acm.org]
> Sent: Friday, May 27, 2016 10:20
> To: office-comment@lists.oasis-open.org
> Subject: RE: [office-comment] DAYS360 third parameter should be Logical
> 
> 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
[orcmid] 

There have been no objections on this on the Apache OpenOffice lists.

 - 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
> 
> 
> --
> This publicly archived list offers a means to provide input to the
> OASIS Open Document Format for Office Applications (OpenDocument) TC.
> 
> In order to verify user consent to the Feedback License terms and
> to minimize spam in the list archive, subscription is required
> before posting.
> 
> Subscribe: office-comment-subscribe@lists.oasis-open.org
> Unsubscribe: office-comment-unsubscribe@lists.oasis-open.org
> List help: office-comment-help@lists.oasis-open.org
> List archive: http://lists.oasis-open.org/archives/office-comment/
> Feedback License: http://www.oasis-open.org/who/ipr/feedback_license.pdf
> List Guidelines: http://www.oasis-open.org/maillists/guidelines.php
> Committee: http://www.oasis-
> open.org/committees/tc_home.php?wg_abbrev=office
> Join OASIS: http://www.oasis-open.org/join/