Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index


Hi Ronnie, Steve

Removed from the Help.
https://gerrit.libreoffice.org/c/help/+/105531

Thanks
Olivier

Em 10/11/2020 06:43, Steve Fanning escreveu:
Hello Olivier and Ronnie,

I agree that the note about _ADD and _EXCEL2003 does not appear to be
relevant to this particular function (DURATION).

I have added this to our list of help issues to be addressed on
completion of GSOD20.

I'm looking forward to speaking to you both later.

Regards,

Steve


On 10/11/2020 08:47, GANDHI RONNIE 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.wh@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.wh@gmail.com>
To: "GANDHI RONNIE" <gronnie@cs.iitr.ac.in>
Cc: "Olivier Hallot" <olivier.hallot@libreoffice.org>; "Documentation
Team" <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" <gronnie@cs.iitr.ac.in>
To: "Steve (GMail)" <stevemfanning.wh@gmail.com>
Cc: "Olivier Hallot" <olivier.hallot@libreoffice.org>; "Documentation
Team" <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.wh@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" <gronnie@cs.iitr.ac.in>
To: "Steve (GMail)" <stevemfanning.wh@gmail.com>
Cc: "Documentation Team" <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.wh@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" <gronnie@cs.iitr.ac.in>
To: documentation@libreoffice.org; "Documentation Team"
<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+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


-- 
Olivier Hallot
LibreOffice Documentation Coordinator
Rio de Janeiro - Brasil - Local Time: UTC-03:00
LibreOffice – free and open source office suite: https://www.libreoffice.org
Respects your privacy, and gives you back control over your data
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

Context


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.