Created attachment 158807 [details] Example of IMPRODUCT function parameters problem There is a problem with using the Function Wizard to create a call to the IMPRODUCT function. (1) The Function Wizard provides for the input of 256 complex numbers. (2) If you fill up these fields the function gives an error 512 (formula overflow). (3) If you clear the 256th field, the function then gives an answer rather than an error. See the attached spreadsheet for worked example. So for this function, the Function Wizard UI is incorrect and should only provide for the input of 255 parameters. It is possible that the same problem exists for the following functions: - AGGREGATE - GCD_EXCEL2003 - LCM_EXCEL2003 - MULTINOMIAL - RAWSUBTRACT - IMSUM
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d43d2662ff64c613740080e166d1046214edb0f0 Resolves: tdf#131423 Handle Function Wizard max argument count correctly It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/c/core/+/91300 for 6-4
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/a79bbe2f92f6a25b2e170f11a6aa2b6a5123fe2f Resolves: tdf#131423 Handle Function Wizard max argument count correctly It will be available in 6.4.4. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
It's ok now. 255 fields. Verified on Version: 7.0.0.0.alpha1 Build ID: 6a03b2a54143a9bc0c6d4c7f1... CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
*** Bug 131657 has been marked as a duplicate of this bug. ***
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/92a87f9f128cf91f6af1fc7c61a85a10d659334d Related: tdf#131423 CHOOSE() supports only 30 jump targets, limit in dialog It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/f92220b73d971e9d760c545efd60179ad1b6902a Related: tdf#131423 CHOOSE() supports only 30 jump targets, limit in dialog It will be available in 7.0.0.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/9bbee72fc90e4449cb67dd9caa06a0ccf8f4883e Related: tdf#131423 CHOOSE() supports only 30 jump targets, limit in dialog It will be available in 6.4.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.