diff options
Diffstat (limited to 'source/text/scalc')
94 files changed, 126 insertions, 126 deletions
diff --git a/source/text/scalc/00/00000004.xhp b/source/text/scalc/00/00000004.xhp index 640164de3b..80966c4d35 100644 --- a/source/text/scalc/00/00000004.xhp +++ b/source/text/scalc/00/00000004.xhp @@ -25,7 +25,7 @@ </topic> </meta> <body> -<paragraph role="heading" id="hd_id3155535" xml-lang="en-US" level="1"><variable id="wie">To access this function...</variable></paragraph> +<h1 id="hd_id3155535"><variable id="wie">To access this function...</variable></h1> <paragraph role="paragraph" id="par_idN1056E" xml-lang="en-US"><variable id="moreontop">More explanations on top of this page.</variable></paragraph> <paragraph role="note" id="par_idN105AF" xml-lang="en-US"><variable id="optional">In the %PRODUCTNAME Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.</variable><comment>UFI: see #i43239# and #i3879#</comment></paragraph> <paragraph role="paragraph" id="par_id9751884" xml-lang="en-US"><variable id="codes">Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable.</variable></paragraph> diff --git a/source/text/scalc/01/01120000.xhp b/source/text/scalc/01/01120000.xhp index c6da1a179c..c243e35549 100644 --- a/source/text/scalc/01/01120000.xhp +++ b/source/text/scalc/01/01120000.xhp @@ -31,7 +31,7 @@ <body> <section id="printpreview"> <bookmark xml-lang="en-US" branch="hid/.uno:PrintPreview" id="bm_id2822117" localize="false"/> -<paragraph role="heading" id="hd_id1918698" xml-lang="en-US" level="1"><link href="text/scalc/01/01120000.xhp">Print Preview</link></paragraph> +<h1 id="hd_id1918698"><link href="text/scalc/01/01120000.xhp">Print Preview</link></h1> <paragraph role="paragraph" id="par_id3831598" xml-lang="en-US"><ahelp hid=".uno:PrintPreview">Displays a preview of the printed page or closes the preview.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02120000.xhp b/source/text/scalc/01/02120000.xhp index bd399d1dc9..4958762a95 100644 --- a/source/text/scalc/01/02120000.xhp +++ b/source/text/scalc/01/02120000.xhp @@ -27,7 +27,7 @@ <body> <section id="headers_footers"> <bookmark xml-lang="en-US" branch="hid/.uno:EditHeaderAndFooter" id="bm_id6105651" localize="false"/> -<paragraph id="hd_id3145251" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/02120000.xhp">Headers & Footers</link></paragraph> +<h1 id="hd_id3145251"><link href="text/scalc/01/02120000.xhp">Headers & Footers</link></h1> <paragraph id="par_id3151073" role="paragraph" xml-lang="en-US"><variable id="kopfundfusszeilentext"><ahelp hid=".">Allows you to define and format headers and footers.</ahelp> </variable></paragraph> </section> <paragraph id="par_id3153415" role="paragraph" xml-lang="en-US">The <emph>Headers/Footers</emph> dialog contains the tabs for defining headers and footers. There will be separate tabs for the left and right page headers and footers if the <emph>Same content left/right</emph> option was not marked in the <link href="text/scalc/01/05070000.xhp"><emph>Page Style</emph></link> dialog.</paragraph> diff --git a/source/text/scalc/01/02120100.xhp b/source/text/scalc/01/02120100.xhp index 76e5e92d51..118ed0b3bf 100644 --- a/source/text/scalc/01/02120100.xhp +++ b/source/text/scalc/01/02120100.xhp @@ -38,7 +38,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/HeaderFooterContent" id="bm_id3156422" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/headerfootercontent/@@nowidget@@" id="bm_id3156422" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3153360" role="heading" level="1"><link href="text/scalc/01/02120100.xhp">Header/Footer</link></paragraph> +<h1 id="hd_id3153360"><link href="text/scalc/01/02120100.xhp">Header/Footer</link></h1> <paragraph xml-lang="en-US" id="par_id3150768" role="paragraph"><ahelp hid="modules/scalc/ui/headerfootercontent/HeaderFooterContent">Defines or formats a header or footer for a Page Style.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02140000.xhp b/source/text/scalc/01/02140000.xhp index 010bbb7d15..b34f0e9a08 100644 --- a/source/text/scalc/01/02140000.xhp +++ b/source/text/scalc/01/02140000.xhp @@ -32,7 +32,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id8473769"><bookmark_value>filling;selection lists</bookmark_value> <bookmark_value>selection lists;filling cells</bookmark_value> </bookmark><comment>MW inserted 2 index entries</comment> -<paragraph xml-lang="en-US" id="hd_id3153876" role="heading" level="1"><link href="text/scalc/01/02140000.xhp">Fill</link></paragraph> +<h1 id="hd_id3153876"><link href="text/scalc/01/02140000.xhp">Fill</link></h1> <paragraph xml-lang="en-US" id="par_id3156285" role="paragraph"><ahelp hid=".">Automatically fills cells with content.</ahelp></paragraph> </section> <section id="howtoget"> @@ -43,9 +43,9 @@ <embed href="text/scalc/01/02140200.xhp#right"/> <embed href="text/scalc/01/02140300.xhp#up"/> <embed href="text/scalc/01/02140400.xhp#left"/> - <paragraph xml-lang="en-US" id="hd_id3149207" role="heading" level="2"><link href="text/scalc/01/02140500.xhp">Sheet</link></paragraph> + <h2 id="hd_id3149207"><link href="text/scalc/01/02140500.xhp">Sheet</link></h2> <embed href="text/scalc/01/02140500.xhp#tabellenfuellentext"/> - <paragraph xml-lang="en-US" id="hd_id3155111" role="heading" level="2"><link href="text/scalc/01/02140600.xhp">Series</link></paragraph> + <h2 id="hd_id3155111"><link href="text/scalc/01/02140600.xhp">Series</link></h2> <embed href="text/scalc/01/02140600.xhp#reihenfuellentext"/> <paragraph xml-lang="en-US" id="par_id3152994" role="paragraph"> <emph>Filling cells using context menus:</emph> diff --git a/source/text/scalc/01/02140100.xhp b/source/text/scalc/01/02140100.xhp index 2ea089ddee..87d7aabfb5 100644 --- a/source/text/scalc/01/02140100.xhp +++ b/source/text/scalc/01/02140100.xhp @@ -34,7 +34,7 @@ <section id="down"> <bookmark branch="hid/.uno:FillDown" xml-lang="en-US" id="bm_id3145173" localize="false"/> -<paragraph id="hd_id3150792" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/02140100.xhp">Down</link></paragraph> +<h1 id="hd_id3150792"><link href="text/scalc/01/02140100.xhp">Down</link></h1> <paragraph role="paragraph" id="par_id3153969" xml-lang="en-US"><ahelp hid=".uno:FillDown" visibility="visible">Fills a selected range of at least two rows with the contents of the top cell of the range.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02140200.xhp b/source/text/scalc/01/02140200.xhp index edbb6de4b0..032a93d93c 100644 --- a/source/text/scalc/01/02140200.xhp +++ b/source/text/scalc/01/02140200.xhp @@ -34,7 +34,7 @@ <section id="right"> <bookmark branch="hid/.uno:FillRight" xml-lang="en-US" id="bm_id3149456" localize="false"/> -<paragraph id="hd_id3153896" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/02140200.xhp">Right</link></paragraph> +<h1 id="hd_id3153896"><link href="text/scalc/01/02140200.xhp">Right</link></h1> <paragraph role="paragraph" id="par_id3153361" xml-lang="en-US"><ahelp hid=".uno:FillRight" visibility="visible">Fills a selected range of at least two columns with the contents of the left most cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02140300.xhp b/source/text/scalc/01/02140300.xhp index 44695cdc2c..e9757cc929 100644 --- a/source/text/scalc/01/02140300.xhp +++ b/source/text/scalc/01/02140300.xhp @@ -34,7 +34,7 @@ <section id="up"> <bookmark branch="hid/.uno:FillUp" xml-lang="en-US" id="bm_id3149456" localize="false"/> -<paragraph id="hd_id3147264" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/02140300.xhp">Up</link></paragraph> +<h1 id="hd_id3147264"><link href="text/scalc/01/02140300.xhp">Up</link></h1> <paragraph role="paragraph" id="par_id3150793" xml-lang="en-US"><ahelp hid=".uno:FillUp" visibility="visible">Fills a selected range of at least two rows with the contents of the bottom most cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02140400.xhp b/source/text/scalc/01/02140400.xhp index b109492336..36a8c51445 100644 --- a/source/text/scalc/01/02140400.xhp +++ b/source/text/scalc/01/02140400.xhp @@ -34,7 +34,7 @@ <section id="left"> <bookmark branch="hid/.uno:FillLeft" xml-lang="en-US" id="bm_id3149456" localize="false"/> -<paragraph id="hd_id3153896" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/02140400.xhp">Left</link></paragraph> +<h1 id="hd_id3153896"><link href="text/scalc/01/02140400.xhp">Left</link></h1> <paragraph role="paragraph" id="par_id3150793" xml-lang="en-US"><ahelp hid=".uno:FillLeft" visibility="visible">Fills a selected range of at least two columns with the contents of the far right cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/02150000.xhp b/source/text/scalc/01/02150000.xhp index 442e65d533..7123a47657 100644 --- a/source/text/scalc/01/02150000.xhp +++ b/source/text/scalc/01/02150000.xhp @@ -52,7 +52,7 @@ <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"/><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> +<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/deletecontents/text" id="bm_id3147394" localize="false"/><h3 id="hd_id3156286">Text<comment>i50439</comment></h3> <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"/><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> diff --git a/source/text/scalc/01/02190000.xhp b/source/text/scalc/01/02190000.xhp index e076a34daf..a51a85b921 100644 --- a/source/text/scalc/01/02190000.xhp +++ b/source/text/scalc/01/02190000.xhp @@ -30,7 +30,7 @@ <section id="del_page_break"> <bookmark xml-lang="en-US" branch="hid/.uno:DelBreakMenu" id="bm_id8417004" localize="false"/> -<paragraph id="hd_id3150541" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/02190000.xhp">Delete Page Break</link></paragraph> +<h1 id="hd_id3150541"><link href="text/scalc/01/02190000.xhp">Delete Page Break</link></h1> <paragraph id="par_id3154365" role="paragraph" xml-lang="en-US"><ahelp hid=".">Choose the type of page break that you want to delete.</ahelp></paragraph> </section> diff --git a/source/text/scalc/01/02190100.xhp b/source/text/scalc/01/02190100.xhp index a5410f226b..31c47dbf97 100644 --- a/source/text/scalc/01/02190100.xhp +++ b/source/text/scalc/01/02190100.xhp @@ -36,7 +36,7 @@ <bookmark_value>row breaks; deleting</bookmark_value> </bookmark><comment>MW deleted "removing;..." and changed "deleting;...!</comment> <bookmark xml-lang="en-US" branch="hid/.uno:DeleteRowbreak" id="bm_id6936520" localize="false"/> -<paragraph role="heading" id="hd_id3156326" xml-lang="en-US" level="1"><link href="text/scalc/01/02190100.xhp">Row Break</link></paragraph> +<h1 id="hd_id3156326"><link href="text/scalc/01/02190100.xhp">Row Break</link></h1> <paragraph role="paragraph" id="par_id3154366" xml-lang="en-US"><ahelp hid=".uno:DeleteRowbreak">Removes the manual row break above the active cell.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3151041" xml-lang="en-US">Position the cursor in a cell directly below the row break indicated by a horizontal line and choose <emph>Sheet - Delete Page Break - Row Break</emph>. The manual row break is removed.</paragraph> diff --git a/source/text/scalc/01/02190200.xhp b/source/text/scalc/01/02190200.xhp index 0b7ed13642..45482adc18 100644 --- a/source/text/scalc/01/02190200.xhp +++ b/source/text/scalc/01/02190200.xhp @@ -42,7 +42,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:DeleteColumnbreak" id="bm_id2513425" localize="false"/> - <paragraph xml-lang="en-US" id="hd_id3151384" role="heading" level="1"><link href="text/scalc/01/02190200.xhp">Column Break</link></paragraph> + <h1 id="hd_id3151384"><link href="text/scalc/01/02190200.xhp">Column Break</link></h1> <paragraph xml-lang="en-US" id="par_id3154124" role="paragraph"><ahelp hid=".uno:DeleteColumnbreak">Removes a manual column break to the left of the active cell.</ahelp></paragraph> </section> diff --git a/source/text/scalc/01/02200000.xhp b/source/text/scalc/01/02200000.xhp index 83d0bacb08..afb4d69071 100644 --- a/source/text/scalc/01/02200000.xhp +++ b/source/text/scalc/01/02200000.xhp @@ -31,7 +31,7 @@ <section id="sheet"> <bookmark xml-lang="en-US" branch="hid/.uno:EditSheetMenu" id="bm_id8190862" localize="false"/> -<paragraph id="hd_id3146794" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/02200000.xhp">Sheet</link></paragraph> +<h1 id="hd_id3146794"><link href="text/scalc/01/02200000.xhp">Sheet</link></h1> <paragraph id="par_id3149456" role="paragraph" xml-lang="en-US"><ahelp hid=".">Edit commands for entire sheets.</ahelp></paragraph> </section> </body> diff --git a/source/text/scalc/01/03070000.xhp b/source/text/scalc/01/03070000.xhp index 451ec69220..289bb82cf2 100644 --- a/source/text/scalc/01/03070000.xhp +++ b/source/text/scalc/01/03070000.xhp @@ -36,7 +36,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:ViewRowColumnHeaders" id="bm_id4366858" localize="false"/> -<paragraph id="hd_id3156024" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/03070000.xhp">Column & Row Headers</link></paragraph> +<h1 id="hd_id3156024"><link href="text/scalc/01/03070000.xhp">Column & Row Headers</link></h1> <paragraph id="par_id3147230" role="paragraph" xml-lang="en-US"><ahelp hid=".">Shows column headers and row headers.</ahelp></paragraph> </section> diff --git a/source/text/scalc/01/03080000.xhp b/source/text/scalc/01/03080000.xhp index 8956912db9..e8e5c07392 100644 --- a/source/text/scalc/01/03080000.xhp +++ b/source/text/scalc/01/03080000.xhp @@ -38,7 +38,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:ViewValueHighlighting" id="bm_id3145068" localize="false"/> -<paragraph id="hd_id3151384" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/03080000.xhp">Value Highlighting</link></paragraph> +<h1 id="hd_id3151384"><link href="text/scalc/01/03080000.xhp">Value Highlighting</link></h1> <paragraph id="par_id3154366" role="paragraph" xml-lang="en-US"><ahelp hid=".">Displays cell contents in different colors, depending on type.</ahelp></paragraph> </section> <paragraph id="par_id3125863" role="paragraph" xml-lang="en-US">To remove the highlighting, unmark the menu entry.</paragraph> diff --git a/source/text/scalc/01/03090000.xhp b/source/text/scalc/01/03090000.xhp index a7b4c13ea5..c925dc7f5d 100644 --- a/source/text/scalc/01/03090000.xhp +++ b/source/text/scalc/01/03090000.xhp @@ -36,7 +36,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:InputLineVisible" id="bm_id268003" localize="false"/> -<paragraph id="hd_id3147264" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/03090000.xhp">Formula Bar</link></paragraph> +<h1 id="hd_id3147264"><link href="text/scalc/01/03090000.xhp">Formula Bar</link></h1> <paragraph id="par_id3156423" role="paragraph" xml-lang="en-US"><ahelp hid=".">Shows or hides the Formula Bar, which is used for entering and editing formulas. The Formula Bar is the most important tool when working with spreadsheets.</ahelp></paragraph> </section> <paragraph id="par_id3154686" role="paragraph" xml-lang="en-US">To hide the Formula Bar, unmark the menu item.</paragraph> diff --git a/source/text/scalc/01/03100000.xhp b/source/text/scalc/01/03100000.xhp index 2feeddd477..442711931c 100644 --- a/source/text/scalc/01/03100000.xhp +++ b/source/text/scalc/01/03100000.xhp @@ -31,7 +31,7 @@ <section id="page_break_view_title"> <bookmark xml-lang="en-US" branch="hid/.uno:PagebreakMode" id="bm_id3465342" localize="false"/> -<paragraph id="hd_id3151384" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/03100000.xhp">Page Break View</link></paragraph> +<h1 id="hd_id3151384"><link href="text/scalc/01/03100000.xhp">Page Break View</link></h1> <paragraph id="par_id3150792" role="paragraph" xml-lang="en-US"><variable id="page_break_view_text"><ahelp hid=".">Display the page breaks and print ranges in the sheet.</ahelp></variable> Choose <item type="menuitem">View - Normal</item> to switch this mode off.</paragraph> </section> diff --git a/source/text/scalc/01/04010000.xhp b/source/text/scalc/01/04010000.xhp index ea3759e68a..548818206f 100644 --- a/source/text/scalc/01/04010000.xhp +++ b/source/text/scalc/01/04010000.xhp @@ -36,7 +36,7 @@ <bookmark_value>page breaks; inserting in spreadsheets</bookmark_value> </bookmark><comment>mw changed "page breaks;..."</comment> <bookmark xml-lang="en-US" branch="hid/.uno:InsertBreakMenu" id="bm_id2778710" localize="false"/> -<paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="1"><link href="text/scalc/01/04010000.xhp">Insert Page Break</link></paragraph> +<h1 id="hd_id3153192"><link href="text/scalc/01/04010000.xhp">Insert Page Break</link></h1> <paragraph role="paragraph" id="par_id3125864" xml-lang="en-US"><ahelp hid=".">This command inserts manual row or column breaks to ensure that your data prints properly. You can insert a horizontal page break above, or a vertical page break to the left of, the active cell.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3155133" xml-lang="en-US">Choose <link href="text/scalc/01/02190000.xhp">Sheet - Delete Page Break</link> to remove breaks created manually.</paragraph> diff --git a/source/text/scalc/01/04010100.xhp b/source/text/scalc/01/04010100.xhp index d5ff3f05f7..83dd79005f 100644 --- a/source/text/scalc/01/04010100.xhp +++ b/source/text/scalc/01/04010100.xhp @@ -37,7 +37,7 @@ <bookmark_value>manual row breaks</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/.uno:InsertRowBreak" id="bm_id3151245" localize="false"/> -<paragraph role="heading" id="hd_id3153821" xml-lang="en-US" level="1"><link href="text/scalc/01/04010100.xhp">Row Break</link></paragraph> +<h1 id="hd_id3153821"><link href="text/scalc/01/04010100.xhp">Row Break</link></h1> <paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><ahelp hid=".uno:InsertRowBreak">Inserts a row break (horizontal page break) above the selected cell.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3156422" xml-lang="en-US">The manual row break is indicated by a dark blue horizontal line.</paragraph> diff --git a/source/text/scalc/01/04010200.xhp b/source/text/scalc/01/04010200.xhp index e680326078..925f9e2f39 100644 --- a/source/text/scalc/01/04010200.xhp +++ b/source/text/scalc/01/04010200.xhp @@ -37,7 +37,7 @@ <bookmark_value>manual column breaks</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/.uno:InsertColumnBreak" id="bm_id3148947" localize="false"/> -<paragraph role="heading" id="hd_id3155923" xml-lang="en-US" level="1"><link href="text/scalc/01/04010200.xhp">Column Break</link></paragraph> +<h1 id="hd_id3155923"><link href="text/scalc/01/04010200.xhp">Column Break</link></h1> <paragraph role="paragraph" id="par_id3150447" xml-lang="en-US"><ahelp hid=".uno:InsertColumnBreak">Inserts a column break (vertical page break) to the left of the active cell.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3145171" xml-lang="en-US">The manual column break is indicated by a dark blue vertical line.</paragraph> diff --git a/source/text/scalc/01/04030000.xhp b/source/text/scalc/01/04030000.xhp index f388b2178c..cebc717482 100644 --- a/source/text/scalc/01/04030000.xhp +++ b/source/text/scalc/01/04030000.xhp @@ -36,7 +36,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:InsertRowsBefore" id="bm_id4302477" localize="false"/> -<paragraph id="hd_id3150541" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/04030000.xhp">Insert Rows</link></paragraph> +<h1 id="hd_id3150541"><link href="text/scalc/01/04030000.xhp">Insert Rows</link></h1> <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> <h2 id="hd_id160220162131439740">Rows Above</h2> diff --git a/source/text/scalc/01/04040000.xhp b/source/text/scalc/01/04040000.xhp index 1c98f75a78..01650176ca 100644 --- a/source/text/scalc/01/04040000.xhp +++ b/source/text/scalc/01/04040000.xhp @@ -36,7 +36,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:InsertColumnsBefore" id="bm_id601010" localize="false"/> -<paragraph id="hd_id3155628" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/04040000.xhp">Insert Columns</link></paragraph> +<h1 id="hd_id3155628"><link href="text/scalc/01/04040000.xhp">Insert Columns</link></h1> <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> <h2 id="hd_id160220162139258865">Columns Before</h2> diff --git a/source/text/scalc/01/04050100.xhp b/source/text/scalc/01/04050100.xhp index 0d120c7681..ea6f804a54 100644 --- a/source/text/scalc/01/04050100.xhp +++ b/source/text/scalc/01/04050100.xhp @@ -31,7 +31,7 @@ <body> <section id="sheetfromfile"> <bookmark xml-lang="en-US" branch="hid/.uno:InsertSheetFromFile" id="bm_id1850337" localize="false"/> -<paragraph role="heading" id="par_idN105C1" xml-lang="en-US" level="1"><link href="text/scalc/01/04050100.xhp">Sheet from file</link></paragraph> +<h1 id="par_idN105C1"><link href="text/scalc/01/04050100.xhp">Sheet from file</link></h1> <paragraph role="paragraph" id="par_idN105D1" xml-lang="en-US"><ahelp hid=".">Inserts a sheet from a different spreadsheet file.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/04060100.xhp b/source/text/scalc/01/04060100.xhp index 138ebcd90a..068494b934 100644 --- a/source/text/scalc/01/04060100.xhp +++ b/source/text/scalc/01/04060100.xhp @@ -33,25 +33,25 @@ <paragraph xml-lang="en-US" id="par_id3149378" role="paragraph">This section describes the functions of $[officename] Calc. The various functions are divided into categories in the Function Wizard.</paragraph> <h2 xml-lang="en-US" id="hd_id3146972"><link href="text/scalc/01/04060101.xhp">Database</link></h2> <embed href="text/scalc/01/04060101.xhp#datenbanktext"/> - <paragraph xml-lang="en-US" id="hd_id3155443" role="heading" level="2"><link href="text/scalc/01/04060102.xhp">Date & Time</link></paragraph> + <h2 id="hd_id3155443"><link href="text/scalc/01/04060102.xhp">Date & Time</link></h2> <embed href="text/scalc/01/04060102.xhp#datumzeittext"/> - <paragraph xml-lang="en-US" id="hd_id3147339" role="heading" level="2"><link href="text/scalc/01/04060103.xhp">Financial</link></paragraph> + <h2 id="hd_id3147339"><link href="text/scalc/01/04060103.xhp">Financial</link></h2> <embed href="text/scalc/01/04060103.xhp#finanztext"/> - <paragraph xml-lang="en-US" id="hd_id3153963" role="heading" level="2"><link href="text/scalc/01/04060104.xhp">Information</link></paragraph> + <h2 id="hd_id3153963"><link href="text/scalc/01/04060104.xhp">Information</link></h2> <embed href="text/scalc/01/04060104.xhp#informationtext"/> <h2 xml-lang="en-US" id="hd_id3146316"><link href="text/scalc/01/04060105.xhp">Logical</link></h2> <embed href="text/scalc/01/04060105.xhp#logicaltext"/> - <paragraph xml-lang="en-US" id="hd_id3148485" role="heading" level="2"><link href="text/scalc/01/04060106.xhp">Mathematical</link></paragraph> + <h2 id="hd_id3148485"><link href="text/scalc/01/04060106.xhp">Mathematical</link></h2> <embed href="text/scalc/01/04060106.xhp#mathematiktext"/> - <paragraph xml-lang="en-US" id="hd_id3150363" role="heading" level="2"><link href="text/scalc/01/04060107.xhp">Array</link></paragraph> + <h2 id="hd_id3150363"><link href="text/scalc/01/04060107.xhp">Array</link></h2> <embed href="text/scalc/01/04060107.xhp#matrixtext"/> - <paragraph xml-lang="en-US" id="hd_id3150208" role="heading" level="2"><link href="text/scalc/01/04060108.xhp">Statistical</link></paragraph> + <h2 id="hd_id3150208"><link href="text/scalc/01/04060108.xhp">Statistical</link></h2> <embed href="text/scalc/01/04060108.xhp#statistiktext"/> - <paragraph xml-lang="en-US" id="hd_id3166428" role="heading" level="2"><link href="text/scalc/01/04060109.xhp">Spreadsheet</link></paragraph> + <h2 id="hd_id3166428"><link href="text/scalc/01/04060109.xhp">Spreadsheet</link></h2> <embed href="text/scalc/01/04060109.xhp#tabelletext"/> - <paragraph xml-lang="en-US" id="hd_id3145585" role="heading" level="2"><link href="text/scalc/01/04060110.xhp">Text</link></paragraph> + <h2 id="hd_id3145585"><link href="text/scalc/01/04060110.xhp">Text</link></h2> <embed href="text/scalc/01/04060110.xhp#texttext"/> - <paragraph xml-lang="en-US" id="hd_id3156449" role="heading" level="2"><link href="text/scalc/01/04060111.xhp">Add-in</link></paragraph> + <h2 id="hd_id3156449"><link href="text/scalc/01/04060111.xhp">Add-in</link></h2> <embed href="text/scalc/01/04060111.xhp#addintext"/> <section id="relatedtopics"> <paragraph xml-lang="en-US" id="par_id3150715" role="paragraph"><link href="text/scalc/01/04060199.xhp">Operators</link></paragraph> diff --git a/source/text/scalc/01/04090000.xhp b/source/text/scalc/01/04090000.xhp index 37b2489655..5e85c8fe30 100644 --- a/source/text/scalc/01/04090000.xhp +++ b/source/text/scalc/01/04090000.xhp @@ -34,7 +34,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:InsertExternalDataSource" id="bm_id3748965" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/ExternalDataDialog" id="bm_id3150441" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/@@nowidget@@" id="bm_id3150441" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3145785" role="heading" level="1"><link href="text/scalc/01/04090000.xhp">External Links</link></paragraph> +<h1 id="hd_id3145785"><link href="text/scalc/01/04090000.xhp">External Links</link></h1> <paragraph xml-lang="en-US" id="par_id3149262" role="paragraph"><ahelp hid=".uno:InsertExternalDataSourc">Inserts data from an HTML, Calc, CSV or Excel file into the current sheet as a link. The data must be located within a named range.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/05020600.xhp b/source/text/scalc/01/05020600.xhp index 2e177e0b2c..987e090bc0 100644 --- a/source/text/scalc/01/05020600.xhp +++ b/source/text/scalc/01/05020600.xhp @@ -33,7 +33,7 @@ <section id="cell_protection"> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/cellprotectionpage/CellProtectionPage" id="bm_id3151385" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/cellprotectionpage/@@nowidget@@" id="bm_id3151385" localize="false"/> -<paragraph role="heading" id="hd_id3145119" xml-lang="en-US" level="1"><link href="text/scalc/01/05020600.xhp">Cell Protection</link></paragraph> +<h1 id="hd_id3145119"><link href="text/scalc/01/05020600.xhp">Cell Protection</link></h1> <paragraph role="paragraph" id="par_id3150398" xml-lang="en-US"><ahelp hid="modules/scalc/ui/cellprotectionpage/CellProtectionPage">Defines protection options for selected cells.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/05030000.xhp b/source/text/scalc/01/05030000.xhp index 4bd5f3d589..29e503b8b0 100644 --- a/source/text/scalc/01/05030000.xhp +++ b/source/text/scalc/01/05030000.xhp @@ -32,15 +32,15 @@ <body> <section id="row"> <bookmark xml-lang="en-US" branch="hid/.uno:RowMenu" id="bm_id8181096" localize="false"/> -<paragraph role="heading" id="hd_id3147228" xml-lang="en-US" level="1"><link href="text/scalc/01/05030000.xhp">Row</link></paragraph> +<h1 id="hd_id3147228"><link href="text/scalc/01/05030000.xhp">Row</link></h1> <paragraph role="paragraph" id="par_id3154685" xml-lang="en-US"><ahelp hid=".">Sets the row height and hides or shows selected rows.</ahelp></paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#fozei"/> </section> -<paragraph role="heading" id="hd_id3155132" xml-lang="en-US" level="2"><link href="text/shared/01/05340100.xhp">Height</link></paragraph> +<h2 id="hd_id3155132"><link href="text/shared/01/05340100.xhp">Height</link></h2> <embed href="text/shared/01/05340100.xhp#zeilenhoehetext"/> -<paragraph role="heading" id="hd_id3155854" xml-lang="en-US" level="2"><link href="text/scalc/01/05030200.xhp">Optimal Height</link></paragraph> +<h2 id="hd_id3155854"><link href="text/scalc/01/05030200.xhp">Optimal Height</link></h2> <embed href="text/scalc/01/05030200.xhp#optitext"/> <embed href="text/scalc/01/05030300.xhp#hide"/> <embed href="text/scalc/01/05030400.xhp#show"/> diff --git a/source/text/scalc/01/05030300.xhp b/source/text/scalc/01/05030300.xhp index 72effc355e..db53e49758 100644 --- a/source/text/scalc/01/05030300.xhp +++ b/source/text/scalc/01/05030300.xhp @@ -42,7 +42,7 @@ <bookmark xml-lang="en-US" branch="hid/.uno:HideRow" id="bm_id3154760" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:HideColumn" id="bm_id3148663" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:Hide" id="bm_id3149457" localize="false"/> -<paragraph role="heading" id="hd_id3147265" xml-lang="en-US" level="1"><link href="text/scalc/01/05030300.xhp">Hide</link></paragraph> +<h1 id="hd_id3147265"><link href="text/scalc/01/05030300.xhp">Hide</link></h1> <paragraph role="paragraph" id="par_id3156281" xml-lang="en-US"><ahelp hid=".">Hides selected rows, columns or individual sheets.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/05030400.xhp b/source/text/scalc/01/05030400.xhp index 74087f855c..492b093739 100644 --- a/source/text/scalc/01/05030400.xhp +++ b/source/text/scalc/01/05030400.xhp @@ -37,7 +37,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/.uno:ShowRow" id="bm_id3154760" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:ShowColumn" id="bm_id3149456" localize="false"/> -<paragraph role="heading" id="hd_id3147264" xml-lang="en-US" level="1"><link href="text/scalc/01/05030400.xhp">Show</link></paragraph> +<h1 id="hd_id3147264"><link href="text/scalc/01/05030400.xhp">Show</link></h1> <paragraph role="paragraph" id="par_id3150447" xml-lang="en-US"><ahelp hid=".">Choose this command to show previously hidden rows or columns.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/05040000.xhp b/source/text/scalc/01/05040000.xhp index 8542693f89..ffb9a63786 100644 --- a/source/text/scalc/01/05040000.xhp +++ b/source/text/scalc/01/05040000.xhp @@ -32,15 +32,15 @@ <body> <section id="column"> <bookmark xml-lang="en-US" branch="hid/.uno:ColumnMenu" id="bm_id9955137" localize="false"/> -<paragraph role="heading" id="hd_id3155628" xml-lang="en-US" level="1"><link href="text/scalc/01/05040000.xhp">Column</link></paragraph> +<h1 id="hd_id3155628"><link href="text/scalc/01/05040000.xhp">Column</link></h1> <paragraph role="paragraph" id="par_id3148946" xml-lang="en-US"><ahelp hid=".">Sets the column width and hides or shows selected columns.</ahelp></paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#fospa"/> </section> -<paragraph role="heading" id="hd_id3150398" xml-lang="en-US" level="2"><link href="text/shared/01/05340200.xhp">Width</link></paragraph> +<h2 id="hd_id3150398"><link href="text/shared/01/05340200.xhp">Width</link></h2> <embed href="text/shared/01/05340200.xhp#spaltetext"/> -<paragraph role="heading" id="hd_id3145171" xml-lang="en-US" level="2"><link href="text/scalc/01/05040200.xhp">Optimal Width</link></paragraph> +<h2 id="hd_id3145171"><link href="text/scalc/01/05040200.xhp">Optimal Width</link></h2> <embed href="text/scalc/01/05040200.xhp#optitext"/> <embed href="text/scalc/01/05030300.xhp#hide"/> <embed href="text/scalc/01/05030400.xhp#show"/> diff --git a/source/text/scalc/01/05050000.xhp b/source/text/scalc/01/05050000.xhp index e1db786e16..0bb80198ac 100644 --- a/source/text/scalc/01/05050000.xhp +++ b/source/text/scalc/01/05050000.xhp @@ -36,16 +36,16 @@ <bookmark_value>right-to-left text;spreadsheets</bookmark_value> </bookmark><comment>mw changed "right-to-left;..."</comment> <bookmark xml-lang="en-US" branch="hid/.uno:SheetMenu" id="bm_id5620899" localize="false"/> -<paragraph role="heading" id="hd_id3155923" xml-lang="en-US" level="1"><link href="text/scalc/01/05050000.xhp">Sheet</link></paragraph> +<h1 id="hd_id3155923"><link href="text/scalc/01/05050000.xhp">Sheet</link></h1> <paragraph role="paragraph" id="par_id3154758" xml-lang="en-US"><ahelp hid=".">Sets the sheet name and hides or shows selected sheets.</ahelp></paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000405.xhp#fot"/> </section> -<paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="2"><link href="text/scalc/01/05050100.xhp">Rename</link></paragraph> +<h2 id="hd_id3156280"><link href="text/scalc/01/05050100.xhp">Rename</link></h2> <embed href="text/scalc/01/05050100.xhp#umbenennentext"/> <embed href="text/scalc/01/05030300.xhp#hide"/> -<paragraph role="heading" id="hd_id3145787" xml-lang="en-US" level="2"><link href="text/scalc/01/05050300.xhp">Show</link></paragraph> +<h2 id="hd_id3145787"><link href="text/scalc/01/05050300.xhp">Show</link></h2> <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"/> diff --git a/source/text/scalc/01/05070500.xhp b/source/text/scalc/01/05070500.xhp index 4693456f96..f4e78b6434 100644 --- a/source/text/scalc/01/05070500.xhp +++ b/source/text/scalc/01/05070500.xhp @@ -34,7 +34,7 @@ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/@@nowidget@@" id="bm_id3147335" localize="false"/> <bookmark xml-lang="en-US" branch="index" id="bm_id3150542"><bookmark_value>pages; order when printing</bookmark_value> <bookmark_value>printing; page order</bookmark_value> -</bookmark><comment>mw deletes three "printing;..." entries and copies 4 index entries to Calc guide print_details.xhp</comment><paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1"><link href="text/scalc/01/05070500.xhp">Sheet</link></paragraph> +</bookmark><comment>mw deletes three "printing;..." entries and copies 4 index entries to Calc guide print_details.xhp</comment><h1 id="hd_id3156329"><link href="text/scalc/01/05070500.xhp">Sheet</link></h1> <paragraph role="paragraph" id="par_id3151384" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/SheetPrintPage">Specifies the elements to be included in the printout of all sheets with the current Page Style. Additionally, you can set the print order, the first page number, and the page scale.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/05080000.xhp b/source/text/scalc/01/05080000.xhp index 0a51787016..130169ab9e 100644 --- a/source/text/scalc/01/05080000.xhp +++ b/source/text/scalc/01/05080000.xhp @@ -32,7 +32,7 @@ <body> <bookmark xml-lang="en-US" branch="hid/.uno:PrintRangesMenu" id="bm_id4606769" localize="false"/> <section id="printranges"> -<paragraph role="heading" id="hd_id3154013" xml-lang="en-US" level="1"><link href="text/scalc/01/05080000.xhp">Print Ranges</link></paragraph> +<h1 id="hd_id3154013"><link href="text/scalc/01/05080000.xhp">Print Ranges</link></h1> <paragraph role="paragraph" id="par_id3155855" xml-lang="en-US"><ahelp hid=".">Manages print ranges. Only cells within the print ranges will be printed.</ahelp></paragraph> </section> <section id="howtoget"> @@ -42,7 +42,7 @@ <embed href="text/scalc/01/05080100.xhp#define"/> <embed href="text/scalc/01/05080400.xhp#add"/> <embed href="text/scalc/01/05080200.xhp#clear"/> -<paragraph role="heading" id="hd_id3154729" xml-lang="en-US" level="2"><link href="text/scalc/01/05080300.xhp">Edit</link></paragraph> +<h2 id="hd_id3154729"><link href="text/scalc/01/05080300.xhp">Edit</link></h2> <embed href="text/scalc/01/05080300.xhp#printrangestext"/> </body> </helpdocument> diff --git a/source/text/scalc/01/05080100.xhp b/source/text/scalc/01/05080100.xhp index ec31275b5a..0759c4634a 100644 --- a/source/text/scalc/01/05080100.xhp +++ b/source/text/scalc/01/05080100.xhp @@ -32,7 +32,7 @@ <body> <section id="define"> <bookmark xml-lang="en-US" branch="hid/.uno:DefinePrintArea" id="bm_id3153561" localize="false"/> -<paragraph role="heading" id="hd_id3145673" xml-lang="en-US" level="1"><link href="text/scalc/01/05080100.xhp">Define</link></paragraph> +<h1 id="hd_id3145673"><link href="text/scalc/01/05080100.xhp">Define</link></h1> <paragraph role="paragraph" id="par_id3153896" xml-lang="en-US"><ahelp hid=".uno:DefinePrintArea">Defines an active cell or selected cell area as the print range.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/05080200.xhp b/source/text/scalc/01/05080200.xhp index 1bf3528436..c260f0ff46 100644 --- a/source/text/scalc/01/05080200.xhp +++ b/source/text/scalc/01/05080200.xhp @@ -32,7 +32,7 @@ <body> <section id="clear"> <bookmark xml-lang="en-US" branch="hid/.uno:DeletePrintArea" id="bm_id3150275" localize="false"/> -<paragraph role="heading" id="hd_id3153562" xml-lang="en-US" level="1"><link href="text/scalc/01/05080200.xhp">Clear</link></paragraph> +<h1 id="hd_id3153562"><link href="text/scalc/01/05080200.xhp">Clear</link></h1> <paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp hid=".uno:DeletePrintArea">Removes the defined print area.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/05080400.xhp b/source/text/scalc/01/05080400.xhp index 609908aa3a..b0b9413bc8 100644 --- a/source/text/scalc/01/05080400.xhp +++ b/source/text/scalc/01/05080400.xhp @@ -32,7 +32,7 @@ <body> <section id="add"> <bookmark xml-lang="en-US" branch="hid/.uno:AddPrintArea" id="bm_id3150543" localize="false"/> -<paragraph role="heading" id="hd_id3149457" xml-lang="en-US" level="1"><link href="text/scalc/01/05080400.xhp">Add</link></paragraph> +<h1 id="hd_id3149457"><link href="text/scalc/01/05080400.xhp">Add</link></h1> <paragraph role="paragraph" id="par_id3156423" xml-lang="en-US"><ahelp hid=".uno:AddPrintArea">Adds the current selection to the defined print areas.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030000.xhp b/source/text/scalc/01/06030000.xhp index 56110fca38..d1d5d8de72 100644 --- a/source/text/scalc/01/06030000.xhp +++ b/source/text/scalc/01/06030000.xhp @@ -34,7 +34,7 @@ <bookmark_value>Formula Auditing,see Detective</bookmark_value> <bookmark_value>Detective</bookmark_value> </bookmark><comment>MW added "Detective" and a cross-reference</comment> -<paragraph xml-lang="en-US" id="hd_id3151245" role="heading" level="1"><link href="text/scalc/01/06030000.xhp">Detective</link></paragraph> +<h1 id="hd_id3151245"><link href="text/scalc/01/06030000.xhp">Detective</link></h1> <paragraph xml-lang="en-US" id="par_id3151211" role="paragraph">This command activates the Spreadsheet Detective. With the Detective, you can trace the dependencies from the current formula cell to the cells in the spreadsheet.</paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030100.xhp b/source/text/scalc/01/06030100.xhp index 05999f11f4..f6eefa94e8 100644 --- a/source/text/scalc/01/06030100.xhp +++ b/source/text/scalc/01/06030100.xhp @@ -35,7 +35,7 @@ <bookmark_value>formula cells;tracing precedents</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/.uno:ShowPrecedents" id="bm_id3145673" localize="false"/> -<paragraph role="heading" id="hd_id3155628" xml-lang="en-US" level="1"><link href="text/scalc/01/06030100.xhp">Trace Precedents</link></paragraph> +<h1 id="hd_id3155628"><link href="text/scalc/01/06030100.xhp">Trace Precedents</link></h1> <paragraph role="paragraph" id="par_id3153542" xml-lang="en-US"><ahelp hid=".uno:ShowPrecedents">This function shows the relationship between the current cell containing a formula and the cells used in the formula.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3147265" xml-lang="en-US">Traces are displayed in the sheet with marking arrows. At the same time, the range of all the cells contained in the formula of the current cell is highlighted with a blue frame.</paragraph> diff --git a/source/text/scalc/01/06030200.xhp b/source/text/scalc/01/06030200.xhp index 4c1fda7456..587ea1bd6e 100644 --- a/source/text/scalc/01/06030200.xhp +++ b/source/text/scalc/01/06030200.xhp @@ -35,7 +35,7 @@ <bookmark_value>formula cells;removing precedents</bookmark_value> </bookmark><comment>mw changed "formula..." entry</comment> <bookmark xml-lang="en-US" branch="hid/.uno:ClearArrowPrecedents" id="bm_id8005825" localize="false"/> -<paragraph role="heading" id="hd_id3155628" xml-lang="en-US" level="1"><link href="text/scalc/01/06030200.xhp">Remove Precedents</link></paragraph> +<h1 id="hd_id3155628"><link href="text/scalc/01/06030200.xhp">Remove Precedents</link></h1> <paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><ahelp hid=".uno:ClearArrowPrecedents">Deletes one level of the trace arrows that were inserted with the <emph>Trace Precedents</emph> command.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030300.xhp b/source/text/scalc/01/06030300.xhp index 6d54bda364..5ae0a69372 100644 --- a/source/text/scalc/01/06030300.xhp +++ b/source/text/scalc/01/06030300.xhp @@ -34,7 +34,7 @@ <section id="trace_dependents"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153252"><bookmark_value>cells; tracing dependents</bookmark_value></bookmark> <bookmark branch="hid/.uno:ShowDependents" xml-lang="en-US" id="bm_id3143267" localize="false"/> -<paragraph id="hd_id3153252" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030300.xhp">Trace Dependents</link></paragraph> +<h1 id="hd_id3153252"><link href="text/scalc/01/06030300.xhp">Trace Dependents</link></h1> <paragraph role="paragraph" id="par_id3156024" xml-lang="en-US"><ahelp hid=".uno:ShowDependents" visibility="visible">Draws tracer arrows to the active cell from formulas that depend on values in the active cell.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3148948" xml-lang="en-US">The area of all cells that are used together with the active cell in a formula is highlighted by a blue frame.</paragraph> diff --git a/source/text/scalc/01/06030400.xhp b/source/text/scalc/01/06030400.xhp index 95c3272fc5..56357f6528 100644 --- a/source/text/scalc/01/06030400.xhp +++ b/source/text/scalc/01/06030400.xhp @@ -35,7 +35,7 @@ <section id="remove_dependents"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147335"><bookmark_value>cells; removing dependents</bookmark_value></bookmark> <bookmark branch="hid/.uno:ClearArrowDependents" xml-lang="en-US" id="bm_id3148552" localize="false"/> -<paragraph id="hd_id3147335" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030400.xhp">Remove Dependents</link></paragraph> +<h1 id="hd_id3147335"><link href="text/scalc/01/06030400.xhp">Remove Dependents</link></h1> <paragraph role="paragraph" id="par_id3148663" xml-lang="en-US"><ahelp visibility="visible" hid=".uno:ClearArrowDependents">Deletes one level of tracer arrows created with <emph>Trace Dependents</emph>.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030500.xhp b/source/text/scalc/01/06030500.xhp index 51f44309ef..d464a37f50 100644 --- a/source/text/scalc/01/06030500.xhp +++ b/source/text/scalc/01/06030500.xhp @@ -35,7 +35,7 @@ <section id="remove_all_traces"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153088"><bookmark_value>cells; removing traces</bookmark_value></bookmark> <bookmark branch="hid/.uno:ClearArrows" xml-lang="en-US" id="bm_id3153541" localize="false"/> -<paragraph id="hd_id3153088" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030500.xhp">Remove All Traces</link></paragraph> +<h1 id="hd_id3153088"><link href="text/scalc/01/06030500.xhp">Remove All Traces</link></h1> <paragraph role="paragraph" id="par_id3151246" xml-lang="en-US"><ahelp hid=".uno:ClearArrows" visibility="visible">Removes all tracer arrows from the spreadsheet.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030600.xhp b/source/text/scalc/01/06030600.xhp index 5cfc1d72ad..753d307419 100644 --- a/source/text/scalc/01/06030600.xhp +++ b/source/text/scalc/01/06030600.xhp @@ -35,7 +35,7 @@ <section id="trace_error"> <bookmark branch="index" xml-lang="en-US" id="bm_id3153561"><bookmark_value>cells; tracing errors</bookmark_value><bookmark_value>tracing errors</bookmark_value><bookmark_value>error tracing</bookmark_value></bookmark> <bookmark branch="hid/.uno:ShowErrors" xml-lang="en-US" id="bm_id3153541" localize="false"/> -<paragraph id="hd_id3153561" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030600.xhp">Trace Error</link></paragraph> +<h1 id="hd_id3153561"><link href="text/scalc/01/06030600.xhp">Trace Error</link></h1> <paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp hid=".uno:ShowErrors" visibility="visible">Draws tracer arrows to all precedent cells which cause an error value in a selected cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030700.xhp b/source/text/scalc/01/06030700.xhp index e74f950791..3a0770ac42 100644 --- a/source/text/scalc/01/06030700.xhp +++ b/source/text/scalc/01/06030700.xhp @@ -35,7 +35,7 @@ <bookmark_value>traces; precedents for multiple cells</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/.uno:AuditingFillMode" id="bm_id3148491" localize="false"/> -<paragraph role="heading" id="hd_id3145119" xml-lang="en-US" level="1"><link href="text/scalc/01/06030700.xhp">Fill Mode</link></paragraph> +<h1 id="hd_id3145119"><link href="text/scalc/01/06030700.xhp">Fill Mode</link></h1> <paragraph role="paragraph" id="par_id3151246" xml-lang="en-US"><ahelp hid=".uno:AuditingFillMode">Activates the Fill Mode in the Detective. The mouse pointer changes to a special symbol, and you can click any cell to see a trace to the precedent cell.</ahelp> To exit this mode, press Escape or click the <emph>End Fill Mode</emph> command in the context menu.</paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030800.xhp b/source/text/scalc/01/06030800.xhp index 871dfc938d..27710674ce 100644 --- a/source/text/scalc/01/06030800.xhp +++ b/source/text/scalc/01/06030800.xhp @@ -35,7 +35,7 @@ <section id="mark_invalid_data"> <bookmark branch="index" xml-lang="en-US" id="bm_id3153821"><bookmark_value>cells; invalid data</bookmark_value><bookmark_value>data; showing invalid data</bookmark_value><bookmark_value>invalid data;marking</bookmark_value></bookmark> <bookmark branch="hid/.uno:ShowInvalid" xml-lang="en-US" id="bm_id3157909" localize="false"/> -<paragraph id="hd_id3153821" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06030800.xhp">Mark Invalid Data</link></paragraph> +<h1 id="hd_id3153821"><link href="text/scalc/01/06030800.xhp">Mark Invalid Data</link></h1> <paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp hid=".uno:ShowInvalid" visibility="visible">Marks all cells in the sheet that contain values outside the validation rules.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06030900.xhp b/source/text/scalc/01/06030900.xhp index e1ec3edaac..f0d7576292 100644 --- a/source/text/scalc/01/06030900.xhp +++ b/source/text/scalc/01/06030900.xhp @@ -36,7 +36,7 @@ <bookmark_value>updating;traces</bookmark_value> </bookmark><comment>mw made "updating..." a two level entry</comment> <bookmark xml-lang="en-US" branch="hid/.uno:RefreshArrows" id="bm_id9951902" localize="false"/> -<paragraph role="heading" id="hd_id3152349" xml-lang="en-US" level="1"><link href="text/scalc/01/06030900.xhp">Refresh Traces</link></paragraph> +<h1 id="hd_id3152349"><link href="text/scalc/01/06030900.xhp">Refresh Traces</link></h1> <paragraph role="paragraph" id="par_id3148947" xml-lang="en-US"><ahelp hid=".uno:RefreshArrows">Redraws all traces in the sheet. Formulas modified when traces are redrawn are taken into account.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06031000.xhp b/source/text/scalc/01/06031000.xhp index 1121a94a2f..f7742f149e 100644 --- a/source/text/scalc/01/06031000.xhp +++ b/source/text/scalc/01/06031000.xhp @@ -35,7 +35,7 @@ <section id="autorefresh"> <bookmark branch="index" xml-lang="en-US" id="bm_id3154515"><bookmark_value>cells; autorefreshing traces</bookmark_value><bookmark_value>traces; autorefreshing</bookmark_value></bookmark> <bookmark branch="hid/.uno:AutoRefreshArrows" xml-lang="en-US" id="bm_id3153821" localize="false"/> -<paragraph id="hd_id3154515" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/06031000.xhp">AutoRefresh</link></paragraph> +<h1 id="hd_id3154515"><link href="text/scalc/01/06031000.xhp">AutoRefresh</link></h1> <paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp hid=".uno:AutoRefreshArrows" visibility="visible">Automatically refreshes all the traces in the sheet whenever you modify a formula.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/06050000.xhp b/source/text/scalc/01/06050000.xhp index 8bb6fbeb0b..2d2ff4401d 100644 --- a/source/text/scalc/01/06050000.xhp +++ b/source/text/scalc/01/06050000.xhp @@ -54,7 +54,7 @@ <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> +<h3 id="hd_id3145367">Display border<comment>UFI: #i38688#</comment></h3> <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"/> <h3 id="hd_id3149582">Copy back</h3> diff --git a/source/text/scalc/01/06060000.xhp b/source/text/scalc/01/06060000.xhp index 91ee8d0956..b57bd65a69 100644 --- a/source/text/scalc/01/06060000.xhp +++ b/source/text/scalc/01/06060000.xhp @@ -31,16 +31,16 @@ </meta> <body> <section id="protect_document"> -<paragraph role="heading" id="hd_id3148946" xml-lang="en-US" level="1"><link href="text/scalc/01/06060000.xhp">Protect Document</link></paragraph> +<h1 id="hd_id3148946"><link href="text/scalc/01/06060000.xhp">Protect Document</link></h1> <paragraph role="paragraph" id="par_id3153362" xml-lang="en-US">The <emph>Protect Sheet</emph> or <emph>Protect Spreadsheet Structure</emph> commands prevent changes from being made to cells in the sheets or to sheets in a document. As an option, you can define a password. If a password is defined, removal of the protection is only possible if the user enters the correct password.</paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000406.xhp#protect_sheet"/> <embed href="text/scalc/00/00000406.xhp#protect_spreadsheet"/> </section> -<paragraph role="heading" id="hd_id3147228" xml-lang="en-US" level="2"><link href="text/scalc/01/06060100.xhp">Sheets</link></paragraph> +<h2 id="hd_id3147228"><link href="text/scalc/01/06060100.xhp">Sheets</link></h2> <embed href="text/scalc/01/06060100.xhp#tabelletext"/> -<paragraph role="heading" id="hd_id3153768" xml-lang="en-US" level="2"><link href="text/scalc/01/06060200.xhp">Documents</link></paragraph> +<h2 id="hd_id3153768"><link href="text/scalc/01/06060200.xhp">Documents</link></h2> <embed href="text/scalc/01/06060200.xhp#dokumenttext"/> <section id="relatedtopics"> <paragraph role="paragraph" id="par_idN10622" xml-lang="en-US" localize="false"> diff --git a/source/text/scalc/01/06130000.xhp b/source/text/scalc/01/06130000.xhp index 260db76a42..f00a138ecc 100644 --- a/source/text/scalc/01/06130000.xhp +++ b/source/text/scalc/01/06130000.xhp @@ -34,7 +34,7 @@ <bookmark_value>capital letters;AutoInput function</bookmark_value> </bookmark><comment>mw made "entering..." a one level entry</comment> <bookmark xml-lang="en-US" branch="hid/.uno:AutoComplete" id="bm_id6682843" localize="false"/> -<paragraph role="heading" id="hd_id3148492" xml-lang="en-US" level="1"><link href="text/scalc/01/06130000.xhp">AutoInput</link></paragraph> +<h1 id="hd_id3148492"><link href="text/scalc/01/06130000.xhp">AutoInput</link></h1> <paragraph role="paragraph" id="par_id3150793" xml-lang="en-US"><ahelp hid=".uno:AutoComplete">Switches the AutoInput function on and off, which automatically completes entries, based on other entries in the same column.</ahelp> The column is scanned up to a maximum of 2000 cells or 200 different strings.</paragraph> <embed href="text/scalc/guide/auto_off.xhp#auto_off"/> <section id="howtoget"> diff --git a/source/text/scalc/01/07080000.xhp b/source/text/scalc/01/07080000.xhp index 659706aa1c..d316a33cfa 100644 --- a/source/text/scalc/01/07080000.xhp +++ b/source/text/scalc/01/07080000.xhp @@ -31,7 +31,7 @@ <section id="split_window"> <bookmark xml-lang="en-US" branch="hid/.uno:SplitWindow" id="bm_id6328790" localize="false"/> -<paragraph id="hd_id3163800" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/07080000.xhp">Split Window</link></paragraph> +<h1 id="hd_id3163800"><link href="text/scalc/01/07080000.xhp">Split Window</link></h1> <paragraph id="par_id3150084" role="paragraph" xml-lang="en-US"><ahelp hid=".">Divides the current window at the top left corner of the active cell.</ahelp></paragraph> </section> diff --git a/source/text/scalc/01/12040400.xhp b/source/text/scalc/01/12040400.xhp index 646e9435cf..2e6e3b1843 100644 --- a/source/text/scalc/01/12040400.xhp +++ b/source/text/scalc/01/12040400.xhp @@ -31,7 +31,7 @@ <body> <section id="reset_filter"> <bookmark xml-lang="en-US" branch="hid/.uno:DataFilterRemoveFilter" id="bm_id2352791" localize="false"/> -<paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="1"><link href="text/scalc/01/12040400.xhp">Reset Filter</link></paragraph> +<h1 id="hd_id3153087"><link href="text/scalc/01/12040400.xhp">Reset Filter</link></h1> <paragraph role="paragraph" id="par_id3154760" xml-lang="en-US"><ahelp hid=".uno:DataFilterRemoveFilter">Removes the filter from the selected cell range. To enable this command, click inside the cell area where the filter was applied.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12040500.xhp b/source/text/scalc/01/12040500.xhp index 4bcb925bb8..e31b0cc285 100644 --- a/source/text/scalc/01/12040500.xhp +++ b/source/text/scalc/01/12040500.xhp @@ -35,7 +35,7 @@ <section id="hide_autofilter"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150276"><bookmark_value>database ranges; hiding AutoFilter</bookmark_value></bookmark> <bookmark branch="hid/.uno:DataFilterHideAutoFilter" xml-lang="en-US" id="bm_id3145674" localize="false"/> -<paragraph id="hd_id3150276" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12040500.xhp">Hide AutoFilter</link></paragraph> +<h1 id="hd_id3150276"><link href="text/scalc/01/12040500.xhp">Hide AutoFilter</link></h1> <paragraph role="paragraph" id="par_id3156326" xml-lang="en-US"><ahelp hid=".uno:DataFilterHideAutoFilter" visibility="visible">Hides the AutoFilter buttons in the selected cell range.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12080000.xhp b/source/text/scalc/01/12080000.xhp index 5e85a63fcc..233482f1c6 100644 --- a/source/text/scalc/01/12080000.xhp +++ b/source/text/scalc/01/12080000.xhp @@ -37,7 +37,7 @@ <bookmark_value>showing; sheet details</bookmark_value> <bookmark_value>grouping;cells</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3152350" xml-lang="en-US" level="1"><link href="text/scalc/01/12080000.xhp">Group and Outline</link></paragraph> +<h1 id="hd_id3152350"><link href="text/scalc/01/12080000.xhp">Group and Outline</link></h1> <paragraph role="paragraph" id="par_id3150793" xml-lang="en-US">You can create an outline of your data and group rows and columns together so that you can collapse and expand the groups with a single click.</paragraph> </section> <section id="howtoget"> @@ -45,9 +45,9 @@ </section> <embed href="text/scalc/01/12080100.xhp#hide_details"/> <embed href="text/scalc/01/12080200.xhp#show_details"/> -<paragraph role="heading" id="hd_id3147229" xml-lang="en-US" level="2"><link href="text/scalc/01/12080300.xhp">Group</link></paragraph> +<h2 id="hd_id3147229"><link href="text/scalc/01/12080300.xhp">Group</link></h2> <embed href="text/scalc/01/12080300.xhp#gruppierung"/> -<paragraph role="heading" id="hd_id3153188" xml-lang="en-US" level="2"><link href="text/scalc/01/12080400.xhp">Ungroup</link></paragraph> +<h2 id="hd_id3153188"><link href="text/scalc/01/12080400.xhp">Ungroup</link></h2> <embed href="text/scalc/01/12080400.xhp#gruppierungauf"/> <embed href="text/scalc/01/12080500.xhp#auto_outline"/> <embed href="text/scalc/01/12080600.xhp#remove"/> diff --git a/source/text/scalc/01/12080100.xhp b/source/text/scalc/01/12080100.xhp index 56b2c50f5f..a4cc6dfed4 100644 --- a/source/text/scalc/01/12080100.xhp +++ b/source/text/scalc/01/12080100.xhp @@ -35,7 +35,7 @@ <section id="hide_details"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155628"><bookmark_value>sheets; hiding details</bookmark_value></bookmark> <bookmark branch="hid/.uno:HideDetail" xml-lang="en-US" id="bm_id3149784" localize="false"/> -<paragraph id="hd_id3155628" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12080100.xhp">Hide Details</link></paragraph> +<h1 id="hd_id3155628"><link href="text/scalc/01/12080100.xhp">Hide Details</link></h1> <paragraph role="paragraph" id="par_id3154515" xml-lang="en-US"><ahelp hid=".uno:HideDetail" visibility="visible">Hides the details of the grouped row or column that contains the cursor. To hide all of the grouped rows or columns, select the outlined table, and then choose this command.</ahelp></paragraph> </section> <paragraph xml-lang="en-US" role="paragraph" id="par_id3153252">To show all hidden groups, select the outlined table, and then choose <emph>Data - Group and Outline –</emph> <link href="text/scalc/01/12080200.xhp"><emph>Show Details</emph></link>.</paragraph> diff --git a/source/text/scalc/01/12080200.xhp b/source/text/scalc/01/12080200.xhp index ca8366b5a2..d098ca0cda 100644 --- a/source/text/scalc/01/12080200.xhp +++ b/source/text/scalc/01/12080200.xhp @@ -33,7 +33,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3153561"><bookmark_value>tables; showing details</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/.uno:ShowDetail" id="bm_id3178188" localize="false"/> -<paragraph role="heading" id="hd_id3153561" xml-lang="en-US" level="1"><link href="text/scalc/01/12080200.xhp">Show Details</link></paragraph> +<h1 id="hd_id3153561"><link href="text/scalc/01/12080200.xhp">Show Details</link></h1> <paragraph role="paragraph" id="par_id3153822" xml-lang="en-US"><ahelp hid=".uno:ShowDetail">Shows the details of the grouped row or column that contains the cursor. To show the details of all of the grouped rows or columns, select the outlined table, and then choose this command.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3155922" xml-lang="en-US">To hide a selected group, choose <emph>Data - Group and Outline – </emph><link href="text/scalc/01/12080100.xhp"><emph>Hide Details</emph></link>.</paragraph> diff --git a/source/text/scalc/01/12080300.xhp b/source/text/scalc/01/12080300.xhp index f4e7457469..1e0e799e28 100644 --- a/source/text/scalc/01/12080300.xhp +++ b/source/text/scalc/01/12080300.xhp @@ -36,7 +36,7 @@ <bookmark branch="hid/modules/scalc/ui/groupdialog/GroupDialog" xml-lang="en-US" id="bm_id3156329" localize="false"/> <bookmark branch="hid/modules/scalc/ui/groupdialog/@@nowidget@@" xml-lang="en-US" id="bm_id3156329" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:Group" id="bm_id9177845" localize="false"/> -<paragraph id="hd_id3153088" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12080300.xhp">Group</link></paragraph> +<h1 id="hd_id3153088"><link href="text/scalc/01/12080300.xhp">Group</link></h1> </section> <paragraph role="paragraph" id="par_id3153821" xml-lang="en-US"><variable id="gruppierung"><ahelp hid=".">Defines the selected cell range as a group of rows or columns.</ahelp></variable></paragraph> <section id="howtoget"> diff --git a/source/text/scalc/01/12080400.xhp b/source/text/scalc/01/12080400.xhp index 41ce6e720e..0bcd6bbb2a 100644 --- a/source/text/scalc/01/12080400.xhp +++ b/source/text/scalc/01/12080400.xhp @@ -34,7 +34,7 @@ <section id="ungroup"> <bookmark branch="hid/.uno:Ungroup" xml-lang="en-US" id="bm_id3153561" localize="false"/> -<paragraph id="hd_id3148492" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12080400.xhp">Ungroup</link></paragraph> +<h1 id="hd_id3148492"><link href="text/scalc/01/12080400.xhp">Ungroup</link></h1> </section> <paragraph role="paragraph" id="par_id3151384" xml-lang="en-US"><variable id="gruppierungauf"><ahelp hid=".uno:Ungroup" visibility="visible">Ungroups the selection. In a nested group, the last rows or columns that were added are removed from the group.</ahelp></variable></paragraph> <section id="howtoget"> diff --git a/source/text/scalc/01/12080600.xhp b/source/text/scalc/01/12080600.xhp index d11b264a58..aa22adcdc5 100644 --- a/source/text/scalc/01/12080600.xhp +++ b/source/text/scalc/01/12080600.xhp @@ -34,7 +34,7 @@ <section id="remove"> <bookmark branch="hid/.uno:ClearOutline" xml-lang="en-US" id="bm_id3150400" localize="false"/> -<paragraph id="hd_id3148947" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12080600.xhp">Remove</link></paragraph> +<h1 id="hd_id3148947"><link href="text/scalc/01/12080600.xhp">Remove</link></h1> <paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><ahelp hid=".uno:ClearOutline" visibility="visible">Removes the outline from the selected cell range.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12080700.xhp b/source/text/scalc/01/12080700.xhp index b3ccd7df7a..f347ce1deb 100644 --- a/source/text/scalc/01/12080700.xhp +++ b/source/text/scalc/01/12080700.xhp @@ -30,7 +30,7 @@ </meta> <body> <section id="details"> -<paragraph role="heading" id="hd_id3344523" xml-lang="en-US" level="1"><link href="text/scalc/01/12080700.xhp">Show Details (Pivot Table)</link></paragraph> +<h1 id="hd_id3344523"><link href="text/scalc/01/12080700.xhp">Show Details (Pivot Table)</link></h1> <paragraph role="paragraph" id="par_id871303" xml-lang="en-US"><ahelp hid=".">Inserts a new "drill-down" sheet with more information about the current pivot table cell. You can also double-click a pivot table cell to insert the "drill-down" sheet. The new sheet shows a subset of rows from the original data source that constitutes the result data displayed in the current cell.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12090103.xhp b/source/text/scalc/01/12090103.xhp index 9aca2a9a96..63acf988c9 100644 --- a/source/text/scalc/01/12090103.xhp +++ b/source/text/scalc/01/12090103.xhp @@ -108,7 +108,7 @@ </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"/><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> + <bookmark branch="hid/modules/scalc/ui/pivotfilterdialog/more" xml-lang="en-US" id="bm_id3152987" localize="false"/><h2 id="hd_id3146980"><link href="text/scalc/01/12090104.xhp">Options</link></h2> <embed href="text/scalc/01/12090104.xhp#zusaetzetext"/> </body> </helpdocument> diff --git a/source/text/scalc/01/12090104.xhp b/source/text/scalc/01/12090104.xhp index 1528444f16..6b3c7d79b7 100644 --- a/source/text/scalc/01/12090104.xhp +++ b/source/text/scalc/01/12090104.xhp @@ -33,7 +33,7 @@ - <paragraph id="hd_id3149119" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12090104.xhp">Options</link></paragraph> + <h1 id="hd_id3149119"><link href="text/scalc/01/12090104.xhp">Options</link></h1> <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> <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> diff --git a/source/text/scalc/01/12090200.xhp b/source/text/scalc/01/12090200.xhp index dd67d341e1..131c88832c 100644 --- a/source/text/scalc/01/12090200.xhp +++ b/source/text/scalc/01/12090200.xhp @@ -32,7 +32,7 @@ <body> <section id="refresh"> <bookmark xml-lang="en-US" branch="hid/.uno:RecalcPivotTable" id="bm_id3145069" localize="false"/> -<paragraph role="heading" id="hd_id3151385" xml-lang="en-US" level="1"><link href="text/scalc/01/12090200.xhp">Refresh</link></paragraph> +<h1 id="hd_id3151385"><link href="text/scalc/01/12090200.xhp">Refresh</link></h1> <paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><ahelp hid=".uno:RecalcPivotTable">Updates the pivot table.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3150400" xml-lang="en-US">After you import an Excel spreadsheet that contains a pivot table, click in the table, and then choose <emph>Data - Pivot Table - Refresh</emph>.</paragraph> diff --git a/source/text/scalc/01/12090300.xhp b/source/text/scalc/01/12090300.xhp index a565e82926..b488b85aa4 100644 --- a/source/text/scalc/01/12090300.xhp +++ b/source/text/scalc/01/12090300.xhp @@ -29,7 +29,7 @@ <body> <section id="delete"> <bookmark branch="hid/.uno:DeletePivotTable" xml-lang="en-US" id="bm_id3148491" localize="false"/> -<paragraph id="hd_id3150276" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/12090300.xhp">Delete</link></paragraph> +<h1 id="hd_id3150276"><link href="text/scalc/01/12090300.xhp">Delete</link></h1> <paragraph role="paragraph" id="par_id3159400" xml-lang="en-US"><ahelp hid=".uno:DeletePivotTable" visibility="visible">Deletes the selected pivot table.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12120200.xhp b/source/text/scalc/01/12120200.xhp index d2bbf4a434..69a60d9dda 100644 --- a/source/text/scalc/01/12120200.xhp +++ b/source/text/scalc/01/12120200.xhp @@ -33,7 +33,7 @@ <section id="input_help"> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationhelptabpage/ValidationHelpTabPage" id="bm_id3150871" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationhelptabpage/@@nowidget@@" id="bm_id3150871" localize="false"/> -<paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="1"><link href="text/scalc/01/12120200.xhp">Input Help</link></paragraph> +<h1 id="hd_id3156280"><link href="text/scalc/01/12120200.xhp">Input Help</link></h1> <paragraph role="paragraph" id="par_id3147229" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationhelptabpage/ValidationHelpTabPage">Enter the message that you want to display when the cell or cell range is selected in the sheet.</ahelp></paragraph> </section> <section id="howtoget"> diff --git a/source/text/scalc/01/12120300.xhp b/source/text/scalc/01/12120300.xhp index f887153b77..9ffe4720d4 100644 --- a/source/text/scalc/01/12120300.xhp +++ b/source/text/scalc/01/12120300.xhp @@ -31,7 +31,7 @@ <section id="error_alert"> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage" id="bm_id3156024" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/erroralerttabpage/@@nowidget@@" id="bm_id3156024" localize="false"/> - <paragraph role="heading" id="hd_id3153821" xml-lang="en-US" level="1"><link href="text/scalc/01/12120300.xhp">Error Alert</link></paragraph> + <h1 id="hd_id3153821"><link href="text/scalc/01/12120300.xhp">Error Alert</link></h1> <paragraph role="paragraph" id="par_id3153379" xml-lang="en-US"><ahelp hid="modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage">Defines the error message that is displayed when invalid data is entered in a cell.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3154138" xml-lang="en-US">You can also start a macro with an error message. A sample macro is provided at the end of this page.</paragraph> diff --git a/source/text/scalc/01/format_graphic.xhp b/source/text/scalc/01/format_graphic.xhp index 4dc9a68312..fba576a5d8 100644 --- a/source/text/scalc/01/format_graphic.xhp +++ b/source/text/scalc/01/format_graphic.xhp @@ -32,13 +32,13 @@ <body> <section id="graphic"> <bookmark xml-lang="en-US" branch="hid/.uno:DrawGraphicMenu" id="bm_id7711111" localize="false"/> -<paragraph role="heading" id="par_idN10548" xml-lang="en-US" level="1"><link href="text/scalc/01/format_graphic.xhp">Graphic</link></paragraph> +<h1 id="par_idN10548"><link href="text/scalc/01/format_graphic.xhp">Graphic</link></h1> <paragraph role="paragraph" id="par_idN10558" xml-lang="en-US"><ahelp hid=".">Opens a submenu to edit the properties of the selected object.</ahelp></paragraph> </section> <embed href="text/shared/01/05230000.xhp#position_and_size"/> <embed href="text/shared/01/05200000.xhp#line"/> <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> +<h2 id="par_id1650440"><link href="text/shared/01/05990000.xhp">Define Text Attributes</link></h2> <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> <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> diff --git a/source/text/scalc/02/06010000.xhp b/source/text/scalc/02/06010000.xhp index 034d064e17..cfc1b577c7 100644 --- a/source/text/scalc/02/06010000.xhp +++ b/source/text/scalc/02/06010000.xhp @@ -38,7 +38,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_POS" id="bm_id3153087" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:FocusCellAddress" id="bm_id2941984" localize="false"/> -<paragraph role="heading" id="hd_id3156326" xml-lang="en-US" level="1"><link href="text/scalc/02/06010000.xhp">Name Box</link></paragraph> +<h1 id="hd_id3156326"><link href="text/scalc/02/06010000.xhp">Name Box</link></h1> <paragraph role="paragraph" id="par_id3149656" xml-lang="en-US"><ahelp hid="HID_INSWIN_POS">Displays the reference for the current cell, the range of the selected cells, or the name of the area. You can also select a range of cells, and then type a name for that range into the <emph>Name Box</emph>.</ahelp><comment>UFI: fixes #i28238#</comment></paragraph> </section> <section id="syname_box"> diff --git a/source/text/scalc/02/06040000.xhp b/source/text/scalc/02/06040000.xhp index 1df327f05d..d61770b3b7 100644 --- a/source/text/scalc/02/06040000.xhp +++ b/source/text/scalc/02/06040000.xhp @@ -32,7 +32,7 @@ <bookmark_value>functions; formula bar icon</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_FUNC" id="bm_id3145119" localize="false"/> -<paragraph role="heading" id="hd_id3150084" xml-lang="en-US" level="1"><link href="text/scalc/02/06040000.xhp">Function</link></paragraph> +<h1 id="hd_id3150084"><link href="text/scalc/02/06040000.xhp">Function</link></h1> <paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><ahelp hid="HID_INSWIN_FUNC">Adds a formula to the current cell. Click this icon, and then enter the formula in the <emph>Input line</emph>.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3153360" xml-lang="en-US">This icon is only available when the <emph>Input line</emph> box is not active.</paragraph> diff --git a/source/text/scalc/02/06050000.xhp b/source/text/scalc/02/06050000.xhp index a77157ce0a..906e346752 100644 --- a/source/text/scalc/02/06050000.xhp +++ b/source/text/scalc/02/06050000.xhp @@ -32,7 +32,7 @@ <body> <section id="input_line"> <bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_INPUT" id="bm_id3150084" localize="false"/> -<paragraph role="heading" id="hd_id3153821" xml-lang="en-US" level="1"><link href="text/scalc/02/06050000.xhp">Input line</link></paragraph> +<h1 id="hd_id3153821"><link href="text/scalc/02/06050000.xhp">Input line</link></h1> <paragraph role="paragraph" id="par_id3155922" xml-lang="en-US"><ahelp hid="HID_INSWIN_INPUT">Enter the formula that you want to add to the current cell. You can also click the <link href="text/scalc/01/04060000.xhp">Function Wizard</link> icon to insert a predefined function into the formula.</ahelp></paragraph> </section> <embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/> diff --git a/source/text/scalc/02/06060000.xhp b/source/text/scalc/02/06060000.xhp index 330006a2e4..44f2acdc3b 100644 --- a/source/text/scalc/02/06060000.xhp +++ b/source/text/scalc/02/06060000.xhp @@ -35,7 +35,7 @@ <bookmark_value>functions; canceling input icon</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_CANCEL" id="bm_id3153088" localize="false"/> -<paragraph role="heading" id="hd_id3154514" xml-lang="en-US" level="1"><link href="text/scalc/02/06060000.xhp">Cancel</link></paragraph> +<h1 id="hd_id3154514"><link href="text/scalc/02/06060000.xhp">Cancel</link></h1> <paragraph role="paragraph" id="par_id3153823" xml-lang="en-US"><ahelp hid="HID_INSWIN_CANCEL">Clears the contents of the <emph>Input line</emph>, or cancels the changes that you made to an existing formula.</ahelp></paragraph> </section> <section id="sycancel"> diff --git a/source/text/scalc/02/06070000.xhp b/source/text/scalc/02/06070000.xhp index cfd94b1b04..b144b8fc9c 100644 --- a/source/text/scalc/02/06070000.xhp +++ b/source/text/scalc/02/06070000.xhp @@ -35,7 +35,7 @@ <bookmark_value>functions; accepting input icon</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_INSWIN_OK" id="bm_id3149164" localize="false"/> -<paragraph role="heading" id="hd_id3143267" xml-lang="en-US" level="1"><link href="text/scalc/02/06070000.xhp">Accept</link></paragraph> +<h1 id="hd_id3143267"><link href="text/scalc/02/06070000.xhp">Accept</link></h1> <paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><ahelp hid="HID_INSWIN_OK">Accepts the contents of the <emph>Input line</emph>, and then inserts the contents into the current cell.</ahelp></paragraph> </section> <section id="syaccept"> diff --git a/source/text/scalc/02/06080000.xhp b/source/text/scalc/02/06080000.xhp index be72f4b648..1c088e6818 100644 --- a/source/text/scalc/02/06080000.xhp +++ b/source/text/scalc/02/06080000.xhp @@ -31,7 +31,7 @@ </meta> <body> <bookmark xml-lang="en-US" branch="hid/.uno:ChooseDesign" id="bm_id3147335" localize="false"/> -<paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="1"><link href="text/scalc/02/06080000.xhp">Theme Selection</link></paragraph> +<h1 id="hd_id3153087"><link href="text/scalc/02/06080000.xhp">Theme Selection</link></h1> <paragraph role="paragraph" id="par_id3154515" xml-lang="en-US"><variable id="thementext"><ahelp hid=".uno:ChooseDesign">Applies a formatting style to the selected cells.</ahelp> </variable> The styles include font, border, and background color information.</paragraph> <section id="sythemes"> diff --git a/source/text/scalc/02/08010000.xhp b/source/text/scalc/02/08010000.xhp index d67143c25b..91c796e0ec 100644 --- a/source/text/scalc/02/08010000.xhp +++ b/source/text/scalc/02/08010000.xhp @@ -32,7 +32,7 @@ <body> <section id="position_in_document"> <bookmark xml-lang="en-US" branch="hid/.uno:StatusDocPos" id="bm_id4735827" localize="false"/> -<paragraph role="heading" id="hd_id3145119" xml-lang="en-US" level="1"><link href="text/scalc/02/08010000.xhp">Position in document</link></paragraph> +<h1 id="hd_id3145119"><link href="text/scalc/02/08010000.xhp">Position in document</link></h1> <paragraph role="paragraph" id="par_id3147265" xml-lang="en-US"><ahelp hid=".uno:StatusDocPos">Displays the number of the current sheet and the total number of sheets in the spreadsheet.</ahelp></paragraph> </section> </body> diff --git a/source/text/scalc/02/08080000.xhp b/source/text/scalc/02/08080000.xhp index f47a0f6a0b..a75e9c4185 100644 --- a/source/text/scalc/02/08080000.xhp +++ b/source/text/scalc/02/08080000.xhp @@ -34,7 +34,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3147335"><bookmark_value>formulas;status bar</bookmark_value> </bookmark><comment>MW changed index entry</comment> <bookmark xml-lang="en-US" branch="hid/.uno:StateTableCell" id="bm_id2262199" localize="false"/> -<paragraph role="heading" id="hd_id3147335" xml-lang="en-US" level="1"><link href="text/scalc/02/08080000.xhp">Standard Formula, Date/Time, Error Warning</link></paragraph> +<h1 id="hd_id3147335"><link href="text/scalc/02/08080000.xhp">Standard Formula, Date/Time, Error Warning</link></h1> <paragraph role="paragraph" id="par_id3150791" xml-lang="en-US"><ahelp hid=".uno:StateTableCell">Displays information about the current document. By default, the SUM of the contents of the selected cells is displayed.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3155061" xml-lang="en-US">To change the default formula that is displayed, right-click the field, and then choose the formula that you want. The available formulas are: Average, count of values (COUNTA), count of numbers (COUNT), Maximum, Minimum, Sum, or None.</paragraph> diff --git a/source/text/scalc/02/18010000.xhp b/source/text/scalc/02/18010000.xhp index 3d4eb8f7e9..3754fbf1de 100644 --- a/source/text/scalc/02/18010000.xhp +++ b/source/text/scalc/02/18010000.xhp @@ -33,7 +33,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3156329"><bookmark_value>inserting; objects, toolbar icon</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/.uno:InsertCtrl" id="bm_id5322551" localize="false"/> -<paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1"><link href="text/scalc/02/18010000.xhp">Insert</link></paragraph> +<h1 id="hd_id3156329"><link href="text/scalc/02/18010000.xhp">Insert</link></h1> <paragraph role="paragraph" id="par_id3147336" xml-lang="en-US"><ahelp hid=".uno:InsertCtrl">Click the arrow next to the icon to open the <emph>Insert </emph>toolbar, where you can add graphics and special characters to the current sheet.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3148664" xml-lang="en-US">Tools bar icon:</paragraph> @@ -52,23 +52,23 @@ </table> </section> <paragraph role="paragraph" id="par_id3153188" xml-lang="en-US">You can select the following icons:</paragraph> -<paragraph role="heading" id="hd_id4283883" xml-lang="en-US" level="2"><link href="text/shared/01/04160500.xhp">Floating Frame</link></paragraph> +<h2 id="hd_id4283883"><link href="text/shared/01/04160500.xhp">Floating Frame</link></h2> <embed href="text/shared/01/04160500.xhp#frameeinfuegentext"/> <embed href="text/shared/00/00000404.xhp#syframe"/> -<paragraph role="heading" id="hd_id3149410" xml-lang="en-US" level="2"><link href="text/shared/01/04100000.xhp">Special Character</link></paragraph> +<h2 id="hd_id3149410"><link href="text/shared/01/04100000.xhp">Special Character</link></h2> <embed href="text/shared/01/04100000.xhp#sonder"/> <embed href="text/shared/00/00000404.xhp#syspecial_char"/> -<paragraph role="heading" id="hd_id3151117" xml-lang="en-US" level="2"><link href="text/shared/01/04140000.xhp">From File</link></paragraph> +<h2 id="hd_id3151117"><link href="text/shared/01/04140000.xhp">From File</link></h2> <embed href="text/shared/01/04140000.xhp#grafiktext"/> <embed href="text/shared/00/00000404.xhp#syimage"/> <embed href="text/shared/01/moviesound.xhp#moviesound"/> <embed href="text/shared/00/00000404.xhp#symoviesound"/> -<paragraph role="heading" id="hd_id3633533" xml-lang="en-US" level="2"><link href="text/shared/01/04160300.xhp">Formula</link></paragraph> +<h2 id="hd_id3633533"><link href="text/shared/01/04160300.xhp">Formula</link></h2> <embed href="text/shared/01/04160300.xhp#starmath"/> <embed href="text/shared/00/00000404.xhp#systarmath"/> -<paragraph role="heading" id="par_idN10769" xml-lang="en-US" level="2"><link href="text/schart/01/wiz_chart_type.xhp">Chart</link></paragraph> +<h2 id="par_idN10769"><link href="text/schart/01/wiz_chart_type.xhp">Chart</link></h2> <embed href="text/shared/00/00000404.xhp#systarchart"/> -<paragraph role="heading" id="hd_id7581408" xml-lang="en-US" level="2"><link href="text/shared/01/04150100.xhp">OLE Object</link></paragraph> +<h2 id="hd_id7581408"><link href="text/shared/01/04150100.xhp">OLE Object</link></h2> <embed href="text/shared/01/04150100.xhp#ole"/> <embed href="text/shared/00/00000404.xhp#syole"/> </body> diff --git a/source/text/scalc/02/18020000.xhp b/source/text/scalc/02/18020000.xhp index 416f5fb426..7aa65c9839 100644 --- a/source/text/scalc/02/18020000.xhp +++ b/source/text/scalc/02/18020000.xhp @@ -34,22 +34,22 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150275"><bookmark_value>inserting; cells, toolbar icon</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/.uno:InsCellsCtrl" id="bm_id3156329" localize="false"/> -<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1"><link href="text/scalc/02/18020000.xhp">Insert Cells</link></paragraph> +<h1 id="hd_id3150275"><link href="text/scalc/02/18020000.xhp">Insert Cells</link></h1> <paragraph role="paragraph" id="par_id3156024" xml-lang="en-US"><ahelp hid=".uno:InsCellsCtrl">Click the arrow next to the icon to open the <emph>Insert Cells </emph>toolbar, where you can insert cells, rows, and columns into the current sheet.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_id3150398" xml-lang="en-US">Tools bar icon:</paragraph> <embed href="text/scalc/00/00000404.xhp#syinsert_cells"/> <paragraph role="paragraph" id="par_id3150767" xml-lang="en-US">You can select the following icons:</paragraph> -<paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="2"><link href="text/scalc/01/04020000.xhp">Insert Cells Down</link></paragraph> +<h2 id="hd_id3150439"><link href="text/scalc/01/04020000.xhp">Insert Cells Down</link></h2> <embed href="text/scalc/01/04020000.xhp#zellenuntentext"/> <embed href="text/scalc/00/00000404.xhp#syinsert_cells_down"/> -<paragraph role="heading" id="hd_id3146119" xml-lang="en-US" level="2"><link href="text/scalc/01/04020000.xhp">Insert Cells Right</link></paragraph> +<h2 id="hd_id3146119"><link href="text/scalc/01/04020000.xhp">Insert Cells Right</link></h2> <embed href="text/scalc/01/04020000.xhp#zellenrechtstext"/> <embed href="text/scalc/00/00000404.xhp#syinsert_cells_right"/> -<paragraph role="heading" id="hd_id3153190" xml-lang="en-US" level="2"><link href="text/scalc/01/04020000.xhp">Rows</link></paragraph> +<h2 id="hd_id3153190"><link href="text/scalc/01/04020000.xhp">Rows</link></h2> <embed href="text/scalc/01/04020000.xhp#zeilenganzetext"/> <embed href="text/scalc/00/00000404.xhp#syinsert_rows"/> -<paragraph role="heading" id="hd_id3153726" xml-lang="en-US" level="2"><link href="text/scalc/01/04020000.xhp">Columns</link></paragraph> +<h2 id="hd_id3153726"><link href="text/scalc/01/04020000.xhp">Columns</link></h2> <embed href="text/scalc/01/04020000.xhp#spaltenganzetext"/> <embed href="text/scalc/00/00000404.xhp#syinsert_columns"/> </body> diff --git a/source/text/scalc/05/02140000.xhp b/source/text/scalc/05/02140000.xhp index faf36e5db8..42fbf28928 100644 --- a/source/text/scalc/05/02140000.xhp +++ b/source/text/scalc/05/02140000.xhp @@ -29,7 +29,7 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3146797"><bookmark_value>error codes;list of</bookmark_value> </bookmark><comment>mw deleted "%PRODUCTNAME Calc;error codes"</comment> -<paragraph xml-lang="en-US" id="hd_id3146797" role="heading" level="1"><link href="text/scalc/05/02140000.xhp">Error Codes in <item type="productname">%PRODUCTNAME</item> Calc</link></paragraph> +<h1 id="hd_id3146797"><link href="text/scalc/05/02140000.xhp">Error Codes in <item type="productname">%PRODUCTNAME</item> Calc</link></h1> <paragraph xml-lang="en-US" id="par_id3150275" role="paragraph">The following table is an overview of the error messages for <item type="productname">%PRODUCTNAME</item> Calc. If the error occurs in the cell that contains the cursor, the error message is displayed on the <emph>Status Bar</emph>.</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id0202201010205429"><bookmark_value>### error message</bookmark_value></bookmark> <bookmark xml-lang="en-US" branch="index" id="bm_id3154634"><bookmark_value>invalid references; error messages</bookmark_value> diff --git a/source/text/scalc/05/empty_cells.xhp b/source/text/scalc/05/empty_cells.xhp index 56ccc19b73..78ec34d558 100644 --- a/source/text/scalc/05/empty_cells.xhp +++ b/source/text/scalc/05/empty_cells.xhp @@ -30,7 +30,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3146799"> <bookmark_value>empty cells;handling of</bookmark_value> </bookmark><comment>i86303</comment> -<paragraph role="heading" id="hd_id1502121" xml-lang="en-US" level="1"><variable id="empty_cells"><link href="text/scalc/05/empty_cells.xhp">Handling of Empty Cells</link></variable></paragraph> +<h1 id="hd_id1502121"><variable id="empty_cells"><link href="text/scalc/05/empty_cells.xhp">Handling of Empty Cells</link></variable></h1> <paragraph role="paragraph" id="par_id8266853" xml-lang="en-US">In older versions of the software, empty cells were forced to numeric 0 in some contexts and to empty string in others, except in direct comparison where =A1=0 and =A1="" both resulted in TRUE if A1 was empty. Emptiness now is inherited until used, so both =VLOOKUP(...)=0 and =VLOOKUP(...)="" give TRUE if the lookup resulted in an empty cell being returned. </paragraph> <paragraph role="paragraph" id="par_id2733542" xml-lang="en-US">A simple reference to an empty cell is still displayed as numeric 0 but is not necessarily of type numeric anymore, so also comparisons with the referencing cell work as expected. </paragraph> diff --git a/source/text/scalc/guide/address_auto.xhp b/source/text/scalc/guide/address_auto.xhp index 92fc4ffbcc..dfccbc2aee 100644 --- a/source/text/scalc/guide/address_auto.xhp +++ b/source/text/scalc/guide/address_auto.xhp @@ -42,7 +42,7 @@ </bookmark> <comment>mw changes "names;..." entry to "text in cells;..."</comment><comment>mw inserted three index entries from text/shared/optionen/01060500.xhp. Changed "finding;..." entry to "recognizing;..." entry. Adding (Calc) is no longer necessary in this file.</comment> -<paragraph id="hd_id3148797" role="heading" level="1" xml-lang="en-US"><variable id="address_auto"><link href="text/scalc/guide/address_auto.xhp">Recognizing Names as Addressing</link></variable></paragraph> +<h1 id="hd_id3148797"><variable id="address_auto"><link href="text/scalc/guide/address_auto.xhp">Recognizing Names as Addressing</link></variable></h1> <paragraph id="par_id3152597" role="paragraph" xml-lang="en-US">You can use cells with text to refer to the rows or to the columns that contain the cells.</paragraph><comment>removed table as a workaround for issue 108715</comment> <paragraph id="par_id3156283" role="paragraph" xml-lang="en-US"><image id="img_id3154942" src="media/helpimg/names_as_addressing.png" width="5.408cm" height="2.212cm" localize="true"><alt xml-lang="en-US" id="alt_id3154942">Example spreadsheet</alt></image></paragraph> <paragraph id="par_id3154512" role="paragraph" xml-lang="en-US">In the example spreadsheet, you can use the string <item type="literal">'Column One'</item> in a formula to refer to the cell range <item type="literal">B3</item> to <item type="literal">B5</item>, or <item type="literal">'Column Two'</item> for the cell range <item type="literal">C2</item> to <item type="literal">C5</item>. You can also use <item type="literal">'Row One'</item> for the cell range <item type="literal">B3</item> to <item type="literal">D3</item>, or <item type="literal">'Row Two'</item> for the cell range <item type="literal">B4</item> to <item type="literal">D4</item>. The result of a formula that uses a cell name, for example, <item type="literal">SUM('Column One')</item>, is 600.</paragraph> diff --git a/source/text/scalc/guide/auto_off.xhp b/source/text/scalc/guide/auto_off.xhp index 2b901dd376..a1d739bb8d 100644 --- a/source/text/scalc/guide/auto_off.xhp +++ b/source/text/scalc/guide/auto_off.xhp @@ -46,7 +46,7 @@ </bookmark> <comment>mw added one entry</comment> -<paragraph id="hd_id3149456" role="heading" level="1" xml-lang="en-US"><variable id="auto_off"><link href="text/scalc/guide/auto_off.xhp">Deactivating Automatic Changes</link> </variable></paragraph> +<h1 id="hd_id3149456"><variable id="auto_off"><link href="text/scalc/guide/auto_off.xhp">Deactivating Automatic Changes</link> </variable></h1> <paragraph id="par_id3156442" role="paragraph" xml-lang="en-US">By default, $[officename] automatically corrects many common typing errors and applies formatting while you type. You can immediately undo any automatic changes with <switchinline select="sys"><caseinline select="MAC">Command </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> diff --git a/source/text/scalc/guide/calc_date.xhp b/source/text/scalc/guide/calc_date.xhp index 9d7e0ad89d..3d9b9ad3fb 100644 --- a/source/text/scalc/guide/calc_date.xhp +++ b/source/text/scalc/guide/calc_date.xhp @@ -35,7 +35,7 @@ </bookmark> -<paragraph id="hd_id3146120" role="heading" level="1" xml-lang="en-US"><variable id="calc_date"><link href="text/scalc/guide/calc_date.xhp">Calculating With Dates and Times</link></variable></paragraph> +<h1 id="hd_id3146120"><variable id="calc_date"><link href="text/scalc/guide/calc_date.xhp">Calculating With Dates and Times</link></variable></h1> <paragraph id="par_id3154320" role="paragraph" xml-lang="en-US">In $[officename] Calc, you can perform calculations with current date and time values. As an example, to find out exactly how old you are in seconds or hours, follow the following steps:</paragraph> <list type="ordered"> diff --git a/source/text/scalc/guide/calculate.xhp b/source/text/scalc/guide/calculate.xhp index 4d31598097..dd1e83601a 100644 --- a/source/text/scalc/guide/calculate.xhp +++ b/source/text/scalc/guide/calculate.xhp @@ -29,7 +29,7 @@ <bookmark_value>calculating; spreadsheets</bookmark_value> <bookmark_value>formulas; calculating</bookmark_value> </bookmark><comment>mw changed "formulas;..." entry</comment> -<paragraph id="hd_id3150791" role="heading" xml-lang="en-US" level="1"><variable id="calculate"><link href="text/scalc/guide/calculate.xhp">Calculating in Spreadsheets</link></variable></paragraph> +<h1 id="hd_id3150791"><variable id="calculate"><link href="text/scalc/guide/calculate.xhp">Calculating in Spreadsheets</link></variable></h1> <paragraph id="par_id3146120" role="paragraph" xml-lang="en-US">The following is an example of a calculation in $[officename] Calc.</paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/cellstyle_by_formula.xhp b/source/text/scalc/guide/cellstyle_by_formula.xhp index 197f46ab45..049787bd73 100644 --- a/source/text/scalc/guide/cellstyle_by_formula.xhp +++ b/source/text/scalc/guide/cellstyle_by_formula.xhp @@ -36,7 +36,7 @@ </bookmark> <comment>mw deleted "applying;"</comment> -<paragraph id="hd_id3145673" role="heading" level="1" xml-lang="en-US"><variable id="cellstyle_by_formula"><link href="text/scalc/guide/cellstyle_by_formula.xhp">Assigning Formats by Formula</link></variable></paragraph> +<h1 id="hd_id3145673"><variable id="cellstyle_by_formula"><link href="text/scalc/guide/cellstyle_by_formula.xhp">Assigning Formats by Formula</link></variable></h1> <paragraph id="par_id3150275" role="paragraph" xml-lang="en-US">The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; "Red"; "Green")) applies the cell style "Red" to cells if the value is greater than 3, otherwise the cell style "Green" is applied.</paragraph> <paragraph id="par_id3151385" role="paragraph" xml-lang="en-US">If you would like to apply a formula to all cells in a selected area, you can use the <item type="menuitem">Find & Replace</item> dialog.</paragraph> diff --git a/source/text/scalc/guide/edit_multitables.xhp b/source/text/scalc/guide/edit_multitables.xhp index ab7b141dd8..211c1c5d95 100644 --- a/source/text/scalc/guide/edit_multitables.xhp +++ b/source/text/scalc/guide/edit_multitables.xhp @@ -32,7 +32,7 @@ <bookmark_value>sheets; simultaneous multiple filling</bookmark_value> </bookmark> <comment>mw moved "multiple sheets" and "selecting;" to multitables.xhp, transferred "sheets;" from there and deleted "sheets;transferring.."</comment> -<paragraph xml-lang="en-US" id="hd_id3149456" role="heading" level="1"><variable id="edit_multitables"><link href="text/scalc/guide/edit_multitables.xhp">Copying to Multiple Sheets</link></variable></paragraph> +<h1 id="hd_id3149456"><variable id="edit_multitables"><link href="text/scalc/guide/edit_multitables.xhp">Copying to Multiple Sheets</link></variable></h1> <paragraph xml-lang="en-US" id="par_id3150868" role="paragraph">In $[officename] Calc, you can insert values, text or formulas that are simultaneously copied to other selected sheets of your document.</paragraph> <list type="unordered"> <listitem> diff --git a/source/text/scalc/guide/integer_leading_zero.xhp b/source/text/scalc/guide/integer_leading_zero.xhp index 70391f0582..eb6b92d216 100644 --- a/source/text/scalc/guide/integer_leading_zero.xhp +++ b/source/text/scalc/guide/integer_leading_zero.xhp @@ -39,7 +39,7 @@ </bookmark> <comment>UFI: inserted "converting;text to numbers"</comment><comment>mw changed "converting;" and deleted "numbers,changing..."</comment> -<paragraph id="hd_id3147560" role="heading" level="1" xml-lang="en-US"><variable id="integer_leading_zero"><link href="text/scalc/guide/integer_leading_zero.xhp">Entering a Number with Leading Zeros</link></variable></paragraph> +<h1 id="hd_id3147560"><variable id="integer_leading_zero"><link href="text/scalc/guide/integer_leading_zero.xhp">Entering a Number with Leading Zeros</link></variable></h1> <section id="inttext"> <paragraph id="par_id3153194" role="paragraph" xml-lang="en-US">There are various ways to enter integers starting with a zero:</paragraph> diff --git a/source/text/scalc/guide/main.xhp b/source/text/scalc/guide/main.xhp index 6def7f40d7..b1bcb5f72c 100644 --- a/source/text/scalc/guide/main.xhp +++ b/source/text/scalc/guide/main.xhp @@ -90,7 +90,7 @@ <embed href="text/scalc/guide/matrixformula.xhp#matrixformula"/> <embed href="text/scalc/guide/table_rotate.xhp#table_rotate"/> <embed href="text/scalc/guide/userdefined_function.xhp#userdefined_function"/> -<paragraph role="heading" id="hd_id3152899" xml-lang="en-US" level="2">Entering References<comment>mw deleted link to Calc guide address_byname.xhp</comment></paragraph> +<h2 id="hd_id3152899">Entering References<comment>mw deleted link to Calc guide address_byname.xhp</comment></h2> <embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/> <embed href="text/scalc/guide/address_auto.xhp#address_auto"/> <embed href="text/scalc/guide/cellreference_dragdrop.xhp#cellreference_dragdrop"/> diff --git a/source/text/scalc/guide/pivotchart_create.xhp b/source/text/scalc/guide/pivotchart_create.xhp index a960da8cd1..8023b65b3f 100644 --- a/source/text/scalc/guide/pivotchart_create.xhp +++ b/source/text/scalc/guide/pivotchart_create.xhp @@ -19,7 +19,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id531525141739769"> <bookmark_value>pivot chart;creating</bookmark_value> </bookmark> - <paragraph role="heading" id="hd_id441525141699185" level="1" xml-lang="en-US"><variable id="pivotchartcreate"><link href="text/scalc/guide/pivotchart_create.xhp">Creating Pivot Charts</link></variable></paragraph> + <h1 id="hd_id441525141699185"><variable id="pivotchartcreate"><link href="text/scalc/guide/pivotchart_create.xhp">Creating Pivot Charts</link></variable></h1> <paragraph role="paragraph" id="par_id481525142550652" xml-lang="en-US">To create a pivot chart proceed as below:</paragraph> <list type="ordered"> <listitem> diff --git a/source/text/scalc/guide/pivotchart_delete.xhp b/source/text/scalc/guide/pivotchart_delete.xhp index 3a57a36437..da5122f892 100644 --- a/source/text/scalc/guide/pivotchart_delete.xhp +++ b/source/text/scalc/guide/pivotchart_delete.xhp @@ -16,7 +16,7 @@ </topic> </meta> <body> - <paragraph role="heading" id="hd_id231525147891984" level="1" xml-lang="en-US"><variable id="pivotchartdelete"><link href="text/scalc/guide/pivotchart_delete.xhp">Deleting a Pivot Chart</link></variable></paragraph> + <h1 id="hd_id231525147891984"><variable id="pivotchartdelete"><link href="text/scalc/guide/pivotchart_delete.xhp">Deleting a Pivot Chart</link></variable></h1> <bookmark xml-lang="en-US" branch="index" id="bm_id231525149357908"> <bookmark_value>pivot chart;deleting</bookmark_value> </bookmark> diff --git a/source/text/scalc/guide/pivotchart_edit.xhp b/source/text/scalc/guide/pivotchart_edit.xhp index 99174e16c8..423a5a629a 100644 --- a/source/text/scalc/guide/pivotchart_edit.xhp +++ b/source/text/scalc/guide/pivotchart_edit.xhp @@ -19,7 +19,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id661525144028976"> <bookmark_value>pivot chart;editing</bookmark_value> </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> + <h1 id="hd_id271525144002806"><variable id="pivotchartedit"><link href="text/scalc/guide/pivotchart_edit.xhp">Editing Pivot Charts</link></variable></h1> <paragraph role="paragraph" id="par_id971525144066574" xml-lang="en-US">Edit a pivot chart in the same way as normal charts.</paragraph> <h2 id="hd_id5631580">To edit a pivot chart</h2> <embed href="text/schart/main0000.xhp#chartedit"/> diff --git a/source/text/scalc/guide/pivotchart_filter.xhp b/source/text/scalc/guide/pivotchart_filter.xhp index 19cbe99e45..12462de67c 100644 --- a/source/text/scalc/guide/pivotchart_filter.xhp +++ b/source/text/scalc/guide/pivotchart_filter.xhp @@ -16,7 +16,7 @@ </topic> </meta> <body> - <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> + <h1 id="hd_id401525165755583"><variable id="pivotchartfilter"><link href="text/scalc/guide/pivotchart_filter.xhp">Filtering Pivot Charts</link></variable></h1> <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> <h2 id="hd_id201525166689277">Pivot chart field buttons</h2> diff --git a/source/text/scalc/guide/pivotchart_update.xhp b/source/text/scalc/guide/pivotchart_update.xhp index 64d793c2ec..eb2cf8949f 100644 --- a/source/text/scalc/guide/pivotchart_update.xhp +++ b/source/text/scalc/guide/pivotchart_update.xhp @@ -19,7 +19,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id801525146393791"> <bookmark_value>pivot chart;update</bookmark_value> </bookmark> - <paragraph role="heading" id="hd_id281525146417678" level="1" xml-lang="en-US"><variable id="pivotchartupdate"><link href="text/scalc/guide/pivotchart_update.xhp">Updating Pivot Charts</link></variable></paragraph> + <h1 id="hd_id281525146417678"><variable id="pivotchartupdate"><link href="text/scalc/guide/pivotchart_update.xhp">Updating Pivot Charts</link></variable></h1> <paragraph role="paragraph" id="par_id831525146706944" xml-lang="en-US">If the data of the source sheet has been changed, you must refresh the pivot table and the pivot chart is updated accordingly. To refresh the pivot table (and thus the pivot chart):</paragraph> <list type="unordered"> <listitem> diff --git a/source/text/scalc/guide/table_cellmerge.xhp b/source/text/scalc/guide/table_cellmerge.xhp index b211e6b8c7..e107b9144a 100644 --- a/source/text/scalc/guide/table_cellmerge.xhp +++ b/source/text/scalc/guide/table_cellmerge.xhp @@ -31,7 +31,7 @@ <bookmark_value>split/splitting cells</bookmark_value> </bookmark> <section id="merge_unmerge_cells"> - <paragraph xml-lang="en-US" id="hd_id8005005" role="heading" level="1"><variable id="table_cellmerge"><link href="text/scalc/guide/table_cellmerge.xhp">Merge and Unmerge Cells</link></variable></paragraph> + <h1 id="hd_id8005005"><variable id="table_cellmerge"><link href="text/scalc/guide/table_cellmerge.xhp">Merge and Unmerge Cells</link></variable></h1> <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> |