The following message is part of a proposal to the OASIS Open Document TC to improve the specification of the DAYS360 function in the ODF OpenFormula specification for spreadsheet formulas.
The proposed change, if made in an Errata or a future version of the ODF specification, will not impact the continued use of the current OpenOffice Calc implementation. Use of DAYS360 in existing .ods files will continue to work without change. If anyone knows of currently-supported cases that *are* impacted by this change, please make that known. - Dennis PS: The formulas are shown in the OpenFormula format as it is actually carried in the .ods file. The UI accepts and can present different variations. That has nothing to do with this proposal, which is about the form and interpretation of the formulas as carried within the .ods files. PPS: The 330 and 332 results are correct and in accordance with the OpenFormula specification. > -----Original Message----- > From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] > Sent: Friday, May 27, 2016 10:20 > To: office-comm...@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 > > > -----Original Message----- > > From: Eike Rathke [mailto:er...@redhat.com] > > Sent: Friday, May 27, 2016 04:26 > > To: office-comm...@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-subscr...@lists.oasis-open.org > Unsubscribe: office-comment-unsubscr...@lists.oasis-open.org > List help: office-comment-h...@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/ --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
