I've copied this email exchange to the mailing list in case others are interested. I will raise a bug to address the problem of the Function Wizard allowing users to enter too many parameters.
Regards, Steve On Thu, 19 Mar 2020 at 12:37, Olivier Hallot <olivier.hal...@libreoffice.org> wrote: > Steve > > You are an Hero. It may make sense to have 255 params instead of 256, as > 256 is the boundary of a byte. > > Here is my chat with Eike Rahtke (erAck) > > 08:42:46 - ohallot: erAck: hi... With Steve Fanning I am reviewing the > number of params in several Calc functions for Help review. The limit > used to be 30 (e.g. in SUM()) but now it has been raised to ~ 256. Can > you tell me is the top limit is 255 or 256? Where is this number > defined? Is it one limit for all or a limit for each function? > (...) > 08:44:28 - ohallot: for =SUM () the wizzard says N1.. N255, but for > IMPRODUCT, the wizzard says n1 ... N256. However if you have 256 args in > IMPRODUCT, you get an error. > (...) > 09:27:43 - erAck: ohallot: limit is 255 for all functions that take > multiple sequences > 09:28:57 - erAck: ohallot: that already previously was the case, just > the wizard didn't handle it > > > > So I have actually to update my last patch to set it right. > > Kind regards > Olivier > > Note... we should move this thread to the doc list... other may be > interested in the subject. > > > Em 19/03/2020 08:09, Stephen Fanning escreveu: > > Hi Olivier, > > > > Many thanks again for the help yesterday. > > > > It appears that we will have to be very thorough in getting the help > > information correct. Take the IMPRODUCT function for example: > > (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 gives an answer rather > > than an error. > > See the attached spreadsheet for worked example. > > > > So we might conclude that in this case the Function Wizard UI is > > incorrect and should only provide for input of 255 parameters. > > > > I wondered if you had a chance to find the code that controlled Calc's > > handling of parameters, which might make it easier for me to spot this > > kind of issue? If not, shall I try and open up a conversation with Eike > > Rathke on the subject? > > > > Regards, > > > > Steve > > > > -- > Olivier Hallot > LibreOffice Documentation Coordinator > Comunidade LibreOffice > Rio de Janeiro - Brasil - Local Time: UTC-03:00 > http://tdf.io/joinus > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
