[Libreoffice-commits] help.git: source/text

[Mike Kaganski]

 source/text/scalc/01/04060106.xhp |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit cac2a5ccfd5d7197a1a1ad706bca5f0f4235a2fd
Author: Mike Kaganski <mike.kaganski at collabora.com>
Date:   Fri Dec 29 12:27:36 2017 +0100

    Correction to the QUOTIENT spreadsheet function documentation
    
    If arguments have different signs, it isn't equivalent to
    INT(numerator/denominator). E.g., QUOTIENT(-3,14;1) gives -3, while
    INT(-3,14/1) gives -4.
    
    Change-Id: I1abe0a6bd77ba5f451844cf3e5c2ab2e021d7c96
    Reviewed-on: https://gerrit.libreoffice.org/47171
    Reviewed-by: Adolfo Jayme Barrientos <fitojb at ubuntu.com>
    Tested-by: Adolfo Jayme Barrientos <fitojb at ubuntu.com>

diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index 7d49a2905..806a043a1 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -887,7 +887,7 @@
 <paragraph id="hd_id3144646" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
 <paragraph id="par_id3144659" role="code" xml-lang="en-US">QUOTIENT(Numerator; Denominator)</paragraph>
 <paragraph id="par_id9038972" role="paragraph" xml-lang="en-US">Returns the integer part of <emph>Numerator</emph> divided by <emph>Denominator</emph>.</paragraph>
-<paragraph id="par_id7985168" role="paragraph" xml-lang="en-US">QUOTIENT is equivalent to <item type="literal">INT(numerator/denominator)</item>, except that it may report errors with different error codes.</paragraph>
+<paragraph id="par_id7985168" role="paragraph" xml-lang="en-US">QUOTIENT is equivalent to <item type="literal">INT(numerator/denominator)</item> for same-sign numerator and denominator, except that it may report errors with different error codes. More generally, it is equivalent to <item type="literal">INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator)</item>.</paragraph>
 
 <paragraph id="hd_id3144674" role="heading" level="3" xml-lang="en-US">Example</paragraph>
 <paragraph id="par_id3144687" role="paragraph" xml-lang="en-US"><item type="input">=QUOTIENT(11;3)</item> returns 3. The remainder of 2 is lost.</paragraph><comment>see also MOD, INT</comment>