Re: [libreoffice-users] CRITBINOM function description is wrong

2013-07-23 Thread Mihovil Stanic 

Done.
https://bugs.freedesktop.org/show_bug.cgi?id=67205

Dana 22.7.2013. 23:11, Sérgio Marques je napisao:



2013/7/22 Mihovil Stanic >


Thank you for help Brian and Regina.
Sergio, can you please open bug report then and CC Andras so he
can fix it?


I don´t have an bugzilla account. Can You do it? Or someone with an 
account there.





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] CRITBINOM function description is wrong

2013-07-22 Thread Sérgio Marques 
2013/7/22 Mihovil Stanic 

>  Thank you for help Brian and Regina.
> Sergio, can you please open bug report then and CC Andras so he can fix it?
>
>
I don´t have an bugzilla account. Can You do it? Or someone with an account
there.

What needs to be fixed is:


UI:

File: sc/source/ui/src.po
Context:

scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_KRIT_BINOM 1 string.text


 Comment:

o6CUv


Border arguments of the binomial distribution.

To:
 Context:

scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CRIT_BINOM 1 string.text
 Returns the smallest value for which the cumulative binomial distribution
is greater than or equal to a criterion value.

Help files:
 File:


scalc/01.po
Context:

04060183.xhp par_id3149254 49 help.text
Comment:


yXdFy


From:

Returns the smallest value for which the
cumulative binomialdistribution is less than or equal to a criterion value.


To

Returns the smallest value for which the
cumulative binomialdistribution is greater than or equal to a criterion va
lue.


 If someone could do it I would appreciate it.



http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM


 Regards





>  Best regards,
> Mihovil
>
> Dana 22.7.2013. 17:21, Brian Barker je napisao:
>
>
> It hardly necessary to do any testing: cumulative probability
> distributions start at zero and finish at one.  Zero is always going to be
> less than any criterion value, so any result is going to correspond to the
> start of the distribution and be trivial.  The original correspondent must
> be right: "greater than" is surely correct?
>
> Brian Barker
>
>
>
> Dana 22.7.2013. 18:08, Regina Henschel je napisao:
>
> Hi Mihovil,
>
> Mihovil Stanic schrieb:
>
> Nice catch.
> Oasis says it's "greater then"
>
> http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM
>
>
> That is correct. Although in the help I would not use "is greater than or
> equal to a criterion value" but "...  threshold probability" as it is used
> in explanation of "Alpha".
>
>
> MS Office says "less then" in function title description
>
> http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HA102752955.aspx?CTT=1
>
>
> Wrong.
>
>
> and then it says "greater then" in function description
>
> http://office.microsoft.com/en-us/excel-help/critbinom-function-HA102753199.aspx?CTT=5&origin=HA102752955
>
>
> Correct.
>
>
> LO says "less then".
> Would be nice if someone could actually use this formula and say which
> is true. :)
>
>
> Wrong.
>
> Kind regards
> Regina
>
>
>


-- 
Sérgio Marques

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] CRITBINOM function description is wrong

2013-07-22 Thread Mihovil Stanic 

Thank you for help Brian and Regina.
Sergio, can you please open bug report then and CC Andras so he can fix it?

Best regards,
Mihovil

Dana 22.7.2013. 17:21, Brian Barker je napisao:


It hardly necessary to do any testing: cumulative probability 
distributions start at zero and finish at one.  Zero is always going 
to be less than any criterion value, so any result is going to 
correspond to the start of the distribution and be trivial. The 
original correspondent must be right: "greater than" is surely correct?


Brian Barker




Dana 22.7.2013. 18:08, Regina Henschel je napisao:

Hi Mihovil,

Mihovil Stanic schrieb:

Nice catch.
Oasis says it's "greater then"
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM 





That is correct. Although in the help I would not use "is greater than 
or equal to a criterion value" but "...  threshold probability" as it 
is used in explanation of "Alpha".




MS Office says "less then" in function title description
http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HA102752955.aspx?CTT=1 





Wrong.



and then it says "greater then" in function description
http://office.microsoft.com/en-us/excel-help/critbinom-function-HA102753199.aspx?CTT=5&origin=HA102752955 





Correct.



LO says "less then".
Would be nice if someone could actually use this formula and say which
is true. :)


Wrong.

Kind regards
Regina 



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] CRITBINOM function description is wrong

2013-07-22 Thread Brian Barker 

At 14:18 22/07/2013 +0100, Tom Davies wrote:

From: Mihovil Stanic:

Dana 22.7.2013. 1:44, Sérgio Marques je napisao:

File: scalc/01.po
Context: 04060183.xhp par_id3149254 49 help.txt
Comments: yXdFy
Returns the 
smallest value for which the cumulative 
binomial distribution is less than or equal to a criterion value.

Should be:
Returns the 
smallest value for which the cumulative 
binomial distribution is greater than or equal to a criterion value.


Also in:
File: sc/source/ui/src.po
Context:
scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_KRIT_BINOM 1 string.text
Comments: o6CUv
Should be:
Context:
scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CRIT_BINOM 1 string.text


Nice catch.
Oasis says it's "greater then"
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM

MS Office says "less than" in function title description
http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HA102752955.aspx?CTT=1

and then it says "greater than" in function description
http://office.microsoft.com/en-us/excel-help/critbinom-function-HA102753199.aspx?CTT=5&origin=HA102752955

LO says "less than".
Would be nice if someone could actually use 
this formula and say which is true. :)


If anyone could try out this weird function and 
let us know what the results are then the 
documentation and translators teams might be 
able to describe it correctly.  So far  Oasis 
doesn't seem to know what it does and MS can't 
decide what their equivalent function does either!


It hardly necessary to do any testing: cumulative 
probability distributions start at zero and 
finish at one.  Zero is always going to be less 
than any criterion value, so any result is going 
to correspond to the start of the distribution 
and be trivial.  The original correspondent must 
be right: "greater than" is surely correct?


Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] CRITBINOM function description is wrong

2013-07-22 Thread Tom Davies 
Hi :)
If anyone could try out this weird function and let us know what the results 
are then the documentation and translators teams might be able to describe it 
correctly.  So far  Oasis doesn't seem to know what it does and MS can't decide 
 what their equivalent function does either!
Regards from 

Tom :)  





>
> From: Mihovil Stanic 
>To: l...@global.libreoffice.org; documentat...@global.libreoffice.org 
>Sent: Monday, 22 July 2013, 6:48
>Subject: [libreoffice-documentation] Re: [libreoffice-l10n] CRITBINOM function 
>description is wrong
> 
>
>Nice catch.
>Oasis says it's "greater then"
>http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CRITBINOM
>
>MS Office says "less then" in function title description
>http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HA102752955.aspx?CTT=1
>
>and then it says "greater then" in function description
>http://office.microsoft.com/en-us/excel-help/critbinom-function-HA102753199.aspx?CTT=5&origin=HA102752955
>
>LO says "less then".
>Would be nice if someone could actually use this formula and say which 
>is true. :)
>
>Best regards,
>Mihovil
>
>
>Dana 22.7.2013. 1:44, Sérgio Marques je napisao:
>> File: scalc/01.po
>> Context: 04060183.xhp par_id3149254 49 help.txt
>> Comments: yXdFy
>>
>> Returns the smallest value for which the
>> cumulative binomial distribution is less than or equal to a criterion value.
>> 
>>
>> Should be:
>>
>> Returns the smallest value for which the
>> cumulative binomial distribution is greater than or equal to a criterion
>> value.
>>
>>
>> Also in:
>>
>>   File:
>>
>>
>> sc/source/ui/src.po
>> Context:
>>
>> scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_KRIT_BINOM 1 string.text
>> Comments:
>>
>>
>> o6CUv
>>
>>
>>   Should be:
>>
>>
>>   Context:
>>
>> scfuncs.src RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CRIT_BINOM 1 string.text
>>
>>
>
>
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted