https://bugs.documentfoundation.org/show_bug.cgi?id=105512

m.a.riosv <miguelange...@libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |miguelangelrv@libreoffice.o
                   |                            |rg
         Resolution|---                         |NOTABUG

--- Comment #1 from m.a.riosv <miguelange...@libreoffice.org> ---
Looks ODF definition daesn't allow that.
"
6.18.17
CORREL
Summary:
 Calculates the correlation coefficient of values in N1 and N2.
Syntax:
 CORREL( ForceArray Array N1 ; ForceArray Array N2 )
Returns:
 Number
Constraints:
 COLUMNS(N1) = COLUMNS(N2), ROWS(N1) = ROWS(N2), both sequences shall
contain at least one number at corresponding positions each.
Semantics:
 Has the same value as COVAR(N1;N2)/STDEVP(N1)*(STDEVP(N2)). The CORREL
function actually is identical to the PEARSON function.
For an empty element or an element of type Text or Boolean in 
N1  the element at the corresponding position of N2  is ignored, and vice versa
"
Perhaps could be an acceptable request for enhacement for compatibility
reasons.

BTW can be solved using TRANSPOSE() function
=CORREL(A1:A5;TRANSPOSE(B1:F1))

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to