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

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2
    • Affects Version/s: None
    • Component/s: OpenFormula
    • None
    • 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)

      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.

            Assignee:
            Eike Rathke (Inactive)
            Reporter:
            Eike Rathke (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: