diff options
| author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2023-03-13 16:04:19 +0100 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-03-16 15:18:10 +0000 |
| commit | 77cb682cd1b004e7247560e60f603a4bb0565b8d (patch) | |
| tree | 5ff7d8bf5fcc8f9fe162b8ed05ca7eeaf21022ba /source/text/scalc | |
| parent | 00567a452bb1e270dd2438dcc865359edba56c19 (diff) | |
convert plain paragraphs with role="heading" → h<level>
i.e. without child elements and also drop the language that was changed
to implied in the dtd previously/defaults to en-US unless specified.
This change doesn't affect translations, only the content of the
paragraph/headings is extracted.
done with:
perl -CSD -pi -e 'BEGIN {$base = qr/role="heading"|level="(?<level>\d+)"|(?<id>id="[^"]+")/;} s#<paragraph(((\s+($base)){3})|(\s+($base|xml-lang="en-US")){4})>(?<body>[^<]+)</paragraph>#<h$+{level} $+{id}>$+{body}</h$+{level}>#g'
(all permutations re order of attributes, and xml-lang="en-US" being
optional / implied)
Change-Id: I365a2bb983a3969af9390753fce7b7f3597c7b8b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148795
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
75 files changed, 372 insertions, 372 deletions
diff --git a/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp index 60b8675236..dba59f6f34 100644 --- a/source/text/scalc/00/00000402.xhp +++ b/source/text/scalc/00/00000402.xhp @@ -25,7 +25,7 @@ </topic> </meta> <body> -<paragraph id="hd_id3147303" role="heading" level="1" xml-lang="en-US">Edit Menu</paragraph> +<h1 id="hd_id3147303">Edit Menu</h1> <paragraph id="par_id3155555" role="paragraph" xml-lang="en-US"><variable id="kopffuss">Choose <emph>Insert - Headers and Footers</emph>.</variable></paragraph> <paragraph id="par_id3159233" role="paragraph" xml-lang="en-US"><variable id="bkopfzeile">Choose <emph>Insert - Headers and Footers - Header and Footer</emph> tabs.</variable></paragraph> <paragraph id="par_id3150443" role="paragraph" xml-lang="en-US"><variable id="bausfullen">Choose <emph>Sheet - Fill Cells</emph>.</variable></paragraph> diff --git a/source/text/scalc/00/00000403.xhp b/source/text/scalc/00/00000403.xhp index 328c318507..b58a32ebb2 100644 --- a/source/text/scalc/00/00000403.xhp +++ b/source/text/scalc/00/00000403.xhp @@ -25,7 +25,7 @@ </topic> </meta> <body> -<paragraph id="hd_id3145673" role="heading" level="1" xml-lang="en-US">View Menu</paragraph> +<h1 id="hd_id3145673">View Menu</h1> <paragraph id="par_id3150275" role="paragraph" xml-lang="en-US"><variable id="aspze">Choose <emph>View - Column & Row Headers</emph>.</variable></paragraph> <paragraph id="par_id3154514" role="paragraph" xml-lang="en-US"><variable id="awehe">Choose <emph>View - Value Highlighting</emph>.</variable></paragraph> <paragraph id="par_id3148947" role="paragraph" xml-lang="en-US"><variable id="rechenleiste">Choose <emph>View - Formula Bar</emph>.</variable></paragraph> diff --git a/source/text/scalc/01/02120100.xhp b/source/text/scalc/01/02120100.xhp index 003fd53772..76e5e92d51 100644 --- a/source/text/scalc/01/02120100.xhp +++ b/source/text/scalc/01/02120100.xhp @@ -45,19 +45,19 @@ <embed href="text/scalc/00/00000402.xhp#bkopfzeile"/> </section> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/textviewWND_LEFT" id="bm_id3153726" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3145748" role="heading" level="2">Left Area</paragraph> +<h2 id="hd_id3145748">Left Area</h2> <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/textviewWND_LEFT">Enter the text to be displayed at the left side of the header or footer.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/textviewWND_CENTER" id="bm_id3153951" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3148648" role="heading" level="2">Center Area</paragraph> +<h2 id="hd_id3148648">Center Area</h2> <paragraph xml-lang="en-US" id="par_id3163710" role="paragraph"><ahelp hid=".">Enter the text to be displayed at the center of the header or footer.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/textviewWND_RIGHT" id="bm_id3155418" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3154942" role="heading" level="2">Right Area</paragraph> +<h2 id="hd_id3154942">Right Area</h2> <paragraph xml-lang="en-US" id="par_id3147126" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/textviewWND_RIGHT">Enter the text to be displayed at the right side of the header or footer.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/comboLB_DEFINED" id="bm_id0609200910173918" localize="false"/> -<paragraph xml-lang="en-US" id="par_idN10811" role="heading" level="2">Header/Footer</paragraph> +<h2 id="par_idN10811">Header/Footer</h2> <paragraph xml-lang="en-US" id="par_idN10815" role="paragraph"><ahelp hid=".">Select a predefined header or footer from the list.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/buttonBTN_TEXT" id="bm_id3144766" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3154729" role="heading" level="2">Text attributes</paragraph> +<h2 id="hd_id3154729">Text attributes</h2> <paragraph xml-lang="en-US" id="par_id3150717" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/buttonBTN_TEXT">Opens a dialog to assign formats to new or selected text.</ahelp> The <emph>Text Attributes</emph> dialog contains the tab pages <link href="text/shared/01/05020100.xhp"><emph>Font</emph></link>, <link href="text/shared/01/05020200.xhp"><emph>Font Effects</emph></link> and <link href="text/shared/01/05020500.xhp"><emph>Font Position</emph></link>.</paragraph> <table id="tbl_id3149018"> <tablerow> @@ -72,7 +72,7 @@ </table> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/buttonBTN_FILE" id="bm_id3154020" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3145792" role="heading" level="2">File Name </paragraph> +<h2 id="hd_id3145792">File Name </h2> <paragraph xml-lang="en-US" id="par_id3150206" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/buttonBTN_FILE">Inserts a file name placeholder in the selected area.</ahelp> Click to insert the title. Long-click <comment>UFI: this is still a long-click</comment>to select either title, file name or path/file name from the submenu. If a title has not be assigned (see <emph>File - Properties</emph>), the file name will be inserted instead.</paragraph> <table id="tbl_id3149529"> <tablerow> @@ -87,7 +87,7 @@ </table> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/buttonBTN_TABLE" id="bm_id3149408" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3155812" role="heading" level="2">Sheet Name</paragraph> +<h2 id="hd_id3155812">Sheet Name</h2> <paragraph xml-lang="en-US" id="par_id3148842" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/buttonBTN_TABLE">Inserts a placeholder in the selected header/footer area, which is replaced by the sheet name in the header/footer of the actual document.</ahelp></paragraph> <table id="tbl_id3159174"> <tablerow> @@ -102,7 +102,7 @@ </table> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/buttonBTN_PAGE" id="bm_id3153288" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3144768" role="heading" level="2">Page</paragraph> +<h2 id="hd_id3144768">Page</h2> <paragraph xml-lang="en-US" id="par_id3154960" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/buttonBTN_PAGE">Inserts a placeholder in the selected header/footer area, which is replaced by page numbering. This allows continuous page numbering in a document.</ahelp></paragraph> <table id="tbl_id3153246"> <tablerow> @@ -117,7 +117,7 @@ </table> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/buttonBTN_PAGES" id="bm_id3153012" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3146962" role="heading" level="2">Pages</paragraph> +<h2 id="hd_id3146962">Pages</h2> <paragraph xml-lang="en-US" id="par_id3153812" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/buttonBTN_PAGES">Inserts a placeholder in the selected header/footer area, which is replaced by the total number of pages in the document.</ahelp></paragraph> <table id="tbl_id3154737"> <tablerow> @@ -132,7 +132,7 @@ </table> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/buttonBTN_DATE" id="bm_id3150438" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3149050" role="heading" level="2">Date</paragraph> +<h2 id="hd_id3149050">Date</h2> <paragraph xml-lang="en-US" id="par_id3153960" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/buttonBTN_DATE">Inserts a placeholder in the selected header/footer area, which is replaced by the current date which will be repeated in the header/footer on each page of the document.</ahelp></paragraph> <table id="tbl_id3147406"> <tablerow> @@ -147,7 +147,7 @@ </table> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/buttonBTN_TIME" id="bm_id3147412" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3147610" role="heading" level="2">Time</paragraph> +<h2 id="hd_id3147610">Time</h2> <paragraph xml-lang="en-US" id="par_id3145638" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/buttonBTN_TIME">Inserts a placeholder in the selected header/footer area, which is replaced by the current time in the header/footer on each page of the document.</ahelp></paragraph> <table id="tbl_id3157875"> <tablerow> diff --git a/source/text/scalc/01/02140600.xhp b/source/text/scalc/01/02140600.xhp index da3139a682..3ee6a542da 100644 --- a/source/text/scalc/01/02140600.xhp +++ b/source/text/scalc/01/02140600.xhp @@ -31,7 +31,7 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/FillSeriesDialog" id="bm_id3150791" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/@@nowidget@@" id="bm_id3150791" localize="false"/> -<paragraph id="hd_id3148664" role="heading" level="1" xml-lang="en-US">Fill Series</paragraph> +<h1 id="hd_id3148664">Fill Series</h1> <paragraph id="par_id3148797" role="paragraph" xml-lang="en-US"><variable id="reihenfuellentext"><ahelp hid=".uno:FillSeries">Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.</ahelp></variable></paragraph> <paragraph id="par_id3146976" role="note" xml-lang="en-US">Before filling a series, first select the cell range.</paragraph> @@ -40,76 +40,76 @@ </section> <paragraph id="par_id3145748" role="paragraph" xml-lang="en-US">To automatically continue a series using the assumed completion rules, choose the <emph>AutoFill</emph> option after opening the <emph>Fill Series</emph> dialog.</paragraph> -<paragraph id="hd_id3147435" role="heading" level="2" xml-lang="en-US">Direction</paragraph> +<h2 id="hd_id3147435">Direction</h2> <paragraph id="par_id3154729" role="paragraph" xml-lang="en-US">Determines the direction of series creation.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/down" id="bm_id3147124" localize="false"/> -<paragraph id="hd_id3145253" role="heading" level="3" xml-lang="en-US">Down</paragraph> +<h3 id="hd_id3145253">Down</h3> <paragraph id="par_id3155418" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/down">Creates a downward series in the selected cell range for the column using the defined increment to the end value.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/right" id="bm_id3153415" localize="false"/> -<paragraph id="hd_id3155738" role="heading" level="3" xml-lang="en-US">Right</paragraph> +<h3 id="hd_id3155738">Right</h3> <paragraph id="par_id3149402" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/right">Creates a series running from left to right within the selected cell range using the defined increment to the end value.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/up" id="bm_id3155067" localize="false"/> -<paragraph id="hd_id3146972" role="heading" level="3" xml-lang="en-US">Up</paragraph> +<h3 id="hd_id3146972">Up</h3> <paragraph id="par_id3153711" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/up">Creates an upward series in the cell range of the column using the defined increment to the end value.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/left" id="bm_id3147341" localize="false"/> -<paragraph id="hd_id3153764" role="heading" level="3" xml-lang="en-US">Left</paragraph> +<h3 id="hd_id3153764">Left</h3> <paragraph id="par_id3156382" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/left">Creates a series running from right to left in the selected cell range using the defined increment to the end value.</ahelp></paragraph> -<paragraph id="hd_id3147344" role="heading" level="2" xml-lang="en-US">Series Type</paragraph> +<h2 id="hd_id3147344">Series Type</h2> <paragraph id="par_id3149257" role="paragraph" xml-lang="en-US">Defines the series type. Choose between <emph>Linear</emph>, <emph>Growth</emph>, <emph>Date</emph> and <emph>AutoFill</emph>.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/linear" id="bm_id3150298" localize="false"/> -<paragraph id="hd_id3148488" role="heading" level="3" xml-lang="en-US">Linear</paragraph> +<h3 id="hd_id3148488">Linear</h3> <paragraph id="par_id3159238" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/linear">Creates a linear number series using the defined increment and end value.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/growth" id="bm_id3150784" localize="false"/> -<paragraph id="hd_id3149210" role="heading" level="3" xml-lang="en-US">Growth</paragraph> +<h3 id="hd_id3149210">Growth</h3> <paragraph id="par_id3150364" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/growth">Creates a growth series using the defined increment and end value.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/date" id="bm_id3155378" localize="false"/> -<paragraph id="hd_id3149528" role="heading" level="3" xml-lang="en-US">Date</paragraph> +<h3 id="hd_id3149528">Date</h3> <paragraph id="par_id3150887" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/date">Creates a date series using the defined increment and end date.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/autofill" id="bm_id3152985" localize="false"/> -<paragraph id="hd_id3150202" role="heading" level="3" xml-lang="en-US">AutoFill</paragraph> +<h3 id="hd_id3150202">AutoFill</h3> <paragraph id="par_id3156288" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/autofill">Forms a series directly in the sheet.</ahelp> The <emph>AutoFill</emph> function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph> </caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Sort Lists</emph>.</paragraph> <paragraph id="par_id3155811" role="paragraph" xml-lang="en-US">AutoFill tries to complete a value series by using a defined pattern. The series 1,3,5 is automatically completed with 7,9,11,13, and so on. Date and time series are completed accordingly; for example, after 01.01.99 and 15.01.99, an interval of 14 days is used.</paragraph> <paragraph id="par_id2956483" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/guide/calc_series.xhp#calc_series"/></paragraph> -<paragraph id="hd_id3148700" role="heading" level="2" xml-lang="en-US">Unit of Time</paragraph> +<h2 id="hd_id3148700">Unit of Time</h2> <paragraph id="par_id3153308" role="paragraph" xml-lang="en-US">In this area you can specify the desired unit of time. This area is only active if the <emph>Date</emph> option has been chosen in the <emph>Series type</emph> area.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/day" id="bm_id3153913" localize="false"/> -<paragraph id="hd_id3148868" role="heading" level="3" xml-lang="en-US">Day</paragraph> +<h3 id="hd_id3148868">Day</h3> <paragraph id="par_id3148605" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/day">Use the <emph>Date</emph> series type and this option to create a series using all seven days of the week. Unit of <emph>Increment</emph> is day.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/week" id="bm_id3145074" localize="false"/> -<paragraph id="hd_id3144771" role="heading" level="3" xml-lang="en-US">Weekday</paragraph> +<h3 id="hd_id3144771">Weekday</h3> <paragraph id="par_id3150108" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/week">Use the <emph>Date</emph> series type and this option to create a series only using the five weekdays. Unit of <emph>Increment</emph> is day.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/month" id="bm_id3159204" localize="false"/> -<paragraph id="hd_id3154957" role="heading" level="3" xml-lang="en-US">Month</paragraph> +<h3 id="hd_id3154957">Month</h3> <paragraph id="par_id3149126" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/month">Use the <emph>Date</emph> series type and this option to form a series which unit of <emph>Increment</emph> is month.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/year" id="bm_id3146777" localize="false"/> -<paragraph id="hd_id3152870" role="heading" level="3" xml-lang="en-US">Year</paragraph> +<h3 id="hd_id3152870">Year</h3> <paragraph id="par_id3151300" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/year">Use the <emph>Date</emph> series type and this option to create a series which unit of <emph>Increment</emph> is year.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/startValue" id="bm_id3145357" localize="false"/> -<paragraph id="hd_id3154762" role="heading" level="2" xml-lang="en-US">Start Value</paragraph> +<h2 id="hd_id3154762">Start Value</h2> <paragraph id="par_id3149381" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/startValue">Determines the start value for the series.</ahelp> Use numbers, dates or times.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/endValue" id="bm_id3153557" localize="false"/> -<paragraph id="hd_id3153013" role="heading" level="2" xml-lang="en-US">End Value</paragraph> +<h2 id="hd_id3153013">End Value</h2> <paragraph id="par_id3153487" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/filldlg/endValue">Determines the end value for the series.</ahelp> Use numbers, dates or times.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/filldlg/increment" id="bm_id3151196" localize="false"/> -<paragraph id="hd_id3149312" role="heading" level="2" xml-lang="en-US">Increment</paragraph> +<h2 id="hd_id3149312">Increment</h2> <paragraph id="par_id3154739" role="paragraph" xml-lang="en-US">The term "increment" denotes the amount by which a given value increases.<ahelp hid="modules/scalc/ui/filldlg/increment"> Determines the value by which the series of the selected type increases by each step.</ahelp> Entries can only be made if the linear, growth or date series types have been selected.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/02140700.xhp b/source/text/scalc/01/02140700.xhp index 7905f4e8d6..a948801fa9 100644 --- a/source/text/scalc/01/02140700.xhp +++ b/source/text/scalc/01/02140700.xhp @@ -27,7 +27,7 @@ <body> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog" id="bm_id3150791" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/@@nowidget@@" id="bm_id3150791" localize="false"/> -<paragraph id="hd_id2308201415431520596" role="heading" xml-lang="en-US" level="1">Fill Random Numbers</paragraph> +<h1 id="hd_id2308201415431520596">Fill Random Numbers</h1> <paragraph id="par_id2308201415431525817" role="paragraph" xml-lang="en-US"><ahelp hid=".">Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id2308201416102526759"> <bookmark_value>fill range;random numbers</bookmark_value> @@ -37,12 +37,12 @@ <section id="howtoget"> <paragraph id="par_id2308201415500176457" role="paragraph" xml-lang="en-US">Choose <item type="menuitem">Sheet - Fill Cells - Random Number</item></paragraph> </section> -<paragraph id="hd_id2308201415431233475" role="heading" xml-lang="en-US" level="2">Data</paragraph> -<paragraph id="hd_id2308201415431883475" role="heading" xml-lang="en-US" level="3">Cell Range</paragraph> +<h2 id="hd_id2308201415431233475">Data</h2> +<h3 id="hd_id2308201415431883475">Cell Range</h3> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/cell-range-edit" id="bm_id3150792" localize="false"/> <paragraph id="par_id2308201415431811111" role="paragraph" xml-lang="en-US"><ahelp hid=".">Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here.</ahelp></paragraph> -<paragraph id="hd_id2308201415431850229" role="heading" xml-lang="en-US" level="2">Random number generator</paragraph> -<paragraph id="hd_id2308201415431880497" role="heading" xml-lang="en-US" level="3">Distribution</paragraph> +<h2 id="hd_id2308201415431850229">Random number generator</h2> +<h3 id="hd_id2308201415431880497">Distribution</h3> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/distribution-combo" id="bm_id2308201416384294287" localize="false"/> <paragraph id="par_id2308201415431874867" role="paragraph" xml-lang="en-US"><ahelp hid=".">The distribution function for the random number generator.</ahelp></paragraph> <paragraph id="par_id2308201416441240058" role="paragraph" xml-lang="en-US">Valid distributions function and their parameters are</paragraph> @@ -177,17 +177,17 @@ </tablecell> </tablerow> </table> -<paragraph id="hd_id2308201415431232932" role="heading" xml-lang="en-US" level="2">Options</paragraph> -<paragraph id="hd_id2308201415431832932" role="heading" xml-lang="en-US" level="3">Enable custom seed</paragraph> +<h2 id="hd_id2308201415431232932">Options</h2> +<h3 id="hd_id2308201415431832932">Enable custom seed</h3> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/enable-seed-check" id="bm_id3150793" localize="false"/> <paragraph id="par_id2308201415431841782" role="paragraph" xml-lang="en-US"><ahelp hid=".">Set the initial value of the random number generator to a known value <emph>Seed.</emph></ahelp></paragraph> -<paragraph id="hd_id2308201415431881107" role="heading" xml-lang="en-US" level="3">Seed</paragraph> +<h3 id="hd_id2308201415431881107">Seed</h3> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/seed-spin" id="bm_id3150794" localize="false"/> <paragraph id="par_id2308201415431834837" role="paragraph" xml-lang="en-US"><ahelp hid=".">Value set to initiate the random number generator algorithm. It is used to initialize (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence, or leave the field blank if you don't need this particular feature.</ahelp></paragraph> -<paragraph id="hd_id2308201415431875641" role="heading" xml-lang="en-US" level="3">Enable rounding</paragraph> +<h3 id="hd_id2308201415431875641">Enable rounding</h3> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/enable-rounding-check" id="bm_id3150795" localize="false"/> <paragraph id="par_id2308201415431822157" role="paragraph" xml-lang="en-US"><ahelp hid=".">Round the number to a given number of <emph>Decimal Places</emph>.</ahelp></paragraph> -<paragraph id="hd_id2308201415431826506" role="heading" xml-lang="en-US" level="3">Decimal places</paragraph> +<h3 id="hd_id2308201415431826506">Decimal places</h3> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/randomnumbergenerator/decimal-places-spin" id="bm_id3150796" localize="false"/> <paragraph id="par_id2308201415431820502" role="paragraph" xml-lang="en-US"><ahelp hid=".">Number of decimal places of the numbers generated.</ahelp></paragraph> </body> diff --git a/source/text/scalc/01/02150000.xhp b/source/text/scalc/01/02150000.xhp index 5721ab0498..442e65d533 100644 --- a/source/text/scalc/01/02150000.xhp +++ b/source/text/scalc/01/02150000.xhp @@ -38,7 +38,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:Delete" id="bm_id5511579" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/DeleteContentsDialog" id="bm_id3145382" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/@@nowidget@@" id="bm_id3145382" localize="false"/> -<paragraph role="heading" id="hd_id3143284" xml-lang="en-US" level="1">Deleting Contents</paragraph> +<h1 id="hd_id3143284">Deleting Contents</h1> <paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><variable id="inhalteloeschentext"><ahelp hid=".uno:Delete">Specifies the contents to be deleted from the active cell or from a selected cell range.</ahelp> </variable> If several sheets are selected, all selected sheets will be affected.</paragraph> </section> @@ -48,23 +48,23 @@ <paragraph role="tip" id="par_id3159154" xml-lang="en-US">This dialog is also called by pressing Backspace after the cell cursor has been activated on the sheet.</paragraph> <paragraph role="tip" id="par_id3145367" xml-lang="en-US">Pressing Delete deletes content without calling the dialog or changing formats.</paragraph> <paragraph role="tip" id="par_id3153951" xml-lang="en-US">Use <emph>Cut</emph> on the Standard bar to delete contents and formats without the dialog.</paragraph> -<paragraph role="heading" id="hd_id3148575" xml-lang="en-US" level="2">Selection</paragraph> +<h2 id="hd_id3148575">Selection</h2> <paragraph role="paragraph" id="par_id3149665" xml-lang="en-US">This area lists the options for deleting contents.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/deleteall" id="bm_id3144766" localize="false"/><paragraph role="heading" id="hd_id3146975" xml-lang="en-US" level="3">Delete All</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/deleteall" id="bm_id3144766" localize="false"/><h3 id="hd_id3146975">Delete All</h3> <paragraph role="paragraph" id="par_id3154729" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/deleteall">Deletes all content from the selected cell range.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/text" id="bm_id3147394" localize="false"/><paragraph role="heading" id="hd_id3156286" xml-lang="en-US" level="3">Text<comment>i50439</comment></paragraph> <paragraph role="paragraph" id="par_id3154015" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/text">Deletes text only. Formats, formulas, numbers and dates are not affected.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/numbers" id="bm_id3156276" localize="false"/><paragraph role="heading" id="hd_id3153840" xml-lang="en-US" level="3">Numbers</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/numbers" id="bm_id3156276" localize="false"/><h3 id="hd_id3153840">Numbers</h3> <paragraph role="paragraph" id="par_id3148405" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/numbers">Deletes numbers only. Formats and formulas remain unchanged.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/datetime" id="bm_id3154757" localize="false"/><paragraph role="heading" id="hd_id3155764" xml-lang="en-US" level="3">Date & time</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/datetime" id="bm_id3154757" localize="false"/><h3 id="hd_id3155764">Date & time</h3> <paragraph role="paragraph" id="par_id3149567" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/datetime">Deletes date and time values. Formats, text, numbers and formulas remain unchanged.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/formulas" id="bm_id3149256" localize="false"/><paragraph role="heading" id="hd_id3154703" xml-lang="en-US" level="3">Formulas</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/formulas" id="bm_id3149256" localize="false"/><h3 id="hd_id3154703">Formulas</h3> <paragraph role="paragraph" id="par_id3148485" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/formulas">Deletes formulas. Text, numbers, formats, dates and times remain unchanged.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/comments" id="bm_id3152775" localize="false"/><paragraph role="heading" id="hd_id3150300" xml-lang="en-US" level="3">Comments</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/comments" id="bm_id3152775" localize="false"/><h3 id="hd_id3150300">Comments</h3> <paragraph role="paragraph" id="par_id3154658" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/comments">Deletes comments added to cells. All other elements remain unchanged.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/formats" id="bm_id3145258" localize="false"/><paragraph role="heading" id="hd_id3155112" xml-lang="en-US" level="3">Formats</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/formats" id="bm_id3145258" localize="false"/><h3 id="hd_id3155112">Formats</h3> <paragraph role="paragraph" id="par_id3146134" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/formats">Deletes format attributes applied to cells. All cell content remains unchanged.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/objects" id="bm_id3152582" localize="false"/><paragraph role="heading" id="hd_id3150088" xml-lang="en-US" level="3">Objects</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/objects" id="bm_id3152582" localize="false"/><h3 id="hd_id3150088">Objects</h3> <paragraph role="paragraph" id="par_id3152990" xml-lang="en-US"><ahelp hid="modules/scalc/ui/deletecontents/objects">Deletes objects. All cell content remains unchanged.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/02160000.xhp b/source/text/scalc/01/02160000.xhp index 828278ad07..f5e9ddbc84 100644 --- a/source/text/scalc/01/02160000.xhp +++ b/source/text/scalc/01/02160000.xhp @@ -43,7 +43,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:DeleteCell" id="bm_id3151115" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecells/DeleteCellsDialog" id="bm_id3151116" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecells/@@nowidget@@" id="bm_id3151116" localize="false"/> - <paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1">Delete Cells</paragraph> + <h1 id="hd_id3153726">Delete Cells</h1> <paragraph xml-lang="en-US" id="par_id3154490" role="paragraph"><variable id="zellenloeschentext"><ahelp hid=".uno:DeleteCell">Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space.</ahelp> </variable> Note that the selected delete option is stored and reloaded when the dialog is next called.</paragraph> </section> @@ -53,25 +53,25 @@ </section> <paragraph id="par_id082520160232335032" role="paragraph" xml-lang="en-US"><image id="img_id083120161149318932" src="media/screenshots/modules/scalc/ui/deletecells/DeleteCellsDialog.png" width="3.3126in" height="1.5209in"><alt xml-lang="en-US" id="alt_id083120161149318932">Delete cells dialog</alt></image></paragraph> - <paragraph xml-lang="en-US" id="hd_id3149121" role="heading" level="2">Selection</paragraph> + <h2 id="hd_id3149121">Selection</h2> <paragraph xml-lang="en-US" id="par_id3150751" role="paragraph">This area contains options for specifying how sheets are displayed after deleting cells.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecells/up" id="bm_id3154755" localize="false"/> - <paragraph xml-lang="en-US" id="hd_id3155767" role="heading" level="3">Shift cells up</paragraph> + <h3 id="hd_id3155767">Shift cells up</h3> <paragraph xml-lang="en-US" id="par_id3153714" role="paragraph"><ahelp hid="modules/scalc/ui/deletecells/up">Fills the space produced by the deleted cells with the cells underneath it.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecells/left" id="bm_id3147346" localize="false"/> - <paragraph xml-lang="en-US" id="hd_id3156382" role="heading" level="3">Shift cells left</paragraph> + <h3 id="hd_id3156382">Shift cells left</h3> <paragraph xml-lang="en-US" id="par_id3154702" role="paragraph"><ahelp hid="modules/scalc/ui/deletecells/left">Fills the resulting space by the cells to the right of the deleted cells.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecells/rows" id="bm_id3149566" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:DeleteRows" id="bm_id3149565" localize="false"/> - <paragraph xml-lang="en-US" id="hd_id3146918" role="heading" level="3">Delete entire row(s)</paragraph> + <h3 id="hd_id3146918">Delete entire row(s)</h3> <paragraph xml-lang="en-US" id="par_id3148487" role="paragraph"><ahelp hid=".uno:DeleteRows">After selecting at least one cell, deletes the entire row from the sheet.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecells/cols" id="bm_id3150342" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:DeleteColumns" id="bm_id3159240" localize="false"/> - <paragraph xml-lang="en-US" id="hd_id3155114" role="heading" level="3">Delete entire column(s)</paragraph> + <h3 id="hd_id3155114">Delete entire column(s)</h3> <paragraph xml-lang="en-US" id="par_id3150086" role="paragraph"><ahelp hid=".uno:DeleteColumns">After selecting at least one cell, deletes the entire column from the sheet.</ahelp></paragraph> <section id="relatedtopics"> diff --git a/source/text/scalc/01/02170000.xhp b/source/text/scalc/01/02170000.xhp index 531253d844..77c0fbacf2 100644 --- a/source/text/scalc/01/02170000.xhp +++ b/source/text/scalc/01/02170000.xhp @@ -35,16 +35,16 @@ <bookmark_value>deleting; spreadsheets</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/.uno:Remove" id="bm_id3150769" localize="false"/> -<paragraph role="heading" id="hd_id3156424" xml-lang="en-US" level="1"> Delete Sheet</paragraph> +<h1 id="hd_id3156424"> Delete Sheet</h1> <paragraph role="paragraph" id="par_id3153193" xml-lang="en-US"><variable id="tabelleloeschentext"><ahelp hid=".uno:Remove">Deletes the current sheet after query confirmation.</ahelp> </variable></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000402.xhp#delete_sheet"/> </section> <paragraph role="note" id="par_id3145801" xml-lang="en-US">You cannot delete a sheet while <emph>Edit - Track Changes - Record</emph> is activated.</paragraph> -<paragraph role="heading" id="hd_id3147124" xml-lang="en-US" level="2">Yes</paragraph> +<h2 id="hd_id3147124">Yes</h2> <paragraph role="paragraph" id="par_id3154943" xml-lang="en-US">Deletes the current sheet.</paragraph> -<paragraph role="heading" id="hd_id3149412" xml-lang="en-US" level="2">No</paragraph> +<h2 id="hd_id3149412">No</h2> <paragraph role="paragraph" id="par_id3154510" xml-lang="en-US">Cancels the dialog. No delete is performed.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/02180000.xhp b/source/text/scalc/01/02180000.xhp index d18b1e473a..57287363f6 100644 --- a/source/text/scalc/01/02180000.xhp +++ b/source/text/scalc/01/02180000.xhp @@ -38,7 +38,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:Move" id="bm_id9622978" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movecopysheet/MoveCopySheetDialog" id="bm_id3149657" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movecopysheet/@@nowidget@@" id="bm_id3149657" localize="false"/> -<paragraph role="heading" id="hd_id3153360" xml-lang="en-US" level="1">Move or Copy a Sheet</paragraph> +<h1 id="hd_id3153360">Move or Copy a Sheet</h1> <paragraph role="paragraph" id="par_id3154686" xml-lang="en-US"><variable id="tabelleverschiebenkopierentext"><ahelp hid=".uno:Move">Moves or copies a sheet to a new location in the document or to a different document.</ahelp> </variable></paragraph> <section id="howtoget"> @@ -46,13 +46,13 @@ </section> <paragraph role="warning" id="par_id2282479" xml-lang="en-US">When you copy and paste cells containing <link href="text/scalc/01/04060102.xhp">date values</link> between different spreadsheets, both spreadsheet documents must be set to the same date base. If date bases differ, the displayed date values will change!</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movecopysheet/toDocument" id="bm_id3146119" localize="false"/> -<paragraph role="heading" id="hd_id3163710" xml-lang="en-US" level="2">To Document</paragraph> +<h2 id="hd_id3163710">To Document</h2> <paragraph role="paragraph" id="par_id3148645" xml-lang="en-US"><ahelp hid="modules/scalc/ui/movecopysheet/toDocument">Indicates where the current sheet is to be moved or copied to.</ahelp> Select <emph>- new document -</emph> if you want to create a new location for the sheet to be moved or copied.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movecopysheet/insertBefore" id="bm_id3147350" localize="false"/> -<paragraph role="heading" id="hd_id3154012" xml-lang="en-US" level="2">Insert Before</paragraph> +<h2 id="hd_id3154012">Insert Before</h2> <paragraph role="paragraph" id="par_id3145366" xml-lang="en-US"><ahelp hid="modules/scalc/ui/movecopysheet/insertBefore">The current sheet is moved or copied in front of the selected sheet.</ahelp> The <emph>- move to end position -</emph> option places the current sheet at the end.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/movecopysheet/copy" id="bm_id3156283" localize="false"/> -<paragraph role="heading" id="hd_id3153726" xml-lang="en-US" level="2">Copy</paragraph> +<h2 id="hd_id3153726">Copy</h2> <paragraph role="paragraph" id="par_id3144764" xml-lang="en-US"><ahelp hid="modules/scalc/ui/movecopysheet/copy">Specifies that the sheet is to be copied. If the option is unmarked, the sheet is moved.</ahelp> Moving sheets is the default.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/02210000.xhp b/source/text/scalc/01/02210000.xhp index 43f4cc5224..a31d3ae288 100644 --- a/source/text/scalc/01/02210000.xhp +++ b/source/text/scalc/01/02210000.xhp @@ -33,10 +33,10 @@ <bookmark branch="hid/.uno:SelectTables" xml-lang="en-US" id="bm_id3154758" localize="false"/> -<paragraph role="heading" level="1" id="hd_id3156023" xml-lang="en-US">Selecting Sheets</paragraph> +<h1 id="hd_id3156023">Selecting Sheets</h1> <paragraph role="paragraph" id="par_id3147265" xml-lang="en-US"><variable id="tabellenauswaehlen"><ahelp hid=".uno:SelectTables" visibility="visible">Selects multiple sheets.</ahelp></variable></paragraph> <bookmark branch="hid/SC_HID_SELECTTABLES" xml-lang="en-US" id="bm_id3154126" localize="false"/> -<paragraph role="heading" level="2" id="hd_id3125863" xml-lang="en-US">Selected Sheets</paragraph> +<h2 id="hd_id3125863">Selected Sheets</h2> <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><ahelp hid="SC_HID_SELECTTABLES">Lists the sheets in the current document. To select a sheet, press the up or down arrow keys to move to a sheet in the list. To add a sheet to the selection, hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while pressing the arrow keys and then press Spacebar. To select a range of sheets, hold down Shift and press the arrow keys. </ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/03100000.xhp b/source/text/scalc/01/03100000.xhp index c7feaea92c..2feeddd477 100644 --- a/source/text/scalc/01/03100000.xhp +++ b/source/text/scalc/01/03100000.xhp @@ -43,10 +43,10 @@ <paragraph id="par_id3153877" role="paragraph" xml-lang="en-US">The context menu of the page break preview contains functions for editing page breaks, including the following options:</paragraph> <bookmark xml-lang="en-US" branch="hid/.uno:DeleteAllBreaks" id="bm_id8896104" localize="false"/> -<paragraph id="hd_id3154731" role="heading" level="2" xml-lang="en-US">Delete Page Breaks</paragraph> +<h2 id="hd_id3154731">Delete Page Breaks</h2> <paragraph id="par_id3149400" role="paragraph" xml-lang="en-US"><ahelp hid=".">Deletes all manual breaks in the current sheet.</ahelp></paragraph> -<paragraph id="hd_id3155067" role="heading" level="2" xml-lang="en-US">Add Print Range</paragraph> +<h2 id="hd_id3155067">Add Print Range</h2> <paragraph id="par_id3155764" role="paragraph" xml-lang="en-US">Adds the selected cells to print ranges.</paragraph> </body> diff --git a/source/text/scalc/01/04020000.xhp b/source/text/scalc/01/04020000.xhp index 45d80c09dc..f4fb05b919 100644 --- a/source/text/scalc/01/04020000.xhp +++ b/source/text/scalc/01/04020000.xhp @@ -36,31 +36,31 @@ <bookmark xml-lang="en-US" branch="hid/.uno:InsertCell" id="bm_id6503296" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/InsertCellsDialog" id="bm_id3147264" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/@@nowidget@@" id="bm_id3147264" localize="false"/> -<paragraph role="heading" id="hd_id3156023" xml-lang="en-US" level="1"> Insert Cells</paragraph> +<h1 id="hd_id3156023"> Insert Cells</h1> <paragraph role="paragraph" id="par_id3150542" xml-lang="en-US"><variable id="zelleneinfuegentext"><ahelp hid=".uno:InsertCell">Opens the<emph> Insert Cells </emph>dialog, in which you can insert new cells according to the options that you specify.</ahelp> </variable> You can delete cells by choosing <link href="text/scalc/01/02160000.xhp"><emph>Edit - Delete Cells</emph></link>.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000404.xhp#insert_cells"/> </section> -<paragraph role="heading" id="hd_id3153768" xml-lang="en-US" level="2">Selection</paragraph> +<h2 id="hd_id3153768">Selection</h2> <paragraph role="paragraph" id="par_id3149262" xml-lang="en-US">This area contains the options available for inserting cells into a sheet. The cell quantity and position is defined by selecting a cell range in the sheet beforehand.</paragraph> <bookmark xml-lang="en-US" branch="hid/.uno:InsertCellsDown" id="bm_id6210706" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/down" id="bm_id3152578" localize="false"/> -<paragraph role="heading" id="hd_id3146120" xml-lang="en-US" level="3">Shift cells down</paragraph> +<h3 id="hd_id3146120">Shift cells down</h3> <paragraph role="paragraph" id="par_id3152596" xml-lang="en-US"><variable id="zellenuntentext"><ahelp hid="modules/scalc/ui/insertcells/down">Moves the contents of the selected range downward when cells are inserted.</ahelp> </variable></paragraph> <embed href="text/scalc/00/00000404.xhp#syinsert_cells_down"/> <bookmark xml-lang="en-US" branch="hid/.uno:InsertCellsRight" id="bm_id7689959" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/right" id="bm_id3147348" localize="false"/> -<paragraph role="heading" id="hd_id3147434" xml-lang="en-US" level="3">Shift cells right</paragraph> +<h3 id="hd_id3147434">Shift cells right</h3> <paragraph role="paragraph" id="par_id3144764" xml-lang="en-US"><variable id="zellenrechtstext"><ahelp hid="modules/scalc/ui/insertcells/right">Moves the contents of the selected range to the right when cells are inserted.</ahelp> </variable></paragraph> <embed href="text/scalc/00/00000404.xhp#syinsert_cells_right"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/rows" id="bm_id3154731" localize="false"/><paragraph role="heading" id="hd_id3153877" xml-lang="en-US" level="3">Entire row</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/rows" id="bm_id3154731" localize="false"/><h3 id="hd_id3153877">Entire row</h3> <paragraph role="paragraph" id="par_id3155417" xml-lang="en-US"><variable id="zeilenganzetext"><ahelp hid="modules/scalc/ui/insertcells/rows">Inserts an entire row. The position of the row is determined by the selection on the sheet.</ahelp> </variable> The number of rows inserted depends on how many rows are selected. The contents of the original rows are moved downward.</paragraph> <embed href="text/scalc/00/00000404.xhp#syinsert_rows"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/cols" id="bm_id3150750" localize="false"/><paragraph role="heading" id="hd_id3146971" xml-lang="en-US" level="3">Entire column</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertcells/cols" id="bm_id3150750" localize="false"/><h3 id="hd_id3146971">Entire column</h3> <paragraph role="paragraph" id="par_id3155068" xml-lang="en-US"><variable id="spaltenganzetext"><ahelp hid="modules/scalc/ui/insertcells/cols">Inserts an entire column. The number of columns to be inserted is determined by the selected number of columns.</ahelp> </variable> The contents of the original columns are shifted to the right.</paragraph> <embed href="text/scalc/00/00000404.xhp#syinsert_columns"/> diff --git a/source/text/scalc/01/04030000.xhp b/source/text/scalc/01/04030000.xhp index 6772cb7be2..f388b2178c 100644 --- a/source/text/scalc/01/04030000.xhp +++ b/source/text/scalc/01/04030000.xhp @@ -39,7 +39,7 @@ <paragraph id="hd_id3150541" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/04030000.xhp">Insert Rows</link></paragraph> <paragraph id="par_id160220162210581072" role="paragraph" xml-lang="en-US"><variable id="sheet_insert_rows">Insert rows above or below the active cell.</variable> The number of rows inserted corresponds to the number of rows selected. If no row is selected, one row is inserted. The existing rows are moved downward.</paragraph> -<paragraph id="hd_id160220162131439740" role="heading" level="2" xml-lang="en-US">Rows Above</paragraph> +<h2 id="hd_id160220162131439740">Rows Above</h2> <paragraph id="par_id3150767" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertRowsBefore">Inserts a new row above the active cell.</ahelp></paragraph> <section id="howtoget"> @@ -47,7 +47,7 @@ </section> <bookmark xml-lang="en-US" branch="hid/.uno:InsertColumnsAfter" id="bm_id601010" localize="false"/> -<paragraph id="hd_id160220162133372726" role="heading" level="2" xml-lang="en-US">Rows Below</paragraph> +<h2 id="hd_id160220162133372726">Rows Below</h2> <paragraph id="par_id3150768" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertRowsAfter">Inserts a new row below the active cell.</ahelp></paragraph> <section id="howtoget"> diff --git a/source/text/scalc/01/04040000.xhp b/source/text/scalc/01/04040000.xhp index 0a6e280741..1c98f75a78 100644 --- a/source/text/scalc/01/04040000.xhp +++ b/source/text/scalc/01/04040000.xhp @@ -39,7 +39,7 @@ <paragraph id="hd_id3155628" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/04040000.xhp">Insert Columns</link></paragraph> <paragraph id="par_id160220162214111932" role="paragraph" xml-lang="en-US"><variable id="sheet_insert_columns">Inserts columns to the left or to the right of the active cell.</variable> The number of columns inserted corresponds to the number of columns selected. If no column is selected, one column is inserted. The existing columns are moved to the right.</paragraph> -<paragraph id="hd_id160220162139258865" role="heading" level="2" xml-lang="en-US">Columns Before</paragraph> +<h2 id="hd_id160220162139258865">Columns Before</h2> <paragraph id="par_id3150791" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertColumnsBefore">Inserts a new column before the active cell.</ahelp></paragraph> <section id="howtoget"> @@ -47,7 +47,7 @@ </section> <bookmark xml-lang="en-US" branch="hid/.uno:InsertColumnsAfter" id="bm_id601010" localize="false"/> -<paragraph id="hd_id160220162139252941" role="heading" level="2" xml-lang="en-US">Columns After</paragraph> +<h2 id="hd_id160220162139252941">Columns After</h2> <paragraph id="par_id160220162138041164" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:InsertColumnsAfter">Inserts a new column after the active cell.</ahelp></paragraph> <section id="howtoget"> diff --git a/source/text/scalc/01/04050000.xhp b/source/text/scalc/01/04050000.xhp index 7f4eab60f5..e1c7556f93 100644 --- a/source/text/scalc/01/04050000.xhp +++ b/source/text/scalc/01/04050000.xhp @@ -32,43 +32,43 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/InsertSheetDialog" id="bm_id3151384" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/@@nowidget@@" id="bm_id3151384" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:Insert" id="bm_id1669896" localize="false"/> -<paragraph role="heading" id="hd_id3155629" xml-lang="en-US" level="1">Insert Sheet</paragraph> +<h1 id="hd_id3155629">Insert Sheet</h1> <paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><variable id="tabelleeinfuegentext"><ahelp hid=".uno:Insert">Defines the options to be used to insert a new sheet.</ahelp> You can create a new sheet, or insert an existing sheet from a file. </variable></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000404.xhp#eitab"/> </section> -<paragraph role="heading" id="hd_id3154684" xml-lang="en-US" level="2">Position</paragraph> +<h2 id="hd_id3154684">Position</h2> <paragraph role="paragraph" id="par_id3156281" xml-lang="en-US">Specifies where the new sheet is to be inserted into your document.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/before" id="bm_id3155131" localize="false"/> -<paragraph role="heading" id="hd_id3154123" xml-lang="en-US" level="3">Before current sheet</paragraph> +<h3 id="hd_id3154123">Before current sheet</h3> <paragraph role="paragraph" id="par_id3145787" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/before">Inserts a new sheet directly before the current sheet.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/after" id="bm_id3147434" localize="false"/> -<paragraph role="heading" id="hd_id3155414" xml-lang="en-US" level="3">After current sheet</paragraph> +<h3 id="hd_id3155414">After current sheet</h3> <paragraph role="paragraph" id="par_id3145271" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/after">Inserts a new sheet directly after the current sheet.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="2">Sheet</paragraph> +<h2 id="hd_id3147428">Sheet</h2> <paragraph role="paragraph" id="par_id3154012" xml-lang="en-US">Specifies whether a new sheet or an existing sheet is inserted into the document.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/new" id="bm_id3145750" localize="false"/> -<paragraph role="heading" id="hd_id3147350" xml-lang="en-US" level="2">New sheet</paragraph> +<h2 id="hd_id3147350">New sheet</h2> <paragraph role="paragraph" id="par_id3149262" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/new">Creates a new sheet. Enter a sheet name in the <emph>Name</emph> field. Allowed characters are letters, numbers, spaces, and the underline character.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/countnf" id="bm_id3153157" localize="false"/> -<paragraph role="heading" id="hd_id3155418" xml-lang="en-US" level="3">No. of sheets</paragraph> +<h3 id="hd_id3155418">No. of sheets</h3> <paragraph role="paragraph" id="par_id3148457" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/countnf">Specifies the number of sheets to be created.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/nameed" id="bm_id3154510" localize="false"/> -<paragraph role="heading" id="hd_id3149379" xml-lang="en-US" level="3">Name</paragraph> +<h3 id="hd_id3149379">Name</h3> <paragraph role="paragraph" id="par_id3150718" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/nameed">Specifies the name of the new sheet.</ahelp></paragraph> <embed href="text/scalc/guide/rename_table.xhp#rename_table"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/fromfile" id="bm_id3150328" localize="false"/> -<paragraph role="heading" id="hd_id3155066" xml-lang="en-US" level="2">From File</paragraph> +<h2 id="hd_id3155066">From File</h2> <paragraph role="paragraph" id="par_id3153714" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/fromfile">Inserts a sheet from an existing file into the current document.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/browse" id="bm_id3150044" localize="false"/> -<paragraph role="heading" id="hd_id3149020" xml-lang="en-US" level="3">Browse</paragraph> +<h3 id="hd_id3149020">Browse</h3> <paragraph role="paragraph" id="par_id3159267" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/browse">Opens a dialog for selecting a file.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/tables" id="bm_id3146314" localize="false"/> -<paragraph role="heading" id="hd_id3149255" xml-lang="en-US" level="3">Available Sheets</paragraph> +<h3 id="hd_id3149255">Available Sheets</h3> <paragraph role="paragraph" id="par_id3155336" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/tables">If you selected a file by using the <emph>Browse</emph> button, the sheets contained in it are displayed in the list box. The file path is displayed below this box. Select the sheet to be inserted from the list box.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertsheet/link" id="bm_id3149814" localize="false"/> -<paragraph role="heading" id="hd_id3145791" xml-lang="en-US" level="3">Link</paragraph> +<h3 id="hd_id3145791">Link</h3> <paragraph role="paragraph" id="par_id3152580" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertsheet/link">Select to insert the sheet as a link instead as a copy. The links can be updated to show the current contents.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/04070100.xhp b/source/text/scalc/01/04070100.xhp index 3ac1b1e0f7..03db97a285 100644 --- a/source/text/scalc/01/04070100.xhp +++ b/source/text/scalc/01/04070100.xhp @@ -32,7 +32,7 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/@@nowidget@@" id="bm_id3155922" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/ManageNamesDialog" id="bm_id3155923" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/@@nowidget@@" id="bm_id3155923" localize="false"/> -<paragraph role="heading" id="hd_id3156330" xml-lang="en-US" level="1">Define Names</paragraph> +<h1 id="hd_id3156330">Define Names</h1> <paragraph role="paragraph" id="par_id3154366" xml-lang="en-US"><variable id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens a dialog where you can specify a name for a selected area or a name for a formula expression.</ahelp> </variable></paragraph> <paragraph role="paragraph" id="par_id3154123" xml-lang="en-US">Use the mouse to define ranges or type the reference into the <emph>Define Name </emph>dialog fields.</paragraph> @@ -42,42 +42,42 @@ <paragraph role="paragraph" id="par_id3155131" xml-lang="en-US">The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/edit" id="bm_id3151114" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/name" id="bm_id3151115" localize="false"/> -<paragraph role="heading" id="hd_id3151118" xml-lang="en-US" level="2">Name</paragraph> +<h2 id="hd_id3151118">Name</h2> <paragraph role="paragraph" id="par_id3163712" xml-lang="en-US"><ahelp hid=".">Enter the name of the area for which you want to define a reference or a formula expression.</ahelp> All area names already defined in the spreadsheet are listed in the text field above. If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/range" id="bm_id3145750" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/range" id="bm_id3145751" localize="false"/> -<paragraph role="heading" id="hd_id3153728" xml-lang="en-US" level="2">Range or formula expression</paragraph> +<h2 id="hd_id3153728">Range or formula expression</h2> <paragraph role="paragraph" id="par_id3147435" xml-lang="en-US"><ahelp hid=".">The reference of the selected area name is shown here as an absolute value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3146986" xml-lang="en-US">To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document. To insert a new named formula, type the formula expression.</paragraph> <embed href="text/shared/00/00000001.xhp#shrink_maximize"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/scope" id="bm_id3148455" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/scope" id="bm_id3148456" localize="false"/> -<paragraph role="heading" id="hd_id31547290" xml-lang="en-US" level="2">Scope</paragraph> +<h2 id="hd_id31547290">Scope</h2> <paragraph role="paragraph" id="hd_id31547291" xml-lang="en-US" level="2"><ahelp hid=".">Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document.</ahelp> Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet. </paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/more" id="bm_id3148457" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/more" id="bm_id3148458" localize="false"/> -<paragraph role="heading" id="hd_id3154729" xml-lang="en-US" level="2">Range options</paragraph> +<h2 id="hd_id3154729">Range options</h2> <paragraph role="paragraph" id="par_id3149958" xml-lang="en-US"><ahelp hid=".">Allows you to specify the <emph>Area type</emph> (optional) for the reference.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3155416" xml-lang="en-US">Defines additional options related to the type of reference area.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/printarea" id="bm_id3146972" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/printrange" id="bm_id3146973" localize="false"/> -<paragraph role="heading" id="hd_id3150716" xml-lang="en-US" level="4">Print range</paragraph> +<h4 id="hd_id3150716">Print range</h4> <paragraph role="paragraph" id="par_id3150751" xml-lang="en-US"><ahelp hid=".">Defines the area as a print range.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/filter" id="bm_id3155446" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/filter" id="bm_id3155447" localize="false"/> -<paragraph role="heading" id="hd_id3153764" xml-lang="en-US" level="4">Filter</paragraph> +<h4 id="hd_id3153764">Filter</h4> <paragraph role="paragraph" id="par_id3155766" xml-lang="en-US"><ahelp hid=".">Defines the selected area to be used in an <link href="text/scalc/01/12040300.xhp">advanced filter</link>.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/colheader" id="bm_id3147344" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/colheader" id="bm_id3147345" localize="false"/> -<paragraph role="heading" id="hd_id3159267" xml-lang="en-US" level="4">Repeat column</paragraph> +<h4 id="hd_id3159267">Repeat column</h4> <paragraph role="paragraph" id="par_id3149565" xml-lang="en-US"><ahelp hid=".">Defines the area as a repeating column.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/rowheader" id="bm_id3154021" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/rowheader" id="bm_id3154022" localize="false"/> -<paragraph role="heading" id="hd_id3153966" xml-lang="en-US" level="4">Repeat row</paragraph> +<h4 id="hd_id3153966">Repeat row</h4> <paragraph role="paragraph" id="par_id3150300" xml-lang="en-US"><ahelp hid=".">Defines the area as a repeating row.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/definename/add" id="bm_id3150207" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/add" id="bm_id3150208" localize="false"/> -<paragraph role="heading" id="hd_id3155112" xml-lang="en-US" level="2">Add</paragraph> +<h2 id="hd_id3155112">Add</h2> <paragraph role="paragraph" id="par_id3159236" xml-lang="en-US"><ahelp hid=".">Click the <emph>Add</emph> button to add a new defined name.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/managenamesdialog/delete" id="bm_id3150209" localize="false"/> <embed href="text/shared/00/00000001.xhp#delete"/> diff --git a/source/text/scalc/01/04070200.xhp b/source/text/scalc/01/04070200.xhp index 24dafe521d..383068705d 100644 --- a/source/text/scalc/01/04070200.xhp +++ b/source/text/scalc/01/04070200.xhp @@ -36,7 +36,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:InsertName" id="bm_id3154910" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertname/InsertNameDialog" id="bm_id3154910" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertname/@@nowidget@@" id="bm_id3154910" localize="false"/> -<paragraph role="heading" id="hd_id3153195" xml-lang="en-US" level="1">Paste Names</paragraph> +<h1 id="hd_id3153195">Paste Names</h1> <paragraph role="paragraph" id="par_id3150011" xml-lang="en-US"><variable id="nameneinfuegentext"><ahelp hid=".uno:InsertName">Inserts a defined named cell range at the current cursor's position.</ahelp> </variable></paragraph> <paragraph role="note" id="par_id3149412" xml-lang="en-US">You can only insert a cell area after having defined a name for the area.</paragraph> @@ -45,15 +45,15 @@ </section> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertname/ctrl" id="bm_id3155415" localize="false"/> -<paragraph role="heading" id="hd_id3153160" xml-lang="en-US" level="2">Table area</paragraph> +<h2 id="hd_id3153160">Table area</h2> <paragraph role="paragraph" id="par_id3154944" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertname/ctrl">Lists all defined cell areas. Double-click an entry to insert the named area into the active sheet at the current cursor position.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertname/pasteall" id="bm_id3153707" localize="false"/> -<paragraph role="heading" id="hd_id3153418" xml-lang="en-US" level="2">Paste All</paragraph> +<h2 id="hd_id3153418">Paste All</h2> <paragraph role="paragraph" id="par_id3155066" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertname/pasteall">Inserts a list of all named areas and the corresponding cell references at the current cursor position.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/insertname/paste" id="bm_id3153708" localize="false"/> -<paragraph role="heading" id="hd_id3153419" xml-lang="en-US" level="2">Paste</paragraph> +<h2 id="hd_id3153419">Paste</h2> <paragraph role="paragraph" id="par_id3155067" xml-lang="en-US"><ahelp hid="modules/scalc/ui/insertname/paste">Inserts the selected named area and the corresponding cell reference at the current cursor position.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/04070300.xhp b/source/text/scalc/01/04070300.xhp index f985494347..76fa81909f 100644 --- a/source/text/scalc/01/04070300.xhp +++ b/source/text/scalc/01/04070300.xhp @@ -36,26 +36,26 @@ <bookmark xml-lang="en-US" branch="hid/.uno:CreateNames" id="bm_id8912439" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/CreateNamesDialog" id="bm_id3150398" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/@@nowidget@@" id="bm_id3150398" localize="false"/> -<paragraph role="heading" id="hd_id3147264" xml-lang="en-US" level="1">Creating Names</paragraph> +<h1 id="hd_id3147264">Creating Names</h1> <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><variable id="namenuebernehmentext"><ahelp hid=".uno:CreateNames">Allows you to automatically name multiple cell ranges.</ahelp> </variable></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000404.xhp#einaueb"/> </section> <paragraph role="paragraph" id="par_id3156280" xml-lang="en-US">Select the area containing all the ranges that you want to name. Then choose <emph>Sheet - Named Ranges and Expressions - Create</emph>. This opens the <emph>Create Names</emph> dialog, from which you can select the naming options that you want.</paragraph> -<paragraph role="heading" id="hd_id3151116" xml-lang="en-US" level="2">Create names from</paragraph> +<h2 id="hd_id3151116">Create names from</h2> <paragraph role="paragraph" id="par_id3152597" xml-lang="en-US">Defines which part of the spreadsheet is to be used for creating the name.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/top" id="bm_id3156444" localize="false"/> -<paragraph role="heading" id="hd_id3153729" xml-lang="en-US" level="3">Top row</paragraph> +<h3 id="hd_id3153729">Top row</h3> <paragraph role="paragraph" id="par_id3149263" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/top">Creates the range names from the header row of the selected range.</ahelp> Each column receives a separated name and cell reference.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/left" id="bm_id3145749" localize="false"/> -<paragraph role="heading" id="hd_id3146984" xml-lang="en-US" level="3">Left Column</paragraph> +<h3 id="hd_id3146984">Left Column</h3> <paragraph role="paragraph" id="par_id3153190" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/left">Creates the range names from the entries in the first column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/bottom" id="bm_id3145645" localize="false"/> -<paragraph role="heading" id="hd_id3156284" xml-lang="en-US" level="3">Bottom row</paragraph> +<h3 id="hd_id3156284">Bottom row</h3> <paragraph role="paragraph" id="par_id3147124" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/bottom">Creates the range names from the entries in the last row of the selected sheet range.</ahelp> Each column receives a separated name and cell reference.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/createnamesdialog/right" id="bm_id3145253" localize="false"/> -<paragraph role="heading" id="hd_id3154731" xml-lang="en-US" level="3">Right Column</paragraph> +<h3 id="hd_id3154731">Right Column</h3> <paragraph role="paragraph" id="par_id3153158" xml-lang="en-US"><ahelp hid="modules/scalc/ui/createnamesdialog/right">Creates the range names from the entries in the last column of the selected sheet range.</ahelp> Each row receives a separated name and cell reference.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/04070400.xhp b/source/text/scalc/01/04070400.xhp index 3cc0ad7381..6ed548c49d 100644 --- a/source/text/scalc/01/04070400.xhp +++ b/source/text/scalc/01/04070400.xhp @@ -45,21 +45,21 @@ <paragraph role="note" id="par_id3147435" xml-lang="en-US">You can set label ranges that contain the same labels on different sheets. $[officename] first searches the label ranges of the current sheet and, following a failed search, the ranges of other sheets.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/range" id="bm_id3149958" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/edassign" id="bm_id3148457" localize="false"/> -<paragraph role="heading" id="hd_id3145801" xml-lang="en-US" level="2">Range</paragraph> +<h2 id="hd_id3145801">Range</h2> <paragraph role="paragraph" id="par_id3154731" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign">Displays the cell reference of each label range.</ahelp> In order to remove a label range from the list box, select it and then click <emph>Delete</emph>.</paragraph> <embed href="text/shared/00/00000001.xhp#shrink_maximize"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/colhead" id="bm_id3155064" localize="false"/> -<paragraph role="heading" id="hd_id3149121" xml-lang="en-US" level="3">Contains column labels</paragraph> +<h3 id="hd_id3149121">Contains column labels</h3> <paragraph role="paragraph" id="par_id3150330" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/colhead">Includes column labels in the current label range.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/rowhead" id="bm_id3145642" localize="false"/> -<paragraph role="heading" id="hd_id3149020" xml-lang="en-US" level="3">Contains row labels</paragraph> +<h3 id="hd_id3149020">Contains row labels</h3> <paragraph role="paragraph" id="par_id3154754" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/rowhead">Includes row labels in the current label range.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/edassign2" id="bm_id3146919" localize="false"/> -<paragraph role="heading" id="hd_id3159264" xml-lang="en-US" level="3">For data range</paragraph> +<h3 id="hd_id3159264">For data range</h3> <paragraph role="paragraph" id="par_id3154703" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/edassign2">Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#shrink_maximize"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/namerangesdialog/add" id="bm_id3150299" localize="false"/> -<paragraph role="heading" id="hd_id3145789" xml-lang="en-US" level="2">Add</paragraph> +<h2 id="hd_id3145789">Add</h2> <paragraph role="paragraph" id="par_id3147005" xml-lang="en-US"><ahelp hid="modules/scalc/ui/namerangesdialog/add">Adds the current label range to the list.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#delete"/> <section id="relatedtopics"> diff --git a/source/text/scalc/01/04090000.xhp b/source/text/scalc/01/04090000.xhp index c140250599..37b2489655 100644 --- a/source/text/scalc/01/04090000.xhp +++ b/source/text/scalc/01/04090000.xhp @@ -41,15 +41,15 @@ <embed href="text/scalc/00/00000404.xhp#eiextdata"/> </section> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/url" id="bm_id3148577" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3146984" role="heading" level="2">URL of external data source.</paragraph> +<h2 id="hd_id3146984">URL of external data source.</h2> <paragraph xml-lang="en-US" id="par_id3145366" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/url">Enter the URL or the file name that contains the data that you want to insert, and then press Enter.</ahelp> Alternatively, click <emph>Browse</emph> button to select the file name from a file dialog that opens. Only then will the URL be requested from the network or file system.</paragraph> <paragraph xml-lang="en-US" id="par_id621519313666202" role="note"><link href="text/shared/00/00000208.xhp">A dialog for CSV data import</link> appears when linking to external CSV file.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/ranges" id="bm_id3153876" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3145251" role="heading" level="2">Available tables/ranges</paragraph> +<h2 id="hd_id3145251">Available tables/ranges</h2> <paragraph xml-lang="en-US" id="par_id3147397" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/ranges">Select the table or the data range that you want to insert.</ahelp> If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and <emph>OK</emph> button will remain inactive </paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/reload" id="bm_id3153418" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/delay" id="bm_id3150718" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3154492" role="heading" level="2">Update every</paragraph> +<h2 id="hd_id3154492">Update every</h2> <paragraph xml-lang="en-US" id="par_id3154017" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/delay">Enter the number of seconds to wait before the external data are reloaded into the current document.</ahelp></paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/webquery.xhp#webquery"/> diff --git a/source/text/scalc/01/05020600.xhp b/source/text/scalc/01/05020600.xhp index b3a5e54a03..2e177e0b2c 100644 --- a/source/text/scalc/01/05020600.xhp +++ b/source/text/scalc/01/05020600.xhp @@ -39,21 +39,21 @@ <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#fozelstz"/> </section> -<paragraph role="heading" id="hd_id3150447" xml-lang="en-US" level="2">Protection</paragraph> +<h2 id="hd_id3150447">Protection</h2> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/cellprotectionpage/checkHideAll" id="bm_id3153192" localize="false"/> -<paragraph role="heading" id="hd_id3125864" xml-lang="en-US" level="3">Hide all</paragraph> +<h3 id="hd_id3125864">Hide all</h3> <paragraph role="paragraph" id="par_id3153768" xml-lang="en-US"><ahelp hid="modules/scalc/ui/cellprotectionpage/checkHideAll">Hides formulas and contents of the selected cells.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/cellprotectionpage/checkProtected" id="bm_id3149260" localize="false"/> -<paragraph role="heading" id="hd_id3153190" xml-lang="en-US" level="3">Protected</paragraph> +<h3 id="hd_id3153190">Protected</h3> <paragraph role="paragraph" id="par_id3151119" xml-lang="en-US"><ahelp hid="modules/scalc/ui/cellprotectionpage/checkProtected">Prevents the selected cells from being modified.</ahelp></paragraph> <paragraph role="note" id="par_id3156283" xml-lang="en-US">This cell protection only takes effect if you also protect the sheet (<emph>Tools - Protect Sheet</emph>).</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/cellprotectionpage/checkHideFormula" id="bm_id3149958" localize="false"/> -<paragraph role="heading" id="hd_id3149377" xml-lang="en-US" level="3">Hide formula</paragraph> +<h3 id="hd_id3149377">Hide formula</h3> <paragraph role="paragraph" id="par_id3154510" xml-lang="en-US"><ahelp hid="modules/scalc/ui/cellprotectionpage/checkHideFormula">Hides formulas in the selected cells.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3155602" xml-lang="en-US" level="2">Print</paragraph> +<h2 id="hd_id3155602">Print</h2> <paragraph role="paragraph" id="par_id3153836" xml-lang="en-US">Defines print options for the sheet.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/cellprotectionpage/checkHidePrinting" id="bm_id3153715" localize="false"/> -<paragraph role="heading" id="hd_id3155065" xml-lang="en-US" level="3">Hide when printing</paragraph> +<h3 id="hd_id3155065">Hide when printing</h3> <paragraph role="paragraph" id="par_id3155443" xml-lang="en-US"><ahelp hid="modules/scalc/ui/cellprotectionpage/checkHidePrinting">Keeps the selected cells from being printed.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/05030200.xhp b/source/text/scalc/01/05030200.xhp index 1ae1c01566..38875c41b9 100644 --- a/source/text/scalc/01/05030200.xhp +++ b/source/text/scalc/01/05030200.xhp @@ -37,17 +37,17 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optimalrowheightdialog/OptimalRowHeightDialog" id="bm_id1299843" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optimalrowheightdialog/@@nowidget@@" id="bm_id1299843" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:SetOptimalRowHeight" id="bm_id3145673" localize="false"/> -<paragraph role="heading" id="hd_id3148491" xml-lang="en-US" level="1">Optimal Row Heights</paragraph> +<h1 id="hd_id3148491">Optimal Row Heights</h1> <paragraph role="paragraph" id="par_id3154758" xml-lang="en-US"><variable id="optitext"><ahelp hid=".uno:SetOptimalRowHeight">Determines the optimal row height for the selected rows.</ahelp> </variable> The optimal row height depends on the font size of the largest character in the row. You can use various <link href="text/shared/00/00000003.xhp#measurement_units">units of measure</link>.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#fozeiophoe"/> </section> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optimalrowheightdialog/value" id="bm_id3156280" localize="false"/> -<paragraph role="heading" id="hd_id3154908" xml-lang="en-US" level="2">Add</paragraph> +<h2 id="hd_id3154908">Add</h2> <paragraph role="paragraph" id="par_id3151044" xml-lang="en-US"><ahelp hid="modules/scalc/ui/optimalrowheightdialog/value">Sets additional spacing between the largest character in a row and the cell boundaries.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optimalrowheightdialog/default" id="bm_id3145271" localize="false"/> -<paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="2">Default value</paragraph> +<h2 id="hd_id3150439">Default value</h2> <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><ahelp hid="modules/scalc/ui/optimalrowheightdialog/default">Restores the default value for the optimal row height.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/05040200.xhp b/source/text/scalc/01/05040200.xhp index f0afbc8876..d77f94cb8e 100644 --- a/source/text/scalc/01/05040200.xhp +++ b/source/text/scalc/01/05040200.xhp @@ -38,17 +38,17 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optimalcolwidthdialog/@@nowidget@@" id="bm_id2742569" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:SetOptimalColumnWidth" id="bm_id3156326" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:SetOptimalColumnWidthDirect" id="bm_id3153254" localize="false"/> -<paragraph role="heading" id="hd_id3155628" xml-lang="en-US" level="1">Optimal Column Width</paragraph> +<h1 id="hd_id3155628">Optimal Column Width</h1> <paragraph role="paragraph" id="par_id3145068" xml-lang="en-US"><variable id="optitext"><ahelp hid=".uno:SetOptimalColumnWidthDi">Defines the optimal column width for selected columns.</ahelp> </variable> The optimal column width depends on the longest entry within a column. You can choose from the available <link href="text/shared/00/00000003.xhp#metrik">measurement units</link>.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#optimal_column_width"/> </section> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optimalcolwidthdialog/value" id="bm_id3153192" localize="false"/> -<paragraph role="heading" id="hd_id3150767" xml-lang="en-US" level="2">Add</paragraph> +<h2 id="hd_id3150767">Add</h2> <paragraph role="paragraph" id="par_id3150449" xml-lang="en-US"><ahelp hid="modules/scalc/ui/optimalcolwidthdialog/value">Defines additional spacing between the longest entry in a column and the vertical column borders.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/optimalcolwidthdialog/default" id="bm_id3155855" localize="false"/> -<paragraph role="heading" id="hd_id3145785" xml-lang="en-US" level="2">Default value</paragraph> +<h2 id="hd_id3145785">Default value</h2> <paragraph role="paragraph" id="par_id3146120" xml-lang="en-US"><ahelp hid="modules/scalc/ui/optimalcolwidthdialog/default">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 2 mm.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/05050000.xhp b/source/text/scalc/01/05050000.xhp index a0ebc88180..e1db786e16 100644 --- a/source/text/scalc/01/05050000.xhp +++ b/source/text/scalc/01/05050000.xhp @@ -49,7 +49,7 @@ <embed href="text/scalc/01/05050300.xhp#tabeintext"/> <paragraph role="paragraph" id="par_id3150542" xml-lang="en-US">If a sheet has been hidden, the Show Sheet dialog opens, which allows you to select a sheet to be shown again.</paragraph> <bookmark xml-lang="en-US" branch="hid/.uno:SheetRightToLeft" id="bm_id9923771" localize="false"/> -<paragraph role="heading" id="par_idN10656" xml-lang="en-US" level="2">Right-To-Left</paragraph> +<h2 id="par_idN10656">Right-To-Left</h2> <paragraph role="paragraph" id="par_idN1065A" xml-lang="en-US"><ahelp hid=".uno:SheetRightToLeft">Changes the orientation of the current sheet to Right-To-Left if <link href="text/shared/optionen/01150300.xhp">CTL</link> support is enabled.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/05050100.xhp b/source/text/scalc/01/05050100.xhp index 525d60862e..66f0f14503 100644 --- a/source/text/scalc/01/05050100.xhp +++ b/source/text/scalc/01/05050100.xhp @@ -35,7 +35,7 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/inputstringdialog/@@nowidget@@" id="bm_id3149166" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:Name" id="bm_id3153252" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:RenameTable" id="bm_id9504501" localize="false"/> -<paragraph role="heading" id="hd_id3147336" xml-lang="en-US" level="1">Rename Sheet</paragraph> +<h1 id="hd_id3147336">Rename Sheet</h1> <paragraph role="paragraph" id="par_id3150792" xml-lang="en-US"><variable id="umbenennentext"><ahelp hid=".uno:RenameTable">This command opens a dialog where you can assign a different name to the current sheet.</ahelp> </variable></paragraph> <section id="howtoget"> @@ -44,7 +44,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_RENAME_NAME" id="bm_id3156280" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/inputstringdialog/name_entry" id="bm_id3154908" localize="false"/> <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_APPEND_NAME" id="bm_id3151041" localize="false"/> -<paragraph role="heading" id="hd_id3153968" xml-lang="en-US" level="2">Name</paragraph> +<h2 id="hd_id3153968">Name</h2> <paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp hid="HID_SC_APPEND_NAME">Enter a new name for the sheet here.</ahelp></paragraph> <paragraph role="tip" id="par_id3153092" xml-lang="en-US">You can also open the<emph> Rename Sheet </emph>dialog through the context menu by positioning the mouse pointer over a sheet tab at the bottom of the window and <switchinline select="sys"><caseinline select="MAC">clicking while pressing Control</caseinline><defaultinline>clicking the right mouse button</defaultinline></switchinline>.</paragraph> <paragraph role="tip" id="par_id3147396" xml-lang="en-US">Alternatively, click the sheet tab while pressing the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Alt</defaultinline></switchinline> key. Now you can change the name directly. <switchinline select="sys"><caseinline select="UNIX"><embedvar href="text/shared/00/00000099.xhp#winmanager"/> diff --git a/source/text/scalc/01/05050300.xhp b/source/text/scalc/01/05050300.xhp index f0628b62b6..5f7ba889f7 100644 --- a/source/text/scalc/01/05050300.xhp +++ b/source/text/scalc/01/05050300.xhp @@ -34,14 +34,14 @@ <bookmark branch="index" xml-lang="en-US" id="bm_id3148946"><bookmark_value>sheets; displaying</bookmark_value><bookmark_value>displaying; sheets</bookmark_value></bookmark> <bookmark branch="hid/.uno:Show" xml-lang="en-US" id="bm_id3150542" localize="false"/> -<paragraph role="heading" level="1" id="hd_id3148946" xml-lang="en-US">Show Sheet</paragraph> +<h1 id="hd_id3148946">Show Sheet</h1> <paragraph xml-lang="en-US" role="paragraph" id="par_id3148799"><variable id="tabeintext"><ahelp visibility="visible" hid=".uno:Show">Displays sheets that were previously hidden with the <emph>Hide Sheets</emph> command.</ahelp></variable> Select one sheet only to call the command. The current sheet is always selected. If a sheet other than the current sheet is selected, you can deselect it by pressing <switchinline select="sys"> <caseinline select="MAC">Command</caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> while clicking the corresponding sheet tab at the bottom of the window.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#fotenb"/> </section> <bookmark branch="hid/modules/scalc/ui/showsheetdialog/ShowSheetDialog" xml-lang="en-US" id="bm_id3149260" localize="false"/> <bookmark branch="hid/modules/scalc/ui/showsheetdialog/@@nowidget@@" xml-lang="en-US" id="bm_id3149260" localize="false"/> - <paragraph role="heading" level="2" id="hd_id3151112" xml-lang="en-US">Hidden sheets</paragraph> + <h2 id="hd_id3151112">Hidden sheets</h2> <paragraph role="paragraph" id="par_id3145273" xml-lang="en-US"><ahelp hid="modules/scalc/ui/showsheetdialog/ShowSheetDialog" visibility="visible">Displays a list of all hidden sheets in your spreadsheet document.</ahelp> To show a certain sheet, click the corresponding entry on the list and confirm with OK.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/05070500.xhp b/source/text/scalc/01/05070500.xhp index 88abec7207..4693456f96 100644 --- a/source/text/scalc/01/05070500.xhp +++ b/source/text/scalc/01/05070500.xhp @@ -40,42 +40,42 @@ <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#fostel"/> </section> -<paragraph role="heading" id="hd_id3150542" xml-lang="en-US" level="2">Print</paragraph> +<h2 id="hd_id3150542">Print</h2> <paragraph role="paragraph" id="par_id3125863" xml-lang="en-US">Defines which elements of the spreadsheet are to be printed.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_HEADER" id="bm_id3150767" localize="false"/><paragraph role="heading" id="hd_id3151041" xml-lang="en-US" level="3">Column and row headers</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_HEADER" id="bm_id3150767" localize="false"/><h3 id="hd_id3151041">Column and row headers</h3> <paragraph role="paragraph" id="par_id3147228" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_HEADER">Specifies whether you want the column and row headers to be printed.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_GRID" id="bm_id3154320" localize="false"/><paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="3">Grid</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_GRID" id="bm_id3154320" localize="false"/><h3 id="hd_id3150439">Grid</h3> <paragraph role="paragraph" id="par_id3147436" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_GRID">Prints out the borders of the individual cells as a grid.</ahelp> For the view on screen, make your choice under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc</emph> - <link href="text/shared/optionen/01060100.xhp"><emph>View</emph></link> - <emph>Grid lines</emph>.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_NOTES" id="bm_id3159153" localize="false"/><paragraph role="heading" id="hd_id3145750" xml-lang="en-US" level="3">Comments</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_NOTES" id="bm_id3159153" localize="false"/><h3 id="hd_id3145750">Comments</h3> <paragraph role="paragraph" id="par_id3150010" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_NOTES">Prints the comments defined in your spreadsheet.</ahelp> They will be printed on a separate page, along with the corresponding cell reference.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_OBJECTS" id="bm_id3144764" localize="false"/><paragraph role="heading" id="hd_id3154944" xml-lang="en-US" level="3">Objects/images</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_OBJECTS" id="bm_id3144764" localize="false"/><h3 id="hd_id3154944">Objects/images</h3> <paragraph role="paragraph" id="par_id3149581" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_OBJECTS">Includes all inserted objects (if printable) and graphics with the printed document.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_CHARTS" id="bm_id3156283" localize="false"/><paragraph role="heading" id="hd_id3149377" xml-lang="en-US" level="3">Charts</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_CHARTS" id="bm_id3156283" localize="false"/><h3 id="hd_id3149377">Charts</h3> <paragraph role="paragraph" id="par_id3148455" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_CHARTS">Prints the charts that have been inserted into your spreadsheet.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_DRAWINGS" id="bm_id3153839" localize="false"/><paragraph role="heading" id="hd_id3153418" xml-lang="en-US" level="3">Drawing Objects</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_DRAWINGS" id="bm_id3153839" localize="false"/><h3 id="hd_id3153418">Drawing Objects</h3> <paragraph role="paragraph" id="par_id3149122" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_DRAWINGS">Includes all drawing objects in the printed document.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_FORMULAS" id="bm_id3155765" localize="false"/><paragraph role="heading" id="hd_id3150330" xml-lang="en-US" level="3">Formulas</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_FORMULAS" id="bm_id3155765" localize="false"/><h3 id="hd_id3150330">Formulas</h3> <paragraph role="paragraph" id="par_id3153715" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_FORMULAS">Prints the formulas contained in the cells, instead of the results.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_NULLVALS" id="bm_id3146314" localize="false"/><paragraph role="heading" id="hd_id3156385" xml-lang="en-US" level="3">Zero Values</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_NULLVALS" id="bm_id3146314" localize="false"/><h3 id="hd_id3156385">Zero Values</h3> <paragraph role="paragraph" id="par_id3149258" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_NULLVALS">Specifies that cells with a zero value are printed.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="2">Page Order</paragraph> +<h2 id="hd_id3154022">Page Order</h2> <paragraph role="paragraph" id="par_id3166423" xml-lang="en-US">Defines the order in which data in a sheet is numbered and printed when it does not fit on one printed page.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/radioBTN_TOPDOWN" id="bm_id3145258" localize="false"/><paragraph role="heading" id="hd_id3152580" xml-lang="en-US" level="3">Top to bottom, then right</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/radioBTN_TOPDOWN" id="bm_id3145258" localize="false"/><h3 id="hd_id3152580">Top to bottom, then right</h3> <paragraph role="paragraph" id="par_id3150205" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/radioBTN_TOPDOWN">Prints vertically from the left column to the bottom of the sheet.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/radioBTN_LEFTRIGHT" id="bm_id3150342" localize="false"/><paragraph role="heading" id="hd_id3150786" xml-lang="en-US" level="3">Left to right, then down</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/radioBTN_LEFTRIGHT" id="bm_id3150342" localize="false"/><h3 id="hd_id3150786">Left to right, then down</h3> <paragraph role="paragraph" id="par_id3154657" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/radioBTN_LEFTRIGHT">Prints horizontally from the top row of the sheet to the right column.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_PAGENO" id="bm_id3150367" localize="false"/><paragraph role="heading" id="hd_id3150887" xml-lang="en-US" level="3">First page number</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_PAGENO" id="bm_id3150367" localize="false"/><h3 id="hd_id3150887">First page number</h3> <paragraph role="paragraph" id="par_id3155378" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_PAGENO">Select this option if you want this style to restart page numbering.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_PAGENO" id="bm_id3156288" localize="false"/><paragraph role="paragraph" id="par_id3145389" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_PAGENO">Enter the number you want to restart at.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3146978" xml-lang="en-US" level="2">Scale</paragraph> +<h2 id="hd_id3146978">Scale</h2> <paragraph role="paragraph" id="par_id3149408" xml-lang="en-US">Defines a page scale for the printed spreadsheet.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/comboLB_SCALEMODE" id="bm_id8574175" localize="false"/><paragraph role="heading" id="par_idN1096D" xml-lang="en-US" level="3">Scaling mode</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/comboLB_SCALEMODE" id="bm_id8574175" localize="false"/><h3 id="par_idN1096D">Scaling mode</h3> <paragraph role="paragraph" id="par_idN10971" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/comboLB_SCALEMODE">Select a scaling mode from the list box. Appropriate controls will be shown below the list box.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3155089" xml-lang="en-US" level="4">Reduce/enlarge printout</paragraph> +<h4 id="hd_id3155089">Reduce/enlarge printout</h4> <paragraph role="paragraph" id="par_id3159171" xml-lang="en-US">Specifies a scaling factor to scale all printed pages.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEALL" id="bm_id3153067" localize="false"/><paragraph role="heading" id="par_idN1099A" xml-lang="en-US" level="5">Scaling factor</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEALL" id="bm_id3153067" localize="false"/><h5 id="par_idN1099A">Scaling factor</h5> <paragraph role="paragraph" id="par_id3152899" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_SCALEALL">Enter a scaling factor. Factors less than 100 reduce the pages, higher factors enlarge the pages.</ahelp></paragraph> -<paragraph role="heading" id="par_idN109B2" xml-lang="en-US" level="4">Shrink print range(s) to width/height</paragraph> +<h4 id="par_idN109B2">Shrink print range(s) to width/height</h4> <paragraph role="paragraph" id="par_idN109B5" xml-lang="en-US">Specifies the maximum number of pages horizontally (width) and vertically (height) on which every sheet with the current Page Style is to be printed. </paragraph> <list type="unordered"> <listitem> @@ -88,13 +88,13 @@ <paragraph role="paragraph" id="par_idN109C3" xml-lang="en-US">If you disable both boxes, this will result in a scaling factor of 100%.</paragraph> </listitem> </list> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEWIDTH" id="bm_id7740714" localize="false"/><paragraph role="heading" id="par_idN109CE" xml-lang="en-US" level="5">Width in pages</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEWIDTH" id="bm_id7740714" localize="false"/><h5 id="par_idN109CE">Width in pages</h5> <paragraph role="paragraph" id="par_idN109D1" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEWIDTH">Enter the maximum number of pages to be printed horizontally across.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEHEIGHT" id="bm_id516983" localize="false"/><paragraph role="heading" id="par_idN109E8" xml-lang="en-US" level="5">Height in pages</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEHEIGHT" id="bm_id516983" localize="false"/><h5 id="par_idN109E8">Height in pages</h5> <paragraph role="paragraph" id="par_idN109EB" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEHEIGHT">Enter the maximum number of pages to be printed vertically stacked.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3148868" xml-lang="en-US" level="4">Shrink print range(s) to number of pages</paragraph> +<h4 id="hd_id3148868">Shrink print range(s) to number of pages</h4> <paragraph role="paragraph" id="par_id3145074" xml-lang="en-US">Specifies the maximum number of pages on which every sheet with the current Page Style is to be printed. The scale will be reduced as necessary to fit the defined number of pages.<comment>UFI: fixes #112585#</comment></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEPAGENUM" id="bm_id3157983" localize="false"/><paragraph role="heading" id="par_idN10A26" xml-lang="en-US" level="5">Number of pages</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEPAGENUM" id="bm_id3157983" localize="false"/><h5 id="par_idN10A26">Number of pages</h5> <paragraph role="paragraph" id="par_id3144507" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_SCALEPAGENUM">Enter the maximum number of pages to be printed.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/05080300.xhp b/source/text/scalc/01/05080300.xhp index 73e4084c46..fdf284ff7d 100644 --- a/source/text/scalc/01/05080300.xhp +++ b/source/text/scalc/01/05080300.xhp @@ -30,7 +30,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:EditPrintArea" id="bm_id2248794" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/PrintAreasDialog" id="bm_id3145673" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/@@nowidget@@" id="bm_id3145673" localize="false"/> -<paragraph role="heading" id="hd_id3153088" xml-lang="en-US" level="1">Edit Print Ranges</paragraph> +<h1 id="hd_id3153088">Edit Print Ranges</h1> <paragraph role="paragraph" id="par_id3159488" xml-lang="en-US"><variable id="printrangestext"><ahelp hid=".uno:EditPrintArea">Opens a dialog where you can specify the print range.</ahelp> </variable> You can also set the rows or columns which are to be repeated in every page.</paragraph> <section id="howtoget"> @@ -42,20 +42,20 @@ </paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/lbprintarea" id="bm_id3154910" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/edprintarea" id="bm_id3150447" localize="false"/> -<paragraph role="heading" id="hd_id3156281" xml-lang="en-US" level="2">Print range</paragraph> +<h2 id="hd_id3156281">Print range</h2> <paragraph role="paragraph" id="par_id3147228" xml-lang="en-US"><ahelp hid="modules/scalc/ui/printareasdialog/edprintarea">Allows you to modify a defined print range.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3145174" xml-lang="en-US">Select <emph>-none-</emph> to remove a print range definition for the current spreadsheet. Select <emph>-entire sheet-</emph> to set the current sheet as a print range. Select <emph>-selection-</emph> to define the selected area of a spreadsheet as the print range. By selecting <emph>-user-defined-</emph>, you can define a print range that you have already defined using the <emph>Format - Print Ranges - Define</emph> command. If you have given a name to a range using the <emph>Sheet - Named Ranges and Expressions - Define</emph> command, this name will be displayed and can be selected from the list box.</paragraph> <paragraph role="paragraph" id="par_id3145272" xml-lang="en-US">In the right-hand text box, you can enter a print range by reference or by name. If the cursor is in the <emph>Print range</emph> text box, you can also select the print range in the spreadsheet with your mouse.</paragraph> <embed href="text/shared/00/00000001.xhp#shrink_maximize"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/lbrepeatrow" id="bm_id3147435" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/edrepeatrow" id="bm_id3153190" localize="false"/> -<paragraph role="heading" id="hd_id3149260" xml-lang="en-US" level="2">Rows to repeat</paragraph> +<h2 id="hd_id3149260">Rows to repeat</h2> <paragraph role="paragraph" id="par_id3147426" xml-lang="en-US"><ahelp hid="modules/scalc/ui/printareasdialog/edrepeatrow">Choose one or more rows to print on every page. In the right text box enter the row reference, for example, "1" or "$1" or "$2:$3".</ahelp> The list box displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating row.</paragraph> <paragraph role="paragraph" id="par_id3155418" xml-lang="en-US">You can also define repeating rows by dragging the mouse in the spreadsheet, if the cursor is in the <emph>Rows to repeat</emph> text field in the dialog.</paragraph> <embed href="text/shared/00/00000001.xhp#shrink_maximize"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/lbrepeatcol" id="bm_id3153876" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/printareasdialog/edrepeatcol" id="bm_id3147396" localize="false"/> -<paragraph role="heading" id="hd_id3149581" xml-lang="en-US" level="2">Columns to repeat</paragraph> +<h2 id="hd_id3149581">Columns to repeat</h2> <paragraph role="paragraph" id="par_id3155602" xml-lang="en-US"><ahelp hid="modules/scalc/ui/printareasdialog/edrepeatcol">Choose one or more columns to print on every page. In the right text box enter the column reference, for example, "A" or "AB" or "$C:$E".</ahelp> The list box then displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating column.</paragraph> <paragraph role="paragraph" id="par_id3150749" xml-lang="en-US">You can also define repeating columns by dragging the mouse in the spreadsheet, if the cursor is in the <emph>Columns to repeat</emph> text field in the dialog.</paragraph> <embed href="text/shared/00/00000001.xhp#shrink_maximize"/> diff --git a/source/text/scalc/01/05110000.xhp b/source/text/scalc/01/05110000.xhp index 2e01bb9bb7..074b7f2c2a 100644 --- a/source/text/scalc/01/05110000.xhp +++ b/source/text/scalc/01/05110000.xhp @@ -36,40 +36,40 @@ </section> <note id="par_id181630332690300">The AutoFormat command is available only if a cell range with at least 3 columns and 3 rows are selected. Otherwise this command will appear grayed out in the menu.</note> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/formatlb" id="bm_id3145645" localize="false"/> -<paragraph role="heading" id="hd_id3148455" xml-lang="en-US" level="2">Format</paragraph> +<h2 id="hd_id3148455">Format</h2> <paragraph role="paragraph" id="par_id3145799" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/formatlb">Choose a predefined AutoFormat to apply to a selected area in your sheet.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#preview_field"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/add" id="bm_id3155600" localize="false"/> -<paragraph role="heading" id="hd_id3149410" xml-lang="en-US" level="2">Add</paragraph> +<h2 id="hd_id3149410">Add</h2> <paragraph role="paragraph" id="par_id3154017" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/add">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats.</ahelp> The <emph>Add AutoFormat</emph> dialog then appears.</paragraph> <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_AUTOFMT_NAME" id="bm_id3153713" localize="false"/> <paragraph role="paragraph" id="par_id3153708" xml-lang="en-US"><ahelp hid=".">Enter a name and click <emph>OK</emph>. </ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#delete"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/rename" id="bm_id3153309" localize="false"/> -<paragraph role="heading" id="hd_id3159223" xml-lang="en-US" level="2">Rename</paragraph> +<h2 id="hd_id3159223">Rename</h2> <paragraph role="paragraph" id="par_id3153064" xml-lang="en-US"><ahelp hid=".">Opens a dialog where you can change the name of the selected AutoFormat.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_REN_AFMT_NAME" id="bm_id3148608" localize="false"/> <paragraph role="paragraph" id="par_id3153912" xml-lang="en-US">The <emph>Rename AutoFormat</emph> dialog opens.<ahelp hid="."> Enter the new name of the AutoFormat here.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3155961" xml-lang="en-US" level="3">Formatting</paragraph> +<h3 id="hd_id3155961">Formatting</h3> <paragraph role="paragraph" id="par_id3153965" xml-lang="en-US">In this section you can select or deselect the available formatting options. If you want to keep any of the settings currently in your spreadsheet, deselect the corresponding option.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/numformatcb" id="bm_id3149210" localize="false"/> -<paragraph role="heading" id="hd_id3154021" xml-lang="en-US" level="3">Number format</paragraph> +<h3 id="hd_id3154021">Number format</h3> <paragraph role="paragraph" id="par_id3159239" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/numformatcb">When marked, specifies that you want to retain the number format of the selected format.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/bordercb" id="bm_id3150206" localize="false"/> -<paragraph role="heading" id="hd_id3149530" xml-lang="en-US" level="3">Borders</paragraph> +<h3 id="hd_id3149530">Borders</h3> <paragraph role="paragraph" id="par_id3145259" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/bordercb">When marked, specifies that you want to retain the border of the selected format.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/fontcb" id="bm_id3150364" localize="false"/> -<paragraph role="heading" id="hd_id3154657" xml-lang="en-US" level="3">Font</paragraph> +<h3 id="hd_id3154657">Font</h3> <paragraph role="paragraph" id="par_id3152990" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/fontcb">When marked, specifies that you want to retain the font of the selected format.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/patterncb" id="bm_id3150515" localize="false"/> -<paragraph role="heading" id="hd_id3155379" xml-lang="en-US" level="3">Pattern</paragraph> +<h3 id="hd_id3155379">Pattern</h3> <paragraph role="paragraph" id="par_id3150368" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/patterncb">When marked, specifies that you want to retain the pattern of the selected format.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/alignmentcb" id="bm_id3146978" localize="false"/> -<paragraph role="heading" id="hd_id3146115" xml-lang="en-US" level="3">Alignment</paragraph> +<h3 id="hd_id3146115">Alignment</h3> <paragraph role="paragraph" id="par_id3156445" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/alignmentcb">When marked, specifies that you want to retain the alignment of the selected format.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/autoformattable/autofitcb" id="bm_id3152892" localize="false"/> -<paragraph role="heading" id="hd_id3155811" xml-lang="en-US" level="3">AutoFit width and height</paragraph> +<h3 id="hd_id3155811">AutoFit width and height</h3> <paragraph role="paragraph" id="par_id3148703" xml-lang="en-US"><ahelp hid="modules/scalc/ui/autoformattable/autofitcb">When marked, specifies that you want to retain the width and height of the selected cells of the selected format.</ahelp></paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/autoformat.xhp#autoformat"/> diff --git a/source/text/scalc/01/06020000.xhp b/source/text/scalc/01/06020000.xhp index 3ce6c93454..0d3481f61f 100644 --- a/source/text/scalc/01/06020000.xhp +++ b/source/text/scalc/01/06020000.xhp @@ -33,14 +33,14 @@ <bookmark_value>syllables in spreadsheets</bookmark_value> </bookmark><comment>mw made "hyphenation..." a two level entry</comment> <bookmark xml-lang="en-US" branch="hid/.uno:Hyphenate" id="bm_id7241058" localize="false"/> -<paragraph role="heading" id="hd_id3159399" xml-lang="en-US" level="1">Hyphenation</paragraph> +<h1 id="hd_id3159399">Hyphenation</h1> <paragraph role="paragraph" id="par_id3145068" xml-lang="en-US"><variable id="silben"><ahelp hid=".uno:Hyphenate">The <emph>Hyphenation </emph>command calls the dialog for setting the hyphenation in $[officename] Calc.</ahelp> </variable></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000406.xhp#silbentrennungc"/> </section> <paragraph role="paragraph" id="par_id3154366" xml-lang="en-US">You can only turn on the automatic hyphenation in $[officename] Calc when the <link href="text/shared/01/05340300.xhp">row break</link> feature is active.</paragraph> -<paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="2">Hyphenation for selected cells.</paragraph> +<h2 id="hd_id3153192">Hyphenation for selected cells.</h2> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3150868" xml-lang="en-US">Select the cells for which you want to change the hyphenation.</paragraph> @@ -55,7 +55,7 @@ <paragraph role="listitem" id="par_id3149260" xml-lang="en-US">Mark the <emph>Wrap text automatically</emph> and <emph>Hyphenation active</emph> check boxes.</paragraph> </listitem> </list> -<paragraph role="heading" id="hd_id3153094" xml-lang="en-US" level="2">Hyphenation for Drawing Objects</paragraph> +<h2 id="hd_id3153094">Hyphenation for Drawing Objects</h2> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3148577" xml-lang="en-US">Select a drawing object.</paragraph> diff --git a/source/text/scalc/01/06040000.xhp b/source/text/scalc/01/06040000.xhp index 9d773a5ac3..ec07d7caad 100644 --- a/source/text/scalc/01/06040000.xhp +++ b/source/text/scalc/01/06040000.xhp @@ -30,22 +30,22 @@ <bookmark xml-lang="en-US" branch="hid/.uno:GoalSeekDialog" id="bm_id4741970" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/GoalSeekDialog" id="bm_id3153088" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/@@nowidget@@" id="bm_id3153088" localize="false"/> -<paragraph role="heading" id="hd_id3155629" xml-lang="en-US" level="1">Goal Seek</paragraph> +<h1 id="hd_id3155629">Goal Seek</h1> <paragraph role="paragraph" id="par_id3145119" xml-lang="en-US"><variable id="zielwertsuchetext"><ahelp hid=".uno:GoalSeekDialog">Opens a dialog where you can solve an equation with a variable.</ahelp> </variable> After a successful search, a dialog with the results opens, allowing you to apply the result and the target value directly to the cell.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000406.xhp#exzws"/> </section> -<paragraph role="heading" id="hd_id3149656" xml-lang="en-US" level="2">Default</paragraph> +<h2 id="hd_id3149656">Default</h2> <paragraph role="paragraph" id="par_id3151211" xml-lang="en-US">In this section, you can define the variables in your formula.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/formulaedit" id="bm_id3145171" localize="false"/> -<paragraph role="heading" id="hd_id3150869" xml-lang="en-US" level="3">Formula cell</paragraph> +<h3 id="hd_id3150869">Formula cell</h3> <paragraph role="paragraph" id="par_id3153194" xml-lang="en-US"><ahelp hid="modules/scalc/ui/goalseekdlg/formulaedit">In the formula cell, enter the reference of the cell which contains the formula. It contains the current cell reference.</ahelp> Click another cell in the sheet to apply its reference to the text box.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/target" id="bm_id3150441" localize="false"/> -<paragraph role="heading" id="hd_id3154685" xml-lang="en-US" level="3">Target value</paragraph> +<h3 id="hd_id3154685">Target value</h3> <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><ahelp hid="modules/scalc/ui/goalseekdlg/target">Specifies the value you want to achieve as a new result.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/goalseekdlg/varedit" id="bm_id3154013" localize="false"/> -<paragraph role="heading" id="hd_id3150012" xml-lang="en-US" level="3">Variable cell</paragraph> +<h3 id="hd_id3150012">Variable cell</h3> <paragraph role="paragraph" id="par_id3147427" xml-lang="en-US"><ahelp hid="modules/scalc/ui/goalseekdlg/varedit">Specifies the reference for the cell that contains the value you want to adjust in order to reach the target.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#shrink_maximize"/> </body> diff --git a/source/text/scalc/01/06050000.xhp b/source/text/scalc/01/06050000.xhp index ce6dd63446..8bb6fbeb0b 100644 --- a/source/text/scalc/01/06050000.xhp +++ b/source/text/scalc/01/06050000.xhp @@ -33,7 +33,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:ScenarioManager" id="bm_id3154490" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/ScenarioDialog" id="bm_id3145068" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/@@nowidget@@" id="bm_id3145068" localize="false"/> -<paragraph role="heading" id="hd_id3156023" xml-lang="en-US" level="1">Create Scenario</paragraph> +<h1 id="hd_id3156023">Create Scenario</h1> <paragraph role="paragraph" id="par_id3150541" xml-lang="en-US"><variable id="szenariotext"><ahelp hid=".">Defines a scenario for the selected sheet area.</ahelp> </variable></paragraph> <section id="howtoget"> @@ -44,26 +44,26 @@ </paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/name" id="bm_id3154123" localize="false"/> <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_SCENWIN_TOP" id="bm_id3153195" localize="false"/> -<paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="2">Name of scenario</paragraph> +<h2 id="hd_id3156280">Name of scenario</h2> <paragraph role="paragraph" id="par_id3151041" xml-lang="en-US"><ahelp hid=".">Defines the name for the scenario. Use a clear and unique name so you can easily identify the scenario.</ahelp> You can also modify a scenario name in the Navigator through the <emph>Properties </emph>context menu command.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/comment" id="bm_id3152596" localize="false"/> <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_SCENWIN_BOTTOM" id="bm_id3156444" localize="false"/> -<paragraph role="heading" id="hd_id3153954" xml-lang="en-US" level="2">Comment</paragraph> +<h2 id="hd_id3153954">Comment</h2> <paragraph role="paragraph" id="par_id3155411" xml-lang="en-US"><ahelp hid=".">Specifies additional information about the scenario. This information will be displayed in the <link href="text/scalc/01/02110000.xhp">Navigator</link> when you click the <emph>Scenarios</emph> icon and select the desired scenario.</ahelp> You can also modify this information in the Navigator through the <emph>Properties </emph>context menu command.</paragraph> -<paragraph role="heading" id="hd_id3145273" xml-lang="en-US" level="2">Settings</paragraph> +<h2 id="hd_id3145273">Settings</h2> <paragraph role="paragraph" id="par_id3153364" xml-lang="en-US">This section is used to define some of the settings used in the scenario display.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/showframe" id="bm_id3151119" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/bordercolor" id="bm_id3151118" localize="false"/> <paragraph role="heading" id="hd_id3145367" xml-lang="en-US" level="3">Display border<comment>UFI: #i38688#</comment></paragraph> <paragraph role="paragraph" id="par_id3151073" xml-lang="en-US"><ahelp hid=".">Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option.</ahelp> The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/copyback" id="bm_id3147124" localize="false"/> -<paragraph role="heading" id="hd_id3149582" xml-lang="en-US" level="3">Copy back</paragraph> +<h3 id="hd_id3149582">Copy back</h3> <paragraph role="paragraph" id="par_id3154942" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scenariodialog/copyback">Copies the values of cells that you change into the active scenario. If you do not select this option, the scenario is not changed when you change cell values. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/copysheet" id="bm_id3153418" localize="false"/> -<paragraph role="heading" id="hd_id3149402" xml-lang="en-US" level="3">Copy entire sheet</paragraph> +<h3 id="hd_id3149402">Copy entire sheet</h3> <paragraph role="paragraph" id="par_id3146969" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scenariodialog/copysheet">Copies the entire sheet into an additional scenario sheet. </ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/scenariodialog/preventchanges" id="bm_id3014007" localize="false"/> -<paragraph role="heading" id="par_idN1075A" xml-lang="en-US" level="3">Prevent changes</paragraph> +<h3 id="par_idN1075A">Prevent changes</h3> <paragraph role="paragraph" id="par_idN1075E" xml-lang="en-US"><ahelp hid="modules/scalc/ui/scenariodialog/preventchanges">Prevents changes to the active scenario. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp></paragraph> <list type="unordered"> <listitem> diff --git a/source/text/scalc/01/06060200.xhp b/source/text/scalc/01/06060200.xhp index 20a68ae451..d590e092b6 100644 --- a/source/text/scalc/01/06060200.xhp +++ b/source/text/scalc/01/06060200.xhp @@ -32,7 +32,7 @@ <body> <bookmark xml-lang="en-US" branch="hid/.uno:ToolProtectionDocument" id="bm_id3150791" localize="false"/> -<paragraph role="heading" id="hd_id3150541" xml-lang="en-US" level="1">Protecting document</paragraph> +<h1 id="hd_id3150541">Protecting document</h1> <paragraph role="paragraph" id="par_id3145172" xml-lang="en-US"><variable id="dokumenttext"><ahelp hid=".uno:ToolProtectionDocument">Protects the sheet structure of your document from modifications. It is impossible to insert, delete, rename, move or copy sheets.</ahelp></variable> Open the <emph>Protect spreadsheet structure</emph> dialog with <emph>Tools - Protect Spreadsheet Structure</emph>. Optionally enter a password and click OK.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000406.xhp#protect_spreadsheet"/> @@ -41,7 +41,7 @@ <paragraph role="paragraph" id="par_id3145750" xml-lang="en-US">A protected document, once saved, can only be saved again with the <emph>File - Save As</emph> menu command. </paragraph> <bookmark xml-lang="en-US" branch="hid/SC_HID_PASSWD_DOC" id="bm_id3154863" localize="false"/> -<paragraph role="heading" id="hd_id3152596" xml-lang="en-US" level="2">Password (optional)</paragraph> +<h2 id="hd_id3152596">Password (optional)</h2> <paragraph role="paragraph" id="par_id3155412" xml-lang="en-US"><ahelp hid="SC_HID_PASSWD_DOC">You can create a password to protect your document against unauthorized or accidental modifications.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/SC_HID_PASSWD_DOC_CONFIRM" id="bm_id3154864" localize="false"/> diff --git a/source/text/scalc/01/12010100.xhp b/source/text/scalc/01/12010100.xhp index 57b2a0573c..f0beaef45a 100644 --- a/source/text/scalc/01/12010100.xhp +++ b/source/text/scalc/01/12010100.xhp @@ -32,18 +32,18 @@ <body> - <paragraph role="heading" level="1" id="hd_id3154760" xml-lang="en-US">Options</paragraph> - <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/ContainsColumnLabels" xml-lang="en-US" id="bm_id3150399" localize="false"/><paragraph role="heading" level="3" id="hd_id3153379" xml-lang="en-US">Contains column labels</paragraph> + <h1 id="hd_id3154760">Options</h1> + <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/ContainsColumnLabels" xml-lang="en-US" id="bm_id3150399" localize="false"/><h3 id="hd_id3153379">Contains column labels</h3> <paragraph role="paragraph" id="par_id3148798" xml-lang="en-US"><ahelp hid="modules/scalc/ui/definedatabaserangedialog/ContainsColumnLabels" visibility="visible">Selected cell ranges contains labels.</ahelp></paragraph> - <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells" xml-lang="en-US" id="bm_id3156422" localize="false"/><paragraph role="heading" level="3" id="hd_id3153970" xml-lang="en-US">Insert or delete cells</paragraph> + <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells" xml-lang="en-US" id="bm_id3156422" localize="false"/><h3 id="hd_id3153970">Insert or delete cells</h3> <paragraph xml-lang="en-US" role="paragraph" id="par_id3154684"><ahelp hid="modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells" visibility="visible">Automatically inserts new rows and columns into the database range in your document when new records are added to the database.</ahelp> To manually update the database range, choose <emph>Data - Refresh Range</emph>.</paragraph> - <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/KeepFormatting" xml-lang="en-US" id="bm_id3151117" localize="false"/><paragraph role="heading" level="3" id="hd_id3153768" xml-lang="en-US">Keep formatting</paragraph> + <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/KeepFormatting" xml-lang="en-US" id="bm_id3151117" localize="false"/><h3 id="hd_id3153768">Keep formatting</h3> <paragraph role="paragraph" id="par_id3147435" xml-lang="en-US"><ahelp hid="modules/scalc/ui/definedatabaserangedialog/KeepFormatting" visibility="visible">Applies the existing cell format of headers and first data row to the whole database range.</ahelp></paragraph> - <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/DontSaveImportedData" xml-lang="en-US" id="bm_id3145748" localize="false"/><paragraph role="heading" level="3" id="hd_id3155856" xml-lang="en-US">Don't save imported data</paragraph> + <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/DontSaveImportedData" xml-lang="en-US" id="bm_id3145748" localize="false"/><h3 id="hd_id3155856">Don't save imported data</h3> <paragraph role="paragraph" id="par_id3153363" xml-lang="en-US"><ahelp hid="modules/scalc/ui/definedatabaserangedialog/DontSaveImportedData" visibility="visible">Only saves a reference to the database, and not the contents of the cells.</ahelp></paragraph> - <paragraph role="heading" level="3" id="hd_id3147428" xml-lang="en-US">Source:</paragraph> + <h3 id="hd_id3147428">Source:</h3> <paragraph role="paragraph" id="par_id3148576" xml-lang="en-US">Displays information about the current database source and any existing operators.</paragraph> - <paragraph role="heading" level="2" id="hd_id3146976" xml-lang="en-US">More <<</paragraph> + <h2 id="hd_id3146976">More <<</h2> <paragraph role="paragraph" id="par_id3149664" xml-lang="en-US">Hides the additional options.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12040300.xhp b/source/text/scalc/01/12040300.xhp index 5e5573ead8..f75075f71b 100644 --- a/source/text/scalc/01/12040300.xhp +++ b/source/text/scalc/01/12040300.xhp @@ -29,7 +29,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:DataFilterSpecialFilter" id="bm_id4998774" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/AdvancedFilterDialog" id="bm_id3154366" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/@@nowidget@@" id="bm_id3154366" localize="false"/> -<paragraph role="heading" id="hd_id3158394" xml-lang="en-US" level="1">Advanced Filter</paragraph> +<h1 id="hd_id3158394">Advanced Filter</h1> <paragraph role="paragraph" id="par_id3156281" xml-lang="en-US"><variable id="spezialfilter"><ahelp hid=".uno:DataFilterSpecialFilter">Defines an advanced filter.</ahelp> </variable></paragraph> <section id="howtoget"> @@ -37,7 +37,7 @@ </section> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/lbfilterarea" id="bm_id3149664" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/advancedfilterdialog/edfilterarea" id="bm_id3151113" localize="false"/> -<paragraph role="heading" id="hd_id3153771" xml-lang="en-US" level="2">Read filter criteria from</paragraph> +<h2 id="hd_id3153771">Read filter criteria from</h2> <paragraph role="paragraph" id="par_id3147426" xml-lang="en-US"><ahelp hid="modules/scalc/ui/advancedfilterdialog/edfilterarea">Select the named range, or enter the cell range that contains the filter criteria that you want to use.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#shrink_maximize"/> <h2 id="hd_id331625165680452">Options</h2> diff --git a/source/text/scalc/01/12070100.xhp b/source/text/scalc/01/12070100.xhp index ef860a2145..8485f9abd3 100644 --- a/source/text/scalc/01/12070100.xhp +++ b/source/text/scalc/01/12070100.xhp @@ -32,17 +32,17 @@ <body> - <paragraph role="heading" level="1" id="hd_id3151210" xml-lang="en-US">Consolidate by</paragraph> - <paragraph role="heading" level="2" id="hd_id3125864" xml-lang="en-US">Consolidate by</paragraph> + <h1 id="hd_id3151210">Consolidate by</h1> + <h2 id="hd_id3125864">Consolidate by</h2> <paragraph role="paragraph" id="par_id3154909" xml-lang="en-US">Use this section if the cell ranges that you want to consolidate contain labels. You only need to select these options if the consolidation ranges contain similar labels and the data arranged is arranged differently.</paragraph> - <bookmark branch="hid/modules/scalc/ui/consolidatedialog/byrow" xml-lang="en-US" id="bm_id3154684" localize="false"/><paragraph role="heading" level="3" id="hd_id3153968" xml-lang="en-US">Row labels</paragraph> + <bookmark branch="hid/modules/scalc/ui/consolidatedialog/byrow" xml-lang="en-US" id="bm_id3154684" localize="false"/><h3 id="hd_id3153968">Row labels</h3> <paragraph role="paragraph" id="par_id3150441" xml-lang="en-US"><ahelp hid="modules/scalc/ui/consolidatedialog/byrow" visibility="visible">Uses the row labels to arrange the consolidated data.</ahelp></paragraph> - <bookmark branch="hid/modules/scalc/ui/consolidatedialog/bycol" xml-lang="en-US" id="bm_id3149260" localize="false"/><paragraph role="heading" level="3" id="hd_id3146976" xml-lang="en-US">Column labels</paragraph> + <bookmark branch="hid/modules/scalc/ui/consolidatedialog/bycol" xml-lang="en-US" id="bm_id3149260" localize="false"/><h3 id="hd_id3146976">Column labels</h3> <paragraph role="paragraph" id="par_id3155411" xml-lang="en-US"><ahelp hid="modules/scalc/ui/consolidatedialog/bycol" visibility="visible">Uses the column labels to arrange the consolidated data.</ahelp></paragraph> - <paragraph role="heading" level="2" id="hd_id3153191" xml-lang="en-US">Options</paragraph> - <bookmark branch="hid/modules/scalc/ui/consolidatedialog/refs" xml-lang="en-US" id="bm_id3153954" localize="false"/><paragraph role="heading" level="3" id="hd_id3159154" xml-lang="en-US">Link to source data</paragraph> + <h2 id="hd_id3153191">Options</h2> + <bookmark branch="hid/modules/scalc/ui/consolidatedialog/refs" xml-lang="en-US" id="bm_id3153954" localize="false"/><h3 id="hd_id3159154">Link to source data</h3> <paragraph role="paragraph" id="par_id3146986" xml-lang="en-US"><ahelp hid="modules/scalc/ui/consolidatedialog/refs" visibility="visible">Links the data in the consolidation range to the source data, and automatically updates the results of the consolidation when the source data is changed.</ahelp></paragraph> - <paragraph role="heading" level="2" id="hd_id3163708" xml-lang="en-US">Options</paragraph> + <h2 id="hd_id3163708">Options</h2> <paragraph role="paragraph" id="par_id3151118" xml-lang="en-US">Hides the additional options.</paragraph> </body> diff --git a/source/text/scalc/01/12080300.xhp b/source/text/scalc/01/12080300.xhp index acb73570c9..f4e7457469 100644 --- a/source/text/scalc/01/12080300.xhp +++ b/source/text/scalc/01/12080300.xhp @@ -43,10 +43,10 @@ <embed href="text/scalc/00/00000412.xhp#data_outline_group"/> </section> <paragraph xml-lang="en-US" role="paragraph" id="par_id3145069">When you group a cell range, and outline icon appears in the margins next to the group. To hide or show the group, click the icon. To ungroup the selection, choose <emph>Data – Group and Outline -</emph> <link href="text/scalc/01/12080400.xhp"><emph>Ungroup</emph></link>.</paragraph> - <paragraph role="heading" level="2" id="hd_id3125863" xml-lang="en-US">Include</paragraph> - <bookmark branch="hid/modules/scalc/ui/groupdialog/rows" xml-lang="en-US" id="bm_id3150770" localize="false"/><paragraph role="heading" level="3" id="hd_id3150448" xml-lang="en-US">Rows</paragraph> + <h2 id="hd_id3125863">Include</h2> + <bookmark branch="hid/modules/scalc/ui/groupdialog/rows" xml-lang="en-US" id="bm_id3150770" localize="false"/><h3 id="hd_id3150448">Rows</h3> <paragraph role="paragraph" id="par_id3153194" xml-lang="en-US"><ahelp hid="modules/scalc/ui/groupdialog/rows">Groups the selected rows.</ahelp></paragraph> - <bookmark branch="hid/modules/scalc/ui/groupdialog/cols" xml-lang="en-US" id="bm_id3153771" localize="false"/><paragraph role="heading" level="3" id="hd_id3145786" xml-lang="en-US">Columns</paragraph> + <bookmark branch="hid/modules/scalc/ui/groupdialog/cols" xml-lang="en-US" id="bm_id3153771" localize="false"/><h3 id="hd_id3145786">Columns</h3> <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US"><ahelp hid="modules/scalc/ui/groupdialog/cols">Groups the selected columns.</ahelp></paragraph> <note id="par_id171608652491036">Grouping and ungrouping is not tracked. Group is greyed out when track changes is on.</note> diff --git a/source/text/scalc/01/12080400.xhp b/source/text/scalc/01/12080400.xhp index e8d8a7dca5..41ce6e720e 100644 --- a/source/text/scalc/01/12080400.xhp +++ b/source/text/scalc/01/12080400.xhp @@ -40,10 +40,10 @@ <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#data_outline_ungroup"/> </section> - <paragraph role="heading" level="2" id="hd_id3151210" xml-lang="en-US">Deactivate for</paragraph> - <paragraph role="heading" level="3" id="hd_id3156280" xml-lang="en-US">Rows</paragraph> + <h2 id="hd_id3151210">Deactivate for</h2> + <h3 id="hd_id3156280">Rows</h3> <paragraph role="paragraph" id="par_id3125864" xml-lang="en-US">Removes selected rows from a group.</paragraph> - <paragraph role="heading" level="3" id="hd_id3147230" xml-lang="en-US">Columns</paragraph> + <h3 id="hd_id3147230">Columns</h3> <paragraph role="paragraph" id="par_id3154685" xml-lang="en-US">Removes selected columns from a group.</paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12090101.xhp b/source/text/scalc/01/12090101.xhp index 483c719510..c7094cd1ea 100644 --- a/source/text/scalc/01/12090101.xhp +++ b/source/text/scalc/01/12090101.xhp @@ -34,21 +34,21 @@ <body> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectdatasource/SelectDataSourceDialog" id="bm_id3154685" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectdatasource/@@nowidget@@" id="bm_id3154685" localize="false"/> -<paragraph role="heading" id="hd_id3143268" xml-lang="en-US" level="1">Select Data Source</paragraph> +<h1 id="hd_id3143268">Select Data Source</h1> <paragraph role="paragraph" id="par_id3148552" xml-lang="en-US">Select the database and the table or query containing the data that you want to use.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#dndq"/> </section> -<paragraph role="heading" id="hd_id3154140" xml-lang="en-US" level="2">Selection</paragraph> +<h2 id="hd_id3154140">Selection</h2> <paragraph role="paragraph" id="par_id3125863" xml-lang="en-US"><ahelp hid=".">You can only select databases that are registered in %PRODUCTNAME.</ahelp> To register a data source, choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Base - Databases</emph>.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectdatasource/database" id="bm_id3154684" localize="false"/> -<paragraph role="heading" id="hd_id3151041" xml-lang="en-US" level="3">Database</paragraph> +<h3 id="hd_id3151041">Database</h3> <paragraph role="paragraph" id="par_id3156424" xml-lang="en-US"><ahelp hid="modules/scalc/ui/selectdatasource/database">Select the database that contains the data source that you want to use.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectdatasource/datasource" id="bm_id3151112" localize="false"/> -<paragraph role="heading" id="hd_id3145364" xml-lang="en-US" level="3">Data source</paragraph> +<h3 id="hd_id3145364">Data source</h3> <paragraph role="paragraph" id="par_id3149260" xml-lang="en-US"><ahelp hid="modules/scalc/ui/selectdatasource/datasource">Select the data source that you want to use.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectdatasource/type" id="bm_id3153726" localize="false"/> -<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="3">Type</paragraph> +<h3 id="hd_id3147428">Type</h3> <paragraph role="paragraph" id="par_id3150010" xml-lang="en-US"><ahelp hid="modules/scalc/ui/selectdatasource/type">Click the source type of for the selected data source.</ahelp> You can choose from four source types: "Table", "Query" and "SQL" or SQL (Native).</paragraph> <section id="relatedtopics"> <paragraph role="paragraph" id="par_id3147348" xml-lang="en-US"><link href="text/scalc/01/12090102.xhp">Pivot table dialog</link></paragraph> diff --git a/source/text/scalc/01/12090102.xhp b/source/text/scalc/01/12090102.xhp index 39e8e032d2..7a3ae51b76 100644 --- a/source/text/scalc/01/12090102.xhp +++ b/source/text/scalc/01/12090102.xhp @@ -33,7 +33,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:DataPilotExec" id="bm_id3154514" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/PivotTableLayout" id="bm_id31545141" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/@@nowidget@@" id="bm_id31545141" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3149165" role="heading" level="1">Pivot Table</paragraph> +<h1 id="hd_id3149165">Pivot Table</h1> <paragraph xml-lang="en-US" id="par_id3155922" role="paragraph"><ahelp hid=".uno:DataPilotExec">Specify the layout of the table that is generated by the pivot table.</ahelp></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#insert_pivot_table"/> @@ -45,46 +45,46 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-row" id="bm_id7529526" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-data" id="bm_id2920621" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/listbox-page" id="bm_id7411420" localize="false"/><comment>UFI: changed help id from 59001 to dply_page</comment> -<paragraph xml-lang="en-US" id="hd_id3154908" role="heading" level="2">Layout</paragraph> +<h2 id="hd_id3154908">Layout</h2> <paragraph xml-lang="en-US" id="par_id3150768" role="paragraph"><ahelp hid="modules/scalc/ui/pivottablelayoutdialog/listbox-fields">To define the layout of a pivot table, drag and drop data field buttons onto the <emph>Filters, Row Fields, Column Fields</emph> and <emph>Data Fields</emph> areas.</ahelp> You can also use drag and drop to rearrange the data fields on a pivot table.</paragraph> <paragraph xml-lang="en-US" id="par_id3147229" role="paragraph">$[officename] automatically adds a caption to buttons that are dragged into the <emph>Data Fields </emph>area. The caption contains the name of the data field as well as the formula that created the data.</paragraph> <paragraph xml-lang="en-US" id="par_id3145749" role="paragraph">To change the function that is used by a data field, double-click a button in the <emph>Data Fields</emph> area to open the <link href="text/scalc/01/12090105.xhp">Data Field</link> dialog. You can also double-click buttons in the <emph>Row Fields</emph> or <emph>Column Fields</emph> areas.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/more" id="bm_id4284798" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3154944" role="heading" level="2">More</paragraph> +<h2 id="hd_id3154944">More</h2> <paragraph xml-lang="en-US" id="par_id3145647" role="paragraph"><ahelp hid="modules/scalc/ui/pivottablelayoutdialog/more">Displays or hides additional options for defining the pivot table.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3151073" role="heading" level="2">Result</paragraph> + <h2 id="hd_id3151073">Result</h2> <paragraph xml-lang="en-US" id="par_id3155417" role="paragraph">Specify the settings for displaying the results of the pivot table.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/source-edit" id="bm_id7418660" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/source-button" id="bm_id7418760" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id0509200913025625" role="heading" level="3">Selection from</paragraph> +<h3 id="hd_id0509200913025625">Selection from</h3> <paragraph xml-lang="en-US" id="par_id0509200913025615" role="paragraph"><ahelp hid=".">Select the area that contains the data for the current pivot table.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-edit" id="bm_id7419660" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/destination-list" id="bm_id2334665" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3155603" role="heading" level="2">Results to</paragraph> +<h2 id="hd_id3155603">Results to</h2> <paragraph xml-lang="en-US" id="par_id3153838" role="paragraph"><ahelp hid="modules/scalc/ui/pivottablelayoutdialog/destination-edit">Select the area where you want to display the results of the pivot table.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#shrink_maximize"/> <paragraph xml-lang="en-US" id="par_id3155961" role="warning">If the selected area contains data, the pivot table overwrites the data. To prevent the loss of existing data, let the pivot table automatically select the area to display the results.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-ignore-empty-rows" id="bm_id7835016" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3147364" role="heading" level="2">Ignore empty rows</paragraph> +<h2 id="hd_id3147364">Ignore empty rows</h2> <paragraph xml-lang="en-US" id="par_id3154022" role="paragraph"><ahelp hid="modules/scalc/ui/pivottablelayoutdialog/check-ignore-empty-rows">Ignores empty fields in the data source.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-identify-categories" id="bm_id5103305" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3155114" role="heading" level="2">Identify categories</paragraph> +<h2 id="hd_id3155114">Identify categories</h2> <paragraph xml-lang="en-US" id="par_id3145257" role="paragraph"><ahelp hid="modules/scalc/ui/pivottablelayoutdialog/check-identify-categories">Automatically assigns rows without labels to the category of the row above.</ahelp><comment>i93137</comment></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-total-columns" id="bm_id2163457" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3149207" role="heading" level="2">Total columns</paragraph> +<h2 id="hd_id3149207">Total columns</h2> <paragraph xml-lang="en-US" id="par_id3166426" role="paragraph"><ahelp hid="modules/scalc/ui/pivottablelayoutdialog/check-total-columns">Calculates and displays the grand total of the column calculation.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-total-rows" id="bm_id3748588" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3150364" role="heading" level="2">Total rows</paragraph> +<h2 id="hd_id3150364">Total rows</h2> <paragraph xml-lang="en-US" id="par_id3152583" role="paragraph"><ahelp hid="modules/scalc/ui/pivottablelayoutdialog/check-total-rows">Calculates and displays the grand total of the row calculation.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-add-filter" id="bm_id6004516" localize="false"/> -<paragraph xml-lang="en-US" id="par_idN10897" role="heading" level="2">Add filter</paragraph> +<h2 id="par_idN10897">Add filter</h2> <paragraph xml-lang="en-US" id="par_idN1089B" role="paragraph"><ahelp hid=".">Adds a Filter button to pivot tables that are based on spreadsheet data.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/.uno:DataPilotFilter" id="bm_id6278267" localize="false"/> <paragraph xml-lang="en-US" id="par_idN108B2" role="paragraph"><ahelp hid=".">Opens the Filter dialog.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivottablelayoutdialog/check-drill-to-details" id="bm_id7366252" localize="false"/> -<paragraph xml-lang="en-US" id="par_idN108C9" role="heading" level="2">Enable drill to details</paragraph> +<h2 id="par_idN108C9">Enable drill to details</h2> <paragraph xml-lang="en-US" id="par_idN108CD" role="paragraph"><ahelp hid=".">Select this check box and double-click an item label in the table to show or hide details for the item. Clear this check box and double-click a cell in the table to edit the contents of the cell.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="par_idN108DC" role="heading" level="2">To examine details inside a pivot table</paragraph> + <h2 id="par_idN108DC">To examine details inside a pivot table</h2> <paragraph xml-lang="en-US" id="par_idN108E0" role="paragraph">Do one of the following:</paragraph> <list type="unordered"> <listitem> @@ -98,7 +98,7 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/showdetaildialog/ShowDetails" id="bm_id9630726" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/showdetaildialog/dimsTreeview" id="bm_id9630726" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/showdetaildialog/@@nowidget@@" id="bm_id9630726" localize="false"/> -<paragraph xml-lang="en-US" id="par_idN10900" role="heading" level="2">Show Detail</paragraph> +<h2 id="par_idN10900">Show Detail</h2> <paragraph xml-lang="en-US" id="par_idN10904" role="paragraph"><ahelp hid=".">Choose the field that you want to view the details for.</ahelp></paragraph> <section id="relatedtopics"> <paragraph xml-lang="en-US" id="par_id3149817" role="paragraph"><link href="text/scalc/04/01020000.xhp">Pivot table shortcut keys</link></paragraph> diff --git a/source/text/scalc/01/12090103.xhp b/source/text/scalc/01/12090103.xhp index 7ef837ad86..9aca2a9a96 100644 --- a/source/text/scalc/01/12090103.xhp +++ b/source/text/scalc/01/12090103.xhp @@ -33,15 +33,15 @@ <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/PivotFilterDialog" xml-lang="en-US" id="bm_id3153143" localize="false"/> <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/@@nowidget@@" xml-lang="en-US" id="bm_id3153143" localize="false"/> - <paragraph role="heading" level="1" id="hd_id3153970" xml-lang="en-US">Filter</paragraph> + <h1 id="hd_id3153970">Filter</h1> <paragraph role="paragraph" id="par_id3150448" xml-lang="en-US">Set the filtering options for the data.</paragraph> - <paragraph role="heading" level="2" id="hd_id3151043" xml-lang="en-US">Filter Criteria</paragraph> + <h2 id="hd_id3151043">Filter Criteria</h2> <paragraph role="paragraph" id="par_id3150440" xml-lang="en-US">You can define a default filter for the data by filtering, for example, field names, using a combination of logical expressions arguments.</paragraph> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/connect1" xml-lang="en-US" id="bm_id3153142" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/connect2" xml-lang="en-US" id="bm_id3155412" localize="false"/><paragraph role="heading" level="3" id="hd_id3159153" xml-lang="en-US">Operator</paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/connect1" xml-lang="en-US" id="bm_id3153142" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/connect2" xml-lang="en-US" id="bm_id3155412" localize="false"/><h3 id="hd_id3159153">Operator</h3> <paragraph role="paragraph" id="par_id3153093" xml-lang="en-US"><ahelp hid=".">Select a logical operator for the filter.</ahelp></paragraph> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/field1" xml-lang="en-US" id="bm_id3147317" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/field2" xml-lang="en-US" id="bm_id3148646" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/field3" xml-lang="en-US" id="bm_id3149667" localize="false"/><paragraph role="heading" level="3" id="hd_id3152462" xml-lang="en-US">Field name</paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/field1" xml-lang="en-US" id="bm_id3147317" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/field2" xml-lang="en-US" id="bm_id3148646" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/field3" xml-lang="en-US" id="bm_id3149667" localize="false"/><h3 id="hd_id3152462">Field name</h3> <paragraph role="paragraph" id="par_id3155306" xml-lang="en-US"><ahelp hid=".">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</ahelp></paragraph> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/cond1" xml-lang="en-US" id="bm_id3147348" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/cond2" xml-lang="en-US" id="bm_id3155855" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/cond3" xml-lang="en-US" id="bm_id3156444" localize="false"/><paragraph role="heading" level="3" id="hd_id3148575" xml-lang="en-US">Condition</paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/cond1" xml-lang="en-US" id="bm_id3147348" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/cond2" xml-lang="en-US" id="bm_id3155855" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/cond3" xml-lang="en-US" id="bm_id3156444" localize="false"/><h3 id="hd_id3148575">Condition</h3> <paragraph role="paragraph" id="par_id3147394" xml-lang="en-US"><ahelp hid=".">Select an operator to compare the <emph>Field name</emph> and <emph>Value</emph> entries.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3144764" xml-lang="en-US">The following operators are available:</paragraph> <table id="tbl_id3149379"> @@ -106,7 +106,7 @@ </tablecell> </tablerow> </table> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/val1" xml-lang="en-US" id="bm_id3152990" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/val2" xml-lang="en-US" id="bm_id3152994" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/val3" xml-lang="en-US" id="bm_id3150370" localize="false"/><paragraph role="heading" level="3" id="hd_id3150886" xml-lang="en-US">Value</paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/val1" xml-lang="en-US" id="bm_id3152990" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/val2" xml-lang="en-US" id="bm_id3152994" localize="false"/><bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/val3" xml-lang="en-US" id="bm_id3150370" localize="false"/><h3 id="hd_id3150886">Value</h3> <paragraph role="paragraph" id="par_id3155506" xml-lang="en-US"><ahelp hid=".">Select the value that you want to compare to the selected field.</ahelp></paragraph> <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/more" xml-lang="en-US" id="bm_id3152987" localize="false"/><paragraph id="hd_id3146980" role="heading" level="2" xml-lang="en-US"><link href="text/scalc/01/12090104.xhp">Options</link></paragraph> <embed href="text/scalc/01/12090104.xhp#zusaetzetext"/> diff --git a/source/text/scalc/01/12090104.xhp b/source/text/scalc/01/12090104.xhp index 95d7b763f3..1528444f16 100644 --- a/source/text/scalc/01/12090104.xhp +++ b/source/text/scalc/01/12090104.xhp @@ -35,15 +35,15 @@ <paragraph id="hd_id3149119" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12090104.xhp">Options</link></paragraph> <paragraph role="paragraph" id="par_id3147102" xml-lang="en-US"><variable id="zusaetzetext"><ahelp hid="modules/scalc/ui/pivotfilterdialog/more" visibility="visible">Displays or hides additional filtering options.</ahelp></variable></paragraph> - <paragraph role="heading" level="2" id="hd_id3147008" xml-lang="en-US">Options</paragraph> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/case" xml-lang="en-US" id="bm_id3153562" localize="false"/><paragraph role="heading" level="3" id="hd_id3153662" xml-lang="en-US">Case sensitive</paragraph> + <h2 id="hd_id3147008">Options</h2> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/case" xml-lang="en-US" id="bm_id3153562" localize="false"/><h3 id="hd_id3153662">Case sensitive</h3> <paragraph role="paragraph" id="par_id3145673" xml-lang="en-US"><ahelp hid="." visibility="visible">Distinguishes between uppercase and lowercase letters.</ahelp></paragraph> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/regexp" xml-lang="en-US" id="bm_id3153881" localize="false"/><paragraph role="heading" level="3" id="hd_id3156327" xml-lang="en-US">Regular Expression</paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/regexp" xml-lang="en-US" id="bm_id3153881" localize="false"/><h3 id="hd_id3156327">Regular Expression</h3> <paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><ahelp hid="." visibility="visible">Allows you to use regular expressions in the filter definition.</ahelp></paragraph> <paragraph xml-lang="en-US" role="paragraph" id="par_id3147264">If the <emph>Regular Expression</emph> check box is selected, you can use EQUAL (=) and NOT EQUAL (<>) also in comparisons. You can also use the following functions: DCOUNTA, DGET, MATCH, COUNTIF, SUMIF, LOOKUP, VLOOKUP and HLOOKUP.</paragraph> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/unique" xml-lang="en-US" id="bm_id3150541" localize="false"/><paragraph role="heading" level="3" id="hd_id3153379" xml-lang="en-US">No duplications</paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/unique" xml-lang="en-US" id="bm_id3150541" localize="false"/><h3 id="hd_id3153379">No duplications</h3> <paragraph role="paragraph" id="par_id3154138" xml-lang="en-US"><ahelp hid="." visibility="visible">Excludes duplicate rows in the list of filtered data.</ahelp></paragraph> - <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/dbarea" xml-lang="en-US" id="bm_id3150541" localize="false"/><paragraph role="heading" level="2" id="hd_id3156282" xml-lang="en-US">Data range</paragraph> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/dbarea" xml-lang="en-US" id="bm_id3150541" localize="false"/><h2 id="hd_id3156282">Data range</h2> <paragraph role="paragraph" id="par_id3150768" xml-lang="en-US"><ahelp hid="." visibility="visible">Displays the name of the filtered data range in the table.</ahelp></paragraph> <section id="relatedtopics"> <paragraph role="paragraph" id="par_id3154011" xml-lang="en-US"><link href="text/shared/01/02100001.xhp">List of Regular Expressions</link></paragraph> diff --git a/source/text/scalc/01/12090105.xhp b/source/text/scalc/01/12090105.xhp index 88273c8912..0478e95182 100644 --- a/source/text/scalc/01/12090105.xhp +++ b/source/text/scalc/01/12090105.xhp @@ -33,37 +33,37 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafielddialog/@@nowidget@@" id="bm_id8070926" localize="false"/> <bookmark xml-lang="en-US" branch="index" id="bm_id7292397"><bookmark_value>calculating;pivot table</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3150871" xml-lang="en-US" level="1">Data field</paragraph> +<h1 id="hd_id3150871">Data field</h1> <paragraph role="paragraph" id="par_id3154124" xml-lang="en-US">The contents of this dialog is different for data fields in the <emph>Data</emph> area, and data fields in the <emph>Row</emph> or <emph>Column</emph> area of the <link href="text/scalc/01/12090102.xhp">Pivot Table</link> dialog.</paragraph> -<paragraph role="heading" id="hd_id3152596" xml-lang="en-US" level="2">Subtotals</paragraph> +<h2 id="hd_id3152596">Subtotals</h2> <paragraph role="paragraph" id="par_id3151113" xml-lang="en-US"><ahelp hid="modules/scalc/ui/pivotfielddialog/PivotFieldDialog">Specify the subtotals that you want to calculate.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3145366" xml-lang="en-US" level="3">None</paragraph> +<h3 id="hd_id3145366">None</h3> <paragraph role="paragraph" id="par_id3152576" xml-lang="en-US"><ahelp hid="modules/scalc/ui/pivotfielddialog/none">Does not calculate subtotals.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3154012" xml-lang="en-US" level="3">Automatic</paragraph> +<h3 id="hd_id3154012">Automatic</h3> <paragraph role="paragraph" id="par_id3155856" xml-lang="en-US"><ahelp hid="modules/scalc/ui/pivotfielddialog/auto">Automatically calculates subtotals.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3155411" xml-lang="en-US" level="3">User-defined</paragraph> +<h3 id="hd_id3155411">User-defined</h3> <paragraph role="paragraph" id="par_id3149581" xml-lang="en-US"><ahelp hid="modules/scalc/ui/pivotfielddialog/user">Select this option, and then click the type of subtotal that you want to calculate in the list.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivotfielddialog/functions" id="bm_id3145799" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafielddialog/functions" id="bm_id1523789" localize="false"/> -<paragraph role="heading" id="hd_id3147124" xml-lang="en-US" level="3">Function</paragraph> +<h3 id="hd_id3147124">Function</h3> <paragraph role="paragraph" id="par_id3154490" xml-lang="en-US"><ahelp hid=".">Click the type of subtotal that you want to calculate. This option is only available if the <emph>User-defined</emph> option is selected.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivotfielddialog/showall" id="bm_id3154015" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafielddialog/checkbutton1" id="bm_id1523790" localize="false"/> -<paragraph role="heading" id="hd_id3154944" xml-lang="en-US" level="2">Show items without data</paragraph> +<h2 id="hd_id3154944">Show items without data</h2> <paragraph role="paragraph" id="par_id3149403" xml-lang="en-US"><ahelp hid=".">Includes empty columns and rows in the results table.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3149122" xml-lang="en-US" level="2">Name:</paragraph> +<h2 id="hd_id3149122">Name:</h2> <paragraph role="paragraph" id="par_id3150749" xml-lang="en-US">Lists the name of the selected data field.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafielddialog/expander" id="bm_id4281746" localize="false"/> -<paragraph role="heading" id="par_idN106EC" xml-lang="en-US" level="2">More</paragraph> +<h2 id="par_idN106EC">More</h2> <paragraph role="paragraph" id="par_idN106F0" xml-lang="en-US"><ahelp hid=".">Expands or reduces the dialog. The <emph>More</emph> button is visible for data fields only.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/pivotfielddialog/options" id="bm_id2855922" localize="false"/> -<paragraph role="heading" id="par_idN106F3" xml-lang="en-US" level="2">Options</paragraph> +<h2 id="par_idN106F3">Options</h2> <paragraph role="paragraph" id="par_idN106F7" xml-lang="en-US"><ahelp hid=".">Opens the <link href="text/scalc/01/12090106.xhp">Data Field Options</link> dialog. The <emph>Options</emph> button is visible for filters and column or row fields only.</ahelp></paragraph> <paragraph role="paragraph" id="par_idN10708" xml-lang="en-US">If the dialog is expanded by the <emph>More</emph> button, the following items are added to the dialog:</paragraph> -<paragraph role="heading" id="par_idN1070B" xml-lang="en-US" level="2">Displayed value</paragraph> +<h2 id="par_idN1070B">Displayed value</h2> <paragraph role="paragraph" id="par_idN1070F" xml-lang="en-US"><ahelp hid=".">For each data field, you can select the type of display.</ahelp> For some types you can select additional information for a base field and a base item.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafielddialog/type" id="bm_id3325907" localize="false"/> -<paragraph role="heading" id="par_idN10712" xml-lang="en-US" level="3">Type</paragraph> +<h3 id="par_idN10712">Type</h3> <paragraph role="paragraph" id="par_idN10716" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafielddialog/type">Select the type of calculating of the displayed value for the data field.</ahelp></paragraph> <table id=""> <tablerow> @@ -159,10 +159,10 @@ </table> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafielddialog/basefield" id="bm_id7005523" localize="false"/> -<paragraph role="heading" id="par_idN107BA" xml-lang="en-US" level="3">Base field</paragraph> +<h3 id="par_idN107BA">Base field</h3> <paragraph role="paragraph" id="par_idN107BE" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafielddialog/basefield">Select the field from which the respective value is taken as base for the calculation.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafielddialog/baseitem" id="bm_id8070925" localize="false"/> -<paragraph role="heading" id="par_idN107C1" xml-lang="en-US" level="3">Base item</paragraph> +<h3 id="par_idN107C1">Base item</h3> <paragraph role="paragraph" id="par_idN107C5" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafielddialog/baseitem">Select the item of the base field from which the respective value is taken as base for the calculation.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12090106.xhp b/source/text/scalc/01/12090106.xhp index 2cde7124c4..ea15c556ba 100644 --- a/source/text/scalc/01/12090106.xhp +++ b/source/text/scalc/01/12090106.xhp @@ -35,35 +35,35 @@ <bookmark_value>data field options for pivot table</bookmark_value> </bookmark><comment>mw changed "hiding..." entry</comment> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/@@nowidget@@" id="@@nowidget@@" localize="false"/> -<paragraph role="heading" id="par_idN10542" xml-lang="en-US" level="1">Data Field Options</paragraph> +<h1 id="par_idN10542">Data Field Options</h1> <paragraph role="paragraph" id="par_idN10546" xml-lang="en-US">You can specify additional options for column, row, and page data fields in the <link href="text/scalc/01/12090105.xhp">pivot table</link>.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/sortby" id="bm_id6588335" localize="false"/><paragraph role="heading" id="par_idN10557" xml-lang="en-US" level="2">Sort by</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/sortby" id="bm_id6588335" localize="false"/><h2 id="par_idN10557">Sort by</h2> <paragraph role="paragraph" id="par_idN1055B" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/sortby">Select the data field that you want to sort columns or rows by.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/ascending" id="bm_id6422009" localize="false"/><paragraph role="heading" id="par_idN1055E" xml-lang="en-US" level="3">Ascending</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/ascending" id="bm_id6422009" localize="false"/><h3 id="par_idN1055E">Ascending</h3> <paragraph role="paragraph" id="par_idN10562" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/ascending">Sorts the values from the lowest value to the highest value. If the selected field is the field for which the dialog was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/descending" id="bm_id1683706" localize="false"/><paragraph role="heading" id="par_idN10565" xml-lang="en-US" level="3">Descending</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/descending" id="bm_id1683706" localize="false"/><h3 id="par_idN10565">Descending</h3> <paragraph role="paragraph" id="par_idN10569" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/descending">Sorts the values descending from the highest value to the lowest value. If the selected field is the field for which the dialog was opened, the items are sorted by name. If a data field was selected, the items are sorted by the resultant value of the selected data field.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/manual" id="bm_id9101840" localize="false"/><paragraph role="heading" id="par_idN1056C" xml-lang="en-US" level="3">Manual</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/manual" id="bm_id9101840" localize="false"/><h3 id="par_idN1056C">Manual</h3> <paragraph role="paragraph" id="par_idN10570" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/manual">Sorts values alphabetically.</ahelp><comment>UFI: see spec doc. Currently set to alphabetically.</comment></paragraph> -<paragraph role="heading" id="par_idN10585" xml-lang="en-US" level="2">Display options</paragraph> +<h2 id="par_idN10585">Display options</h2> <paragraph role="paragraph" id="par_idN10589" xml-lang="en-US">You can specify the display options for all row fields except for the last, innermost row field.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/layout" id="bm_id113223" localize="false"/><paragraph role="heading" id="par_idN1058C" xml-lang="en-US" level="3">Layout</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/layout" id="bm_id113223" localize="false"/><h3 id="par_idN1058C">Layout</h3> <paragraph role="paragraph" id="par_idN10590" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/layout">Select the layout mode for the field in the list box.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/emptyline" id="bm_id2646870" localize="false"/><paragraph role="heading" id="par_idN10593" xml-lang="en-US" level="3">Empty line after each item</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/emptyline" id="bm_id2646870" localize="false"/><h3 id="par_idN10593">Empty line after each item</h3> <paragraph role="paragraph" id="par_idN10597" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/emptyline">Adds an empty row after the data for each item in the pivot table.</ahelp></paragraph> -<paragraph role="heading" id="par_idN1059A" xml-lang="en-US" level="2">Show automatically</paragraph> +<h2 id="par_idN1059A">Show automatically</h2> <paragraph role="paragraph" id="par_idN1059E" xml-lang="en-US">Displays the top or bottom nn items when you sort by a specified field.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/show" id="bm_id4634540" localize="false"/><paragraph role="heading" id="par_idN105A1" xml-lang="en-US" level="3">Show</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/show" id="bm_id4634540" localize="false"/><h3 id="par_idN105A1">Show</h3> <paragraph role="paragraph" id="par_idN105A5" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/show">Turns on the automatic show feature.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/items" id="bm_id6690878" localize="false"/><paragraph role="heading" id="par_idN105A8" xml-lang="en-US" level="4">items</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/items" id="bm_id6690878" localize="false"/><h4 id="par_idN105A8">items</h4> <paragraph role="paragraph" id="par_idN105AC" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/items">Enter the maximum number of items that you want to show automatically.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/from" id="bm_id9420148" localize="false"/><paragraph role="heading" id="par_idN105AF" xml-lang="en-US" level="4">From</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/from" id="bm_id9420148" localize="false"/><h4 id="par_idN105AF">From</h4> <paragraph role="paragraph" id="par_idN105B3" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/from">Shows the top or bottom items in the specified sort order.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/using" id="bm_id923184" localize="false"/><paragraph role="heading" id="par_idN105B6" xml-lang="en-US" level="4">Using field</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/using" id="bm_id923184" localize="false"/><h4 id="par_idN105B6">Using field</h4> <paragraph role="paragraph" id="par_idN105BA" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/using">Select the data field that you want to sort the data by.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/hideitems" id="bm_id2068849" localize="false"/><paragraph role="heading" id="par_idN105BD" xml-lang="en-US" level="2">Hide items</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/hideitems" id="bm_id2068849" localize="false"/><h2 id="par_idN105BD">Hide items</h2> <paragraph role="paragraph" id="par_idN105C1" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/hideitems">Select the items that you want to hide from the calculations.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/hierarchy" id="bm_id6507461" localize="false"/><paragraph role="heading" id="par_idN105C4" xml-lang="en-US" level="3">Hierarchy</paragraph> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/datafieldoptionsdialog/hierarchy" id="bm_id6507461" localize="false"/><h3 id="par_idN105C4">Hierarchy</h3> <paragraph role="paragraph" id="par_idN105C8" xml-lang="en-US"><ahelp hid="modules/scalc/ui/datafieldoptionsdialog/hierarchy">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp></paragraph> <note id="par_id681598453957935">Calc does not provide multiple hierarchies for a single field and so this option is normally grayed. If you use a pivot table data source extension, that extension could define multiple hierarchies for some fields and then the option could become available. See the documentation supplied with that extension for more details.</note> </body> diff --git a/source/text/scalc/01/12090400.xhp b/source/text/scalc/01/12090400.xhp index 4a4cfc4d28..b4006ec09f 100644 --- a/source/text/scalc/01/12090400.xhp +++ b/source/text/scalc/01/12090400.xhp @@ -27,28 +27,28 @@ </topic> </meta> <body> -<paragraph role="heading" id="par_idN1054D" xml-lang="en-US" level="1">Grouping</paragraph> +<h1 id="par_idN1054D">Grouping</h1> <paragraph role="paragraph" id="par_idN10551" xml-lang="en-US">Grouping pivot tables displays the <emph>Grouping</emph> dialog for either values or dates.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#grouping"/> </section> -<paragraph role="heading" id="par_idN10568" xml-lang="en-US" level="2">Start</paragraph> +<h2 id="par_idN10568">Start</h2> <paragraph role="paragraph" id="par_idN1056C" xml-lang="en-US">Specifies the start of the grouping.</paragraph> -<paragraph role="heading" id="par_idN1056F" xml-lang="en-US" level="3">Automatically</paragraph> +<h3 id="par_idN1056F">Automatically</h3> <paragraph role="paragraph" id="par_idN10573" xml-lang="en-US">Specifies whether to start grouping at the smallest value.</paragraph> -<paragraph role="heading" id="par_idN10576" xml-lang="en-US" level="3">Manually at</paragraph> +<h3 id="par_idN10576">Manually at</h3> <paragraph role="paragraph" id="par_idN1057A" xml-lang="en-US">Specifies whether to enter the start value for grouping yourself.</paragraph> -<paragraph role="heading" id="par_idN1057D" xml-lang="en-US" level="2">End</paragraph> +<h2 id="par_idN1057D">End</h2> <paragraph role="paragraph" id="par_idN10581" xml-lang="en-US">Specifies the end of the grouping.</paragraph> -<paragraph role="heading" id="par_idN10584" xml-lang="en-US" level="3">Automatically</paragraph> +<h3 id="par_idN10584">Automatically</h3> <paragraph role="paragraph" id="par_idN10588" xml-lang="en-US">Specifies whether to end grouping at the largest value.</paragraph> -<paragraph role="heading" id="par_idN1058B" xml-lang="en-US" level="3">Manually at</paragraph> +<h3 id="par_idN1058B">Manually at</h3> <paragraph role="paragraph" id="par_idN1058F" xml-lang="en-US">Specifies whether to enter the end value for grouping yourself.</paragraph> -<paragraph role="heading" id="par_idN10592" xml-lang="en-US" level="2">Group by</paragraph> +<h2 id="par_idN10592">Group by</h2> <paragraph role="paragraph" id="par_idN10596" xml-lang="en-US">Specifies the value range by which every group's limits are calculated.</paragraph> -<paragraph role="heading" id="par_idN10599" xml-lang="en-US" level="3">Number of days</paragraph> +<h3 id="par_idN10599">Number of days</h3> <paragraph role="paragraph" id="par_idN1059D" xml-lang="en-US">In the case of grouping date values, specifies the number of days to group by.</paragraph> -<paragraph role="heading" id="par_idN105A0" xml-lang="en-US" level="3">Intervals</paragraph> +<h3 id="par_idN105A0">Intervals</h3> <paragraph role="paragraph" id="par_idN105A4" xml-lang="en-US">In the case of grouping date values, specifies the intervals to group by.</paragraph> <section id="relatedtopics"> <paragraph role="paragraph" id="par_idN105B2" xml-lang="en-US" localize="false"> diff --git a/source/text/scalc/01/12120100.xhp b/source/text/scalc/01/12120100.xhp index 0acf0d1fa9..d54d62edbf 100644 --- a/source/text/scalc/01/12120100.xhp +++ b/source/text/scalc/01/12120100.xhp @@ -140,18 +140,18 @@ <h2 id="par_idN1073F" xml-lang="en-US">Source</h2> <paragraph role="paragraph" id="par_idN10743" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/min">Enter the cell range that contains the valid values or text.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/minlist" id="bm_id5921506" localize="false"/> -<paragraph role="heading" id="par_idN1075A" xml-lang="en-US" level="2">Entries</paragraph> +<h2 id="par_idN1075A">Entries</h2> <paragraph role="paragraph" id="par_idN1075E" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/minlist">Enter the entries that will be valid values or text strings.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/data" id="bm_id3147344" localize="false"/> -<paragraph role="heading" id="hd_id3163807" xml-lang="en-US" level="2">Data</paragraph> +<h2 id="hd_id3163807">Data</h2> <paragraph role="paragraph" id="par_id3144502" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/data">Select the comparative operator that you want to use.</ahelp> The available operators depend on what you selected in the <emph>Allow </emph>box. If you select "between" or "not between", the <emph>Minimum</emph> and <emph>Maximum</emph> input boxes appear. Otherwise, only the <emph>Minimum</emph>, the <emph>Maximum</emph>, or the <emph>Value</emph> input boxes appear.</paragraph> -<paragraph role="heading" id="hd_id3153782" xml-lang="en-US" level="2">Value</paragraph> +<h2 id="hd_id3153782">Value</h2> <paragraph role="paragraph" id="par_id3153266" xml-lang="en-US">Enter the value for the data validation option that you selected in the <emph>Allow </emph>box.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/min" id="bm_id3149528" localize="false"/> <h2 id="hd_id3149814" xml-lang="en-US">Minimum</h2> <paragraph role="paragraph" id="par_id3153199" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/min">Enter the minimum value for the data validation option that you selected in the <emph>Allow </emph>box.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/max" id="bm_id3150206" localize="false"/> -<paragraph role="heading" id="hd_id3149035" xml-lang="en-US" level="2">Maximum</paragraph> +<h2 id="hd_id3149035">Maximum</h2> <paragraph role="paragraph" id="par_id3150089" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/max">Enter the maximum value for the data validation option that you selected in the <emph>Allow </emph>box.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12120200.xhp b/source/text/scalc/01/12120200.xhp index acdca60051..d2bbf4a434 100644 --- a/source/text/scalc/01/12120200.xhp +++ b/source/text/scalc/01/12120200.xhp @@ -40,15 +40,15 @@ <embed href="text/scalc/00/00000412.xhp#datengueltigeingabe"/> </section> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationhelptabpage/tsbhelp" id="bm_id3149260" localize="false"/> -<paragraph role="heading" id="hd_id3146986" xml-lang="en-US" level="2">Show input help when cell is selected</paragraph> +<h2 id="hd_id3146986">Show input help when cell is selected</h2> <paragraph role="paragraph" id="par_id3153363" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationhelptabpage/tsbhelp">Displays the message that you enter in the <emph>Contents</emph> box when the cell or cell range is selected in the sheet.</ahelp></paragraph> <paragraph role="warning" id="par_id3154730" xml-lang="en-US">If you enter text in the <emph>Contents</emph> box of this dialog, and then select and clear this check box, the text will be lost.</paragraph> -<paragraph role="heading" id="hd_id3147394" xml-lang="en-US" level="2">Contents</paragraph> +<h2 id="hd_id3147394">Contents</h2> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationhelptabpage/title" id="bm_id3149377" localize="false"/> -<paragraph role="heading" id="hd_id3149582" xml-lang="en-US" level="3">Title</paragraph> +<h3 id="hd_id3149582">Title</h3> <paragraph role="paragraph" id="par_id3149400" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationhelptabpage/title">Enter the title that you want to display when the cell or cell range is selected.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationhelptabpage/inputhelp" id="bm_id3156275" localize="false"/> -<paragraph role="heading" id="hd_id3149121" xml-lang="en-US" level="3">Input help</paragraph> +<h3 id="hd_id3149121">Input help</h3> <paragraph role="paragraph" id="par_id3150752" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationhelptabpage/inputhelp">Enter the message that you want to display when the cell or cell range is selected.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12120300.xhp b/source/text/scalc/01/12120300.xhp index c9952422f6..f887153b77 100644 --- a/source/text/scalc/01/12120300.xhp +++ b/source/text/scalc/01/12120300.xhp @@ -39,21 +39,21 @@ <embed href="text/scalc/00/00000412.xhp#datengueltigfehler"/> </section> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/erroralerttabpage/tsbshow" id="bm_id3154908" localize="false"/> -<paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="2">Show error message when invalid values are entered.</paragraph> +<h2 id="hd_id3156280">Show error message when invalid values are entered.</h2> <paragraph role="paragraph" id="par_id3150768" xml-lang="en-US"><ahelp hid=".">Displays the error message that you enter in the <emph>Contents</emph> area when invalid data is entered in a cell.</ahelp> If enabled, the message is displayed to prevent an invalid entry.</paragraph> <paragraph role="paragraph" id="par_id3146984" xml-lang="en-US">In both cases, if you select "Stop", the invalid entry is deleted and the previous value is reentered in the cell. The same applies if you close the "Warning" and "Information" dialogs by clicking the <emph>Cancel </emph>button. If you close the dialogs with the <emph>OK</emph> button, the invalid entry is not deleted.</paragraph> -<paragraph role="heading" id="hd_id3152460" xml-lang="en-US" level="2">Contents</paragraph> +<h2 id="hd_id3152460">Contents</h2> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/erroralerttabpage/actionCB" id="bm_id3154014" localize="false"/> -<paragraph role="heading" id="hd_id3148646" xml-lang="en-US" level="3">Action</paragraph> +<h3 id="hd_id3148646">Action</h3> <paragraph role="paragraph" id="par_id3151115" xml-lang="en-US"><ahelp hid="modules/scalc/ui/erroralerttabpage/actionCB">Select the action that you want to occur when invalid data is entered in a cell.</ahelp> The "Stop" action rejects the invalid entry and displays a dialog that you have to close by clicking <emph>OK</emph>. The "Warning" and "Information" actions display a dialog that can be closed by clicking <emph>OK</emph> or <emph>Cancel</emph>. The invalid entry is only rejected when you click <emph>Cancel</emph>.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/erroralerttabpage/browseBtn" id="bm_id3154729" localize="false"/> -<paragraph role="heading" id="hd_id3156441" xml-lang="en-US" level="3">Browse</paragraph> +<h3 id="hd_id3156441">Browse</h3> <paragraph role="paragraph" id="par_id3153160" xml-lang="en-US"><ahelp hid="modules/scalc/ui/erroralerttabpage/browseBtn">Opens the <link href="text/shared/01/06130000.xhp">Macro</link> dialog where you can select the macro that is executed when invalid data is entered in a cell. The macro is executed after the error message is displayed.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/erroralerttabpage/title" id="bm_id3149958" localize="false"/> -<paragraph role="heading" id="hd_id3153876" xml-lang="en-US" level="3">Title</paragraph> +<h3 id="hd_id3153876">Title</h3> <paragraph role="paragraph" id="par_id3149410" xml-lang="en-US"><ahelp hid="modules/scalc/ui/erroralerttabpage/title">Enter the title of the macro or the error message that you want to display when invalid data is entered in a cell.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/erroralerttabpage/errorMsg" id="bm_id3153836" localize="false"/> -<paragraph role="heading" id="hd_id3154510" xml-lang="en-US" level="3">Error message</paragraph> +<h3 id="hd_id3154510">Error message</h3> <paragraph role="paragraph" id="par_id3149122" xml-lang="en-US"><ahelp hid="modules/scalc/ui/erroralerttabpage/errorMsg">Enter the message that you want to display when invalid data is entered in a cell.</ahelp></paragraph> <h3 id="hd_id881545240342781">Sample macro:</h3> <paragraph role="paragraph" id="par_id521625929022780">Below is a sample function that can be called when an error occurs. Note that the macro takes in two parameters that are passed on by %PRODUCTNAME when the function is called:</paragraph> diff --git a/source/text/scalc/01/format_graphic.xhp b/source/text/scalc/01/format_graphic.xhp index 01f17a2d7e..4dc9a68312 100644 --- a/source/text/scalc/01/format_graphic.xhp +++ b/source/text/scalc/01/format_graphic.xhp @@ -40,7 +40,7 @@ <embed href="text/shared/01/05210000.xhp#area"/> <paragraph role="heading" id="par_id1650440" xml-lang="en-US" level="2"><link href="text/shared/01/05990000.xhp">Define Text Attributes</link></paragraph> <paragraph role="paragraph" id="par_id363475" xml-lang="en-US">Sets the layout and anchoring properties for text in the selected drawing or text object.</paragraph> -<paragraph role="heading" id="par_id9746696" xml-lang="en-US" level="2">Points</paragraph> +<h2 id="par_id9746696">Points</h2> <paragraph role="paragraph" id="par_id2480544" xml-lang="en-US"><ahelp hid=".">Switches <emph>Edit Points</emph> mode for an inserted freeform line on and off.</ahelp></paragraph> </body> </helpdocument> 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> |