source/text/scalc/guide/multioperation.xhp | 20 +++++++++-----------
1 file changed, 9 insertions(+), 11 deletions(-)
New commits:
commit 105ffa961374ac3dfc7c2bde23f6c677b9a7f2f5
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Feb 17 18:25:10 2020 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Feb 17 23:13:56 2020 +0100
Fix image size in page
Change-Id: I8b3c885bb98d59880dfce42339344e6119fbf1c8
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/88893
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/guide/multioperation.xhp
b/source/text/scalc/guide/multioperation.xhp
index 48544fcc9..8a4a8e0e0 100644
--- a/source/text/scalc/guide/multioperation.xhp
+++ b/source/text/scalc/guide/multioperation.xhp
@@ -1,5 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
<helpdocument version="1.0">
<!--
@@ -34,17 +33,16 @@
<bookmark_value>data tables; multiple operations in</bookmark_value>
<bookmark_value>cross-classified tables</bookmark_value>
</bookmark><comment>mw made "what if operations" a two level entry</comment>
-<paragraph role="heading" id="hd_id3147559" xml-lang="en-US"
level="1"><variable id="multioperation"><link
href="text/scalc/guide/multioperation.xhp" name="Applying Multiple
Operations">Applying Multiple Operations</link>
-</variable></paragraph>
-<paragraph role="heading" id="hd_id3145171" xml-lang="en-US"
level="2">Multiple Operations in Columns or Rows</paragraph>
+<h1 id="hd_id3147559"><variable id="multioperation"><link
href="text/scalc/guide/multioperation.xhp" name="Applying Multiple
Operations">Applying Multiple Operations</link>
+</variable></h1>
+<h2 id="hd_id3145171">Multiple Operations in Columns or Rows</h2>
<paragraph role="paragraph" id="par_id4123966" xml-lang="en-US">The <item
type="menuitem">Data - Multiple Operations</item> command provides a planning
tool for "what if" questions. In your spreadsheet, you enter a formula to
calculate a result from values that are stored in other cells. Then, you set up
a cell range where you enter some fixed values, and the Multiple Operations
command will calculate the results depending on the formula.</paragraph>
<paragraph role="paragraph" id="par_id3156424" xml-lang="en-US">In the
<emph>Formulas</emph> field, enter the cell reference to the formula that
applies to the data range. In the <emph>Column input cell/Row input cell</emph>
field, enter the cell reference to the corresponding cell that is part of the
formula. This can be explained best by examples:</paragraph>
-<paragraph role="heading" id="hd_id3159153" xml-lang="en-US"
level="3">Examples</paragraph>
+<h3 id="hd_id3159153">Examples</h3>
<paragraph role="paragraph" id="par_id3153189" xml-lang="en-US">You produce
toys which you sell for $10 each. Each toy costs $2 to make, in addition to
which you have fixed costs of $10,000 per year. How much profit will you make
in a year if you sell a particular number of toys?</paragraph>
<paragraph role="paragraph" id="par_id6478774" xml-lang="en-US">
-<image id="img_id1621753" src="media/helpimg/what-if.png" width="0.2228in"
height="0.2228in"><alt id="alt_id1621753" xml-lang="en-US">what-if sheet
area</alt>
- </image></paragraph>
-<paragraph role="heading" id="hd_id3145239" xml-lang="en-US"
level="3">Calculating With One Formula and One Variable</paragraph>
+<image id="img_id1621753" src="media/helpimg/what-if.png"><alt
id="alt_id1621753" xml-lang="en-US">what-if sheet area</alt></image></paragraph>
+<h3 id="hd_id3145239">Calculating With One Formula and One Variable</h3>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3146888" xml-lang="en-US">To calculate
the profit, first enter any number as the quantity (items sold) - in this
example 2000. The profit is found from the formula Profit=Quantity * (Selling
price - Direct costs) - Fixed costs. Enter this formula in B5.</paragraph>
@@ -68,7 +66,7 @@
<paragraph role="listitem" id="par_id3149009" xml-lang="en-US">Close the
dialog with <emph>OK</emph>. You see the profits for the different quantities
in column E.</paragraph>
</listitem>
</list>
-<paragraph role="heading" id="hd_id3148725" xml-lang="en-US"
level="3">Calculating with Several Formulas Simultaneously</paragraph>
+<h3 id="hd_id3148725">Calculating with Several Formulas Simultaneously</h3>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3146880" xml-lang="en-US">Delete column
E.</paragraph>
@@ -92,10 +90,10 @@
<paragraph role="listitem" id="par_id3150862" xml-lang="en-US">Close the
dialog with <emph>OK</emph>. You will now see the profits in column E and the
annual profit per item in column F.</paragraph>
</listitem>
</list>
-<paragraph role="heading" id="hd_id3146139" xml-lang="en-US"
level="2">Multiple Operations Across Rows and Columns</paragraph>
+<h2 id="hd_id3146139">Multiple Operations Across Rows and Columns</h2>
<paragraph role="paragraph" id="par_id3148584" xml-lang="en-US">
<item type="productname">%PRODUCTNAME</item> allows you to carry out joint
multiple operations for columns and rows in so-called cross-tables. The formula
cell has to refer to both the data range arranged in rows and the one arranged
in columns. Select the range defined by both data ranges and call the multiple
operation dialog. Enter the reference to the formula in the
<emph>Formulas</emph> field. The <emph>Row input cell</emph> and the
<emph>Column input cell</emph> fields are used to enter the reference to the
corresponding cells of the formula.</paragraph>
-<paragraph role="heading" id="hd_id3149949" xml-lang="en-US"
level="3">Calculating with Two Variables</paragraph>
+<h3 id="hd_id3149949">Calculating with Two Variables</h3>
<paragraph role="paragraph" id="par_id3154808" xml-lang="en-US">Consider
columns A and B of the sample table above. You now want to vary not just the
quantity produced annually, but also the selling price, and you are interested
in the profit in each case.</paragraph>
<paragraph role="paragraph" id="par_id3149731" xml-lang="en-US">Expand the
table shown above. D2 thru D11 contain the numbers 500, 1000 and so on, up to
5000. In E1 through H1 enter the numbers 8, 10, 15 and 20.</paragraph>
<list type="ordered">
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
