Apache OpenOffice (AOO) Bugzilla – Issue 88302
Descriptions on the function QUOTIENT in the on-line help could be revised
Last modified: 2013-01-29 21:46:29 UTC
==================================================== Contents in the on-line help of OpenOffice.org 2.4.0 ==================================================== QUOTIENT Returns the integer part of a division operation. This function is only available if Analysis AddIn is installed. Syntax QUOTIENT(Numerator;Denominator) Returns the integer part of numerator divided by denominator. QUOTIENT is equivalent to INT(numerator/denominator), except that it may report errors with different error codes. Example =QUOTIENT(11;3) returns 3. The remainder of 2 is lost. ===== Facts ===== 1. Without additionally installing Analysis AddIn, this function is available. 2. QUOTIENT seems NOT equivalent to INT(numerator/denominator). The following table - attachment file - shows the differences between them. numerator denominator QUOTIENT (*1) INT (*2) Judge ============== ============== ============== ============== ========== 11 3 3 3 9 3 3 3 7 3 2 2 5 3 1 1 3 3 1 1 1 3 0 0 -1 3 0 -1 different -3 3 -1 -1 -5 3 -1 -2 different -7 3 -2 -3 different -9 3 -3 -3 -11 3 -3 -4 different Err:502 ========================================================================== *1 =QUOTIENT(Numerator;Denominator) *2 =INT(numerator/denominator) References issue 75536 OOH680_m12/helpcontent2/source/text/scalc/01/04060106.xhp Acknowledgments This is originally reported by tabotabo.
Created attachment 52829 [details] A bugdoc that shows the differences between QUOTIENT and INT
The table has been revised to make numerator sequential. numerator denominator QUOTIENT (*1) INT (*2) Judge ============== ============== ============== ============== ========== 11 3 3 3 10 3 3 3 9 3 3 3 8 3 2 2 7 3 2 2 6 3 2 2 5 3 1 1 4 3 1 1 3 3 1 1 2 3 0 0 1 3 0 0 0 3 0 0 -1 3 0 -1 different -2 3 0 -1 different -3 3 -1 -1 -4 3 -1 -2 different -5 3 -1 -2 different -6 3 -2 -2 -7 3 -2 -3 different -8 3 -2 -3 different -9 3 -3 -3 -10 3 -3 -4 different -11 3 -3 -4 different Err:502 #DIV/0! Err:502 ========================================================================== *1 =QUOTIENT(Numerator;Denominator) *2 =INT(numerator/denominator)
Created attachment 52835 [details] A revised bugdoc