diff options
Diffstat (limited to 'source/text/scalc/guide')
26 files changed, 78 insertions, 78 deletions
diff --git a/source/text/scalc/guide/auto_off.xhp b/source/text/scalc/guide/auto_off.xhp index d01db05e2b..2b901dd376 100644 --- a/source/text/scalc/guide/auto_off.xhp +++ b/source/text/scalc/guide/auto_off.xhp @@ -51,21 +51,21 @@ </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Z.</paragraph> <paragraph id="par_id3145273" role="paragraph" xml-lang="en-US">The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc:</paragraph> -<paragraph id="hd_id3145748" role="heading" level="2" xml-lang="en-US">Automatic Text or Number Completion</paragraph> +<h2 id="hd_id3145748">Automatic Text or Number Completion</h2> <paragraph id="par_id3154730" role="paragraph" xml-lang="en-US">When making an entry in a cell, $[officename] Calc automatically suggests matching input found in the same column. This function is known as <emph>AutoInput</emph>.</paragraph> <paragraph id="par_id3153878" role="paragraph" xml-lang="en-US">To turn the AutoInput on and off, set or remove the check mark in front of <link href="text/scalc/01/06130000.xhp"><emph>Tools - AutoInput</emph></link>.</paragraph> -<paragraph id="hd_id3146972" role="heading" level="2" xml-lang="en-US">Automatic Conversion to Date Format</paragraph> +<h2 id="hd_id3146972">Automatic Conversion to Date Format</h2> <paragraph id="par_id3153707" role="paragraph" xml-lang="en-US">$[officename] Calc automatically converts certain entries to dates. For example, the entry <emph>1.1</emph> may be interpreted as January 1 of the current year, according to the locale settings of your operating system, and then displayed according to the date format applied to the cell.<comment>for sure 1.1 will not be interpreted as a date in the USofA !!</comment></paragraph> <paragraph id="par_id3159267" role="paragraph" xml-lang="en-US">To ensure that an entry is interpreted as text, add an apostrophe at the beginning of the entry. The apostrophe is not displayed in the cell.</paragraph> -<paragraph id="hd_id3150043" role="heading" level="2" xml-lang="en-US">Quotation Marks Replaced by Custom Quotes</paragraph> +<h2 id="hd_id3150043">Quotation Marks Replaced by Custom Quotes</h2> <paragraph id="par_id3155333" role="paragraph" xml-lang="en-US">Choose <emph>Tools - AutoCorrect - AutoCorrect Options</emph>. Go to the <emph>Localized Options</emph> tab and unmark <emph>Replace</emph>.</paragraph> -<paragraph id="hd_id3149565" role="heading" level="2" xml-lang="en-US">Cell Content Always Begins With Uppercase</paragraph> +<h2 id="hd_id3149565">Cell Content Always Begins With Uppercase</h2> <paragraph id="par_id3147001" role="paragraph" xml-lang="en-US">Choose <item type="menuitem">Tools - AutoCorrect - AutoCorrect Options</item>. Go to the <item type="menuitem">Options</item> tab. Unmark <item type="menuitem">Capitalize first letter of every sentence</item>.</paragraph> -<paragraph id="hd_id3150345" role="heading" level="2" xml-lang="en-US">Replace Word With Another Word</paragraph> +<h2 id="hd_id3150345">Replace Word With Another Word</h2> <paragraph id="par_id3166425" role="paragraph" xml-lang="en-US">Choose <item type="menuitem">Tools - AutoCorrect - AutoCorrect Options</item>. Go to the <item type="menuitem">Replace</item> tab. Select the word pair and click <item type="menuitem">Delete</item>.</paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/guide/borders.xhp b/source/text/scalc/guide/borders.xhp index 885aad22e1..53fe411ea2 100644 --- a/source/text/scalc/guide/borders.xhp +++ b/source/text/scalc/guide/borders.xhp @@ -49,7 +49,7 @@ </listitem> </list> <paragraph xml-lang="en-US" id="par_id1342204" role="paragraph">The options in the <emph>Line arrangement</emph> area can be used to apply multiple border styles.</paragraph> - <paragraph xml-lang="en-US" id="hd_id4454481" role="heading" level="2">Selection of cells</paragraph> + <h2 id="hd_id4454481">Selection of cells</h2> <paragraph xml-lang="en-US" id="par_id7251503" role="paragraph">Depending on the selection of cells, the area looks different.</paragraph> <table id="tbl_id4423352"> <tablerow> @@ -114,7 +114,7 @@ <paragraph xml-lang="en-US" id="par_id4818872" role="listitem">The thick gray lines inside an icon show the lines that will not be changed.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id8989226" role="heading" level="3">Examples</paragraph> + <h3 id="hd_id8989226">Examples</h3> <paragraph xml-lang="en-US" id="par_id622577" role="paragraph">Select a block of about 8x8 cells, then choose <emph>Format - Cells - Borders</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id8119754" role="paragraph"> <image id="img_id7261268" src="media/helpimg/border_ca_5.png" width="1.0937in" height="0.2189in"><alt xml-lang="en-US" id="alt_id7261268">default icon row of Borders tab page</alt> @@ -131,7 +131,7 @@ </listitem> </list> <paragraph xml-lang="en-US" id="par_id9269386" role="paragraph">Now you can continue to see which lines the other icons will set or remove.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3593554" role="heading" level="2">User Defined Settings</paragraph> + <h2 id="hd_id3593554">User Defined Settings</h2> <paragraph xml-lang="en-US" id="par_id4018066" role="paragraph">In the <emph>User defined</emph> area, you can click to set or remove individual lines. The preview shows lines in three different states. </paragraph> <paragraph xml-lang="en-US" id="par_id8004699" role="paragraph">Repeatedly click an edge or a corner to switch through the three different states.</paragraph> <table id="tbl_id5196996"> @@ -186,7 +186,7 @@ </tablecell> </tablerow> </table> - <paragraph xml-lang="en-US" id="hd_id7282937" role="heading" level="3">Examples</paragraph> + <h3 id="hd_id7282937">Examples</h3> <paragraph xml-lang="en-US" id="par_id4230780" role="paragraph">Select a single cell, then choose <emph>Format - Cells - Borders</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id1712393" role="paragraph">Click the lower edge to set a very thin line as a lower border. All other lines will be removed from the cell.</paragraph> <paragraph xml-lang="en-US" id="par_id5149693" role="paragraph"> diff --git a/source/text/scalc/guide/calc_series.xhp b/source/text/scalc/guide/calc_series.xhp index f3ba21842a..f61c7c8956 100644 --- a/source/text/scalc/guide/calc_series.xhp +++ b/source/text/scalc/guide/calc_series.xhp @@ -41,7 +41,7 @@ <paragraph xml-lang="en-US" id="hd_id3150769" role="heading" level="1"><variable id="calc_series"><link href="text/scalc/guide/calc_series.xhp">Automatically Filling in Data Based on Adjacent Cells</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_idN106A8" role="paragraph">You can automatically fill cells with data with the AutoFill command or the Series command.</paragraph> - <paragraph xml-lang="en-US" id="par_idN106D3" role="heading" level="2">Using AutoFill</paragraph> + <h2 id="par_idN106D3">Using AutoFill</h2> <paragraph xml-lang="en-US" id="par_idN106D7" role="paragraph">AutoFill automatically generates a data series based on a defined pattern.</paragraph> <list type="ordered"> <listitem> @@ -60,7 +60,7 @@ </caseinline><defaultinline>Ctrl</defaultinline></switchinline> if you do not want to fill the cells with different values.</paragraph> <paragraph xml-lang="en-US" id="par_id3154490" role="note">If you select two or more adjacent cells that contain different numbers, and drag, the remaining cells are filled with the arithmetic pattern that is recognized in the numbers. The AutoFill function also recognizes customized lists that are defined under <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem"> - %PRODUCTNAME Calc - Sort Lists</item>.</paragraph> <paragraph xml-lang="en-US" id="par_idN10737" role="tip">You can double-click the fill handle to automatically fill all empty columns of the current data block. For example, first enter Jan into A1 and drag the fill handle down to A12 to get the twelve months in the first column. Now enter some values into B1 and C1. Select those two cells, and double-click the fill handle. This fills automatically the data block B1:C12.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10713" role="heading" level="2">Using a Defined Series</paragraph> + <h2 id="par_idN10713">Using a Defined Series</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3150749" role="listitem">Select the cell range in the sheet that you want to fill.</paragraph> diff --git a/source/text/scalc/guide/cellstyle_conditional.xhp b/source/text/scalc/guide/cellstyle_conditional.xhp index 7f7d478326..899893d10f 100644 --- a/source/text/scalc/guide/cellstyle_conditional.xhp +++ b/source/text/scalc/guide/cellstyle_conditional.xhp @@ -42,7 +42,7 @@ <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph">Using the menu command <emph>Format - Conditional - Condition</emph>, the dialog allows you to define conditions per cell, which must be met in order for the selected cells to have a particular format.</paragraph> <paragraph xml-lang="en-US" id="par_id8039796" role="warning">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</paragraph> <paragraph xml-lang="en-US" id="par_id3154944" role="paragraph">With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually.</paragraph> - <paragraph xml-lang="en-US" id="hd_id4480727" role="heading" level="2">To Define the Conditions</paragraph> + <h2 id="hd_id4480727">To Define the Conditions</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3154490" role="listitem">Select the cells to which you want to apply a conditional style.</paragraph> @@ -54,8 +54,8 @@ <paragraph xml-lang="en-US" id="par_id3146969" role="listitem">Enter the condition(s) into the dialog box. The dialog is described in detail in <link href="text/scalc/01/05120000.xhp">$[officename] Help</link>, and an example is provided below:</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3155766" role="heading" level="2">Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value</paragraph> - <paragraph xml-lang="en-US" id="hd_id4341868" role="heading" level="3">Step1: Generate Number Values</paragraph> + <h2 id="hd_id3155766">Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value</h2> + <h3 id="hd_id4341868">Step1: Generate Number Values</h3> <paragraph xml-lang="en-US" id="par_id3150043" role="paragraph">You want to give certain values in your tables particular emphasis. For example, in a table of turnovers, you can show all the values above the average in green and all those below the average in red. This is possible with conditional formatting.</paragraph> <list type="ordered"> <listitem> @@ -69,7 +69,7 @@ <paragraph xml-lang="en-US" id="par_id3159236" role="listitem">In the same way as described above, drag down the corner of the rightmost cell in order to create more rows of random numbers.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3149211" role="heading" level="3">Step 2: Define Cell Styles</paragraph> + <h3 id="hd_id3149211">Step 2: Define Cell Styles</h3> <paragraph xml-lang="en-US" id="par_id3154659" role="paragraph">The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles window is visible before proceeding.</paragraph> <list type="ordered"> <listitem> @@ -85,7 +85,7 @@ <paragraph xml-lang="en-US" id="par_id3152889" role="listitem">To define a second style, click again in a blank cell and proceed as described above. Assign a different background color for the cell and assign a name (for this example, "Below").</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3148704" role="heading" level="3">Step 3: Calculate Average</paragraph> + <h3 id="hd_id3148704">Step 3: Calculate Average</h3> <paragraph xml-lang="en-US" id="par_id3148837" role="paragraph">In our particular example, we are calculating the average of the random values. The result is placed in a cell:</paragraph> <list type="ordered"> <listitem> @@ -98,7 +98,7 @@ <paragraph xml-lang="en-US" id="par_id3153246" role="listitem">Close the Function Wizard with <item type="menuitem">OK</item>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3149898" role="heading" level="3">Step 4: Apply Cell Styles</paragraph> + <h3 id="hd_id3149898">Step 4: Apply Cell Styles</h3> <paragraph xml-lang="en-US" id="par_id3149126" role="paragraph">Now you can apply the conditional formatting to the sheet:</paragraph> <list type="ordered"> <listitem> @@ -111,7 +111,7 @@ <paragraph xml-lang="en-US" id="par_id3153013" role="listitem">Define the condition as follows: If cell value is less than J14, format with cell style "Below", and if cell value is greater than or equal to J14, format with cell style "Above".</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3155761" role="heading" level="3">Step 5: Copy Cell Style</paragraph> + <h3 id="hd_id3155761">Step 5: Copy Cell Style</h3> <paragraph xml-lang="en-US" id="par_id3145320" role="paragraph">To apply the conditional formatting to other cells later:</paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/consolidate.xhp b/source/text/scalc/guide/consolidate.xhp index 55eb650e06..f78b4d0298 100644 --- a/source/text/scalc/guide/consolidate.xhp +++ b/source/text/scalc/guide/consolidate.xhp @@ -37,7 +37,7 @@ <paragraph xml-lang="en-US" id="hd_id3150791" role="heading" level="1"><variable id="consolidate"><link href="text/scalc/guide/consolidate.xhp">Consolidating Data</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153191" role="paragraph">During consolidation, the contents of the cells from several sheets will be combined in one place.</paragraph> - <paragraph xml-lang="en-US" id="hd_id892056" role="heading" level="2">To Combine Cell Contents</paragraph> + <h2 id="hd_id892056">To Combine Cell Contents</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3151073" role="listitem">Open the document that contains the cell ranges to be consolidated.</paragraph> @@ -66,7 +66,7 @@ <paragraph xml-lang="en-US" id="par_id3149315" role="listitem">Click <emph>OK</emph> to consolidate the ranges.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_idN107DE" role="heading" level="2">Additional Settings</paragraph> + <h2 id="par_idN107DE">Additional Settings</h2> <paragraph xml-lang="en-US" id="par_id3147250" role="paragraph">Click <emph>More</emph> in the <emph>Consolidate</emph> dialog to display additional settings:</paragraph> <list type="unordered"> <listitem> diff --git a/source/text/scalc/guide/csv_formula.xhp b/source/text/scalc/guide/csv_formula.xhp index 1e793caf7a..05b95dd53c 100644 --- a/source/text/scalc/guide/csv_formula.xhp +++ b/source/text/scalc/guide/csv_formula.xhp @@ -35,7 +35,7 @@ <paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1"><variable id="csv_formula"><link href="text/scalc/guide/csv_formula.xhp">Importing and Exporting CSV Text Files with Formulas</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3149402" role="paragraph">Comma separated values (CSV) files are text files that contain the cell contents of a single sheet. Commas, semicolons, or other characters can be used as the field delimiters between the cells. Text strings are put in quotation marks, numbers are written without quotation marks.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3150715" role="heading" level="2">To Import a CSV File</paragraph> + <h2 id="hd_id3150715">To Import a CSV File</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3153709" role="listitem">Choose <emph>File - Open</emph>.</paragraph> @@ -48,7 +48,7 @@ </listitem> </list> <paragraph xml-lang="en-US" id="par_id3149255" role="tip">If the csv file contains formulas, but you want to import the results of those formulas, then choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - View</emph> and clear the <emph>Formulas</emph> check box.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3154022" role="heading" level="2">To Export Formulas and Values as CSV Files</paragraph> + <h2 id="hd_id3154022">To Export Formulas and Values as CSV Files</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3150342" role="listitem">Click the sheet to be written as a csv file.</paragraph> diff --git a/source/text/scalc/guide/database_filter.xhp b/source/text/scalc/guide/database_filter.xhp index be0468eee4..29b577ff4c 100644 --- a/source/text/scalc/guide/database_filter.xhp +++ b/source/text/scalc/guide/database_filter.xhp @@ -34,7 +34,7 @@ <paragraph xml-lang="en-US" id="hd_id3153541" role="heading" level="1"><variable id="database_filter"><link href="text/scalc/guide/database_filter.xhp">Filtering Cell Ranges</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3145069" role="paragraph">You can use several filters to filter cell ranges in spreadsheets. A standard filter uses the options that you specify to filter the data. An AutoFilter filters data according to a specific value or string. An advanced filter uses filter criteria from specified cells.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10682" role="heading" level="2">To Apply a Standard Filter to a Cell Range</paragraph> + <h2 id="par_idN10682">To Apply a Standard Filter to a Cell Range</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3150398" role="listitem">Click in a cell range.</paragraph> @@ -50,7 +50,7 @@ <paragraph xml-lang="en-US" id="par_id3153143" role="paragraph">The records that match the filter options that you specified are shown.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id3153728" role="heading" level="2">To Apply an AutoFilter to a Cell Range</paragraph> + <h2 id="par_id3153728">To Apply an AutoFilter to a Cell Range</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3144764" role="listitem">Click in a cell range or a database range.</paragraph> @@ -68,7 +68,7 @@ <paragraph xml-lang="en-US" id="par_idN1074C" role="listitem">The records that match the filter criteria that you selected are shown.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_idN106E8" role="heading" level="2">To Remove a Filter From a Cell Range</paragraph> + <h2 id="par_idN106E8">To Remove a Filter From a Cell Range</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_idN1075C" role="paragraph">Click in a filtered cell range.</paragraph> diff --git a/source/text/scalc/guide/dbase_files.xhp b/source/text/scalc/guide/dbase_files.xhp index 79f3c98029..5576ee0bdb 100644 --- a/source/text/scalc/guide/dbase_files.xhp +++ b/source/text/scalc/guide/dbase_files.xhp @@ -36,7 +36,7 @@ <paragraph xml-lang="en-US" id="par_idN10738" role="heading" level="1"><variable id="dbase_files"><link href="text/scalc/guide/dbase_files.xhp">Importing and Exporting dBASE Files</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_idN10756" role="paragraph">You can open and save data in the dBASE file format (*.dbf file extension) in $[officename] Base or a spreadsheet. In %PRODUCTNAME Base, a dBASE database is a folder that contains files with the .dbf file extension. Each file corresponds to a table in the database. Formulas and formatting are lost when you open and save a dBASE file from %PRODUCTNAME.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10759" role="heading" level="2">To Import a dBASE File Into a Spreadsheet</paragraph> + <h2 id="par_idN10759">To Import a dBASE File Into a Spreadsheet</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_idN10760" role="paragraph">Choose <emph>File - Open</emph>.</paragraph> @@ -54,7 +54,7 @@ <paragraph xml-lang="en-US" id="par_idN1074E" role="warning">If you want to save the spreadsheet as a dBASE file, do not alter or delete the first row in the imported file. This row contains information that is required by a dBASE database.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_idN1077A" role="heading" level="2">To Import a dBASE File Into a Database Table</paragraph> + <h2 id="par_idN1077A">To Import a dBASE File Into a Database Table</h2> <paragraph xml-lang="en-US" id="par_idN1076C" role="paragraph">A %PRODUCTNAME Base database table is actually a link to an existing database.</paragraph> <list type="ordered"> <listitem> @@ -82,7 +82,7 @@ <paragraph xml-lang="en-US" id="par_idN107BE" role="paragraph">Click <emph>Create</emph>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_idN107F1" role="heading" level="2">To Save a Spreadsheet as a dBASE File</paragraph> + <h2 id="par_idN107F1">To Save a Spreadsheet as a dBASE File</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_idN107F8" role="paragraph">Choose <emph>File - Save As</emph>.</paragraph> diff --git a/source/text/scalc/guide/finding.xhp b/source/text/scalc/guide/finding.xhp index bc55cf5c2b..be18831431 100644 --- a/source/text/scalc/guide/finding.xhp +++ b/source/text/scalc/guide/finding.xhp @@ -37,9 +37,9 @@ </variable></paragraph> <paragraph role="paragraph" id="par_id9363689" xml-lang="en-US">In spreadsheet documents you can find words, formulas, and styles. You can navigate from one result to the next, or you can highlight all matching cells at once, then apply another format or replace the cell content by other content.</paragraph> </section> -<paragraph role="heading" id="hd_id3610644" xml-lang="en-US" level="2">The Find & Replace dialog</paragraph> +<h2 id="hd_id3610644">The Find & Replace dialog</h2> <paragraph role="paragraph" id="par_id2224494" xml-lang="en-US">Cells can contain text or numbers that were entered directly as in a text document. But cells can also contain text or numbers as the result of a calculation. For example, if a cell contains the formula =1+2 it displays the result 3. You must decide whether to search for the 1 respective 2, or to search the 3.</paragraph> -<paragraph role="heading" id="hd_id2423780" xml-lang="en-US" level="3">To find formulas or values</paragraph> +<h3 id="hd_id2423780">To find formulas or values</h3> <paragraph role="paragraph" id="par_id2569658" xml-lang="en-US">You can specify in the Find & Replace dialog either to find the parts of a formula or the results of a calculation.</paragraph> <list type="ordered"> <listitem> @@ -55,7 +55,7 @@ <paragraph role="paragraph" id="par_id1331217" xml-lang="en-US">With "Formulas" you will find all parts of the formulas. </paragraph> <paragraph role="paragraph" id="par_id393993" xml-lang="en-US">With "Values" you will find the results of the calculations. </paragraph> <paragraph role="note" id="par_id3163853">Cell contents can be formatted in different ways. For example, a number can be formatted as a currency, to be displayed with a currency symbol. These symbols are included in searches when the Formatted Display search option is activated.</paragraph> -<paragraph role="heading" id="hd_id7359233" xml-lang="en-US" level="3">Finding text</paragraph> +<h3 id="hd_id7359233">Finding text</h3> <list type="ordered"> <listitem> <paragraph role="paragraph" id="par_id6549272" xml-lang="en-US">Choose <emph>Edit - Find & Replace</emph> to open the Find & Replace dialog.</paragraph> @@ -77,7 +77,7 @@ </listitem> </list> <paragraph role="paragraph" id="par_id7811822" xml-lang="en-US">When you click <emph>Find All</emph>, Calc selects all cells that contain your entry. Now you can for example set all found cells to bold, or apply a Cell Style to all at once.</paragraph> -<paragraph role="heading" id="hd_id8531449" xml-lang="en-US" level="2">The Navigator</paragraph> +<h2 id="hd_id8531449">The Navigator</h2> <list type="ordered"> <listitem> <paragraph role="paragraph" id="par_id9183935" xml-lang="en-US">Choose <emph>View - Navigator</emph> to open the Navigator window.</paragraph> diff --git a/source/text/scalc/guide/format_table.xhp b/source/text/scalc/guide/format_table.xhp index 823e80d1e0..9dd08cb611 100644 --- a/source/text/scalc/guide/format_table.xhp +++ b/source/text/scalc/guide/format_table.xhp @@ -39,7 +39,7 @@ </bookmark><comment>mw transferred 2 entries from shared/01/05020300.xhp and added 2 new entries</comment><comment>mw deleted "defaults;"</comment> <paragraph role="heading" id="hd_id3154125" xml-lang="en-US" level="1"><variable id="format_table"><link href="text/scalc/guide/format_table.xhp">Formatting Spreadsheets</link> </variable></paragraph> -<paragraph role="heading" id="hd_id3153912" xml-lang="en-US" level="2">Formatting Text in a Spreadsheet </paragraph> +<h2 id="hd_id3153912">Formatting Text in a Spreadsheet </h2> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3144772" xml-lang="en-US">Select the text you want to format.</paragraph> @@ -48,7 +48,7 @@ <paragraph role="listitem" id="par_id3155268" xml-lang="en-US">Choose the desired text attributes from the <emph>Formatting </emph>Bar. You can also choose <emph>Format - Cells</emph>. The <emph>Format Cells</emph> dialog will appear in which you can choose various text attributes on the <emph>Font</emph> tab page.</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3149899" xml-lang="en-US" level="2">Formatting Numbers in a Spreadsheet</paragraph> +<h2 id="hd_id3149899">Formatting Numbers in a Spreadsheet</h2> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3159226" xml-lang="en-US">Select the cells containing the numbers you want to format.</paragraph> @@ -57,7 +57,7 @@ <paragraph role="listitem" id="par_id3150046" xml-lang="en-US">To format numbers in the default currency format or as percentages, use the icons on the <emph>Formatting </emph>Bar. For other formats, choose <emph>Format - Cells</emph>. You can choose from the preset formats or define your own on the <emph>Numbers</emph> tab page.</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3153483" xml-lang="en-US" level="2">Formatting Borders and Backgrounds for Cells and Pages</paragraph> +<h2 id="hd_id3153483">Formatting Borders and Backgrounds for Cells and Pages</h2> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3154733" xml-lang="en-US">You can assign a format to any group of cells by first selecting the cells (for multiple selection, hold down the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key when clicking), and then activating the <emph>Format Cells</emph> dialog in <item type="menuitem">Format - Cells</item>. In this dialog, you can select attributes such as shadows and backgrounds.</paragraph> diff --git a/source/text/scalc/guide/goalseek.xhp b/source/text/scalc/guide/goalseek.xhp index f17b3b4dec..cbbad6c346 100644 --- a/source/text/scalc/guide/goalseek.xhp +++ b/source/text/scalc/guide/goalseek.xhp @@ -37,7 +37,7 @@ <paragraph role="heading" id="hd_id3145068" xml-lang="en-US" level="1"><variable id="goalseek"><link href="text/scalc/guide/goalseek.xhp">Applying Goal Seek</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3145171" xml-lang="en-US">With the help of Goal Seek you can calculate a value that, as part of a formula, leads to the result you specify for the formula. You thus define the formula with several fixed values and one variable value and the result of the formula.</paragraph> -<paragraph role="heading" id="hd_id3153966" xml-lang="en-US" level="2">Goal Seek Example</paragraph> +<h2 id="hd_id3153966">Goal Seek Example</h2> <paragraph role="paragraph" id="par_id3150871" xml-lang="en-US">To calculate annual interest (I), create a table with the values for the capital (C), number of years (n), and interest rate (i). The formula is:</paragraph> <paragraph role="code" id="par_id3152596" xml-lang="en-US">I = C * n* i</paragraph> <paragraph role="paragraph" id="par_id3155335" xml-lang="en-US">Let us assume that the interest rate <item type="literal">i</item> of 7.5% and the number of years <item type="literal">n</item> (1) will remain constant. However, you want to know how much the investment capital <item type="literal">C</item> would have to be modified in order to attain a particular return <item type="literal">I</item>. For this example, calculate how much capital <item type="literal">C</item> would be required if you want an annual return of $15,000.</paragraph> diff --git a/source/text/scalc/guide/html_doc.xhp b/source/text/scalc/guide/html_doc.xhp index 2c7a800184..99a5eded94 100644 --- a/source/text/scalc/guide/html_doc.xhp +++ b/source/text/scalc/guide/html_doc.xhp @@ -36,7 +36,7 @@ </bookmark> <paragraph role="heading" id="hd_id3150542" xml-lang="en-US" level="1"><variable id="html_doc"><link href="text/scalc/guide/html_doc.xhp">Saving and Opening Sheets in HTML</link> </variable></paragraph> -<paragraph role="heading" id="hd_id3154124" xml-lang="en-US" level="2">Saving Sheets in HTML</paragraph> +<h2 id="hd_id3154124">Saving Sheets in HTML</h2> <paragraph role="paragraph" id="par_id3145785" xml-lang="en-US"> <item type="productname">%PRODUCTNAME</item> Calc saves all the sheets of a Calc document together as an HTML document. At the beginning of the HTML document, a heading and a list of hyperlinks are automatically added which lead to the individual sheets within the document.</paragraph> <paragraph role="paragraph" id="par_id3155854" xml-lang="en-US">Numbers are shown as written. In addition, in the <SDVAL> HTML tag, the exact internal number value is written so that after opening the HTML document with <item type="productname">%PRODUCTNAME</item> you know you have the exact values.</paragraph> @@ -51,7 +51,7 @@ <paragraph role="listitem" id="par_id3154729" xml-lang="en-US">Enter a <emph>File name</emph> and click <emph>Save</emph>.</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3149379" xml-lang="en-US" level="2">Opening Sheets in HTML</paragraph> +<h2 id="hd_id3149379">Opening Sheets in HTML</h2> <paragraph role="paragraph" id="par_id3149959" xml-lang="en-US"> <item type="productname">%PRODUCTNAME</item> offers various filters for opening HTML files, which you can select under <emph>File - Open</emph> in the <emph>Files of type</emph> list box:</paragraph> <list type="unordered"> diff --git a/source/text/scalc/guide/keyboard.xhp b/source/text/scalc/guide/keyboard.xhp index 72c6461195..7688e47376 100644 --- a/source/text/scalc/guide/keyboard.xhp +++ b/source/text/scalc/guide/keyboard.xhp @@ -37,7 +37,7 @@ </variable></paragraph> <paragraph role="paragraph" id="par_id3154760" xml-lang="en-US">Refer also to the lists of shortcut keys for <item type="productname">%PRODUCTNAME</item> Calc and <item type="productname">%PRODUCTNAME</item> in general.</paragraph> <embed href="text/shared/00/00000099.xhp#keys"/> -<paragraph role="heading" id="hd_id3153360" xml-lang="en-US" level="2">Cell Selection Mode</paragraph> +<h2 id="hd_id3153360">Cell Selection Mode</h2> <table id="tbl_id3153968"> <tablerow> <tablecell colspan="" rowspan=""> @@ -52,7 +52,7 @@ </table> <paragraph role="paragraph" id="par_id3145272" xml-lang="en-US">In the cell selection mode, you can use the common navigation keys to select cells.</paragraph> -<paragraph role="heading" id="hd_id3148646" xml-lang="en-US" level="2">Controlling the Outline</paragraph> +<h2 id="hd_id3148646">Controlling the Outline</h2> <paragraph role="paragraph" id="par_id3146120" xml-lang="en-US">You can use the keyboard in <link href="text/scalc/01/12080000.xhp">Outline</link>:</paragraph> <list type="unordered"> <listitem> @@ -80,7 +80,7 @@ <paragraph role="listitem" id="par_id3154253" xml-lang="en-US">Use <item type="keycode">Up</item>, <item type="keycode">Down</item>, <item type="keycode">Left</item>, or <item type="keycode">Right</item> arrow to cycle through all buttons in the current level.</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3147343" xml-lang="en-US" level="2">Selecting a Drawing Object or a Graphic</paragraph> +<h2 id="hd_id3147343">Selecting a Drawing Object or a Graphic</h2> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_idN107AA" xml-lang="en-US">Choose View - Toolbars - Drawing to open the Drawing toolbar.</paragraph> diff --git a/source/text/scalc/guide/main.xhp b/source/text/scalc/guide/main.xhp index 3c7ffc299f..6def7f40d7 100644 --- a/source/text/scalc/guide/main.xhp +++ b/source/text/scalc/guide/main.xhp @@ -34,7 +34,7 @@ </bookmark><comment>MWdeleted one entry and added one</comment><paragraph role="heading" id="hd_id3150770" xml-lang="en-US" level="1"><variable id="main"><link href="text/scalc/guide/main.xhp">Instructions for Using $[officename] Calc</link> </variable></paragraph> <embed href="text/shared/00/00000099.xhp#table"/> -<paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="2">Formatting Tables and Cells</paragraph> +<h2 id="hd_id3145748">Formatting Tables and Cells</h2> <embed href="text/scalc/guide/line_fix.xhp#line_fix"/> <embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/> <embed href="text/scalc/guide/currency_format.xhp#currency_format"/> @@ -68,7 +68,7 @@ <embed href="text/shared/guide/textmode_change.xhp#textmode_change"/> <embed href="text/shared/guide/space_hyphen.xhp#space_hyphen"/> <embed href="text/shared/guide/redlining_enter.xhp#redlining_enter"/> -<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="2">Entering Values and Formulas</paragraph> +<h2 id="hd_id3154022">Entering Values and Formulas</h2> <embed href="text/scalc/guide/cell_enter.xhp#cell_enter"/> <embed href="text/scalc/guide/formulas.xhp#formulas"/> <embed href="text/scalc/guide/formula_value.xhp#formula_value"/> @@ -99,11 +99,11 @@ <embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> <embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/> <embed href="text/scalc/guide/webquery.xhp#webquery"/> -<paragraph role="heading" id="hd_id3155382" xml-lang="en-US" level="2">Database Ranges in Tables</paragraph> +<h2 id="hd_id3155382">Database Ranges in Tables</h2> <embed href="text/scalc/guide/database_define.xhp#database_define"/> <embed href="text/scalc/guide/database_filter.xhp#database_filter"/> <embed href="text/scalc/guide/database_sort.xhp#database_sort"/> -<paragraph role="heading" id="hd_id3159229" xml-lang="en-US" level="2">Advanced Calculations</paragraph> +<h2 id="hd_id3159229">Advanced Calculations</h2> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> <embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/> @@ -116,14 +116,14 @@ <embed href="text/scalc/guide/multioperation.xhp#multioperation"/> <embed href="text/scalc/guide/validity.xhp#validity"/> <embed href="text/scalc/guide/scenario.xhp#scenario"/> -<paragraph role="heading" id="hd_id3153070" xml-lang="en-US" level="2">Printing and Print Preview</paragraph> +<h2 id="hd_id3153070">Printing and Print Preview</h2> <embed href="text/scalc/guide/printranges.xhp#printranges"/> <embed href="text/scalc/guide/print_details.xhp#print_details"/> <embed href="text/scalc/guide/print_exact.xhp#print_exact"/> <embed href="text/scalc/guide/print_landscape.xhp#print_landscape"/> <embed href="text/scalc/guide/print_title_row.xhp#print_title_row"/> <embed href="text/shared/guide/background.xhp#background"/> -<paragraph role="heading" id="hd_id3150437" xml-lang="en-US" level="2">Importing and Exporting Documents</paragraph> +<h2 id="hd_id3150437">Importing and Exporting Documents</h2> <embed href="text/scalc/guide/csv_files.xhp#csv_files"/> <embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/> <embed href="text/scalc/guide/dbase_files.xhp#dbase_files"/> @@ -131,7 +131,7 @@ <embed href="text/shared/guide/email.xhp#email"/> <embed href="text/shared/guide/import_ms.xhp#import_ms"/> <embed href="text/shared/guide/export_ms.xhp#export_ms"/> -<paragraph role="heading" id="hd_id3166464" xml-lang="en-US" level="2">Miscellaneous</paragraph> +<h2 id="hd_id3166464">Miscellaneous</h2> <embed href="text/scalc/guide/keyboard.xhp#keyboard"/> <embed href="text/shared/guide/pasting.xhp#pasting"/> <embed href="text/shared/guide/workfolder.xhp#workfolder"/> diff --git a/source/text/scalc/guide/mark_cells.xhp b/source/text/scalc/guide/mark_cells.xhp index 73eea1c8af..80487bb28a 100644 --- a/source/text/scalc/guide/mark_cells.xhp +++ b/source/text/scalc/guide/mark_cells.xhp @@ -36,9 +36,9 @@ </bookmark><comment>mw changed "selection modes..."</comment> <paragraph xml-lang="en-US" id="hd_id3153361" role="heading" level="1"><variable id="mark_cells"><link href="text/scalc/guide/mark_cells.xhp">Selecting Multiple Cells</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="hd_id3145272" role="heading" level="2">Select a rectangular range</paragraph> + <h2 id="hd_id3145272">Select a rectangular range</h2> <paragraph xml-lang="en-US" id="par_id3149261" role="paragraph">With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3151119" role="heading" level="2">Mark a single cell</paragraph> + <h2 id="hd_id3151119">Mark a single cell</h2> <paragraph xml-lang="en-US" id="par_id3146975" role="paragraph">Do one of the following:</paragraph> <list type="unordered"> <listitem> @@ -48,7 +48,7 @@ <paragraph xml-lang="en-US" id="par_id3149959" role="listitem">Pressing the mouse button, drag a range across two cells, do not release the mouse button, and then drag back to the first cell. Release the mouse button. You can now move the individual cell by drag and drop.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3154942" role="heading" level="2">Select various dispersed cells</paragraph> + <h2 id="hd_id3154942">Select various dispersed cells</h2> <paragraph xml-lang="en-US" id="par_id1001200901072060" role="paragraph">Do one of the following:</paragraph> <list type="unordered"> <listitem> @@ -59,7 +59,7 @@ <paragraph xml-lang="en-US" id="par_id1001200901072023" role="paragraph">Click the STD / EXT / ADD area in the status bar until it shows ADD. Now click all cells that you want to select.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="hd_id3146971" role="heading" level="2">Switch marking mode</paragraph> + <h2 id="hd_id3146971">Switch marking mode</h2> <paragraph xml-lang="en-US" id="par_id3155064" role="paragraph">On the status bar, click the box with the legend STD / EXT / ADD to switch the marking mode:</paragraph> <table id="tbl_id3145643"> <tablerow> diff --git a/source/text/scalc/guide/multitables.xhp b/source/text/scalc/guide/multitables.xhp index 20065e8204..326194ce9a 100644 --- a/source/text/scalc/guide/multitables.xhp +++ b/source/text/scalc/guide/multitables.xhp @@ -37,7 +37,7 @@ </bookmark><comment>MW moved "sheets;simultaneous.." to edit_multitables.xhp, transferred 2 entries from there and added "calculating;"</comment> <paragraph xml-lang="en-US" id="hd_id3154759" role="heading" level="1"><variable id="multitables"><link href="text/scalc/guide/multitables.xhp">Applying Multiple Sheets</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="hd_id3148576" role="heading" level="2">Inserting a Sheet</paragraph> + <h2 id="hd_id3148576">Inserting a Sheet</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3154731" role="paragraph">Choose <item type="menuitem">Insert - Sheet</item> to insert a new sheet or an existing sheet from another file.</paragraph> @@ -55,13 +55,13 @@ <paragraph xml-lang="en-US" id="par_id050920091402035" role="paragraph"><ahelp hid="." visibility="hidden">Click to select all sheets in the document.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/.uno:TableDeselectAll" id="bm_id9065825" localize="false"/> <paragraph xml-lang="en-US" id="par_id0509200914020391" role="paragraph"><ahelp hid="." visibility="hidden">Click to deselect all sheets in the document, except the current sheet.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3154491" role="heading" level="2">Selecting Multiple Sheets</paragraph> + <h2 id="hd_id3154491">Selecting Multiple Sheets</h2> <paragraph xml-lang="en-US" id="par_id3145251" role="paragraph">The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> you can select multiple sheets.</paragraph> <paragraph xml-lang="en-US" id="par_idN106B7" role="paragraph">You can use Shift+<switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up or Page Down to select multiple sheets using the keyboard.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3155600" role="heading" level="2">Undoing a Selection</paragraph> + <h2 id="hd_id3155600">Undoing a Selection</h2> <paragraph xml-lang="en-US" id="par_id3146969" role="paragraph">To undo the selection of a sheet, click its sheet tab again while pressing the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key. The sheet that is currently visible cannot be removed from the selection.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3156382" role="heading" level="2">Calculating Across Multiple Sheets</paragraph> + <h2 id="hd_id3156382">Calculating Across Multiple Sheets</h2> <paragraph xml-lang="en-US" id="par_id3155333" role="paragraph">You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, <item type="literal">=SUM(Sheet1.A1:Sheet3.A1) </item>sums up all A1 cells on Sheet1 through Sheet3.</paragraph> diff --git a/source/text/scalc/guide/pivotchart_edit.xhp b/source/text/scalc/guide/pivotchart_edit.xhp index 8666b70fa9..99174e16c8 100644 --- a/source/text/scalc/guide/pivotchart_edit.xhp +++ b/source/text/scalc/guide/pivotchart_edit.xhp @@ -21,7 +21,7 @@ </bookmark> <paragraph role="heading" id="hd_id271525144002806" level="1" xml-lang="en-US"><variable id="pivotchartedit"><link href="text/scalc/guide/pivotchart_edit.xhp">Editing Pivot Charts</link></variable></paragraph> <paragraph role="paragraph" id="par_id971525144066574" xml-lang="en-US">Edit a pivot chart in the same way as normal charts.</paragraph> - <paragraph xml-lang="en-US" id="hd_id5631580" role="heading" level="2">To edit a pivot chart</paragraph> + <h2 id="hd_id5631580">To edit a pivot chart</h2> <embed href="text/schart/main0000.xhp#chartedit"/> <embed href="text/shared/guide/chart_title.xhp#chart_title"/> <embed href="text/shared/guide/chart_axis.xhp#chart_axis"/> diff --git a/source/text/scalc/guide/pivotchart_filter.xhp b/source/text/scalc/guide/pivotchart_filter.xhp index 5a6269f821..19cbe99e45 100644 --- a/source/text/scalc/guide/pivotchart_filter.xhp +++ b/source/text/scalc/guide/pivotchart_filter.xhp @@ -19,7 +19,7 @@ <paragraph role="heading" id="hd_id401525165755583" level="1" xml-lang="en-US"><variable id="pivotchartfilter"><link href="text/scalc/guide/pivotchart_filter.xhp">Filtering Pivot Charts</link></variable></paragraph> <paragraph role="paragraph" id="par_id781525166702239" xml-lang="en-US">Filters are used to remove unwanted data from the pivot chart. You can use filters in the pivot chart or in the corresponding <link href="text/scalc/guide/datapilot_filtertable.xhp">pivot table</link>, since the resulting chart is exactly the same.</paragraph> - <paragraph role="heading" id="hd_id201525166689277" level="2" xml-lang="en-US">Pivot chart field buttons</paragraph> + <h2 id="hd_id201525166689277">Pivot chart field buttons</h2> <paragraph role="paragraph" id="par_id751525167435160" xml-lang="en-US">Pivot chart buttons are unique to pivot charts, normal charts don't have them. The buttons shows the layout of the pivot table, which are the pivot table fields. If present, filters are displayed in the top. Row fields are displayed on the bottom of the chart next to each other and the legend shows the buttons from column fields stacked.</paragraph> diff --git a/source/text/scalc/guide/printranges.xhp b/source/text/scalc/guide/printranges.xhp index 54211ba362..04274b3e3d 100644 --- a/source/text/scalc/guide/printranges.xhp +++ b/source/text/scalc/guide/printranges.xhp @@ -51,7 +51,7 @@ <paragraph xml-lang="en-US" id="par_idN108F5" role="paragraph">You can define which range of cells on a spreadsheet to print.</paragraph> <paragraph xml-lang="en-US" id="par_idN108FB" role="paragraph">The cells on the sheet that are not part of the defined print range are not printed or exported. Sheets without a defined print range are not printed and not exported to a PDF file, unless the document uses the Excel file format.</paragraph> <paragraph xml-lang="en-US" id="par_idN1077A" role="note">For files opened in Excel format, all sheets that do not contain a defined print range are printed. The same behavior occurs when you export the Excel formatted spreadsheet to a PDF file.<comment>UFI: New, see spec "Calc Print Settings Sheet Property "Print Entire Sheet""</comment></paragraph> - <paragraph xml-lang="en-US" id="par_idN108FE" role="heading" level="2">To Define a Print Range</paragraph> + <h2 id="par_idN108FE">To Define a Print Range</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_idN10905" role="paragraph">Select the cells that you want to print.</paragraph> @@ -60,7 +60,7 @@ <paragraph xml-lang="en-US" id="par_idN10909" role="paragraph">Choose <emph>Format - Print Ranges - Define</emph>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_idN10910" role="heading" level="2">To Add Cells to a Print Range</paragraph> + <h2 id="par_idN10910">To Add Cells to a Print Range</h2> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_idN10917" role="paragraph">Select the cells that you want to add to the existing print range.</paragraph> @@ -69,16 +69,16 @@ <paragraph xml-lang="en-US" id="par_idN1091B" role="paragraph">Choose <emph>Format - Print Ranges - Add</emph>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_idN10922" role="heading" level="2">To Clear a Print Range</paragraph> + <h2 id="par_idN10922">To Clear a Print Range</h2> <list type="unordered"> <listitem> <paragraph xml-lang="en-US" id="par_idN10929" role="paragraph">Choose <emph>Format - Print Ranges - Clear</emph>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_idN10953" role="heading" level="2">Using the Page Break Preview to Edit Print Ranges</paragraph> + <h2 id="par_idN10953">Using the Page Break Preview to Edit Print Ranges</h2> <paragraph xml-lang="en-US" id="par_idN1093E" role="paragraph">In the <emph>Page Break Preview</emph>, print ranges as well as page break regions are outlined by a blue border and contain a centered page number in gray. Nonprinting areas have a gray background.</paragraph> <paragraph xml-lang="en-US" id="par_id3153143" role="paragraph">To define a new page break region, drag the border to a new location. When you define a new page break region, an automatic page break is replaced by a manual page break.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10930" role="heading" level="3">To View and Edit Print Ranges</paragraph> + <h3 id="par_idN10930">To View and Edit Print Ranges</h3> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_idN10937" role="paragraph">Choose <emph>View - Page Break Preview</emph>.</paragraph> diff --git a/source/text/scalc/guide/rounding_numbers.xhp b/source/text/scalc/guide/rounding_numbers.xhp index 105c795686..b82b0a7869 100644 --- a/source/text/scalc/guide/rounding_numbers.xhp +++ b/source/text/scalc/guide/rounding_numbers.xhp @@ -46,7 +46,7 @@ <paragraph role="heading" id="hd_id3156422" xml-lang="en-US" level="1"><variable id="rounding_numbers"><link href="text/scalc/guide/rounding_numbers.xhp">Using Rounded Off Numbers</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3153726" xml-lang="en-US">In $[officename] Calc, all decimal numbers are displayed rounded off to two decimal places.</paragraph> -<paragraph role="heading" id="hd_id3152596" xml-lang="en-US" level="3">To change this for selected cells</paragraph> +<h3 id="hd_id3152596">To change this for selected cells</h3> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3154321" xml-lang="en-US">Mark all the cells you want to modify.</paragraph> @@ -58,7 +58,7 @@ <paragraph role="listitem" id="par_id3153876" xml-lang="en-US">In the <emph>Category</emph> field, select <emph>Number</emph>. Under <emph>Options</emph>, change the number of <emph>Decimal places</emph> and exit the dialog with OK.</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3155415" xml-lang="en-US" level="3">To change this everywhere</paragraph> +<h3 id="hd_id3155415">To change this everywhere</h3> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3150715" xml-lang="en-US">Choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc</emph>.</paragraph> @@ -67,7 +67,7 @@ <paragraph role="listitem" id="par_id3153707" xml-lang="en-US">Go to the <emph>Calculate</emph> page. Modify the number of <emph>Decimal places</emph> and exit the dialog with OK.</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3154755" xml-lang="en-US" level="3">To calculate with the rounded off numbers instead of the internal exact values</paragraph> +<h3 id="hd_id3154755">To calculate with the rounded off numbers instead of the internal exact values</h3> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3150045" xml-lang="en-US">Choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc</emph>.</paragraph> diff --git a/source/text/scalc/guide/row_height.xhp b/source/text/scalc/guide/row_height.xhp index f9aefb6564..de38f9d38e 100644 --- a/source/text/scalc/guide/row_height.xhp +++ b/source/text/scalc/guide/row_height.xhp @@ -44,7 +44,7 @@ </variable></paragraph> <paragraph role="paragraph" id="par_id3154017" xml-lang="en-US">You can change the height of the rows with the mouse or through the dialog.</paragraph> <paragraph role="note" id="par_id3154702" xml-lang="en-US">What is described here for rows and row height applies accordingly for columns and column width.</paragraph> -<paragraph role="heading" id="hd_id3153963" xml-lang="en-US" level="2">Using the mouse to change the row height or column width</paragraph> +<h2 id="hd_id3153963">Using the mouse to change the row height or column width</h2> <list type="unordered"> <listitem> <paragraph role="listitem" id="par_id3154020" xml-lang="en-US">Click the area of the headers on the separator below the current row, keep the mouse button pressed and drag up or down in order to change the row height.</paragraph> @@ -53,7 +53,7 @@ <paragraph role="listitem" id="par_id3159237" xml-lang="en-US">Select the optimal row height by double-clicking the separator below the row.</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3154659" xml-lang="en-US" level="2">Using the dialog to change the row height or column width</paragraph> +<h2 id="hd_id3154659">Using the dialog to change the row height or column width</h2> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3150367" xml-lang="en-US">Click the row so that you achieve the focus.</paragraph> diff --git a/source/text/scalc/guide/scenario.xhp b/source/text/scalc/guide/scenario.xhp index 2743cdb541..ef7fb5b813 100644 --- a/source/text/scalc/guide/scenario.xhp +++ b/source/text/scalc/guide/scenario.xhp @@ -35,7 +35,7 @@ </bookmark><comment>UFI: removed "sample" from index term: no sample in OOo</comment><comment>MW changed "scenarios;"</comment><paragraph role="heading" id="hd_id3125863" xml-lang="en-US" level="1"><variable id="scenario"><link href="text/scalc/guide/scenario.xhp">Using Scenarios</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3150869" xml-lang="en-US">A $[officename] Calc scenario is a set of cell values that can be used within your calculations. You assign a name to every scenario on your sheet. Define several scenarios on the same sheet, each with some different values in the cells. Then you can easily switch the sets of cell values by their name and immediately observe the results. Scenarios are a tool to test out "what-if" questions.</paragraph> -<paragraph role="heading" id="hd_id3149255" xml-lang="en-US" level="3">Creating Your Own Scenarios</paragraph> +<h3 id="hd_id3149255">Creating Your Own Scenarios</h3> <paragraph role="paragraph" id="par_id3154704" xml-lang="en-US">To create a scenario, select all the cells that provide the data for the scenario. </paragraph> <list type="ordered"> <listitem> @@ -48,7 +48,7 @@ <paragraph role="listitem" id="par_id3166426" xml-lang="en-US">Enter a name for the new scenario and leave the other fields unchanged with their default values. Close the dialog with OK. Your new scenario is automatically activated.</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3149664" xml-lang="en-US" level="3">Using Scenarios</paragraph><comment>removed "commercial" switched contents</comment><paragraph role="paragraph" id="par_id3153415" xml-lang="en-US">Scenarios can be selected in the Navigator:</paragraph> +<h3 id="hd_id3149664">Using Scenarios</h3><comment>removed "commercial" switched contents</comment><paragraph role="paragraph" id="par_id3153415" xml-lang="en-US">Scenarios can be selected in the Navigator:</paragraph> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3150752" xml-lang="en-US">Open the Navigator with the <emph>Navigator</emph> icon diff --git a/source/text/scalc/guide/table_cellmerge.xhp b/source/text/scalc/guide/table_cellmerge.xhp index bcca2b3227..b211e6b8c7 100644 --- a/source/text/scalc/guide/table_cellmerge.xhp +++ b/source/text/scalc/guide/table_cellmerge.xhp @@ -35,7 +35,7 @@ <paragraph xml-lang="en-US" id="par_id8049867" role="paragraph">You can select a range of cells, then merge them into a single cell. Conversely, you can take a previously merged cell and divide it back into individual cells.</paragraph> </section> <paragraph xml-lang="en-US" id="par_id0509200913480176" role="note">When you copy cells into a target range containing merged cells, the target range gets unmerged first, then the copied cells are pasted in. If the copied cells are merged cells, they retain their merge state.</paragraph> - <paragraph xml-lang="en-US" id="hd_id235602" role="heading" level="2">Merge Cells</paragraph> + <h2 id="hd_id235602">Merge Cells</h2> <embed href="/text/scalc/01/05060000.xhp#mergecells_warning"/> <section id="howtoget"> @@ -49,7 +49,7 @@ <paragraph xml-lang="en-US" id="par_id961632012538771" role="listitem">The cells will be merged and the content will be centered in the merged cell.</paragraph> </section> <embed href="text/scalc/01/05060000.xhp#mergenotes"/> - <paragraph xml-lang="en-US" id="hd_id451368" role="heading" level="2">Unmerge Cells</paragraph> + <h2 id="hd_id451368">Unmerge Cells</h2> <section id="howtoget"> <paragraph xml-lang="en-US" id="par_id7116611" role="paragraph">Select the cell to be unmerged, or a selection that includes the cells to be unmerged then do one of the following:</paragraph> <paragraph role="listitem" id="par_id581632820903635" xml-lang="en-US">In the Formatting toolbar, click:</paragraph> diff --git a/source/text/scalc/guide/validity.xhp b/source/text/scalc/guide/validity.xhp index 6f6e6f1332..ff5b6733f1 100644 --- a/source/text/scalc/guide/validity.xhp +++ b/source/text/scalc/guide/validity.xhp @@ -50,7 +50,7 @@ <paragraph role="paragraph" id="par_id3156283" xml-lang="en-US">For each cell, you can define entries to be valid. Invalid entries to a cell will be rejected.</paragraph> <paragraph role="warning" id="par_id3145252" xml-lang="en-US">The validity rule is activated when a new value is entered. If an invalid value has already been inserted into the cell, or if you insert a value in the cell either with drag-and-drop or by copying and pasting, the validity rule will not take effect.</paragraph> <paragraph role="note" id="par_id5174718" xml-lang="en-US">You can choose <emph>Tools - Detective</emph> at any time and choose the command <link href="text/scalc/01/06030800.xhp"><emph>Mark Invalid Data</emph></link> to display which cells contain invalid values.</paragraph> -<paragraph role="heading" id="hd_id3155603" xml-lang="en-US" level="2">Using Cell Contents Validity</paragraph> +<h2 id="hd_id3155603">Using Cell Contents Validity</h2> <list type="ordered"> <listitem> <paragraph role="paragraph" id="par_id3155959" xml-lang="en-US">Select the cells for which you want to define a new validity rule.</paragraph> diff --git a/source/text/scalc/guide/value_with_name.xhp b/source/text/scalc/guide/value_with_name.xhp index e7840121b5..2b706ad593 100644 --- a/source/text/scalc/guide/value_with_name.xhp +++ b/source/text/scalc/guide/value_with_name.xhp @@ -43,7 +43,7 @@ </bookmark><comment>mw changed "names;...", "addressing;..." and "references,..." entries.</comment><comment>mw added "renaming;"</comment> <paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1"><variable id="value_with_name"><link href="text/scalc/guide/value_with_name.xhp">Naming Cells</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="hd_id4391918" role="heading" level="2">Allowed names</paragraph> + <h2 id="hd_id4391918">Allowed names</h2> <paragraph xml-lang="en-US" id="par_id2129581" role="paragraph">Names in Calc can contain letters, numeric characters, and the underline character. Names must start with a letter or an underline character.</paragraph> <paragraph xml-lang="en-US" id="par_id1120029" role="paragraph">Allowed special characters:</paragraph> <list type="unordered"> @@ -54,7 +54,7 @@ <paragraph xml-lang="en-US" id="par_id328989" role="paragraph">Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell.</paragraph> <paragraph xml-lang="en-US" id="par_id32898987" role="paragraph">Names must not start with the letters C or R followed by a number; also single characters C and R are not allowed as names. See the ADDRESS function for more information.</paragraph> <paragraph xml-lang="en-US" id="par_id4769737" role="paragraph">Names for cell ranges must not include blanks. Blanks are allowed within names for sheets and documents.</paragraph> - <paragraph xml-lang="en-US" id="hd_id1226233" role="heading" level="2">Naming cells and formulas</paragraph> + <h2 id="hd_id1226233">Naming cells and formulas</h2> <paragraph xml-lang="en-US" id="par_id5489364" role="paragraph">A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as "=SUM(Start)". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces.</paragraph> <paragraph xml-lang="en-US" id="par_id953398" role="paragraph">For example, it is much easier to read a formula for sales tax if you can write "= Amount * Tax_rate" instead of "= A5 * B12". In this case, you would name cell A5 "Amount" and cell B12 "Tax_rate."</paragraph> <paragraph xml-lang="en-US" id="par_id4889675" role="paragraph">Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names,</paragraph> diff --git a/source/text/scalc/guide/webquery.xhp b/source/text/scalc/guide/webquery.xhp index b9bd334f53..59c1c95d97 100644 --- a/source/text/scalc/guide/webquery.xhp +++ b/source/text/scalc/guide/webquery.xhp @@ -43,7 +43,7 @@ <paragraph role="paragraph" id="par_id3155131" xml-lang="en-US">With the help of the <emph>Web Page Query ($[officename] Calc)</emph> import filter, you can insert tables from HTML documents in a Calc spreadsheet.</paragraph> <paragraph role="paragraph" id="par_id3148575" xml-lang="en-US">You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet.</paragraph> <paragraph role="paragraph" id="par_id3149664" xml-lang="en-US">The following insert methods are available:</paragraph> -<paragraph role="heading" id="hd_id3146976" xml-lang="en-US" level="2">Inserting by Dialog</paragraph> +<h2 id="hd_id3146976">Inserting by Dialog</h2> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3154319" xml-lang="en-US">Set the cell cursor at the cell where the new content will be inserted.</paragraph> @@ -62,7 +62,7 @@ </listitem> </list> <paragraph role="paragraph" id="par_id3155443" xml-lang="en-US">The import filter can create names for cell ranges on the fly. As much formatting as possible is retained, while the filter intentionally does not load any images.</paragraph> -<paragraph role="heading" id="hd_id3149021" xml-lang="en-US" level="2">Inserting by Navigator</paragraph> +<h2 id="hd_id3149021">Inserting by Navigator</h2> <list type="ordered"> <listitem> <paragraph role="paragraph" id="par_id3153965" xml-lang="en-US">Open two documents: the $[officename] Calc spreadsheet in which the external data is to be inserted (target document) and the document from which the external data derives (source document).</paragraph> @@ -93,7 +93,7 @@ <item type="literal">HTML_tables</item> - designates all HTML tables in the document</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3149126" xml-lang="en-US" level="2">Editing the external data</paragraph> +<h2 id="hd_id3149126">Editing the external data</h2> <list type="unordered"> <listitem> <paragraph role="listitem" id="par_id3159228" xml-lang="en-US">Open <emph>Edit - Links</emph>. Here you can edit the link to the external data.</paragraph> |