diff options
| author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2023-03-13 16:41:53 +0100 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2023-03-16 15:18:30 +0000 |
| commit | 4453c0b2edae4934f87594d5974783c4a1a5ea54 (patch) | |
| tree | da7008bd439cc57cd8d44597f8cba6fc1808aa0c /source/text/scalc/guide | |
| parent | 77cb682cd1b004e7247560e60f603a4bb0565b8d (diff) | |
convert paragraphs with role="heading" & childelements to → h<level>
and also drop the language that was changed to implied previously/defaults to
en-US unless specified.
This change doesn't affect translations, only the content of the
paragraph/headings is extracted.
done with:
perl -CSD -pi -e 'BEGIN {$base = qr/role="heading"|level="(?<level>\d+)"|(?<id>id="[^"]+")/;} s#<paragraph(((\s+($base)){3})|(\s+($base|xml-lang="en-US")){4})>(?<body>.*?)</paragraph>#<h$+{level} $+{id}>$+{body}</h$+{level}>#g'
and manually undoing the one that uses <sup>in body that's not valid
according to the dtd in the h tags.
Change-Id: Ibd4aed3157ed168cd5005161575672a392e59202
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148797
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/guide')
| -rw-r--r-- | source/text/scalc/guide/address_auto.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/auto_off.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/calc_date.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/calculate.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/cellstyle_by_formula.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/edit_multitables.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/integer_leading_zero.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/main.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/pivotchart_create.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/pivotchart_delete.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/pivotchart_edit.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/pivotchart_filter.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/pivotchart_update.xhp | 2 | ||||
| -rw-r--r-- | source/text/scalc/guide/table_cellmerge.xhp | 2 |
14 files changed, 14 insertions, 14 deletions
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> |