> -----Original Message-----
> From: Dennis E. Hamilton [mailto:]
> Sent: Friday, May 27, 2016 10:20
> To:
> 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:]
> > Sent: Friday, May 27, 2016 04:26
> > To:
> > 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:
> Unsubscribe:
> List help:
> 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/
