summaryrefslogtreecommitdiff
path: root/source
diff options
context:
space:
mode:
authorSophia Schröder <sophia.schroeder@libreoffice.org>2018-04-07 10:40:03 +0100
committerThorsten Behrens <Thorsten.Behrens@CIB.de>2018-04-09 00:10:40 +0200
commitd560cb36d2eb28f15922417c0025892ecfbc1836 (patch)
tree6866953b286bae38201d3a5abd70cb1aeb03476c /source
parent855ce08c6d82aaedd44b770a54003a10b13b33c6 (diff)
scalc: cleanup markup and whitespace
Change-Id: Id279950e7b50f46a55784153ce7faf1fddf6b6b1 Reviewed-on: https://gerrit.libreoffice.org/52531 Reviewed-by: Thorsten Behrens <Thorsten.Behrens@CIB.de> Tested-by: Thorsten Behrens <Thorsten.Behrens@CIB.de>
Diffstat (limited to 'source')
-rw-r--r--source/text/scalc/01/04060106.xhp12
1 files changed, 6 insertions, 6 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index 10c1fd2912..d5ffe778ea 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -730,9 +730,9 @@
<paragraph role="paragraph" id="par_id451516997742909" xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.</paragraph>
<paragraph xml-lang="en-US" id="par_id291516998575663" role="warning">This function exists for interoperability with Microsoft Excel 2013 or newer.</paragraph>
<paragraph role="heading" id="hd_id561516997761868" level="3" xml-lang="en-US">Example</paragraph>
- <paragraph role="paragraph" id="par_id111516997803684" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3)</item> returns -9</paragraph>
- <paragraph role="paragraph" id="par_id1001516997821483" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3;0)</item> returns -9</paragraph>
- <paragraph role="paragraph" id="par_id641516997837754" xml-lang="en-US"><item type="item_type">=CEILING.MATH(-10;-3;1)</item> returns -12</paragraph>
+ <paragraph role="paragraph" id="par_id111516997803684" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3)</item> returns -9</paragraph>
+ <paragraph role="paragraph" id="par_id1001516997821483" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3;0)</item> returns -9</paragraph>
+ <paragraph role="paragraph" id="par_id641516997837754" xml-lang="en-US"><item type="item_type">=CEILING.MATH(-10;-3;1)</item> returns -12</paragraph>
</section>
<section id="Section 31.4">
<bookmark xml-lang="en-US" branch="index" id="bm_id921516998608939">
@@ -747,9 +747,9 @@
<paragraph role="paragraph" id="par_id151516998882622" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded.</paragraph>
<paragraph xml-lang="en-US" id="par_id341516998889754" role="warning">This function exists for interoperability with Microsoft Excel 2007 or older versions.</paragraph>
<paragraph role="heading" id="hd_id81516998896303" level="3" xml-lang="en-US">Example</paragraph>
- <paragraph role="paragraph" id="par_id91516998917254" xml-lang="en-US"><item type="input">=CEILING.XCL(1;3)</item> returns 3</paragraph>
- <paragraph role="paragraph" id="par_id761516998929693" xml-lang="en-US"><item type="input">=CEILING.XCL(7;4)</item> returns 8</paragraph>
- <paragraph role="paragraph" id="par_id671516998958873" xml-lang="en-US"><item type="item_type">=CEILING.XCL(-10;-3)</item> returns -12</paragraph>
+ <paragraph role="paragraph" id="par_id91516998917254" xml-lang="en-US"><item type="input">=CEILING.XCL(1;3)</item> returns 3</paragraph>
+ <paragraph role="paragraph" id="par_id761516998929693" xml-lang="en-US"><item type="input">=CEILING.XCL(7;4)</item> returns 8</paragraph>
+ <paragraph role="paragraph" id="par_id671516998958873" xml-lang="en-US"><item type="item_type">=CEILING.XCL(-10;-3)</item> returns -12</paragraph>
</section>
<section id="Section31.2">
<bookmark xml-lang="en-US" branch="index" id="bm_id8952518">