Created attachment 93445 [details] 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
Created attachment 93446 [details] LibreOffice Calc opening the MS Excel File and fails mapping the BINOM.DIST function
This is fixed for the upcoming 4.2. See also the Metabug for new Excel 2010 functions: https://bugs.freedesktop.org/show_bug.cgi?id=70798 *** This bug has been marked as a duplicate of bug 71081 ***