| Summary: | Add EXcel 2010 functions MODE.SNGL, MODE.MULT, NEGBINOM.DIST, Z.TEST | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Winfried Donkers <winfrieddonkers> |
| Component: | Calc | Assignee: | Winfried Donkers <winfrieddonkers> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 4.2.0.0.alpha0+ Master | ||
| Hardware: | Other | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=104532 | ||
| Whiteboard: | target:4.3.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 70798 | ||
| Attachments: | calc document with results of MODE.MULT | ||
|
Description
Winfried Donkers
2013-12-01 15:21:09 UTC
Created attachment 92679 [details] calc document with results of MODE.MULT Attached document shows a (possible) problem when implementing MODE.MULT. Used code is in https://gerrit.libreoffice.org/#/c/7615/ . I misused the MODE function by replacing its code with that of MODE.MULT, just to test behaviour. When modifying the dataset in such a way that length of the resulting array of MODE.MULT (which is an array) changes, produces incorrect cell values. When the result array decreases, one or more values are duplicated or replaced by N/A. When the result increases, the extra values do not show. BTW, I can't put the function directly in the cell, I must use the function wizard to get an array as result. Inputting {=MODE(A1:C3)} is not recognized as a function, let alone an array function. :/ A calculated result never changes cells it is not assigned to, if the original array formula was entered in F1:F4 you will not get a value in F5 if the result vector is of length 5. If the result vector is shorter than the original array formula you get #N/A in the exceeding cells. Works like designed ;-) Duplicated cells may happen if the result vector has only one element, that then is replicated for remaining cells of the array formula. This is also the case if there is only one column and the array formula consists of several columns, the entire column is replicated for the remaining columns. Same for rows. To enter a matrix/array formula simply close the formula cell with Shift+Ctrl+Enter instead of just Enter. Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e4def6edaa4686e50bbfd4490a4b9ddb928397a4 fdo#72197 Add Excel 2010 functions The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |