Re: [libreoffice-users] CRITBINOM function description is wrong
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 mihovil.sta...@gmail.com mailto:mihovil.sta...@gmail.com 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
[libreoffice-users] CRITBINOM function description is wrong
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 mihovil.sta...@gmail.com 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=5origin=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 ahelp hid=HID_FUNC_KRITBINOMReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. /ahelp Should be: ahelp hid=HID_FUNC_CRITBINOMReturns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value./ahelp 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
Re: [libreoffice-users] CRITBINOM function description is wrong
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 ahelp hid=HID_FUNC_KRITBINOMReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value./ahelp Should be: ahelp hid=HID_FUNC_CRITBINOMReturns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value./ahelp 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=5origin=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
Re: [libreoffice-users] CRITBINOM function description is wrong
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=5origin=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/7/22 Mihovil Stanic mihovil.sta...@gmail.com 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: ahelp hid=HID_FUNC_KRITBINOMReturns the smallest value for which the cumulative binomialdistribution is less than or equal to a criterion value. /ahelp To ahelp hid=HID_FUNC_CRITBINOMReturns the smallest value for which the cumulative binomialdistribution is greater than or equal to a criterion va lue./ahelp 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=5origin=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