https://bugs.freedesktop.org/show_bug.cgi?id=44134
Bug #: 44134
Summary: Using the new STDEV.M and STDEV.P formulas in MS Excel
2010 results in errors in LibreOffice.
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 Beta2
Platform: x86-64 (AMD64)
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 54804
--> https://bugs.freedesktop.org/attachment.cgi?id=54804
Excel 2010 file showing the error
The new STDEV.M and STDEV.P formulas in MS Excel 2010 (Spanish Version) are not
recognized in LibreOffice.
If you create a file in MS Excel 2010 using STDEV.M and STDEV.P formulas and
then open that file with LibreOffice, instead of the expected result, it gives
a #MACRO? error.
See the results for all the available STDEV functions:
RESULT FORMULA MS Excel 2010 RESULTING FORMULA LibreOffice
#MACRO? DESVEST.M(F2:F7) _xlfn.STDEV.S(F2:F7)
#MACRO? DESVEST.P(F2:F7) _xlfn.STDEV.P(F2:F7)
1.87082 DESVEST(F2:F7) STDEVA(F2:F7)
1.70782 DESVESTPA(F2:F7) STDEVPA(F2:F7)
1.87082 DESVEST(F2:F7) STDEV(F2:F7)
It happens with both .xls and .xlsx file formats.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
