[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[libreoffice-documentation] Re: Calc Function Parameters


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.hallot@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+unsubscribe@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

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.