https://bugs.freedesktop.org/show_bug.cgi?id=74565
Priority: medium
Bug ID: 74565
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Other: Mathematical function broken from MS Excel to
LibreOffice
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: tux.b...@gmail.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 93445
--> https://bugs.freedesktop.org/attachment.cgi?id=93445&action=edit
Original MS Excel spreadsheet using BINOM.DIST-function
Problem description:
When creating a spreadsheet using Microsoft Office Excel 2010 (version:
14.0.7106.5003, 32-Bit) using the function wizard, saving the document as
XLSX-file and opening the file using LibreOffice Calc (Version: 4.1.3.2,
Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a), LibreOffice reinterprets
the spreadsheet-function and states the function is unknown, which seems to be
a little strange because LibreOffice implements the same function using the
same parameter setup.
Steps to reproduce:
1. Insert the function for binomial distribution in a spreadsheet-cell in MS
Excel: "=BINOM.DIST(p1; p2; p3; p4)" where p1,...,p4 is the function parameter
given as spreadsheet-cell. The result is a numerical value of the binomial
distribution function.
2. Save the document.
3. Open the document in LibreOffice Calc.
4. Check out the spreadsheet-cell with the binomial function. The cell result
will be "#NAME?".
Current behavior:
LibreOffice Calc interprets the spreadsheet-cells as "=_xlfn.binom.dist(p1; p2;
p3; p4)". The function wizard states that this function is not known. Therefore
the cell value is "#NAME?".
Expected behavior:
The expected behavior would be that LibreOffice Calc will reinterpret or map
the "=_xlfn.binom.dist()" function to its own "BINOMDIST(p1; p2; p3; p4)"
function, which accepts the same parameter (spreadsheet cells or values) in
exactly the same order. The function result is fine and seems to compute the
values correctly.
Operating System: Ubuntu
Version: 4.1.3.2 release
--
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
