[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libreoffice-documentation] Re: Calc Function Parameters
- Subject: [libreoffice-documentation] Re: Calc Function Parameters
- From: Stephen Fanning <email@example.com>
- Date: Thu, 19 Mar 2020 12:57:50 +0000
- To: LibreOffice Documentation <Documentation@global.libreoffice.org>
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.
On Thu, 19 Mar 2020 at 12:37, Olivier Hallot <firstname.lastname@example.org>
> 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
> 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
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
- Prev by Date: Re: [libreoffice-documentation] Re: LibreOffice Base Documentation
- Next by Date: [libreoffice-documentation] Exporting data: how is it done
- Previous by thread: [libreoffice-documentation] Intro Getting Started Email Networking
- Next by thread: [libreoffice-documentation] Exporting data: how is it done