[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: RE: [office-comment] DAYS360 third parameter should be Logical
> -----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/
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]