Hi Ronnie,
An initial check indicates that you are correct. (The code appears to
only return a number)
This means that the help is inaccurate to suggest that the function may
return a string representing a sheet name; I'll add it to our list.
Please make sure that the wiki page is correct in this respect and
include a comment to reflect that Calc's implementation is not strictly
in accordance with ODF 1.2.
The good news is that I don't see any error in the Function Wizard's
description of the function.
Regards,
Steve
On 24/11/2020 10:32, GANDHI RONNIE wrote:
Hello Olivier and Steve,
I believe the SHEET function has error in both ODF section and help pages.
The function states that it returns sheet number or name string for the
referenced sheet (either by cell or by name area or a sheet name). But I
believe it *can only return sheet number not sheet name*.
MS Excel's documentation seems to not have that error and Calc's function
is also working accordingly.
Regards,
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430
On Mon, Nov 23, 2020 at 10:43 PM Steve Fanning <stevefann...@libreoffice.org>
wrote:
Thanks Ronnie.
I've added HLOOKUP to our list.
Regards,
Steve
On 23/11/2020 11:50, GANDHI RONNIE wrote:
Hello Steve and Olivier,
Along with GETPIVOTDATA HLOOKUP's help also has no example section.
Regards,
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430
On Mon, Nov 23, 2020 at 4:12 PM Steve Fanning <
stevefann...@libreoffice.org>
wrote:
Hello Olivier and Ronnie,
Thanks for that information. I have made a note on our list of help
issues that the description for the GETPIVOTDATA() function does not
currently include an example of its usage.
Regards,
Steve
On 23/11/2020 09:21, Olivier Hallot wrote:
Hi Ronnie
Pick the example in the Help pages. All is there.
https://help.libreoffice.org/7.1/en-US/text/scalc/guide/datapilot_createtable.html?DbPAR=CALC#bm_id3148491
Regards
Olivier
Em 23/11/2020 03:48, GANDHI RONNIE escreveu:
Hello Steve and Olivier,
GETPIVOTDATA function seems to be an important one but there are no
examples for it on the help page.
I'll add some on the wiki pages though.
Regards,
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430
On Tue, Nov 10, 2020 at 4:39 PM Steve Fanning
<stevefann...@libreoffice.org <mailto:stevefann...@libreoffice.org>>
wrote:
Thanks Ronnie.
I'm not even sure the statement is 100% correct if you look
across
the
full set of Calc functions. For example, in the case of
DCOUNT(),
you
may omit a value for the 2nd argument but must include a value
for
the
3rd argument.
I'll give some thought as to how to handle these statements in
the
Help.
For the wiki, please omit the statements for now.
Regards,
Steve
On 10/11/2020 10:43, GANDHI RONNIE wrote:
> Hello Steve and Olivier,
>
> I found one more useless text in the FV function.
>
> "In the LibreOfficeDev Calc functions, parameters marked as
"optional" can
> be left out only when no parameter follows. For example, in a
function with
> four parameters, where the last two parameters are marked as
"optional",
> you can leave out parameter 4 or parameters 3 and 4, but you
cannot leave
> out parameter 3 alone."
>
> Either we add this in all functions with optional parameters
which
I think
> is not possible or we remove it from here.
>
> What do you guys think?
>
> Regards,
> Ronnie Gandhi
> Undergraduate at Computer Science and Engineering
> Indian Institute of Technology, Roorkee
> +91-07874243430
>
>
> On Tue, Nov 10, 2020 at 2:17 PM GANDHI RONNIE
<gron...@cs.iitr.ac.in <mailto:gron...@cs.iitr.ac.in>> wrote:
>
>> Hello Steve and Olivier,
>>
>> I found another error in the help pages.
>>
>> For the DURATION function, there is a pinpoint which is not
needed I
>> believe.
>>
>> *The functions whose names end with _ADD or _EXCEL2003 return
the
same
>> results as the corresponding Microsoft Excel 2003 functions
without the
>> suffix. Use the functions without suffix to get results
based on
>> international standards.*
>>
>> Do look into it and see if you find it useless as well.
>>
>> Regards,
>> Ronnie Gandhi
>> Undergraduate at Computer Science and Engineering
>> Indian Institute of Technology, Roorkee
>> +91-07874243430
>>
>>
>> On Mon, Oct 26, 2020 at 2:08 AM Steve (GMail)
<stevemfanning...@gmail.com <mailto:stevemfanning...@gmail.com
>> wrote:
>>
>>> Ronnie / Olivier,
>>>
>>> As promised I have created an initial list of issues with
the
help files
>>> that have been noticed so far during the GSOD2020 Functions
Wiki
work.
>>>
>>> This list can be found in the GSOD2020/WIKI folder in
NextCloud,
file
>>> name "Help pages - problems noticed during GSOD20.odt". We
can
discuss
>>> these during our weekly Tuesday meetings as required.
>>>
>>> Ronnie, please have a quick look and see if I've missed any
of
the issues
>>> that you have raised so far. If you spot any more, please
carry
on emailing
>>> them to us. I can do a quick filter / check before adding
the
issue to the
>>> list.
>>>
>>> Regards,
>>>
>>> Steve
>>>
>>> ------ Original Message ------
>>> From: "Steve (GMail)" <stevemfanning...@gmail.com
<mailto:stevemfanning...@gmail.com>>
>>> To: "GANDHI RONNIE" <gron...@cs.iitr.ac.in
<mailto:gron...@cs.iitr.ac.in>>
>>> Cc: "Olivier Hallot" <olivier.hal...@libreoffice.org
<mailto:olivier.hal...@libreoffice.org>>; "Documentation
>>> Team" <documentation@global.libreoffice.org
<mailto:documentation@global.libreoffice.org>>
>>> Sent: 25/10/2020 13:57:15
>>> Subject: Re[4]: [libreoffice-documentation] GSOD 2020 -
Possible
Error in
>>> Help pages
>>>
>>> Hi Ronnie,
>>>
>>> With regards to the MINIFS problem, I agree with you. I
propose
to keep a
>>> list of these minor changes to the help that are identified
during the
>>> GSOD20 work and will discuss with Olivier how best to fix
them.
>>>
>>> You are also correct about the POISSON.DIST problem. This
will
be added
>>> to the list above. However, in this case, there is a
slightly
more
>>> significant issue - the Function Wizard contains text which
indicates that
>>> the parameter is optional when, in fact, it is required. I
will
raise a bug
>>> report on this.
>>>
>>> Regards,
>>>
>>> Steve
>>>
>>>
>>> ------ Original Message ------
>>> From: "GANDHI RONNIE" <gron...@cs.iitr.ac.in
<mailto:gron...@cs.iitr.ac.in>>
>>> To: "Steve (GMail)" <stevemfanning...@gmail.com
<mailto:stevemfanning...@gmail.com>>
>>> Cc: "Olivier Hallot" <olivier.hal...@libreoffice.org
<mailto:olivier.hal...@libreoffice.org>>; "Documentation
>>> Team" <documentation@global.libreoffice.org
<mailto:documentation@global.libreoffice.org>>
>>> Sent: 25/10/2020 10:46:58
>>> Subject: Re: Re[2]: [libreoffice-documentation] GSOD 2020 -
Possible
>>> Error in Help pages
>>>
>>> Hello Steve and Olivier,
>>>
>>> I have found some more errors in help pages:
>>>
>>> For MINIFS
>>>
<
https://help.libreoffice.org/7.1/en-US/text/scalc/01/func_minifs.html?&DbPAR=CALC&System=UNIX
the
>>> 2nd example in "Using regular expressions and nested
functions"
section the
>>> regex is about "book" but description states "pen".
>>>
>>> Also in POISSON.DIST
>>>
<
https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060184.html?DbPAR=CALC#bm_id2953985
the
>>> function says "C" parameter is optional but that is not
true. I
tried it in
>>> Calc.
>>>
>>> Please look into the above.
>>>
>>> Regards,
>>> Ronnie Gandhi
>>> Undergraduate at Computer Science and Engineering
>>> Indian Institute of Technology, Roorkee
>>> +91-07874243430
>>>
>>>
>>> On Tue, Oct 20, 2020 at 8:09 PM Steve (GMail)
<stevemfanning...@gmail.com <mailto:stevemfanning...@gmail.com
>>> wrote:
>>>
>>>> Ronnie / Olivier,
>>>>
>>>> Section 6.18.37 in the Open Document Format for Office
Applications
>>>> (OpenDocument) Version 1.2 contains the following
statement:
“cumulative is
>>>> a Logical parameter … If omitted, FALSE() is assumed.”.
>>>>
>>>> The 7.1 Help description of this function states that “The
cumulative
>>>> distribution function is the default if no value is
specified
for this
>>>> parameter”. It also states that if cumulative is set to
anything other than
>>>> FALSE or 0, then you get the cumulative distribution
function.
Therefore,
>>>> there is a discrepancy between the Help description and the
ODF.
>>>>
>>>> Moving on to the software, the following fragment of a
spreadsheet
>>>> demonstrates its behaviour. (Note: image wont be visible
via
mailing list)
>>>>
>>>>
>>>>
>>>> This shows that the software is defaulting cumulative to
0, in
>>>> accordance with the ODF.
>>>>
>>>> Consequently, it looks to me as if the help page is wrong
in
this
>>>> respect. It should be changed to say that the default is
the
probability
>>>> density function.
>>>>
>>>> Olivier, if you agree, would you like me to make the change
via
Gerrit?
>>>>
>>>> Regards,
>>>>
>>>> Steve
>>>>
>>>>
>>>> ------ Original Message ------
>>>> From: "GANDHI RONNIE" <gron...@cs.iitr.ac.in
<mailto:gron...@cs.iitr.ac.in>>
>>>> To: "Steve (GMail)" <stevemfanning...@gmail.com
<mailto:stevemfanning...@gmail.com>>
>>>> Cc: "Documentation Team" <
documentation@global.libreoffice.org
<mailto:documentation@global.libreoffice.org>>
>>>> Sent: 18/10/2020 17:20:43
>>>> Subject: Re: [libreoffice-documentation] GSOD 2020 -
Possible
Error in
>>>> Help pages
>>>>
>>>> Hello Steve and Olivier,
>>>>
>>>> I found one more erroneous function in help pages.
HYPEGEOMDIST's
>>>> description of *cumulative *parameter's last statement is
wrong. It
>>>> states "The cumulative distribution function is the
default if
no value is
>>>> specified for this parameter." but I tested and by default
probability
>>>> density function is considered. So changes should be
incorporated
>>>> accordingly.
>>>>
>>>> Regards,
>>>> Ronnie Gandhi
>>>> Undergraduate at Computer Science and Engineering
>>>> Indian Institute of Technology, Roorkee
>>>> +91-07874243430
>>>>
>>>>
>>>> On Mon, Oct 5, 2020 at 1:58 PM Steve (GMail)
<stevemfanning...@gmail.com <mailto:stevemfanning...@gmail.com
>>>> wrote:
>>>>
>>>>> Hi Ronnie,
>>>>>
>>>>> I agree that the Help page for these two functions could
be
improved.
>>>>>
>>>>> I will raise a bug in our Bugzilla system so that the
issue
can be
>>>>> progressed.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Steve
>>>>>
>>>>>
>>>>>
>>>>> ------ Original Message ------
>>>>> From: "GANDHI RONNIE" <gron...@cs.iitr.ac.in
<mailto:gron...@cs.iitr.ac.in>>
>>>>> To: documentat...@libreoffice.org
<mailto:documentat...@libreoffice.org>; "Documentation Team"
>>>>> <documentation@global.libreoffice.org
<mailto:documentation@global.libreoffice.org>>
>>>>> Sent: 04/10/2020 19:05:41
>>>>> Subject: [libreoffice-documentation] GSOD 2020 - Possible
Error in Help
>>>>> pages
>>>>>
>>>>>> Hello Olivier and Steve,
>>>>>>
>>>>>> I could sense an error on the help pages for BETA.INV and
BETAINV
>>>>> function.
>>>>>> The definition of Number is wrong. It states Number to be
between
>>>>> Start and
>>>>>> End but actually it is the probability which is
associated
with BETA
>>>>>> function for other given arguments and the output will be
that Number.
>>>>>>
>>>>>> Compare it with MS excel equivalent
>>>>>>
>>>>>
https://support.microsoft.com/en-us/office/beta-inv-function-e84cb8aa-8df0-4cf6-9892-83a341d252eb
>>>>>> .
>>>>>>
>>>>>> Actually out function works the same way but the
description
of this
>>>>> Number
>>>>>> is wrong.
>>>>>>
>>>>>> One eg to prove the point is : =BETA.INV(0.5,3,4,3,4)
gives
>>>>> 3.42140719069071
>>>>>> But =BETA.INV(3.5,3,4,3,4) gives Err:502 which infact
qualifies the
>>>>>> definition.
>>>>>>
>>>>>> Ronnie Gandhi
>>>>>> Undergraduate at Computer Science and Engineering
>>>>>> Indian Institute of Technology, Roorkee
>>>>>> +91-07874243430
>>>>>>
>>>>>> --
>>>>>> To unsubscribe e-mail to:
>>>>> documentation+unsubscr...@global.libreoffice.org
<mailto:documentation%2bunsubscr...@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
>>>>>
--
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
