summaryrefslogtreecommitdiff
path: root/source/text/scalc/05
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2023-03-13 16:41:53 +0100
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-03-16 15:18:30 +0000
commit4453c0b2edae4934f87594d5974783c4a1a5ea54 (patch)
treeda7008bd439cc57cd8d44597f8cba6fc1808aa0c /source/text/scalc/05
parent77cb682cd1b004e7247560e60f603a4bb0565b8d (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/05')
-rw-r--r--source/text/scalc/05/02140000.xhp2
-rw-r--r--source/text/scalc/05/empty_cells.xhp2
2 files changed, 2 insertions, 2 deletions
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>