OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: [OASIS Issue Tracker] (OFFICE-3907) DAYS360 third parameter should be Logical


     [ https://issues.oasis-open.org/browse/OFFICE-3907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Patrick Durusau updated OFFICE-3907:
------------------------------------

    Proposal: 
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 constraints be removed. 

> DAYS360 third parameter should be Logical
> -----------------------------------------
>
>                 Key: OFFICE-3907
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3907
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>            Reporter: Patrick Durusau
>            Assignee: Patrick Durusau
>             Fix For: ODF 1.3
>
>
> 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.
> From Eike Rathke - https://lists.oasis-open.org/archives/office-comment/201605/msg00002.html



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]