https://bugs.freedesktop.org/show_bug.cgi?id=70000
Priority: medium
Bug ID: 70000
Assignee: [email protected]
Summary: Add capability to handle Excel functions COVARIATE.S
and COVARIATE.P (should be easy)
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.1.1 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 86905
--> https://bugs.freedesktop.org/attachment.cgi?id=86905&action=edit
COVAR COVARIATE.P COVARIATE.S not correctly handled in Calc
The Excel functions COVARIATE.S and COVARIATE.P are not handled correctly in
LibreOffice Calc. Please add the correct handling of these functions. According
to the source document, this should be easy and a low hanging fruit :-)
Please import attached spreadsheet (created in Excel 2010) in LibreOffice Calc.
To test the correctness of the functions, please change a single value in
either array 1 or array 2.
In cell B1 you see the function COVAR which is correclty handled by Calc.
However, Microsoft deprecated this function (it is still there for
compatability reasons) and created the successor COVARIATE.P.
However, the function COVARIATE.P (cell B2) is not correctly handled by Calc,
although the source document states that a "Direct mapping possible".
Currently, Calc reports and error on COVARIATE.P.
Microsoft created a new function COVARIATE.S (cell B3) which is currently not
supported by Calc, but "implementation would be easy, just copy code from COVAR
and use different denominator" according to the source document. Currently,
Calc reports and error on COVARIATE.S.
"Source document" on handling the new Excle functions in Calc:
http://wiki.openoffice.org/wiki/Calc/Drafts/Treatment_of_new_Excel_2010_functions#COVARIANCE.P
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
