https://bugs.freedesktop.org/show_bug.cgi?id=70000
Priority: medium Bug ID: 70000 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Add capability to handle Excel functions COVARIATE.S and COVARIATE.P (should be easy) Severity: enhancement Classification: Unclassified OS: All Reporter: gerry.trep...@googlemail.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs