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-2174

Sequence evaluation order in arguments significant for CORREL, PEARSON and others

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      For LEGACY.CHITEST, CORREL, PEARSON, STEYX, COVAR, SLOPE, INTERCEPT, RSQ, FORECAST, TTEST

      Change parameter types to ForceArray Array instead of ForceArray NumberSequence.

      With A being the first array and B being the second array:
      Constraints: COLUMNS(A) = COLUMNS(B), ROWS(A) = ROWS(B)

      Add to Semantics:
      For an empty element or an element of type Text or Boolean in A the element at the corresponding position of B is ignored, and vice versa.

      For GROWTH, TREND, LINEST, LOGEST

      Constraints: COLUMNS(A) = COLUMNS(B), ROWS(A) = ROWS(B), COUNT(A) = COUNT(B)

      Show
      For LEGACY.CHITEST, CORREL, PEARSON, STEYX, COVAR, SLOPE, INTERCEPT, RSQ, FORECAST, TTEST Change parameter types to ForceArray Array instead of ForceArray NumberSequence. With A being the first array and B being the second array: Constraints: COLUMNS(A) = COLUMNS(B), ROWS(A) = ROWS(B) Add to Semantics: For an empty element or an element of type Text or Boolean in A the element at the corresponding position of B is ignored, and vice versa. For GROWTH, TREND, LINEST, LOGEST Constraints: COLUMNS(A) = COLUMNS(B), ROWS(A) = ROWS(B), COUNT(A) = COUNT(B)

      Description

      Broken out from bulk issue OFFICE-790

      For some functions the evaluation order of the elements of sequences passed as arguments is significant.
      Affected functions are at least CORREL and PEARSON, check other functions as well.

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              erack Eike Rathke (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: