summaryrefslogtreecommitdiffstats
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
parentFix typo in help (diff)
downloadhelp-d560cb36d2eb28f15922417c0025892ecfbc1836.tar.gz
help-d560cb36d2eb28f15922417c0025892ecfbc1836.zip
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>
-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">