Issue 88302 - Descriptions on the function QUOTIENT in the on-line help could be revised
Descriptions on the function QUOTIENT in the on-line help could be revised
 Status: CONFIRMED None Calc Application ui (show other issues) OOo 2.4.0 All All P3 Trivial (vote) --- AOO issues mailing list

 Reported: 2008-04-15 16:38 UTC by tora3 2013-01-29 21:46 UTC (History) 2 users (show) issues pescetti DEFECT --- ---

Attachments
A bugdoc that shows the differences between QUOTIENT and INT (13.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-04-15 16:48 UTC, tora3
no flags Details
A revised bugdoc (10.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-04-15 19:09 UTC, tora3
no flags Details

 Note You need to log in before you can comment on or make changes to this issue.
 tora3 2008-04-15 16:38:40 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.``` tora3 2008-04-15 16:48:13 UTC ```Created attachment 52829 [details] A bugdoc that shows the differences between QUOTIENT and INT``` tora3 2008-04-15 19:06:24 UTC ```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) ``` tora3 2008-04-15 19:09:07 UTC ```Created attachment 52835 [details] A revised bugdoc```