Bug 131657 - Function Wizard in Calc allows too many parameters for "IFS" functions
Summary: Function Wizard in Calc allows too many parameters for "IFS" functions
Status: CLOSED DUPLICATE of bug 131423
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-03-29 09:35 UTC by Steve Fanning
Modified: 2020-05-14 03:50 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot of Function Wizard showing too many parameters for IFS function (30.13 KB, image/png)
2020-03-29 09:35 UTC, Steve Fanning 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Steve Fanning 2020-03-29 09:35:12 UTC 
Created attachment 159112 [details]
Screenshot of Function Wizard showing too many parameters for IFS function

For the six Calc functions SUMIFS, AVERAGEIFS, COUNTIFS, MAXIFS, MINIFS, and IFS, the Function Wizard provides text boxes for entering either 510 or 511 parameters. I've attached a screenshot showing this.

It is not possible for that many parameters to be processed by these functions and the number of text boxes should be reduced to reflect the actual limit.
Comment 1 Xisco Faulí 2020-05-13 11:50:38 UTC 
@Eike, any opinion on this issue ?
Comment 2 Eike Rathke 2020-05-13 17:12:37 UTC 
Was fixed with tdf#131423

*** This bug has been marked as a duplicate of bug 131423 ***