[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] (OFFICE-3902) Missing ForceArray parameter types
[ https://issues.oasis-open.org/browse/OFFICE-3902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Stahl updated OFFICE-3902: ---------------------------------- Fix Version/s: ODF 1.3 > 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)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]