Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-1170 Public Comment: Re: [office-comment] ODFF: list of suggestions
  3. OFFICE-2247

Array Functions categorization

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 Part 2 CD 1
    • Fix Version/s: ODF 1.2 Part 2 CD 1
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Move these functions to "Mathematical functions":
      SUMPRODUCT
      SUMX2MY2
      SUMX2PY2
      SUMXMY2

      Rename "Array/matrix" to "Matrix functions"
      (MDETERM, MINVERSE, MMULT, MUNIT, TRANSPOSE)

      Show
      Move these functions to "Mathematical functions": SUMPRODUCT SUMX2MY2 SUMX2PY2 SUMXMY2 Rename "Array/matrix" to "Matrix functions" (MDETERM, MINVERSE, MMULT, MUNIT, TRANSPOSE)
    • Resolution:
      Hide

      Moved these functions to "Mathematical functions":
      SUMPRODUCT
      SUMX2MY2
      SUMX2PY2
      SUMXMY2

      Renamed "Array/matrix" to "Matrix functions"
      (MDETERM, MINVERSE, MMULT, MUNIT, TRANSPOSE)

      Changed in 5.5.1 General "Array/matrix functions operate on arrays." to "Matrix functions operate on matrices."

      Show
      Moved these functions to "Mathematical functions": SUMPRODUCT SUMX2MY2 SUMX2PY2 SUMXMY2 Renamed "Array/matrix" to "Matrix functions" (MDETERM, MINVERSE, MMULT, MUNIT, TRANSPOSE) Changed in 5.5.1 General "Array/matrix functions operate on arrays." to "Matrix functions operate on matrices."

      Description

      Broken out from issue OFFICE-1170

      "Array Functions"
      This categorisation seems to me to be inconsistent. Functions which return arrays are:
      MINVERSE, MMULT, MUNIT, TRANSPOSE, FREQUENCY, GROWTH, LINEST, LOGEST, TREND
      Functions which have ForceArray parameters are:
      MDETERM, MINVERSE, MMULT, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, CORREL, COVAR, FORECAST, FTEST, INTERCEPT, MODE, PEARSON, PROB, RSQ, SLOPE, STEYX, TTEST (and LOOKUP sometimes).
      This doesn't relate to the current functions listed as array functions.

      We have for instance SUMPRODUCT listed as an array function (but it's really a maths function) but MODE listed in stats (OK) - but both force array_mode calculation. Surely either both should be 'array functions' or both where they belong.
      Perhaps only matrix functions should be in this category: MINVERSE, MMULT, MUNIT, TRANSPOSE, MDETERM. It could then be called 'matrix functions'.

      TODO: check what we have changed there already and what's left to do, if any. Certainly not all functions that have ForceArray parameters or return arrays belong into the Array Functions category just because they do so.

        Attachments

          Activity

            People

            • Assignee:
              david.wheeler David Wheeler (Inactive)
              Reporter:
              erack Eike Rathke (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: