Details

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

      Description

      "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'.

        Attachments

          Activity

            People

            • Assignee:
              aguelzow Andreas Guelzow
              Reporter:
              rcweir Robert Weir (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: