[OASIS Issue Tracker] (OFFICE-3902) Missing ForceArray parameter types

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

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

Michael Stahl updated OFFICE-3902:
----------------------------------
    Component/s: OpenFormula
                 Part 2 (Formulas)

> Missing ForceArray  parameter types
> -----------------------------------
>
>                 Key: OFFICE-3902
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3902
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>    Affects Versions: ODF 1.2, ODF 1.3
>         Environment: Formula
>            Reporter: Patrick Durusau
>            Priority: Major
>             Fix For: ODF 1.3
>
>
> LINEST, LOGEST, MATCH, VLOOKUP and HLOOKUP should have ForceArray parameter types.
> should read:
> LINEST( ForceArray Array knownY [ ; [ ForceArray Array knownX ] [ ; Logical Const = TRUE() [ ; Logical Stats = FALSE() ] ] ] )
> LOGEST( ForceArray Array knownY [ ; [ ForceArray Array knownX ] [ ; Logical Const = TRUE() [ ; Logical Stats = FALSE() ] ] ] )
> HLOOKUP( Any Lookup ; ForceArray Reference|Array DataSource ; Integer Row [ ; Logical RangeLookup = TRUE() ] )
> MATCH( Scalar Search ; ForceArray Reference|Array SearchRegion [ ; Integer MatchType = 1 ] )
> VLOOKUP( Any Lookup ; ForceArray Reference|Array DataSource ; Integer Column [ ; Logical RangeLookup = TRUE() ] )



--
This message was sent by Atlassian JIRA
(v7.7.2#77003)