This is an automated email from the ASF dual-hosted git repository.
mseidel pushed a commit to branch AOO42X
in repository https://gitbox.apache.org/repos/asf/openoffice.git
The following commit(s) were added to refs/heads/AOO42X by this push:
new 06f0d0cc6f Small corrections in scalc Help files
06f0d0cc6f is described below
commit 06f0d0cc6fa77afc5b47689fa17dd2eedbb84eca
Author: mseidel <msei...@apache.org>
AuthorDate: Tue Jan 2 21:50:18 2024 +0100
Small corrections in scalc Help files
(cherry picked from commit f773ab65b2b83ad4dc8eebfb704aca54989ab28d)
---
.../helpcontent2/source/text/scalc/01/02110000.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/02120100.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/02140600.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/04020000.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/04060000.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/04060103.xhp | 4 +--
.../helpcontent2/source/text/scalc/01/04060104.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/04060106.xhp | 24 +++++++-------
.../helpcontent2/source/text/scalc/01/04060107.xhp | 4 +--
.../helpcontent2/source/text/scalc/01/04060109.xhp | 4 +--
.../helpcontent2/source/text/scalc/01/04060110.xhp | 8 ++---
.../helpcontent2/source/text/scalc/01/04060116.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/04060118.xhp | 4 +--
.../helpcontent2/source/text/scalc/01/04060182.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/04060184.xhp | 7 ++--
.../helpcontent2/source/text/scalc/01/04060185.xhp | 10 +++---
.../helpcontent2/source/text/scalc/01/04070100.xhp | 4 +--
.../helpcontent2/source/text/scalc/01/05030300.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/05050100.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/05070500.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/06050000.xhp | 4 +--
.../helpcontent2/source/text/scalc/01/06060100.xhp | 4 +--
.../helpcontent2/source/text/scalc/01/06060200.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/12070000.xhp | 4 +--
.../helpcontent2/source/text/scalc/01/12090102.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/12090105.xhp | 4 +--
.../helpcontent2/source/text/scalc/01/12120100.xhp | 8 ++---
.../helpcontent2/source/text/scalc/01/12120300.xhp | 2 +-
.../helpcontent2/source/text/scalc/01/func_day.xhp | 2 +-
main/helpcontent2/source/text/scalc/01/solver.xhp | 2 +-
.../source/text/scalc/05/empty_cells.xhp | 2 +-
.../source/text/scalc/guide/borders.xhp | 2 +-
.../source/text/scalc/guide/cell_protect.xhp | 4 +--
.../source/text/scalc/guide/cellreferences.xhp | 2 +-
.../source/text/scalc/guide/csv_files.xhp | 2 +-
.../source/text/scalc/guide/database_define.xhp | 2 +-
.../source/text/scalc/guide/dbase_files.xhp | 4 +--
.../source/text/scalc/guide/design.xhp | 2 +-
.../source/text/scalc/guide/filters.xhp | 2 +-
.../source/text/scalc/guide/finding.xhp | 8 ++---
.../source/text/scalc/guide/format_table.xhp | 2 +-
.../source/text/scalc/guide/fraction_enter.xhp | 2 +-
.../source/text/scalc/guide/line_fix.xhp | 2 +-
.../source/text/scalc/guide/move_dragdrop.xhp | 8 ++---
.../source/text/scalc/guide/multioperation.xhp | 2 +-
.../source/text/scalc/guide/print_landscape.xhp | 2 +-
.../source/text/scalc/guide/specialfilter.xhp | 38 +++++++++++-----------
.../text/scalc/guide/userdefined_function.xhp | 2 +-
.../source/text/scalc/guide/validity.xhp | 2 +-
49 files changed, 106 insertions(+), 109 deletions(-)
diff --git a/main/helpcontent2/source/text/scalc/01/02110000.xhp
b/main/helpcontent2/source/text/scalc/01/02110000.xhp
index 8daf31cb68..9209d47d6c 100644
--- a/main/helpcontent2/source/text/scalc/01/02110000.xhp
+++ b/main/helpcontent2/source/text/scalc/01/02110000.xhp
@@ -166,7 +166,7 @@
</table>
<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_DROPMODE_URL"
id="bm_id3146876" localize="false"/>
<paragraph role="heading" id="hd_id3149009" xml-lang="en-US" level="3"
l10n="U" oldref="29">Insert as Hyperlink</paragraph>
-<paragraph role="paragraph" id="par_id3146938" xml-lang="en-US" l10n="U"
oldref="30"><ahelp hid="HID_SC_DROPMODE_URL">Inserts a hyperlink when you
drag-and-drop an object from the Navigator into a document.</ahelp> You can
later click the created hyperlink to set the cursor and the view to the
respective object. </paragraph>
+<paragraph role="paragraph" id="par_id3146938" xml-lang="en-US" l10n="U"
oldref="30"><ahelp hid="HID_SC_DROPMODE_URL">Inserts a hyperlink when you
drag-and-drop an object from the Navigator into a document.</ahelp> You can
later click the created hyperlink to set the cursor and the view to the
respective object.</paragraph>
<paragraph role="note" id="par_id3880733" xml-lang="en-US" l10n="NEW">If you
insert a hyperlink that links to an open document, you need to save the
document before you can use the hyperlink.<comment>UFI: fixes bugtraq
5009354</comment></paragraph>
<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_DROPMODE_LINK"
id="bm_id3150740" localize="false"/>
<paragraph role="heading" id="hd_id3154682" xml-lang="en-US" level="3"
l10n="U" oldref="31">Insert as Link</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/02120100.xhp
b/main/helpcontent2/source/text/scalc/01/02120100.xhp
index f44790a71d..835ef502e5 100644
--- a/main/helpcontent2/source/text/scalc/01/02120100.xhp
+++ b/main/helpcontent2/source/text/scalc/01/02120100.xhp
@@ -88,7 +88,7 @@
</table>
<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_HF_FILE" id="bm_id3154020"
localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3145792" role="heading" level="2" l10n="U"
-oldref="11">File Name </paragraph>
+oldref="11">File Name</paragraph>
<paragraph xml-lang="en-US" id="par_id3150206" role="paragraph" l10n="CHG"
oldref="12"><ahelp hid="HID_SC_HF_FILE">Inserts a file name placeholder in the
selected area.</ahelp> Click to insert the title. Long-click <comment>UFI: this
is still a long-click</comment>to select either title, file name or path/file
name from the submenu. If a title has not be assigned (see <emph>File -
Properties</emph>), the file name will be inserted instead.</paragraph>
<table id="tbl_id3149529">
<tablerow>
diff --git a/main/helpcontent2/source/text/scalc/01/02140600.xhp
b/main/helpcontent2/source/text/scalc/01/02140600.xhp
index 3df74b76ae..4c3b2091a0 100644
--- a/main/helpcontent2/source/text/scalc/01/02140600.xhp
+++ b/main/helpcontent2/source/text/scalc/01/02140600.xhp
@@ -55,7 +55,7 @@
<paragraph role="heading" id="hd_id3153764" xml-lang="en-US" level="3"
l10n="U" oldref="12">Left</paragraph>
<paragraph role="paragraph" id="par_id3156382" xml-lang="en-US" l10n="U"
oldref="13"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_LEFT">Creates a
series running from right to left in the selected cell range using the defined
increment to the end value.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3147344" xml-lang="en-US" level="2"
l10n="U" oldref="14">Series Type</paragraph>
-<paragraph role="paragraph" id="par_id3149257" xml-lang="en-US" l10n="U"
oldref="15">Defines the series type. Choose between <emph>Linear, Growth, Date
</emph>and <emph>AutoFill</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3149257" xml-lang="en-US" l10n="U"
oldref="15">Defines the series type. Choose between <emph>Linear, Growth,
Date</emph> and <emph>AutoFill</emph>.</paragraph>
<bookmark xml-lang="en-US"
branch="hid/sc:RadioButton:RID_SCDLG_FILLSERIES:BTN_ARITHMETIC"
id="bm_id3150298" localize="false"/>
<paragraph role="heading" id="hd_id3148488" xml-lang="en-US" level="3"
l10n="U" oldref="16">Linear</paragraph>
<paragraph role="paragraph" id="par_id3159238" xml-lang="en-US" l10n="U"
oldref="17"><ahelp
hid="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_ARITHMETIC">Creates a linear
number series using the defined increment and end value.</ahelp></paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/04020000.xhp
b/main/helpcontent2/source/text/scalc/01/04020000.xhp
index cdc1b732eb..7de4d63c79 100644
--- a/main/helpcontent2/source/text/scalc/01/04020000.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04020000.xhp
@@ -36,7 +36,7 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:InsertCell" id="bm_id6503296"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:InsertCell" id="bm_id3147264"
localize="false"/><paragraph role="heading" id="hd_id3156023" xml-lang="en-US"
level="1" l10n="U" oldref="1"> Insert Cells</paragraph>
-<paragraph role="paragraph" id="par_id3150542" xml-lang="en-US" l10n="U"
oldref="2"><variable id="zelleneinfuegentext"><ahelp
hid=".uno:InsertCell">Opens the<emph> Insert Cells </emph>dialog, in which you
can insert new cells according to the options that you specify.</ahelp>
+<paragraph role="paragraph" id="par_id3150542" xml-lang="en-US" l10n="U"
oldref="2"><variable id="zelleneinfuegentext"><ahelp
hid=".uno:InsertCell">Opens the <emph>Insert Cells</emph> dialog, in which you
can insert new cells according to the options that you specify.</ahelp>
</variable> You can delete cells by choosing <link
href="text/scalc/01/02160000.xhp" name="Edit - Delete Cells"><emph>Edit -
Delete Cells</emph></link>.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#eize"/>
diff --git a/main/helpcontent2/source/text/scalc/01/04060000.xhp
b/main/helpcontent2/source/text/scalc/01/04060000.xhp
index faafc6fc42..5cc422489d 100644
--- a/main/helpcontent2/source/text/scalc/01/04060000.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060000.xhp
@@ -87,7 +87,7 @@
<paragraph role="tip" id="par_id3146966" xml-lang="en-US" l10n="U"
oldref="56">To select a single function from a complex formula consisting of
several functions, double-click the function in the formula window.</paragraph>
<!-- removed HID SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_FORWARD -->
<paragraph role="heading" id="hd_id3155762" xml-lang="en-US" level="3"
l10n="U" oldref="54">Next</paragraph>
-<paragraph role="paragraph" id="par_id3149316" xml-lang="en-US" l10n="U"
oldref="55"><ahelp hid="SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_FORWARD">Moves
forward through the formula components in the formula window.</ahelp> This
button can also be used to assign functions to the formula. If you select a
function and click the <emph>Next </emph>button, the selection appears in the
formula window.</paragraph>
+<paragraph role="paragraph" id="par_id3149316" xml-lang="en-US" l10n="U"
oldref="55"><ahelp hid="SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_FORWARD">Moves
forward through the formula components in the formula window.</ahelp> This
button can also be used to assign functions to the formula. If you select a
function and click the <emph>Next</emph> button, the selection appears in the
formula window.</paragraph>
<paragraph role="tip" id="par_id3159262" xml-lang="en-US" l10n="U"
oldref="57">Double-click a function in the selection window to transfer it to
the formula window.</paragraph>
<paragraph role="heading" id="hd_id3148745" xml-lang="en-US" level="3"
l10n="U" oldref="58">Cancel</paragraph>
<paragraph role="paragraph" id="par_id3147402" xml-lang="en-US" l10n="U"
oldref="59">Closes the dialog without implementing the formula.</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/04060103.xhp
b/main/helpcontent2/source/text/scalc/01/04060103.xhp
index 003443aa24..8b9f9a9481 100644
--- a/main/helpcontent2/source/text/scalc/01/04060103.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060103.xhp
@@ -56,7 +56,7 @@ oldref="361">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3151074" role="paragraph" l10n="U"
oldref="364">
<emph>DatePurchased</emph> is the date of acquisition.</paragraph>
<paragraph xml-lang="en-US" id="par_id3144765" role="paragraph" l10n="U"
oldref="365">
-<emph>FirstPeriod </emph>is the end date of the first settlement
period.</paragraph>
+<emph>FirstPeriod</emph> is the end date of the first settlement
period.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156286" role="paragraph" l10n="U"
oldref="366">
<emph>Salvage</emph> is the salvage value of the capital asset at the end of
the depreciable life.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153415" role="paragraph" l10n="U"
oldref="367">
@@ -82,7 +82,7 @@ oldref="371">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3163807" role="paragraph" l10n="U"
oldref="374">
<emph>DatePurchased</emph> is the date of acquisition.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148488" role="paragraph" l10n="U"
oldref="375">
-<emph>FirstPeriod </emph>is the end date of the first settlement
period.</paragraph>
+<emph>FirstPeriod</emph> is the end date of the first settlement
period.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149530" role="paragraph" l10n="U"
oldref="376">
<emph>Salvage</emph> is the salvage value of the capital asset at the end of
the depreciable life.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148633" role="paragraph" l10n="U"
oldref="377">
diff --git a/main/helpcontent2/source/text/scalc/01/04060104.xhp
b/main/helpcontent2/source/text/scalc/01/04060104.xhp
index 58f0e87f5d..41afb4281e 100644
--- a/main/helpcontent2/source/text/scalc/01/04060104.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060104.xhp
@@ -424,7 +424,7 @@
</bookmark><comment>mw added "blank..." and "empty cells;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTLEER" id="bm_id3148940"
localize="false"/>
<paragraph role="heading" id="hd_id3159148" xml-lang="en-US" level="2"
l10n="U" oldref="77">ISBLANK</paragraph>
-<paragraph role="paragraph" id="par_id3148800" xml-lang="en-US" l10n="U"
oldref="78"><ahelp hid="HID_FUNC_ISTLEER">Returns TRUE if the reference to a
cell is blank.</ahelp> This function is used to determine if the content of a
cell is empty. A cell with a formula inside is not empty. </paragraph>
+<paragraph role="paragraph" id="par_id3148800" xml-lang="en-US" l10n="U"
oldref="78"><ahelp hid="HID_FUNC_ISTLEER">Returns TRUE if the reference to a
cell is blank.</ahelp> This function is used to determine if the content of a
cell is empty. A cell with a formula inside is not empty.</paragraph>
<embed href="text/shared/00/00000001.xhp#wahr"/>
<paragraph role="heading" id="hd_id3159162" xml-lang="en-US" level="3"
l10n="U" oldref="79">Syntax</paragraph>
<paragraph role="code" id="par_id3158406" xml-lang="en-US" l10n="U"
oldref="80">ISBLANK(Value)</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/04060106.xhp
b/main/helpcontent2/source/text/scalc/01/04060106.xhp
index eaba1398cc..1c78776781 100644
--- a/main/helpcontent2/source/text/scalc/01/04060106.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060106.xhp
@@ -112,7 +112,7 @@ oldref="60">ACOSH</paragraph>
<paragraph xml-lang="en-US" id="hd_id3145295" role="heading" level="3" l10n="U"
oldref="62">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3151017" role="code" l10n="U"
oldref="63">ACOSH(Number)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149000" role="paragraph" l10n="CHG"
oldref="64"> This function returns the inverse hyperbolic cosine of
<emph>Number</emph>, that is the number whose hyperbolic cosine is Number.
</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149000" role="paragraph" l10n="CHG"
oldref="64"> This function returns the inverse hyperbolic cosine of
<emph>Number</emph>, that is the number whose hyperbolic cosine is
Number.</paragraph>
<paragraph xml-lang="en-US" id="par_id6393932" role="paragraph" l10n="NEW">
Number must be greater than or equal to 1.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150566" role="heading" level="3" l10n="U"
oldref="65">Example</paragraph>
@@ -139,7 +139,7 @@ oldref="75">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3155375" role="paragraph" l10n="CHG"
oldref="76">
<item type="input">=ACOT(1)</item> returns 0.785398163397448 (PI/4
radians).</paragraph>
<paragraph xml-lang="en-US" id="par_id8589434" role="paragraph" l10n="NEW">
-<item type="input">=DEGREES(ACOT(1))</item> returns 45. The tangent of 45
degrees is 1. </paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN,
ATAN, ATAN2</comment>
+<item type="input">=DEGREES(ACOT(1))</item> returns 45. The tangent of 45
degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN,
ATAN, ATAN2</comment>
</section>
<section id="Section58">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148426">
@@ -174,7 +174,7 @@ oldref="85">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3156100" role="paragraph" l10n="CHG"
oldref="96">
<item type="input">=ASIN(0)</item> returns 0.</paragraph>
<paragraph xml-lang="en-US" id="par_id6853846" role="paragraph" l10n="NEW">
-<item type="input">=ASIN(1)</item> returns 1.5707963267949 (PI/2 radians).
</paragraph>
+<item type="input">=ASIN(1)</item> returns 1.5707963267949 (PI/2
radians).</paragraph>
<paragraph xml-lang="en-US" id="par_id8772240" role="paragraph" l10n="NEW">
<item type="input">=DEGREES(ASIN(0.5))</item> returns 30. The sine of 30
degrees is 0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ATAN,
ATAN2, ACOT</comment>
</section>
@@ -188,7 +188,7 @@ oldref="85">Example</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150763" role="heading" level="3" l10n="U"
oldref="102">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3150882" role="code" l10n="U"
oldref="103">ASINH(Number)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147621" role="paragraph" l10n="CHG"
oldref="104"> This function returns the inverse hyperbolic sine of
<emph>Number</emph>, that is the number whose hyperbolic sine is Number.
</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147621" role="paragraph" l10n="CHG"
oldref="104"> This function returns the inverse hyperbolic sine of
<emph>Number</emph>, that is the number whose hyperbolic sine is
Number.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3153212" role="heading" level="3" l10n="U"
oldref="105">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3156120" role="paragraph" l10n="CHG"
oldref="106">
@@ -247,7 +247,7 @@ oldref="130">ATANH</paragraph>
<paragraph xml-lang="en-US" id="hd_id3146997" role="heading" level="3" l10n="U"
oldref="132">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3149912" role="code" l10n="U"
oldref="133">ATANH(Number)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150521" role="paragraph" l10n="CHG"
oldref="134"> This function returns the inverse hyperbolic tangent of
<emph>Number</emph>, that is the number whose hyperbolic tangent is Number.
</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150521" role="paragraph" l10n="CHG"
oldref="134"> This function returns the inverse hyperbolic tangent of
<emph>Number</emph>, that is the number whose hyperbolic tangent is
Number.</paragraph>
<paragraph xml-lang="en-US" id="par_id9357280" role="paragraph" l10n="NEW">
Number must obey the condition -1 < number < 1.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3148450" role="heading" level="3" l10n="U"
oldref="135">Example</paragraph>
@@ -362,7 +362,7 @@ oldref="198">EXP</paragraph>
<paragraph xml-lang="en-US" id="hd_id3146902" role="heading" level="3"
l10n="U" oldref="210">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3154661" role="code" l10n="U"
oldref="211">FACT(Number)</paragraph>
<paragraph xml-lang="en-US" id="par_id3152952" role="paragraph" l10n="CHG"
oldref="212"> Returns Number!, the factorial of <emph>Number</emph>, calculated
as 1*2*3*4* ... * Number.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3834650" role="paragraph"
l10n="NEW">=FACT(0) returns 1 by definition. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3834650" role="paragraph"
l10n="NEW">=FACT(0) returns 1 by definition.</paragraph>
<paragraph xml-lang="en-US" id="par_id8429517" role="paragraph" l10n="NEW">The
factorial of a negative number returns the "invalid argument" error.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3154569" role="heading" level="3"
l10n="U" oldref="213">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3154476" role="paragraph" l10n="CHG"
oldref="216">
@@ -400,7 +400,7 @@ oldref="198">EXP</paragraph>
<paragraph xml-lang="en-US" id="par_id3149988" role="paragraph" l10n="CHG"
oldref="228"><ahelp hid="HID_FUNC_GERADE">Rounds a positive number up to the
next even integer and a negative number down to the next even
integer.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3148401" role="heading" level="3"
l10n="U" oldref="229">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3150830" role="code" l10n="U"
oldref="230">EVEN(Number)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153350" role="paragraph" l10n="CHG"
oldref="231"> Returns <emph>Number</emph> rounded to the next even integer up,
away from zero. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3153350" role="paragraph" l10n="CHG"
oldref="231"> Returns <emph>Number</emph> rounded to the next even integer up,
away from zero.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3155508" role="heading" level="3"
l10n="U" oldref="232">Examples</paragraph>
<paragraph xml-lang="en-US" id="par_id3154361" role="paragraph" l10n="CHG"
oldref="233">
<item type="input">=EVEN(2.3)</item> returns 4.</paragraph>
@@ -867,7 +867,7 @@ oldref="404">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id1371501" role="paragraph" l10n="NEW">
<item type="input">=ROUND(2.348;0)</item> returns 2.</paragraph>
<paragraph xml-lang="en-US" id="par_id4661702" role="paragraph" l10n="NEW">
-<item type="input">=ROUND(2.5)</item> returns 3. </paragraph>
+<item type="input">=ROUND(2.5)</item> returns 3.</paragraph>
<paragraph xml-lang="en-US" id="par_id7868892" role="paragraph" l10n="NEW">
<item type="input">=ROUND(987.65;-2)</item> returns
1000.</paragraph><comment>see also INT, TRUNC, ROUNDDOWN, ROUNDUP, CEILING,
FLOOR, EVEN, ODD, MROUND</comment>
</section>
@@ -1022,7 +1022,7 @@ oldref="436">SUMIFS</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<paragraph xml-lang="en-US" id="hd_id3152015K" role="heading" level="3"
l10n="U">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3152028K" role="code" l10n="U">SUMIFS(
Reference R ; Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]...
)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3152043K" role="paragraph" l10n="U">Sums
the value of cells in range R that meet the Criterion C1 in the reference range
R1, and the Criterion C2 in the reference range R2, and so on. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3152043K" role="paragraph" l10n="U">Sums
the value of cells in range R that meet the Criterion C1 in the reference range
R1, and the Criterion C2 in the reference range R2, and so on.</paragraph>
<paragraph xml-lang="en-US" id="par_id3152062K" role="paragraph" l10n="CHG" >A
<emph>Criterion</emph> is a single cell Reference, Number or Text. If the
criterion is written into the formula, it has to be surrounded by double
quotes.</paragraph>
<paragraph xml-lang="en-US" id="par_id3152083K" role="paragraph" l10n="U">All
<emph>Reference</emph> ranges shall have the same dimension and size, else an
Error is returned.</paragraph>
<!--<paragraph xml-lang="en-US" id="par_id8347422K" role="note"
l10n="NEW">SUMIFS supports the reference concatenation operator (~) only in the
Criteria parameter, and only if the optional SumRange parameter is not
given.</paragraph>-->
@@ -1229,7 +1229,7 @@ oldref="570"><emph>Examples</emph>
<paragraph xml-lang="en-US" id="hd_id0908200902131152" role="heading"
level="3" l10n="NEW">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id090820090213112" role="paragraph"
l10n="NEW">
<item type="input">=CONVERT(100;"ATS";"EUR")</item> returns the Euro value of
100 Austrian Schillings.</paragraph>
-<paragraph xml-lang="en-US" id="par_id0908200902475431" role="paragraph"
l10n="NEW">=CONVERT(100;"EUR";"DEM") converts 100 Euros into German Marks.
</paragraph>
+<paragraph xml-lang="en-US" id="par_id0908200902475431" role="paragraph"
l10n="NEW">=CONVERT(100;"EUR";"DEM") converts 100 Euros into German
Marks.</paragraph>
</section>
<section id="Section10">
<bookmark xml-lang="en-US" branch="index" id="bm_id3157177">
@@ -1312,7 +1312,7 @@ oldref="658">MROUND</paragraph>
<paragraph xml-lang="en-US" id="hd_id3164306" role="heading" level="3" l10n="U"
oldref="660">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3164320" role="code" l10n="U"
oldref="661">MROUND(Number; Multiple)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3486434" role="paragraph"
l10n="NEW">Returns <emph>Number</emph> rounded to the nearest multiple of
<emph>Multiple</emph>. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3486434" role="paragraph"
l10n="NEW">Returns <emph>Number</emph> rounded to the nearest multiple of
<emph>Multiple</emph>.</paragraph>
<paragraph xml-lang="en-US" id="par_id3068636" role="paragraph" l10n="NEW">An
alternative implementation would be <item type="literal">Multiple *
ROUND(Number/Multiple)</item>.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3164333" role="heading" level="3" l10n="U"
oldref="662">Example</paragraph>
@@ -1426,7 +1426,7 @@ oldref="553">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id2118594" role="paragraph" l10n="NEW">
<item type="input">=COUNTIF(A1:A10;"<"&B1)</item> - when B1 contains
<item type="input">2006</item>, this returns 6</paragraph>
<paragraph xml-lang="en-US" id="par_id166020" role="paragraph" l10n="NEW">
-<item type="input">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text
<item type="input">>2006</item> counts the number of cells in the range
A1:A10 which are >2006 </paragraph>
+<item type="input">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text
<item type="input">>2006</item> counts the number of cells in the range
A1:A10 which are >2006</paragraph>
<paragraph xml-lang="en-US" id="par_id6386913" role="paragraph" l10n="NEW">To
count only negative numbers: <item type="input">=COUNTIF(A1:A10;"<0")</item>
</paragraph>
</section>
diff --git a/main/helpcontent2/source/text/scalc/01/04060107.xhp
b/main/helpcontent2/source/text/scalc/01/04060107.xhp
index e924b430de..e8afed3087 100644
--- a/main/helpcontent2/source/text/scalc/01/04060107.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060107.xhp
@@ -146,8 +146,8 @@
</section>
<paragraph role="paragraph" id="par_id3154342" xml-lang="en-US" l10n="U"
oldref="5">The cells in a results array are automatically protected against
changes. However, you can edit or copy the array formula by selecting the
entire array cell range.</paragraph>
<paragraph role="heading" id="hd_id8834803" xml-lang="en-US" level="3"
l10n="NEW">Using Inline Array Constants in Formulas</paragraph>
-<paragraph role="paragraph" id="par_id985747" xml-lang="en-US" l10n="NEW">Calc
supports inline matrix/array constants in formulas. An inline array is
surrounded by curly braces '{' and '}'. Elements can be each a number
(including negatives), a logical constant (TRUE, FALSE), or a literal string.
Non-constant expressions are not allowed. Arrays can be entered with one or
more rows, and one or more columns. All rows must consist of the same number of
elements, all columns must consist of [...]
-<paragraph role="paragraph" id="par_id936613" xml-lang="en-US" l10n="NEW">The
column separator (separating elements in one row) is the ';' semicolon. The row
separator is a '|' pipe symbol. The separators are not language and locale
dependent. </paragraph>
+<paragraph role="paragraph" id="par_id985747" xml-lang="en-US" l10n="NEW">Calc
supports inline matrix/array constants in formulas. An inline array is
surrounded by curly braces '{' and '}'. Elements can be each a number
(including negatives), a logical constant (TRUE, FALSE), or a literal string.
Non-constant expressions are not allowed. Arrays can be entered with one or
more rows, and one or more columns. All rows must consist of the same number of
elements, all columns must consist of [...]
+<paragraph role="paragraph" id="par_id936613" xml-lang="en-US" l10n="NEW">The
column separator (separating elements in one row) is the ';' semicolon. The row
separator is a '|' pipe symbol. The separators are not language and locale
dependent.</paragraph>
<paragraph role="paragraph" id="par_id1877498" xml-lang="en-US"
l10n="NEW">Arrays can not be nested.</paragraph>
<paragraph role="paragraph" id="par_id4262520" xml-lang="en-US" l10n="NEW">
<emph>Examples:</emph>
diff --git a/main/helpcontent2/source/text/scalc/01/04060109.xhp
b/main/helpcontent2/source/text/scalc/01/04060109.xhp
index b530782ab6..6676b66b75 100644
--- a/main/helpcontent2/source/text/scalc/01/04060109.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060109.xhp
@@ -52,7 +52,7 @@
<paragraph xml-lang="en-US" id="par_id1027200802301348" role="paragraph"
l10n="NEW">For interoperability the ADDRESS and INDIRECT functions support an
optional parameter to specify whether the R1C1 address notation instead of the
usual A1 notation should be used.</paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802301445" role="paragraph"
l10n="NEW">In ADDRESS, the parameter is inserted as the fourth parameter,
shifting the optional sheet name parameter to the fifth position.</paragraph>
<paragraph xml-lang="en-US" id="par_id102720080230153" role="paragraph"
l10n="NEW">In INDIRECT, the parameter is appended as the second
parameter.</paragraph>
-<paragraph xml-lang="en-US" id="par_id102720080230151" role="paragraph"
l10n="NEW">In both functions, if the argument is inserted with the value 0,
then the R1C1 notation is used. If the argument is not given or has a value
other than 0, then the A1 notation is used. </paragraph>
+<paragraph xml-lang="en-US" id="par_id102720080230151" role="paragraph"
l10n="NEW">In both functions, if the argument is inserted with the value 0,
then the R1C1 notation is used. If the argument is not given or has a value
other than 0, then the A1 notation is used.</paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802301556" role="paragraph"
l10n="NEW">In case of R1C1 notation, ADDRESS returns address strings using the
exclamation mark '!' as the sheet name separator, and INDIRECT expects the
exclamation mark as sheet name separator. Both functions still use the dot '.'
sheet name separator with A1 notation.</paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802301521" role="paragraph"
l10n="NEW">When opening documents from ODF 1.0/1.1 format, the ADDRESS
functions that show a sheet name as the fourth parameter will shift that sheet
name to become the fifth parameter. A new fourth parameter with the value 1
will be inserted.</paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802301650" role="paragraph"
l10n="NEW">When storing a document in ODF 1.0/1.1 format, if ADDRESS functions
have a fourth parameter, that parameter will be removed.</paragraph>
@@ -479,7 +479,7 @@ oldref="135">Syntax</paragraph>
oldref="140">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3151374" role="paragraph" l10n="U"
oldref="141">
<item type="input">=STYLE("Invisible";60;"Default")</item> formats the cell in
transparent format for 60 seconds after the document was recalculated or
loaded, then the Default format is assigned. Both cell formats have to be
defined beforehand.</paragraph>
-<paragraph xml-lang="en-US" id="par_id8056886" role="paragraph"
l10n="NEW">Since STYLE() has a numeric return value of zero, this return value
gets appended to a string. This can be avoided using T() as in the following
example </paragraph>
+<paragraph xml-lang="en-US" id="par_id8056886" role="paragraph"
l10n="NEW">Since STYLE() has a numeric return value of zero, this return value
gets appended to a string. This can be avoided using T() as in the following
example</paragraph>
<paragraph xml-lang="en-US" id="par_id3668935" role="paragraph" l10n="NEW">
<item type="input">="Text"&T(STYLE("myStyle"))</item>
</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/04060110.xhp
b/main/helpcontent2/source/text/scalc/01/04060110.xhp
index dd615a887e..637815d2fe 100644
--- a/main/helpcontent2/source/text/scalc/01/04060110.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060110.xhp
@@ -226,7 +226,7 @@ oldref="232">Example</paragraph>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DM" id="bm_id3149532"
localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3148402" role="heading" level="2" l10n="U"
oldref="11">DOLLAR</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153049" role="paragraph" l10n="U"
oldref="12"><ahelp hid="HID_FUNC_DM">Converts a number to an amount in the
currency format, rounded to a specified decimal place.</ahelp> In the <item
type="literal">Value</item> field enter the number to be converted to currency.
Optionally, you may enter the number of decimal places in the <item
type="literal">Decimals</item> field. If no value is specified, all numbers in
currency format will be displayed with tw [...]
+<paragraph xml-lang="en-US" id="par_id3153049" role="paragraph" l10n="U"
oldref="12"><ahelp hid="HID_FUNC_DM">Converts a number to an amount in the
currency format, rounded to a specified decimal place.</ahelp> In the <item
type="literal">Value</item> field enter the number to be converted to currency.
Optionally, you may enter the number of decimal places in the <item
type="literal">Decimals</item> field. If no value is specified, all numbers in
currency format will be displayed with tw [...]
<paragraph xml-lang="en-US" id="par_id3151280" role="paragraph" l10n="U"
oldref="263">You set the currency format in your system settings.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150569" role="heading" level="3" l10n="U"
oldref="13">Syntax</paragraph>
@@ -304,7 +304,7 @@ oldref="36">Syntax</paragraph>
<paragraph xml-lang="en-US" id="hd_id3149040" role="heading" level="3" l10n="U"
oldref="41">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3145208" role="paragraph" l10n="CHG"
oldref="42">
-<item type="input">=FIXED(1234567.89;3)</item> returns 1,234,567.890 as a text
string. </paragraph>
+<item type="input">=FIXED(1234567.89;3)</item> returns 1,234,567.890 as a text
string.</paragraph>
<paragraph xml-lang="en-US" id="par_id5282143" role="paragraph" l10n="NEW">
<item type="input">=FIXED(1234567.89;3;1)</item> returns 1234567.890 as a text
string.</paragraph>
</section>
@@ -553,7 +553,7 @@ oldref="176">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3153675" role="paragraph" l10n="U"
oldref="178">
<emph>Text</emph> is the text in which text segments are to be
exchanged.</paragraph>
<paragraph xml-lang="en-US" id="par_id3156155" role="paragraph" l10n="U"
oldref="179">
-<emph>SearchText </emph>is the text segment that is to be replaced (a number
of times).</paragraph>
+<emph>SearchText</emph> is the text segment that is to be replaced (a number
of times).</paragraph>
<paragraph xml-lang="en-US" id="par_id3145779" role="paragraph" l10n="U"
oldref="180">
<emph>NewText</emph> is the text that is to replace the text
segment.</paragraph>
<paragraph xml-lang="en-US" id="par_id3150348" role="paragraph" l10n="CHG"
oldref="181">
@@ -580,7 +580,7 @@ oldref="142">Syntax</paragraph>
<paragraph xml-lang="en-US" id="hd_id3155544" role="heading" level="3" l10n="U"
oldref="145">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3151062" role="paragraph" l10n="CHG"
oldref="146">
-<item type="input">=T(12345)</item> returns an empty string. </paragraph>
+<item type="input">=T(12345)</item> returns an empty string.</paragraph>
<paragraph xml-lang="en-US" id="par_id4650105" role="paragraph" l10n="NEW">
<item type="input">=T("12345")</item> returns the string 12345.</paragraph>
</section>
diff --git a/main/helpcontent2/source/text/scalc/01/04060116.xhp
b/main/helpcontent2/source/text/scalc/01/04060116.xhp
index 1cafd5a42b..d864e0522e 100644
--- a/main/helpcontent2/source/text/scalc/01/04060116.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060116.xhp
@@ -188,7 +188,7 @@ oldref="">Syntax</paragraph>
<paragraph xml-lang="en-US" id="hd_id3152984" role="heading" level="3"
l10n="New"
oldref="">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3157905" role="paragraph" l10n="New"
oldref="">
-<item type="input">=IMCSCH("3+4j") </item>returns -1.30632891+1.51251400j
(rounded). </paragraph>
+<item type="input">=IMCSCH("3+4j") </item>returns -1.30632891+1.51251400j
(rounded).</paragraph>
</section>
<section id="imdiv">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150024">
diff --git a/main/helpcontent2/source/text/scalc/01/04060118.xhp
b/main/helpcontent2/source/text/scalc/01/04060118.xhp
index b264537c89..637f62a26e 100644
--- a/main/helpcontent2/source/text/scalc/01/04060118.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060118.xhp
@@ -168,7 +168,7 @@
<paragraph role="paragraph" id="par_id3147536" xml-lang="en-US" l10n="CHG"
oldref="231">
<emph>Factor</emph> (optional) is the depreciation factor. Factor = 2 is
double rate depreciation.</paragraph>
<paragraph role="paragraph" id="par_id3154865" xml-lang="en-US" l10n="CHG"
oldref="232">
-<emph>Type </emph>is an optional parameter. Type = 1 means a switch to linear
depreciation. In Type = 0 no switch is made.</paragraph>
+<emph>Type</emph> is an optional parameter. Type = 1 means a switch to linear
depreciation. In Type = 0 no switch is made.</paragraph>
<paragraph role="paragraph" id="par_idN10A0D" xml-lang="en-US" l10n="NEW">
<embedvar href="text/scalc/00/00000004.xhp#optional"/>
</paragraph>
@@ -434,7 +434,7 @@
<paragraph role="paragraph" id="par_id3146075" xml-lang="en-US" l10n="U"
oldref="158">
<emph>Maturity</emph> is the date on which the security matures
(expires).</paragraph>
<paragraph role="paragraph" id="par_id3154620" xml-lang="en-US" l10n="U"
oldref="159">
-<emph>Frequency </emph>is number of interest payments per year (1, 2 or
4).</paragraph>
+<emph>Frequency</emph> is number of interest payments per year (1, 2 or
4).</paragraph>
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
<paragraph role="heading" id="hd_id3155604" xml-lang="en-US" level="3"
l10n="U" oldref="160">Example</paragraph>
<paragraph role="paragraph" id="par_id3148671" xml-lang="en-US" l10n="CHG"
oldref="161">A security is purchased on 2001-01-25; the date of maturity is
2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance
interest calculation (basis 3) how many days are there until the next interest
payment?</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/04060182.xhp
b/main/helpcontent2/source/text/scalc/01/04060182.xhp
index 8e5136dbe7..ce87a6b0d1 100644
--- a/main/helpcontent2/source/text/scalc/01/04060182.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060182.xhp
@@ -327,7 +327,7 @@ oldref="124">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3146992" role="paragraph" l10n="U"
oldref="128">
<emph>Successes</emph> is the number of possible results in the total
population.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148826" role="paragraph" l10n="U"
oldref="129">
-<emph>NPopulation </emph>is the size of the total population.</paragraph>
+<emph>NPopulation</emph> is the size of the total population.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150529" role="heading" level="3" l10n="U"
oldref="130">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3154904" role="paragraph" l10n="U"
oldref="131">
diff --git a/main/helpcontent2/source/text/scalc/01/04060184.xhp
b/main/helpcontent2/source/text/scalc/01/04060184.xhp
index 85c2f1701b..569a6b609a 100644
--- a/main/helpcontent2/source/text/scalc/01/04060184.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060184.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-<helpdocument version="1.0">
-
<!--***********************************************************
*
@@ -23,8 +21,7 @@
*
***********************************************************-->
-
-
+<helpdocument version="1.0">
<meta>
<topic id="textscalc0104060184xml" indexer="include">
<title xml-lang="en-US" id="tit">Statistical Functions Part Four</title>
@@ -45,7 +42,7 @@
<paragraph xml-lang="en-US" id="par_id9282509" role="paragraph"
l10n="NEW">Returns 0 if no numeric value and no error was encountered in the
cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and
MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text)
and no error was encountered. Passing a literal string argument to MIN() or
MAX(), e.g. MIN("string"), still results in an error.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3154256" role="heading" level="3"
l10n="U" oldref="4">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3147340" role="code" l10n="U"
oldref="5">MAX(Number1; Number2; ...Number30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149568" role="paragraph" l10n="CHG"
oldref="6"><emph>Number1; Number2;...Number30</emph> are numerical values or
ranges. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3149568" role="paragraph" l10n="CHG"
oldref="6"><emph>Number1; Number2;...Number30</emph> are numerical values or
ranges.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3153963" role="heading" level="3"
l10n="U" oldref="7">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3147343" role="paragraph" l10n="U"
oldref="8">
<item type="input">=MAX(A1;A2;A3;50;100;200)</item> returns the largest value
from the list.</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/04060185.xhp
b/main/helpcontent2/source/text/scalc/01/04060185.xhp
index 0d081d2582..496c81dd45 100644
--- a/main/helpcontent2/source/text/scalc/01/04060185.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060185.xhp
@@ -48,7 +48,7 @@
<emph>Data</emph> is the array or range of data in the sample.</paragraph>
<paragraph xml-lang="en-US" id="par_id3150215" role="paragraph" l10n="CHG"
oldref="8">
<emph>Type</emph> (optional) is the sequence order.</paragraph>
-<paragraph xml-lang="en-US" id="par_id9305398" role="paragraph"
l10n="NEW">Type = 0 means descending from the last item of the array to the
first (this is the default), </paragraph>
+<paragraph xml-lang="en-US" id="par_id9305398" role="paragraph"
l10n="NEW">Type = 0 means descending from the last item of the array to the
first (this is the default),</paragraph>
<paragraph xml-lang="en-US" id="par_id9996948" role="paragraph"
l10n="NEW">Type = 1 means ascending from the first item of the range to the
last.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3143223" role="heading" level="3"
l10n="U" oldref="9">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3155919" role="paragraph" l10n="U"
oldref="10">
@@ -288,7 +288,7 @@ oldref="90">DEVSQ</paragraph>
oldref="92">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3146790" role="code" l10n="U"
oldref="93">DEVSQ(Number1; Number2; ...Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155995" role="paragraph" l10n="CHG"
oldref="94">
-<emph>Number1, Number2, ...Number30</emph> numerical values or ranges
representing a sample. </paragraph>
+<emph>Number1, Number2, ...Number30</emph> numerical values or ranges
representing a sample.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150254" role="heading" level="3" l10n="U"
oldref="95">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3149136" role="paragraph" l10n="U"
oldref="96">
@@ -504,7 +504,7 @@ oldref="166">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3151107" role="paragraph" l10n="U"
oldref="170">
<emph>Start</emph> is the start value of the interval whose probabilities are
to be summed.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153694" role="paragraph" l10n="U"
oldref="171">
-<emph>End</emph> (optional) is the end value of the interval whose
probabilities are to be summed. If this parameter is missing, the probability
for the <emph>Start </emph>value is calculated.</paragraph>
+<emph>End</emph> (optional) is the end value of the interval whose
probabilities are to be summed. If this parameter is missing, the probability
for the <emph>Start</emph> value is calculated.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3147574" role="heading" level="3" l10n="U"
oldref="172">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3153666" role="paragraph" l10n="U"
oldref="173">
@@ -518,7 +518,7 @@ oldref="172">Example</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150941" role="heading" level="2" l10n="U"
oldref="175">WEIBULL</paragraph>
<paragraph xml-lang="en-US" id="par_id3154916" role="paragraph" l10n="U"
oldref="176"><ahelp hid="HID_FUNC_WEIBULL">Returns the values of the Weibull
distribution.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="par_id0305200911372767" role="paragraph"
l10n="NEW">The Weibull distribution is a continuous probability distribution,
with parameters Alpha > 0 (shape) and Beta > 0 (scale). </paragraph>
+<paragraph xml-lang="en-US" id="par_id0305200911372767" role="paragraph"
l10n="NEW">The Weibull distribution is a continuous probability distribution,
with parameters Alpha > 0 (shape) and Beta > 0 (scale).</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372777" role="paragraph"
l10n="NEW">If C is 0, WEIBULL calculates the probability density
function.</paragraph>
<paragraph xml-lang="en-US" id="par_id0305200911372743" role="paragraph"
l10n="NEW">If C is 1, WEIBULL calculates the cumulative distribution
function.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3159393" role="heading" level="3" l10n="U"
@@ -527,7 +527,7 @@ oldref="177">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3151317" role="paragraph" l10n="U"
oldref="179">
<emph>Number</emph> is the value at which to calculate the Weibull
distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id3158436" role="paragraph" l10n="U"
oldref="180">
-<emph>Alpha </emph>is the shape parameter of the Weibull
distribution.</paragraph>
+<emph>Alpha</emph> is the shape parameter of the Weibull
distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id3154668" role="paragraph" l10n="U"
oldref="181">
<emph>Beta</emph> is the scale parameter of the Weibull
distribution.</paragraph>
<paragraph xml-lang="en-US" id="par_id3154825" role="paragraph" l10n="CHG"
oldref="182">
diff --git a/main/helpcontent2/source/text/scalc/01/04070100.xhp
b/main/helpcontent2/source/text/scalc/01/04070100.xhp
index 63a7f683c3..9076aae7a8 100644
--- a/main/helpcontent2/source/text/scalc/01/04070100.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04070100.xhp
@@ -34,7 +34,7 @@
<paragraph role="heading" id="hd_id3156330" xml-lang="en-US" level="1"
l10n="U" oldref="1">Define Names</paragraph>
<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US" l10n="U"
oldref="2"><variable id="namenfestlegentext"><ahelp hid=".uno:DefineName">Opens
a dialog where you can specify a name for a selected area.</ahelp>
</variable></paragraph>
-<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US" l10n="U"
oldref="31">Use the mouse to define ranges or type the reference into the
<emph>Define Name </emph>dialog fields.</paragraph>
+<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US" l10n="U"
oldref="31">Use the mouse to define ranges or type the reference into the
<emph>Define Name</emph> dialog fields.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#einafe"/>
</section>
@@ -49,7 +49,7 @@
<embed href="text/shared/00/00000001.xhp#eingabesymbol"/>
<bookmark xml-lang="en-US" branch="hid/sc:MoreButton:RID_SCDLG_NAMES:BTN_MORE"
id="bm_id3148455" localize="false"/>
<paragraph role="heading" id="hd_id3154729" xml-lang="en-US" level="2"
l10n="U" oldref="13">More</paragraph>
-<paragraph role="paragraph" id="par_id3149958" xml-lang="en-US" l10n="U"
oldref="14"><ahelp hid="SC:MOREBUTTON:RID_SCDLG_NAMES:BTN_MORE">Allows you to
specify the <emph>Area type </emph>(optional) for the
reference.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3149958" xml-lang="en-US" l10n="U"
oldref="14"><ahelp hid="SC:MOREBUTTON:RID_SCDLG_NAMES:BTN_MORE">Allows you to
specify the <emph>Area type</emph> (optional) for the
reference.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3147394" xml-lang="en-US" level="3"
l10n="U" oldref="15">Area type</paragraph>
<paragraph role="paragraph" id="par_id3155416" xml-lang="en-US" l10n="U"
oldref="16">Defines additional options related to the type of reference
area.</paragraph>
<bookmark xml-lang="en-US"
branch="hid/sc:CheckBox:RID_SCDLG_NAMES:BTN_PRINTAREA" id="bm_id3146972"
localize="false"/>
diff --git a/main/helpcontent2/source/text/scalc/01/05030300.xhp
b/main/helpcontent2/source/text/scalc/01/05030300.xhp
index 1cc175cc38..8ed6623d63 100644
--- a/main/helpcontent2/source/text/scalc/01/05030300.xhp
+++ b/main/helpcontent2/source/text/scalc/01/05030300.xhp
@@ -51,7 +51,7 @@
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#fozeiaus"/>
</section>
-<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US" l10n="U"
oldref="3">Select the rows or columns that you want to hide, and then choose
<emph>Format - Row - Hide </emph>or<emph> Format - Column -
Hide</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US" l10n="U"
oldref="3">Select the rows or columns that you want to hide, and then choose
<emph>Format - Row - Hide</emph> or <emph>Format - Column -
Hide</emph>.</paragraph>
<paragraph role="paragraph" id="par_id3147427" xml-lang="en-US" l10n="U"
oldref="6">You can hide a sheet by selecting the sheet tab and then choosing
<emph>Format - Sheet - Hide</emph>. Hidden sheets are not printed unless they
occur within a <link href="text/scalc/01/05080000.xhp" name="print range">print
range</link>.</paragraph>
<paragraph role="note" id="par_id3153157" xml-lang="en-US" l10n="U"
oldref="5">A break in the row or column header indicates whether the row or
column is hidden.</paragraph>
<paragraph role="paragraph" id="par_id3145251" xml-lang="en-US" l10n="CHG"
oldref="4">To display hidden rows, columns or sheets</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/05050100.xhp
b/main/helpcontent2/source/text/scalc/01/05050100.xhp
index c648355903..42a07b4649 100644
--- a/main/helpcontent2/source/text/scalc/01/05050100.xhp
+++ b/main/helpcontent2/source/text/scalc/01/05050100.xhp
@@ -50,7 +50,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_APPEND_NAME"
id="bm_id3151041" localize="false"/>
<paragraph role="heading" id="hd_id3153968" xml-lang="en-US" level="2"
l10n="U" oldref="3">Name</paragraph>
<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"
l10n="C"><ahelp hid="HID_SC_APPEND_NAME">Enter a new name for the sheet
here.</ahelp></paragraph>
-<paragraph role="tip" id="par_id3153092" xml-lang="en-US" l10n="U"
oldref="5">You can also open the<emph> Rename Sheet </emph>dialog through the
context menu by positioning the mouse pointer over a sheet tab at the bottom of
the window and <switchinline select="sys"><caseinline select="MAC">clicking
while pressing Control</caseinline><defaultinline>clicking the right mouse
button</defaultinline></switchinline>.</paragraph>
+<paragraph role="tip" id="par_id3153092" xml-lang="en-US" l10n="U"
oldref="5">You can also open the <emph>Rename Sheet</emph> dialog through the
context menu by positioning the mouse pointer over a sheet tab at the bottom of
the window and <switchinline select="sys"><caseinline select="MAC">clicking
while pressing Control</caseinline><defaultinline>clicking the right mouse
button</defaultinline></switchinline>.</paragraph>
<paragraph role="tip" id="par_id3147396" xml-lang="en-US" l10n="U"
oldref="6">Alternatively, click the sheet tab while pressing the <switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Alt</defaultinline></switchinline>
key. Now you can change the name directly. <switchinline
select="sys"><caseinline select="UNIX"><embedvar
href="text/shared/00/00000099.xhp#winmanager"/>
</caseinline></switchinline></paragraph>
<section id="relatedtopics">
diff --git a/main/helpcontent2/source/text/scalc/01/05070500.xhp
b/main/helpcontent2/source/text/scalc/01/05070500.xhp
index d93ee79c96..3b2af5cb80 100644
--- a/main/helpcontent2/source/text/scalc/01/05070500.xhp
+++ b/main/helpcontent2/source/text/scalc/01/05070500.xhp
@@ -77,7 +77,7 @@
<bookmark xml-lang="en-US"
branch="hid/sc:MetricField:RID_SCPAGE_TABLE:ED_SCALEALL" id="bm_id3153067"
localize="false"/><paragraph role="heading" id="par_idN1099A" xml-lang="en-US"
level="5" l10n="NEW">Scaling factor</paragraph>
<paragraph role="paragraph" id="par_id3152899" xml-lang="en-US" l10n="CHG"
oldref="36"><ahelp hid="SC_METRICFIELD_RID_SCPAGE_TABLE_ED_SCALEALL"
visibility="hidden">Enter a scaling factor. Factors less than 100 reduce the
pages, higher factors enlarge the pages.</ahelp></paragraph>
<paragraph role="heading" id="par_idN109B2" xml-lang="en-US" level="4"
l10n="NEW">Fit print range(s) to width/height</paragraph>
-<paragraph role="paragraph" id="par_idN109B5" xml-lang="en-US"
l10n="NEW">Specifies the maximum number of pages horizontally (width) and
vertically (height) on which every sheet with the current Page Style is to be
printed. </paragraph>
+<paragraph role="paragraph" id="par_idN109B5" xml-lang="en-US"
l10n="NEW">Specifies the maximum number of pages horizontally (width) and
vertically (height) on which every sheet with the current Page Style is to be
printed.</paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_idN109BB" xml-lang="en-US" l10n="NEW">The
print ranges are always scaled proportionally, so the resulting number of pages
may be less than specified.</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/06050000.xhp
b/main/helpcontent2/source/text/scalc/01/06050000.xhp
index 2d447fcb8c..a2d23e677b 100644
--- a/main/helpcontent2/source/text/scalc/01/06050000.xhp
+++ b/main/helpcontent2/source/text/scalc/01/06050000.xhp
@@ -44,11 +44,11 @@
<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_NEWSCENARIO:ED_NAME"
id="bm_id3154123" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_SCENWIN_TOP"
id="bm_id3153195" localize="false"/>
<paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="2"
l10n="U" oldref="3">Name of scenario</paragraph>
-<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US" l10n="U"
oldref="13"><ahelp hid="HID_SC_SCENWIN_TOP">Defines the name for the scenario.
Use a clear and unique name so you can easily identify the scenario.</ahelp>
You can also modify a scenario name in the Navigator through the
<emph>Properties </emph>context menu command.</paragraph>
+<paragraph role="paragraph" id="par_id3151041" xml-lang="en-US" l10n="U"
oldref="13"><ahelp hid="HID_SC_SCENWIN_TOP">Defines the name for the scenario.
Use a clear and unique name so you can easily identify the scenario.</ahelp>
You can also modify a scenario name in the Navigator through the
<emph>Properties</emph> context menu command.</paragraph>
<bookmark xml-lang="en-US"
branch="hid/sc:MultiLineEdit:RID_SCDLG_NEWSCENARIO:ED_COMMENT"
id="bm_id3152596" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_SCENWIN_BOTTOM"
id="bm_id3156444" localize="false"/>
<paragraph role="heading" id="hd_id3153954" xml-lang="en-US" level="2"
l10n="U" oldref="14">Comment</paragraph>
-<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US" l10n="U"
oldref="15"><ahelp hid="HID_SC_SCENWIN_BOTTOM">Specifies additional information
about the scenario. This information will be displayed in the <link
href="text/scalc/01/02110000.xhp" name="Navigator">Navigator</link> when you
click the <emph>Scenarios</emph> icon and select the desired scenario.</ahelp>
You can also modify this information in the Navigator through the
<emph>Properties </emph>context menu command.</pa [...]
+<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US" l10n="U"
oldref="15"><ahelp hid="HID_SC_SCENWIN_BOTTOM">Specifies additional information
about the scenario. This information will be displayed in the <link
href="text/scalc/01/02110000.xhp" name="Navigator">Navigator</link> when you
click the <emph>Scenarios</emph> icon and select the desired scenario.</ahelp>
You can also modify this information in the Navigator through the
<emph>Properties</emph> context menu command.</pa [...]
<paragraph role="heading" id="hd_id3145273" xml-lang="en-US" level="2"
l10n="U" oldref="16">Settings</paragraph>
<paragraph role="paragraph" id="par_id3153364" xml-lang="en-US" l10n="U"
oldref="17">This section is used to define some of the settings used in the
scenario display.</paragraph>
<bookmark xml-lang="en-US"
branch="hid/sc:CheckBox:RID_SCDLG_NEWSCENARIO:CB_SHOWFRAME" id="bm_id3151119"
localize="false"/>
diff --git a/main/helpcontent2/source/text/scalc/01/06060100.xhp
b/main/helpcontent2/source/text/scalc/01/06060100.xhp
index 2b25b9e7da..fda892260d 100644
--- a/main/helpcontent2/source/text/scalc/01/06060100.xhp
+++ b/main/helpcontent2/source/text/scalc/01/06060100.xhp
@@ -38,11 +38,11 @@
<embed href="text/scalc/00/00000406.xhp#exdst"/>
</section>
<paragraph role="warning" id="par_id3149664" xml-lang="en-US" l10n="U"
oldref="5">To protect cells from further editing, the <emph>Protected</emph>
check box must be checked on the <link href="text/scalc/01/05020600.xhp"
name="Format - Cells - Cell Protection"><emph>Format - Cells - Cell
Protection</emph></link> tab page or on the <emph>Format Cells</emph> context
menu.</paragraph>
-<paragraph role="tip" id="par_id3154490" xml-lang="en-US" l10n="U"
oldref="8">Unprotected cells or cell ranges can be set up on a protected sheet
by using the <emph>Tools - Protect Document - Sheet</emph> and <emph>Format -
Cells - Cell Protection</emph> menus: </paragraph>
+<paragraph role="tip" id="par_id3154490" xml-lang="en-US" l10n="U"
oldref="8">Unprotected cells or cell ranges can be set up on a protected sheet
by using the <emph>Tools - Protect Document - Sheet</emph> and <emph>Format -
Cells - Cell Protection</emph> menus:</paragraph>
<paragraph role="tip" id="par_id3149123" xml-lang="en-US" l10n="U"
oldref="16">Select the cells that will be unprotected</paragraph>
<paragraph role="tip" id="par_id3150329" xml-lang="en-US" l10n="U"
oldref="17">Select <emph>Format - Cells - Cell Protection</emph>. Unmark the
<emph>Protected</emph> box and click <emph>OK</emph>.</paragraph>
<paragraph role="tip" id="par_id3156384" xml-lang="en-US" l10n="U"
oldref="18">On the <emph>Tools - Protect Document - Sheet</emph> menu, activate
protection for the sheet. Effective immediately, only the cell range you
selected in step 1 can be edited.</paragraph>
-<paragraph role="tip" id="par_id3149566" xml-lang="en-US" l10n="U"
oldref="9">To later change an unprotected area to a protected area, select the
range. Next, on the <emph>Format - Cells - Cell Protection</emph> tab page,
check the <emph>Protected</emph> box. Finally, choose the <emph>Tools - Protect
Document - Sheet </emph>menu. The previously editable range is now
protected.</paragraph>
+<paragraph role="tip" id="par_id3149566" xml-lang="en-US" l10n="U"
oldref="9">To later change an unprotected area to a protected area, select the
range. Next, on the <emph>Format - Cells - Cell Protection</emph> tab page,
check the <emph>Protected</emph> box. Finally, choose the <emph>Tools - Protect
Document - Sheet</emph> menu. The previously editable range is now
protected.</paragraph>
<paragraph role="tip" id="par_id3153964" xml-lang="en-US" l10n="CHG"
oldref="10">Sheet protection also affects the context menu of the sheet tabs at
the bottom of the screen. The <emph>Delete</emph> and <emph>Rename</emph>
commands cannot be selected.</paragraph>
<paragraph role="tip" id="par_id3150301" xml-lang="en-US" l10n="U"
oldref="19">If a sheet is protected, you will not be able to modify or delete
any Cell Styles.</paragraph>
<paragraph role="paragraph" id="par_id3154656" xml-lang="en-US" l10n="U"
oldref="3">A protected sheet or cell range can no longer be modified until this
protection is disabled. To disable the protection, choose the <emph>Tools -
Protect Document - Sheet</emph> command. If no password was set, the sheet
protection is immediately disabled. If the sheet was password protected, the
<emph>Remove Protection</emph> dialog opens, where you must enter the
password.</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/06060200.xhp
b/main/helpcontent2/source/text/scalc/01/06060200.xhp
index ec09a3ab6e..d2db5b04cb 100644
--- a/main/helpcontent2/source/text/scalc/01/06060200.xhp
+++ b/main/helpcontent2/source/text/scalc/01/06060200.xhp
@@ -41,6 +41,6 @@
<paragraph role="paragraph" id="par_id3145750" xml-lang="en-US" l10n="U"
oldref="7">A protected document, once saved, can only be saved again with the
<emph>File - Save As</emph> menu command.</paragraph>
<paragraph role="heading" id="hd_id3152596" xml-lang="en-US" level="2"
l10n="U" oldref="4">Password (optional)</paragraph>
<paragraph role="paragraph" id="par_id3155412" xml-lang="en-US" l10n="U"
oldref="5">You can create a password to protect your document against
unauthorized or accidental modifications.</paragraph>
-<paragraph role="note" id="par_id3150717" xml-lang="en-US" l10n="U"
oldref="9">You can completely protect your work by combining both options from
<emph>Tools - Protect Document</emph>, including password entry. If you want to
prevent the document from being opened by other users, select <emph>Save With
Password </emph>and click the <emph>Save</emph> button. The <emph>Enter
Password</emph> dialog appears. Consider carefully when choosing a password; if
you forget it after you close a doc [...]
+<paragraph role="note" id="par_id3150717" xml-lang="en-US" l10n="U"
oldref="9">You can completely protect your work by combining both options from
<emph>Tools - Protect Document</emph>, including password entry. If you want to
prevent the document from being opened by other users, select <emph>Save With
Password</emph> and click the <emph>Save</emph> button. The <emph>Enter
Password</emph> dialog appears. Consider carefully when choosing a password; if
you forget it after you close a doc [...]
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/scalc/01/12070000.xhp
b/main/helpcontent2/source/text/scalc/01/12070000.xhp
index f8c3a80de6..83e74e72ee 100644
--- a/main/helpcontent2/source/text/scalc/01/12070000.xhp
+++ b/main/helpcontent2/source/text/scalc/01/12070000.xhp
@@ -46,7 +46,7 @@
<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DATA_AREA" id="bm_id3149400"
localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA" id="bm_id3154018"
localize="false"/>
<paragraph role="heading" id="hd_id3147397" xml-lang="en-US" level="2"
l10n="U" oldref="12">Source data range</paragraph>
-<paragraph role="paragraph" id="par_id3153836" xml-lang="en-US" l10n="U"
oldref="13"><ahelp hid="SC:EDIT:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA">Specifies
the cell range that you want to consolidate with the cell ranges listed in the
<emph>Consolidation ranges </emph>box. Select a cell range in a sheet, and then
click <emph>Add</emph>. You can also select a the name of a predefined cell
from the <emph>Source data range </emph>list.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153836" xml-lang="en-US" l10n="U"
oldref="13"><ahelp hid="SC:EDIT:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA">Specifies
the cell range that you want to consolidate with the cell ranges listed in the
<emph>Consolidation ranges</emph> box. Select a cell range in a sheet, and then
click <emph>Add</emph>. You can also select a the name of a predefined cell
from the <emph>Source data range</emph> list.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#eingabesymbol"/>
<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:RID_SCDLG_CONSOLIDATE:LB_DEST_AREA" id="bm_id3156383"
localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/sc:Edit:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA" id="bm_id3156382"
localize="false"/>
@@ -55,7 +55,7 @@
<embed href="text/shared/00/00000001.xhp#loeschen1"/>
<bookmark xml-lang="en-US"
branch="hid/sc:PushButton:RID_SCDLG_CONSOLIDATE:BTN_ADD" id="bm_id3145228"
localize="false"/>
<paragraph role="heading" id="hd_id3147345" xml-lang="en-US" level="2"
l10n="U" oldref="17">Add</paragraph>
-<paragraph role="paragraph" id="par_id3155335" xml-lang="en-US" l10n="U"
oldref="18"><ahelp hid="SC:PUSHBUTTON:RID_SCDLG_CONSOLIDATE:BTN_ADD">Adds the
cell range specified in the <emph>Source data range</emph> box to the
<emph>Consolidation ranges </emph>box.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155335" xml-lang="en-US" l10n="U"
oldref="18"><ahelp hid="SC:PUSHBUTTON:RID_SCDLG_CONSOLIDATE:BTN_ADD">Adds the
cell range specified in the <emph>Source data range</emph> box to the
<emph>Consolidation ranges</emph> box.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/sc:MoreButton:RID_SCDLG_CONSOLIDATE:BTN_MORE" id="bm_id3159102"
localize="false"/>
<paragraph role="heading" id="hd_id3148630" xml-lang="en-US" level="2"
l10n="U" oldref="19">More</paragraph>
<paragraph role="paragraph" id="par_id3159239" xml-lang="en-US" l10n="U"
oldref="20"><ahelp hid="SC:MOREBUTTON:RID_SCDLG_CONSOLIDATE:BTN_MORE">Shows
additional <link href="text/scalc/01/12070100.xhp"
name="options">options</link>.</ahelp></paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/12090102.xhp
b/main/helpcontent2/source/text/scalc/01/12090102.xhp
index dae8d4ad25..15fc6a4ee0 100644
--- a/main/helpcontent2/source/text/scalc/01/12090102.xhp
+++ b/main/helpcontent2/source/text/scalc/01/12090102.xhp
@@ -48,7 +48,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_SC_DPLAY_PAGE" id="bm_id7411420"
localize="false"/><comment>UFI: changed help id from 59001 to
dply_page</comment>
<paragraph xml-lang="en-US" id="hd_id3154908" role="heading" level="2" l10n="U"
oldref="18">Layout</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150768" role="paragraph" l10n="CHG"
oldref="19"><ahelp hid="HID_SC_DPLAY_SELECT">To define the layout of a pivot
table, drag and drop data field buttons onto the <emph>Page Fields, Row Fields,
Column Fields, </emph>and<emph> Data Fields </emph>areas.</ahelp> You can also
use drag and drop to rearrange the data fields on a pivot table.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150768" role="paragraph" l10n="CHG"
oldref="19"><ahelp hid="HID_SC_DPLAY_SELECT">To define the layout of a pivot
table, drag and drop data field buttons onto the <emph>Page Fields, Row Fields,
Column Fields</emph>, and <emph>Data Fields</emph> areas.</ahelp> You can also
use drag and drop to rearrange the data fields on a pivot table.</paragraph>
<paragraph xml-lang="en-US" id="par_id3147229" role="paragraph" l10n="CHG"
oldref="20">$[officename] automatically adds a caption to buttons that are
dragged into the <emph>Data Fields</emph> area. The caption contains the name
of the data field as well as the formula that created the data.</paragraph>
<paragraph xml-lang="en-US" id="par_id3145749" role="paragraph" l10n="CHG"
oldref="21">To change the function that is used by a data field, double-click a
button in the <emph>Data Fields</emph> area to open the <link
href="text/scalc/01/12090105.xhp" name="Data Field">Data Field</link> dialog.
You can also double-click buttons in the <emph>Row Fields</emph> or
<emph>Column Fields</emph> areas.</paragraph>
<bookmark xml-lang="en-US"
branch="hid/sc:PushButton:RID_SCDLG_PIVOT_LAYOUT:BTN_REMOVE" id="bm_id1926938"
localize="false"/>
diff --git a/main/helpcontent2/source/text/scalc/01/12090105.xhp
b/main/helpcontent2/source/text/scalc/01/12090105.xhp
index 7b43aafa29..6c93959e6c 100644
--- a/main/helpcontent2/source/text/scalc/01/12090105.xhp
+++ b/main/helpcontent2/source/text/scalc/01/12090105.xhp
@@ -105,7 +105,7 @@
<paragraph role="tablecontent" id="par_idN1075B" xml-lang="en-US" l10n="NEW">%
Of</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_idN10761" xml-lang="en-US"
l10n="NEW">Each result is divided by its reference value. The reference value
is determined in the same way as for "Difference from". Totals outside of the
base field are shown as empty results. </paragraph>
+<paragraph role="tablecontent" id="par_idN10761" xml-lang="en-US"
l10n="NEW">Each result is divided by its reference value. The reference value
is determined in the same way as for "Difference from". Totals outside of the
base field are shown as empty results.</paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -130,7 +130,7 @@
<paragraph role="tablecontent" id="par_idN10787" xml-lang="en-US" l10n="NEW">%
of row</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_idN1078D" xml-lang="en-US"
l10n="NEW">Each result is divided by the total result for its row in the pivot
table. If there are several data fields, the total for the result's data field
is used. If there are subtotals with manually selected summary functions, the
total with the data field's summary function is still used. </paragraph>
+<paragraph role="tablecontent" id="par_idN1078D" xml-lang="en-US"
l10n="NEW">Each result is divided by the total result for its row in the pivot
table. If there are several data fields, the total for the result's data field
is used. If there are subtotals with manually selected summary functions, the
total with the data field's summary function is still used.</paragraph>
</tablecell>
</tablerow>
<tablerow>
diff --git a/main/helpcontent2/source/text/scalc/01/12120100.xhp
b/main/helpcontent2/source/text/scalc/01/12120100.xhp
index b44c858e72..b9dbc39da8 100644
--- a/main/helpcontent2/source/text/scalc/01/12120100.xhp
+++ b/main/helpcontent2/source/text/scalc/01/12120100.xhp
@@ -137,14 +137,14 @@
<paragraph role="paragraph" id="par_idN1075E" xml-lang="en-US"
l10n="NEW"><ahelp hid="sc:MultiLineEdit:TP_VALIDATION_VALUES:EDT_LIST">Enter
the entries that will be valid values or text strings.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:TP_VALIDATION_VALUES:LB_VALUE" id="bm_id3147344"
localize="false"/>
<paragraph role="heading" id="hd_id3163807" xml-lang="en-US" level="2"
l10n="U" oldref="9">Data</paragraph>
-<paragraph role="paragraph" id="par_id3144502" xml-lang="en-US" l10n="U"
oldref="10"><ahelp hid="SC:LISTBOX:TP_VALIDATION_VALUES:LB_VALUE">Select the
comparative operator that you want to use.</ahelp> The available operators
depend on what you selected in the <emph>Allow </emph>box. If you select
"between" or "not between", the <emph>Minimum</emph> and <emph>Maximum</emph>
input boxes appear. Otherwise, only the <emph>Minimum</emph>, the
<emph>Maximum, or the Value</emph> input boxes app [...]
+<paragraph role="paragraph" id="par_id3144502" xml-lang="en-US" l10n="U"
oldref="10"><ahelp hid="SC:LISTBOX:TP_VALIDATION_VALUES:LB_VALUE">Select the
comparative operator that you want to use.</ahelp> The available operators
depend on what you selected in the <emph>Allow</emph> box. If you select
"between" or "not between", the <emph>Minimum</emph> and <emph>Maximum</emph>
input boxes appear. Otherwise, only the <emph>Minimum</emph>, the
<emph>Maximum, or the Value</emph> input boxes app [...]
<paragraph role="heading" id="hd_id3153782" xml-lang="en-US" level="2"
l10n="U" oldref="11">Value</paragraph>
-<paragraph role="paragraph" id="par_id3153266" xml-lang="en-US" l10n="CHG"
oldref="12">Enter the value for the data validation option that you selected in
the <emph>Allow </emph>box.</paragraph>
+<paragraph role="paragraph" id="par_id3153266" xml-lang="en-US" l10n="CHG"
oldref="12">Enter the value for the data validation option that you selected in
the <emph>Allow</emph> box.</paragraph>
<bookmark xml-lang="en-US" branch="hid/sc:Edit:TP_VALIDATION_VALUES:EDT_MIN"
id="bm_id3149528" localize="false"/>
<paragraph role="heading" id="hd_id3149814" xml-lang="en-US" level="2"
l10n="U" oldref="13">Minimum</paragraph>
-<paragraph role="paragraph" id="par_id3153199" xml-lang="en-US" l10n="U"
oldref="14"><ahelp hid="SC:EDIT:TP_VALIDATION_VALUES:EDT_MIN">Enter the minimum
value for the data validation option that you selected in the <emph>Allow
</emph>box.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153199" xml-lang="en-US" l10n="U"
oldref="14"><ahelp hid="SC:EDIT:TP_VALIDATION_VALUES:EDT_MIN">Enter the minimum
value for the data validation option that you selected in the
<emph>Allow</emph> box.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/sc:Edit:TP_VALIDATION_VALUES:EDT_MAX"
id="bm_id3150206" localize="false"/>
<paragraph role="heading" id="hd_id3149035" xml-lang="en-US" level="2"
l10n="U" oldref="15">Maximum</paragraph>
-<paragraph role="paragraph" id="par_id3150089" xml-lang="en-US" l10n="U"
oldref="16"><ahelp hid="SC:EDIT:TP_VALIDATION_VALUES:EDT_MAX">Enter the maximum
value for the data validation option that you selected in the <emph>Allow
</emph>box.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3150089" xml-lang="en-US" l10n="U"
oldref="16"><ahelp hid="SC:EDIT:TP_VALIDATION_VALUES:EDT_MAX">Enter the maximum
value for the data validation option that you selected in the
<emph>Allow</emph> box.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/scalc/01/12120300.xhp
b/main/helpcontent2/source/text/scalc/01/12120300.xhp
index 0d5e147275..a36aaba9e8 100644
--- a/main/helpcontent2/source/text/scalc/01/12120300.xhp
+++ b/main/helpcontent2/source/text/scalc/01/12120300.xhp
@@ -41,7 +41,7 @@
<bookmark xml-lang="en-US"
branch="hid/sc:TriStateBox:TP_VALIDATION_ERROR:TSB_SHOW" id="bm_id3154908"
localize="false"/>
<paragraph role="heading" id="hd_id3156280" xml-lang="en-US" level="2"
l10n="U" oldref="3">Show error message when invalid values are
entered.</paragraph>
<paragraph role="paragraph" id="par_id3150768" xml-lang="en-US" l10n="CHG"
oldref="4"><ahelp hid=".">Displays the error message that you enter in the
<emph>Contents</emph> area when invalid data is entered in a cell.</ahelp> If
enabled, the message is displayed to prevent an invalid entry.</paragraph>
-<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U"
oldref="5">In both cases, if you select "Stop", the invalid entry is deleted
and the previous value is reentered in the cell. The same applies if you close
the "Warning" and "Information" dialogs by clicking the <emph>Cancel
</emph>button. If you close the dialogs with the <emph>OK</emph> button, the
invalid entry is not deleted.</paragraph>
+<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U"
oldref="5">In both cases, if you select "Stop", the invalid entry is deleted
and the previous value is reentered in the cell. The same applies if you close
the "Warning" and "Information" dialogs by clicking the <emph>Cancel</emph>
button. If you close the dialogs with the <emph>OK</emph> button, the invalid
entry is not deleted.</paragraph>
<paragraph role="heading" id="hd_id3152460" xml-lang="en-US" level="2"
l10n="U" oldref="6">Contents</paragraph>
<bookmark xml-lang="en-US"
branch="hid/sc:ListBox:TP_VALIDATION_ERROR:LB_ACTION" id="bm_id3154014"
localize="false"/>
<paragraph role="heading" id="hd_id3148646" xml-lang="en-US" level="3"
l10n="U" oldref="8">Action</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/func_day.xhp
b/main/helpcontent2/source/text/scalc/01/func_day.xhp
index f41047f01b..07486283b5 100644
--- a/main/helpcontent2/source/text/scalc/01/func_day.xhp
+++ b/main/helpcontent2/source/text/scalc/01/func_day.xhp
@@ -39,7 +39,7 @@
<paragraph role="code" id="par_id3149430" xml-lang="en-US" l10n="U"
oldref="109">DAY(Number)</paragraph>
<paragraph role="paragraph" id="par_id3149443" xml-lang="en-US" l10n="U"
oldref="110">
<emph>Number</emph>, as a time value, is a decimal, for which the day is to be
returned.</paragraph>
-<paragraph role="heading" id="hd_id3163809" xml-lang="en-US" level="3"
l10n="U" oldref="111">Examples </paragraph>
+<paragraph role="heading" id="hd_id3163809" xml-lang="en-US" level="3"
l10n="U" oldref="111">Examples</paragraph>
<paragraph role="paragraph" id="par_id3151200" xml-lang="en-US" l10n="U"
oldref="112">DAY(1) returns 31 (since $[officename] starts counting at zero
from December 30, 1899)</paragraph>
<paragraph role="paragraph" id="par_id3154130" xml-lang="en-US" l10n="U"
oldref="113">DAY(NOW()) returns the current day.</paragraph>
<paragraph role="paragraph" id="par_id3159190" xml-lang="en-US" l10n="CHG"
oldref="114">=DAY(C4) returns 5 if you enter 1901-08-05 in cell C4 (the date
value might get formatted differently after you press Enter).</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/01/solver.xhp
b/main/helpcontent2/source/text/scalc/01/solver.xhp
index 5806c8e575..080129612c 100644
--- a/main/helpcontent2/source/text/scalc/01/solver.xhp
+++ b/main/helpcontent2/source/text/scalc/01/solver.xhp
@@ -95,7 +95,7 @@ I hate such spec docs that leave so many
questions</comment></paragraph><comment
<paragraph role="paragraph" id="par_id2569658" xml-lang="en-US"
l10n="NEW"><ahelp hid="." visibility="hidden">Click to solve the equation with
the current settings. The dialog settings are retained until you close the
current document.</ahelp></paragraph>
<paragraph role="heading" id="par_id5474410" xml-lang="en-US" level="2"
l10n="NEW">To solve equations with the solver</paragraph>
<paragraph role="paragraph" id="par_id2216559" xml-lang="en-US" l10n="NEW">The
goal of the solver process is to find those variable values of an equation that
result in an optimized value in the <emph>target cell</emph>, also named the
"objective". You can choose whether the value in the target cell should be a
maximum, a minimum, or approaching a given value.</paragraph>
-<paragraph role="paragraph" id="par_id7869502" xml-lang="en-US" l10n="NEW">The
initial variable values are inserted in a rectangular cell range that you enter
in the <emph>By changing cells</emph> box. </paragraph>
+<paragraph role="paragraph" id="par_id7869502" xml-lang="en-US" l10n="NEW">The
initial variable values are inserted in a rectangular cell range that you enter
in the <emph>By changing cells</emph> box.</paragraph>
<paragraph role="paragraph" id="par_id9852900" xml-lang="en-US" l10n="NEW">You
can define a series of limiting conditions that set constraints for some cells.
For example, you can set the constraint that one of the variables or cells must
not be bigger than another variable, or not bigger than a given value. You can
also define the constraint that one or more variables must be integers (values
without decimals), or binary values (where only 0 and 1 are
allowed).</paragraph>
<paragraph role="note" id="par_id5323953" xml-lang="en-US" l10n="NEW">The
default solver engine supports only linear equations.</paragraph><comment>Add
an example. A good one is at http://www.solver.com/stepbystep.htm but that is
not OpenSource</comment>
</body>
diff --git a/main/helpcontent2/source/text/scalc/05/empty_cells.xhp
b/main/helpcontent2/source/text/scalc/05/empty_cells.xhp
index f9a0105b2d..53fa070933 100644
--- a/main/helpcontent2/source/text/scalc/05/empty_cells.xhp
+++ b/main/helpcontent2/source/text/scalc/05/empty_cells.xhp
@@ -33,7 +33,7 @@
<bookmark_value>empty cells;handling of</bookmark_value>
</bookmark><comment>i86303</comment>
<paragraph role="heading" id="hd_id1502121" xml-lang="en-US" level="1"
l10n="NEW"><variable id="empty_cells"><link
href="text/scalc/05/empty_cells.xhp">Handling of Empty
Cells</link></variable></paragraph>
-<paragraph role="paragraph" id="par_id8266853" xml-lang="en-US" l10n="NEW">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_id8266853" xml-lang="en-US" l10n="NEW">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" l10n="NEW">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>
<paragraph role="paragraph" id="par_id4238715" xml-lang="en-US" l10n="NEW">For
the following examples, A1 contains a number, B1 is empty, C1 contains the
reference to B1:</paragraph>
<paragraph role="code" id="par_id8277230" xml-lang="en-US" l10n="NEW">A1: 1
B1: <empty> C1: =B1 (displays 0)</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/guide/borders.xhp
b/main/helpcontent2/source/text/scalc/guide/borders.xhp
index b6fb5f7990..673ee9d17a 100644
--- a/main/helpcontent2/source/text/scalc/guide/borders.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/borders.xhp
@@ -136,7 +136,7 @@
</list>
<paragraph xml-lang="en-US" id="par_id9269386" role="paragraph" l10n="NEW">Now
you can continue to see which lines the other icons will set or
remove.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3593554" role="heading" level="2"
l10n="NEW">User Defined Settings</paragraph>
-<paragraph xml-lang="en-US" id="par_id4018066" role="paragraph" l10n="NEW">In
the <emph>User defined</emph> area, you can click to set or remove individual
lines. The preview shows lines in three different states. </paragraph>
+<paragraph xml-lang="en-US" id="par_id4018066" role="paragraph" l10n="NEW">In
the <emph>User defined</emph> area, you can click to set or remove individual
lines. The preview shows lines in three different states.</paragraph>
<paragraph xml-lang="en-US" id="par_id8004699" role="paragraph"
l10n="NEW">Repeatedly click an edge or a corner to switch through the three
different states.</paragraph>
<table id="tbl_id5196996">
<tablerow>
diff --git a/main/helpcontent2/source/text/scalc/guide/cell_protect.xhp
b/main/helpcontent2/source/text/scalc/guide/cell_protect.xhp
index 406f720d8b..fa4f9c9854 100644
--- a/main/helpcontent2/source/text/scalc/guide/cell_protect.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/cell_protect.xhp
@@ -56,7 +56,7 @@
<listitem>
<paragraph xml-lang="en-US" id="par_id3152985" role="listitem" l10n="U"
oldref="9">Select the protection options that you want. All options will be
applied only after you protect the sheet from the Tools menu - see
below.</paragraph>
<paragraph xml-lang="en-US" id="par_id31529866655" role="listitem"
l10n="NEW">Uncheck <emph>Protected</emph> to allow the user to change the
currently selected cells.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3152898" role="listitem" l10n="U"
oldref="10">Select <emph>Protected</emph> to prevent changes to the contents
and the format of a cell. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3152898" role="listitem" l10n="U"
oldref="10">Select <emph>Protected</emph> to prevent changes to the contents
and the format of a cell.</paragraph>
<paragraph xml-lang="en-US" id="par_idN1069A" role="listitem"
l10n="NEW">Select <emph>Hide formula</emph> to hide and to protect formulas
from changes.</paragraph>
<paragraph xml-lang="en-US" id="par_idN106A1" role="listitem"
l10n="NEW">Select <emph>Hide when printing</emph> to hide protected cells in
the printed document. The cells are not hidden onscreen.</paragraph>
</listitem>
@@ -73,7 +73,7 @@
<paragraph xml-lang="en-US" id="par_idN106D2" role="warning" l10n="NEW">If you
forget your password, you cannot deactivate the protection. If you only want to
protect cells from accidental changes, set the sheet protection, but do not
enter a password.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id3153810" role="listitem" l10n="U"
oldref="13">Click <emph>OK</emph>. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3153810" role="listitem" l10n="U"
oldref="13">Click <emph>OK</emph>.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
diff --git a/main/helpcontent2/source/text/scalc/guide/cellreferences.xhp
b/main/helpcontent2/source/text/scalc/guide/cellreferences.xhp
index e8c68e6f59..10b73090b7 100644
--- a/main/helpcontent2/source/text/scalc/guide/cellreferences.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/cellreferences.xhp
@@ -70,7 +70,7 @@ oldref="9"><variable id="cellreferences"><link
href="text/scalc/guide/cellrefere
<paragraph xml-lang="en-US" id="par_id8571123" role="listitem" l10n="NEW">Now
switch to the document you have just loaded. Click the cell with the data that
you want to insert in the new document.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id8261665" role="listitem"
l10n="NEW">Switch back to the new spreadsheet. In the input line you will now
see how $[officename] Calc has added the reference to the formula for you.
</paragraph>
+<paragraph xml-lang="en-US" id="par_id8261665" role="listitem"
l10n="NEW">Switch back to the new spreadsheet. In the input line you will now
see how $[officename] Calc has added the reference to the formula for
you.</paragraph>
<paragraph xml-lang="en-US" id="par_id5888241" role="listitem" l10n="NEW">The
reference to a cell of another document contains the name of the other document
in single inverted commas, then a hash #, then the name of the sheet of the
other document, followed by a point and the name of the cell.</paragraph>
</listitem>
<listitem>
diff --git a/main/helpcontent2/source/text/scalc/guide/csv_files.xhp
b/main/helpcontent2/source/text/scalc/guide/csv_files.xhp
index a56666cd20..d7aac2f1a9 100644
--- a/main/helpcontent2/source/text/scalc/guide/csv_files.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/csv_files.xhp
@@ -63,7 +63,7 @@
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_idN108B1" role="listitem"
l10n="NEW">Specify the options to divide the text in the file into
columns.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN108BB" role="listitem" l10n="NEW">You
can preview the layout of the imported data at the bottom of the <item
type="menuitem">Text Import</item> dialog. </paragraph>
+<paragraph xml-lang="en-US" id="par_idN108BB" role="listitem" l10n="NEW">You
can preview the layout of the imported data at the bottom of the <item
type="menuitem">Text Import</item> dialog.</paragraph>
<paragraph xml-lang="en-US" id="par_id8444166" role="listitem"
l10n="NEW">Right-click a column in the preview to set the format or to hide the
column.</paragraph>
<paragraph xml-lang="en-US" id="par_idN108E2" role="tip" l10n="CHG">Check the
text delimiter box that matches the character used as text delimiter in the
file. In case of an unlisted delimiter, type the character into the input
box.</paragraph>
</listitem>
diff --git a/main/helpcontent2/source/text/scalc/guide/database_define.xhp
b/main/helpcontent2/source/text/scalc/guide/database_define.xhp
index f038329966..dcecbd7043 100644
--- a/main/helpcontent2/source/text/scalc/guide/database_define.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/database_define.xhp
@@ -39,7 +39,7 @@
oldref="31"><variable id="database_define"><link
href="text/scalc/guide/database_define.xhp" name="Defining Database
Ranges">Defining a Database Range</link>
</variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3153768" role="paragraph" l10n="U"
oldref="81">You can define a range of cells in a spreadsheet to use as a
database. Each row in this database range corresponds to a database record and
each cell in a row corresponds to a database field. You can sort, group,
search, and perform calculations on the range as you would in a
database.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3145801" role="warning" l10n="CHG"
oldref="82">You can only edit and access a database range in the spreadsheet
that contains the range. You cannot access the database range in the
%PRODUCTNAME Data Sources view. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3145801" role="warning" l10n="CHG"
oldref="82">You can only edit and access a database range in the spreadsheet
that contains the range. You cannot access the database range in the
%PRODUCTNAME Data Sources view.</paragraph>
<paragraph xml-lang="en-US" id="par_idN10648" role="paragraph" l10n="NEW">To
define a database range</paragraph>
<list type="ordered">
<listitem>
diff --git a/main/helpcontent2/source/text/scalc/guide/dbase_files.xhp
b/main/helpcontent2/source/text/scalc/guide/dbase_files.xhp
index 3bc56b6ede..da35b2a9c0 100644
--- a/main/helpcontent2/source/text/scalc/guide/dbase_files.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/dbase_files.xhp
@@ -45,7 +45,7 @@
<paragraph xml-lang="en-US" id="par_idN10760" role="paragraph"
l10n="NEW">Choose <emph>File - Open</emph>.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_idN1071F" role="paragraph"
l10n="NEW">Locate the *.dbf file that you want to import. </paragraph>
+<paragraph xml-lang="en-US" id="par_idN1071F" role="paragraph"
l10n="NEW">Locate the *.dbf file that you want to import.</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_idN10768" role="paragraph"
l10n="NEW">Click <emph>Open</emph>.</paragraph>
@@ -70,7 +70,7 @@
<paragraph xml-lang="en-US" id="par_idN10792" role="paragraph"
l10n="NEW">Click <emph>Save</emph>.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_idN1079A" role="paragraph" l10n="NEW">In
the <emph>Database type </emph>box of the <emph>Database Properties</emph>
dialog, select "dBASE".</paragraph>
+<paragraph xml-lang="en-US" id="par_idN1079A" role="paragraph" l10n="NEW">In
the <emph>Database type</emph> box of the <emph>Database Properties</emph>
dialog, select "dBASE".</paragraph>
</listitem>
<listitem>
<paragraph xml-lang="en-US" id="par_idN107A6" role="paragraph"
l10n="NEW">Click <emph>Next</emph>.</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/guide/design.xhp
b/main/helpcontent2/source/text/scalc/guide/design.xhp
index 368bf78a53..e60b13acc4 100644
--- a/main/helpcontent2/source/text/scalc/guide/design.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/design.xhp
@@ -48,7 +48,7 @@
<paragraph xml-lang="en-US" id="par_id3153963" role="paragraph" l10n="U"
oldref="19">To apply a theme to a spreadsheet:</paragraph>
<list type="ordered">
<listitem>
-<paragraph xml-lang="en-US" id="par_id3146920" role="listitem" l10n="CHG"
oldref="15">Click the <emph>Choose Themes</emph> icon in the <emph>Tools</emph>
bar. </paragraph>
+<paragraph xml-lang="en-US" id="par_id3146920" role="listitem" l10n="CHG"
oldref="15">Click the <emph>Choose Themes</emph> icon in the <emph>Tools</emph>
bar.</paragraph>
<embed href="text/scalc/02/06080000.xhp#sythemen"/>
<paragraph xml-lang="en-US" id="par_id3148488" role="listitem" l10n="CHG"
oldref="20">The <emph>Theme Selection</emph> dialog appears. This dialog lists
the available themes for the whole spreadsheet and the Styles and Formatting
window lists the custom styles for specific cells.</paragraph>
</listitem>
diff --git a/main/helpcontent2/source/text/scalc/guide/filters.xhp
b/main/helpcontent2/source/text/scalc/guide/filters.xhp
index 02e447a68c..6abbbf8383 100644
--- a/main/helpcontent2/source/text/scalc/guide/filters.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/filters.xhp
@@ -50,7 +50,7 @@ oldref="70"><variable id="filters"><link
href="text/scalc/guide/filters.xhp" nam
</listitem>
</list>
<paragraph xml-lang="en-US" id="par_id9384746" role="tip" l10n="NEW">To remove
a filter, so that you see all cells again, click inside the area where the
filter was applied, then choose <item type="menuitem">Data - Filter - Remove
Filter</item>.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN10663" role="note" l10n="NEW">When you
select multiple rows from an area where a filter was applied, then this
selection can include rows that are visible and rows that are hidden by the
filter. If you then apply formatting, or delete the selected rows, this action
then applies only to the visible rows. The hidden rows are not affected.
</paragraph>
+<paragraph xml-lang="en-US" id="par_idN10663" role="note" l10n="NEW">When you
select multiple rows from an area where a filter was applied, then this
selection can include rows that are visible and rows that are hidden by the
filter. If you then apply formatting, or delete the selected rows, this action
then applies only to the visible rows. The hidden rows are not
affected.</paragraph>
<paragraph xml-lang="en-US" id="par_id218817" role="note" l10n="NEW">This is
the opposite to rows that you have hidden manually by the <emph>Format - Rows -
Hide Rows</emph> command. Manually hidden rows are deleted when you delete a
selection that contains them.</paragraph>
<section id="relatedtopics">
<embed href="text/scalc/guide/autofilter.xhp#autofilter"/>
diff --git a/main/helpcontent2/source/text/scalc/guide/finding.xhp
b/main/helpcontent2/source/text/scalc/guide/finding.xhp
index edba0d7bf6..29613179b7 100644
--- a/main/helpcontent2/source/text/scalc/guide/finding.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/finding.xhp
@@ -55,8 +55,8 @@
<paragraph role="paragraph" id="par_id2186346" xml-lang="en-US"
l10n="NEW">Select "Formulas" or "Values" in the <emph>Search in</emph> list
box.</paragraph>
</listitem>
</list>
-<paragraph role="paragraph" id="par_id1331217" xml-lang="en-US"
l10n="NEW">With "Formulas" you will find all parts of the formulas. </paragraph>
-<paragraph role="paragraph" id="par_id393993" xml-lang="en-US" l10n="NEW">With
"Values" you will find the results of the calculations. </paragraph>
+<paragraph role="paragraph" id="par_id1331217" xml-lang="en-US"
l10n="NEW">With "Formulas" you will find all parts of the formulas.</paragraph>
+<paragraph role="paragraph" id="par_id393993" xml-lang="en-US" l10n="NEW">With
"Values" you will find the results of the calculations.</paragraph>
<paragraph role="note" id="par_id3163853" xml-lang="en-US" l10n="NEW">Cell
contents can be formatted in different ways. For example, a number can be
formatted as a currency, to be displayed with a currency symbol. You see the
currency symbol in the cell, but you cannot search for it.</paragraph>
<paragraph role="heading" id="hd_id7359233" xml-lang="en-US" level="3"
l10n="NEW">Finding text</paragraph>
<list type="ordered">
@@ -70,10 +70,10 @@
<paragraph role="paragraph" id="par_id9121982" xml-lang="en-US"
l10n="NEW">Either click <emph>Find</emph> or <emph>Find All</emph>.</paragraph>
</listitem>
</list>
-<paragraph role="paragraph" id="par_id3808404" xml-lang="en-US"
l10n="NEW">When you click <emph>Find</emph>, Calc will select the next cell
that contains your text. You can watch and edit the text, then click
<emph>Find</emph> again to advance to the next found cell. </paragraph>
+<paragraph role="paragraph" id="par_id3808404" xml-lang="en-US"
l10n="NEW">When you click <emph>Find</emph>, Calc will select the next cell
that contains your text. You can watch and edit the text, then click
<emph>Find</emph> again to advance to the next found cell.</paragraph>
<list type="ordered">
<listitem>
-<paragraph role="paragraph" id="par_id2394482" xml-lang="en-US" l10n="NEW">If
you closed the dialog, you can press a key combination (<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+F)
to find the next cell without opening the dialog. </paragraph>
+<paragraph role="paragraph" id="par_id2394482" xml-lang="en-US" l10n="NEW">If
you closed the dialog, you can press a key combination (<switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+F)
to find the next cell without opening the dialog.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id631733" xml-lang="en-US" l10n="NEW">By
default, Calc searches the current sheet. Click <emph>More Options</emph>, then
enable <emph>Search in all sheets</emph> to search through all sheets of the
document.</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/guide/format_table.xhp
b/main/helpcontent2/source/text/scalc/guide/format_table.xhp
index 9426f5ad51..b607756abe 100644
--- a/main/helpcontent2/source/text/scalc/guide/format_table.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/format_table.xhp
@@ -41,7 +41,7 @@
</bookmark><comment>mw transferred 2 entries from shared/01/05020300.xhp and
added 2 new entries</comment><comment>mw deleted "defaults;"</comment>
<paragraph role="heading" id="hd_id3154125" xml-lang="en-US" level="1"
l10n="U" oldref="6"><variable id="format_table"><link
href="text/scalc/guide/format_table.xhp" name="Designing
Spreadsheets">Formatting Spreadsheets</link>
</variable></paragraph>
-<paragraph role="heading" id="hd_id3153912" xml-lang="en-US" level="2"
l10n="U" oldref="13">Formatting Text in a Spreadsheet </paragraph>
+<paragraph role="heading" id="hd_id3153912" xml-lang="en-US" level="2"
l10n="U" oldref="13">Formatting Text in a Spreadsheet</paragraph>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3144772" xml-lang="en-US" l10n="U"
oldref="14">Select the text you want to format.</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/guide/fraction_enter.xhp
b/main/helpcontent2/source/text/scalc/guide/fraction_enter.xhp
index d595ea811d..2ee0aa405f 100644
--- a/main/helpcontent2/source/text/scalc/guide/fraction_enter.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/fraction_enter.xhp
@@ -44,7 +44,7 @@
</listitem>
</list>
<paragraph role="paragraph" id="par_id3145750" xml-lang="en-US" l10n="U"
oldref="43">If you enter "0 1/2" AutoCorrect causes the three characters 1, /
and 2 to be replaced by a single character. The same applies to 1/4 and 3/4.
This replacement is defined in <emph>Tools - AutoCorrect Options -
Options</emph> tab.</paragraph>
-<paragraph role="paragraph" id="par_id3145367" xml-lang="en-US" l10n="U"
oldref="44">If you want to see multi-digit fractions such as "1/10", you must
change the cell format to the multi-digit fraction view. Open the context menu
of the cell, and choose <emph>Format cells. </emph>Select "Fraction" from the
<emph>Category</emph> field, and then select "-1234 10/81". You can then enter
fractions such as 12/31 or 12/32 - the fractions are, however, automatically
reduced, so that in the last [...]
+<paragraph role="paragraph" id="par_id3145367" xml-lang="en-US" l10n="U"
oldref="44">If you want to see multi-digit fractions such as "1/10", you must
change the cell format to the multi-digit fraction view. Open the context menu
of the cell, and choose <emph>Format cells</emph>. Select "Fraction" from the
<emph>Category</emph> field, and then select "-1234 10/81". You can then enter
fractions such as 12/31 or 12/32 - the fractions are, however, automatically
reduced, so that in the last [...]
</section>
<section id="relatedtopics">
<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/>
diff --git a/main/helpcontent2/source/text/scalc/guide/line_fix.xhp
b/main/helpcontent2/source/text/scalc/guide/line_fix.xhp
index fc751ffb8a..f86cb887e6 100644
--- a/main/helpcontent2/source/text/scalc/guide/line_fix.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/line_fix.xhp
@@ -50,7 +50,7 @@
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3156286" xml-lang="en-US" l10n="U"
oldref="4">Choose <emph>Window - Freeze</emph>.</paragraph>
-<paragraph role="listitem" id="par_id3151073" xml-lang="en-US" l10n="U"
oldref="5">To deactivate, choose <emph>Window - Freeze </emph>again.</paragraph>
+<paragraph role="listitem" id="par_id3151073" xml-lang="en-US" l10n="U"
oldref="5">To deactivate, choose <emph>Window - Freeze</emph> again.</paragraph>
</listitem>
</list>
<paragraph role="note" id="par_id3155335" xml-lang="en-US" l10n="U"
oldref="7">If the area defined is to be scrollable, apply the <emph>Window -
Split</emph> command.</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp
b/main/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp
index fbf331bc7a..d38568f2ac 100644
--- a/main/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp
@@ -42,11 +42,11 @@
<paragraph role="paragraph" id="par_id9527268" xml-lang="en-US"
l10n="NEW">When you hold down the <switchinline select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>
key while releasing the mouse button, you enter the <emph>insert
mode</emph>.</paragraph>
<list type="ordered">
<listitem>
-<paragraph role="paragraph" id="par_id79653" xml-lang="en-US" l10n="NEW">In
insert mode, the existing cells where you drop will be shifted to the right or
to the bottom, and the dropped cells are inserted into the now empty positions
without overwriting. </paragraph>
+<paragraph role="paragraph" id="par_id79653" xml-lang="en-US" l10n="NEW">In
insert mode, the existing cells where you drop will be shifted to the right or
to the bottom, and the dropped cells are inserted into the now empty positions
without overwriting.</paragraph>
</listitem>
<listitem>
-<paragraph role="paragraph" id="par_id8676717" xml-lang="en-US" l10n="NEW">The
surrounding box of the moved cells looks different in insert mode. </paragraph>
-<paragraph role="paragraph" id="par_id3968932" xml-lang="en-US" l10n="NEW">In
overwrite mode you see all four borders around the selected area. In insert
mode you see only the left border when target cells will be shifted to the
right. You see only the upper border when target cells will be shifted down.
</paragraph>
+<paragraph role="paragraph" id="par_id8676717" xml-lang="en-US" l10n="NEW">The
surrounding box of the moved cells looks different in insert mode.</paragraph>
+<paragraph role="paragraph" id="par_id3968932" xml-lang="en-US" l10n="NEW">In
overwrite mode you see all four borders around the selected area. In insert
mode you see only the left border when target cells will be shifted to the
right. You see only the upper border when target cells will be shifted
down.</paragraph>
<paragraph role="paragraph" id="par_id7399517" xml-lang="en-US"
l10n="NEW">Whether the target area will be shifted to the right or to the
bottom depends on the distance between source and target cells, if you move
within the same sheet. It depends on the number of horizontal or vertical cells
in the moved area, if you move to a different sheet.</paragraph>
</listitem>
<listitem>
@@ -92,7 +92,7 @@
<paragraph role="tablecontent" id="par_id9518723" xml-lang="en-US"
l10n="NEW"><switchinline select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>
key</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_id2926419" xml-lang="en-US"
l10n="NEW">Cells are moved and shift the cells in the target area to the right
or to the bottom. Source cells are emptied, except if you move within the same
rows on the same sheet. </paragraph>
+<paragraph role="tablecontent" id="par_id2926419" xml-lang="en-US"
l10n="NEW">Cells are moved and shift the cells in the target area to the right
or to the bottom. Source cells are emptied, except if you move within the same
rows on the same sheet.</paragraph>
<paragraph role="tablecontent" id="par_id4021423" xml-lang="en-US"
l10n="NEW">If you move within the same rows on the same sheet, the cells in the
target area shift to the right, and then the whole row shifts to fill the
source area.</paragraph>
</tablecell>
</tablerow>
diff --git a/main/helpcontent2/source/text/scalc/guide/multioperation.xhp
b/main/helpcontent2/source/text/scalc/guide/multioperation.xhp
index 9789401e69..a4609a1c67 100644
--- a/main/helpcontent2/source/text/scalc/guide/multioperation.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/multioperation.xhp
@@ -61,7 +61,7 @@
<paragraph role="listitem" id="par_id3149723" xml-lang="en-US" l10n="U"
oldref="45">Choose <emph>Data - Multiple operations</emph>.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3149149" xml-lang="en-US" l10n="U"
oldref="46">With the cursor in the <emph>Formulas </emph>field, click cell
B5.</paragraph>
+<paragraph role="listitem" id="par_id3149149" xml-lang="en-US" l10n="U"
oldref="46">With the cursor in the <emph>Formulas</emph> field, click cell
B5.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3149355" xml-lang="en-US" l10n="CHG"
oldref="47">Set the cursor in the <emph>Column input cell</emph> field and
click cell B4. This means that B4, the quantity, is the variable in the
formula, which is replaced by the selected column values.</paragraph>
diff --git a/main/helpcontent2/source/text/scalc/guide/print_landscape.xhp
b/main/helpcontent2/source/text/scalc/guide/print_landscape.xhp
index 164e099284..1da0ce5cad 100644
--- a/main/helpcontent2/source/text/scalc/guide/print_landscape.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/print_landscape.xhp
@@ -55,7 +55,7 @@
<paragraph xml-lang="en-US" id="par_id3156288" role="listitem" l10n="U"
oldref="8">Depending on the printer driver and the operating system, it may be
necessary to click the <emph>Properties</emph> button and to change your
printer to landscape format there.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id3149404" role="listitem" l10n="CHG"
oldref="9">In the <emph>Print </emph>dialog in the <emph>General</emph> tab
page, select the contents to be printed:</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149404" role="listitem" l10n="CHG"
oldref="9">In the <emph>Print</emph> dialog in the <emph>General</emph> tab
page, select the contents to be printed:</paragraph>
<paragraph xml-lang="en-US" id="par_id3153305" role="listitem" l10n="CHG"
oldref="10">
<emph>All sheets</emph> - All sheets will be printed.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148871" role="listitem" l10n="CHG"
oldref="12">
diff --git a/main/helpcontent2/source/text/scalc/guide/specialfilter.xhp
b/main/helpcontent2/source/text/scalc/guide/specialfilter.xhp
index c9a44f3b6b..81fb45b665 100644
--- a/main/helpcontent2/source/text/scalc/guide/specialfilter.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/specialfilter.xhp
@@ -45,34 +45,34 @@
<paragraph xml-lang="en-US" id="par_id3153142" role="listitem" l10n="U"
oldref="20">Once you have created a filter matrix, select the sheet ranges to
be filtered. Open the <emph>Advanced Filter</emph> dialog by choosing
<emph>Data - Filter - Advanced Filter</emph>, and define the filter
conditions.</paragraph>
</listitem>
<listitem>
-<paragraph xml-lang="en-US" id="par_id3153726" role="listitem" l10n="U"
oldref="21">Then click OK, and you will see that only the rows from the
original sheet whose contents have met the search criteria are still visible.
All other rows are temporarily hidden and can be made to reappear with the
<emph>Format - Row - Show </emph>command.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153726" role="listitem" l10n="U"
oldref="21">Then click OK, and you will see that only the rows from the
original sheet whose contents have met the search criteria are still visible.
All other rows are temporarily hidden and can be made to reappear with the
<emph>Format - Row - Show</emph> command.</paragraph>
</listitem>
</list>
-<paragraph xml-lang="en-US" id="par_id3149664" role="paragraph" l10n="U"
oldref="22"> <emph>Example</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3149664" role="paragraph" l10n="U"
oldref="22"> <emph>Example</emph></paragraph>
<paragraph xml-lang="en-US" id="par_id3147427" role="paragraph" l10n="U"
oldref="23">Load a spreadsheet with a large number of records. We are using a
fictional <emph>Turnover</emph> document, but you can just as easily use any
other document. The document has the following layout:</paragraph>
<table id="tbl_id3149377">
<tablerow>
<tablecell>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3154510" role="paragraph" l10n="U"
oldref="24"> <emph>A</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3154510" role="paragraph" l10n="U"
oldref="24"> <emph>A</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3150327" role="paragraph" l10n="U"
oldref="25"> <emph>B</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3150327" role="paragraph" l10n="U"
oldref="25"> <emph>B</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3154756" role="paragraph" l10n="U"
oldref="26"> <emph>C</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3154756" role="paragraph" l10n="U"
oldref="26"> <emph>C</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3155335" role="paragraph" l10n="U"
oldref="27"> <emph>D</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3155335" role="paragraph" l10n="U"
oldref="27"> <emph>D</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3146315" role="paragraph" l10n="U"
oldref="28"> <emph>E</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3146315" role="paragraph" l10n="U"
oldref="28"> <emph>E</emph></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3145790" role="paragraph" l10n="U"
oldref="29"> <emph>1</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3145790" role="paragraph" l10n="U"
oldref="29"> <emph>1</emph></paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3159239" role="paragraph" l10n="U"
oldref="30">Month</paragraph>
@@ -92,7 +92,7 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3154486" role="paragraph" l10n="U"
oldref="35"> <emph>2</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3154486" role="paragraph" l10n="U"
oldref="35"> <emph>2</emph></paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3148839" role="paragraph" l10n="U"
oldref="36">January</paragraph>
@@ -112,7 +112,7 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3146782" role="paragraph" l10n="U"
oldref="41"> <emph>3</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3146782" role="paragraph" l10n="U"
oldref="41"> <emph>3</emph></paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3149900" role="paragraph" l10n="U"
oldref="42">February</paragraph>
@@ -132,7 +132,7 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3151191" role="paragraph" l10n="U"
oldref="47"> <emph>4</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3151191" role="paragraph" l10n="U"
oldref="47"> <emph>4</emph></paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3147250" role="paragraph" l10n="U"
oldref="48">March</paragraph>
@@ -155,24 +155,24 @@
<tablecell>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3159115" role="paragraph" l10n="U"
oldref="52"> <emph>A</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3159115" role="paragraph" l10n="U"
oldref="52"> <emph>A</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3146886" role="paragraph" l10n="U"
oldref="53"> <emph>B</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3146886" role="paragraph" l10n="U"
oldref="53"> <emph>B</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3153124" role="paragraph" l10n="U"
oldref="54"> <emph>C</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3153124" role="paragraph" l10n="U"
oldref="54"> <emph>C</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3152979" role="paragraph" l10n="U"
oldref="55"> <emph>D</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3152979" role="paragraph" l10n="U"
oldref="55"> <emph>D</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3145827" role="paragraph" l10n="U"
oldref="56"> <emph>E</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3145827" role="paragraph" l10n="U"
oldref="56"> <emph>E</emph></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3149892" role="paragraph" l10n="U"
oldref="57"> <emph>20</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3149892" role="paragraph" l10n="U"
oldref="57"> <emph>20</emph></paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3150693" role="paragraph" l10n="U"
oldref="58">Month</paragraph>
@@ -192,7 +192,7 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3149188" role="paragraph" l10n="U"
oldref="63"> <emph>21</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3149188" role="paragraph" l10n="U"
oldref="63"> <emph>21</emph></paragraph>
</tablecell>
<tablecell>
<paragraph xml-lang="en-US" id="par_id3149956" role="paragraph" l10n="CHG"
oldref="64">January</paragraph>
@@ -208,7 +208,7 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3150865" role="paragraph" l10n="U"
oldref="65"> <emph>22</emph> </paragraph>
+<paragraph xml-lang="en-US" id="par_id3150865" role="paragraph" l10n="U"
oldref="65"> <emph>22</emph></paragraph>
</tablecell>
<tablecell>
</tablecell>
diff --git a/main/helpcontent2/source/text/scalc/guide/userdefined_function.xhp
b/main/helpcontent2/source/text/scalc/guide/userdefined_function.xhp
index 3a835aa743..a556ad1b50 100644
--- a/main/helpcontent2/source/text/scalc/guide/userdefined_function.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/userdefined_function.xhp
@@ -66,7 +66,7 @@
</listitem>
</list>
<paragraph role="heading" id="hd_id3147340" xml-lang="en-US" level="2"
l10n="U" oldref="18">Copying a Function To a Document</paragraph>
-<paragraph role="paragraph" id="par_id3145232" xml-lang="en-US" l10n="CHG"
oldref="19">In stage 2 of "Defining A Function Using %PRODUCTNAME Basic", in
the <emph>Macro</emph> dialog you clicked on <emph>Edit </emph>. As the
default, in the <emph>Macro from</emph> field the <emph>My Macros - Standard -
Module1</emph> module is selected. The <emph>Standard</emph> library resides
locally in your user directory.</paragraph>
+<paragraph role="paragraph" id="par_id3145232" xml-lang="en-US" l10n="CHG"
oldref="19">In stage 2 of "Defining A Function Using %PRODUCTNAME Basic", in
the <emph>Macro</emph> dialog you clicked on <emph>Edit</emph>. As the default,
in the <emph>Macro from</emph> field the <emph>My Macros - Standard -
Module1</emph> module is selected. The <emph>Standard</emph> library resides
locally in your user directory.</paragraph>
<paragraph role="paragraph" id="par_id3154022" xml-lang="en-US" l10n="U"
oldref="20">If you want to copy the user-defined function to a Calc
document:</paragraph>
<list type="ordered">
<listitem>
diff --git a/main/helpcontent2/source/text/scalc/guide/validity.xhp
b/main/helpcontent2/source/text/scalc/guide/validity.xhp
index 2334269810..6e9ce8aa9b 100644
--- a/main/helpcontent2/source/text/scalc/guide/validity.xhp
+++ b/main/helpcontent2/source/text/scalc/guide/validity.xhp
@@ -58,7 +58,7 @@
<paragraph role="paragraph" id="par_id3148837" xml-lang="en-US" l10n="U"
oldref="8">Choose <item type="menuitem">Data - Validity</item>.</paragraph>
</listitem>
<listitem>
-<paragraph role="paragraph" id="par_id3156020" xml-lang="en-US" l10n="U"
oldref="9">On the <emph>Criteria</emph> tab page, enter the conditions for new
values entered into cells. </paragraph>
+<paragraph role="paragraph" id="par_id3156020" xml-lang="en-US" l10n="U"
oldref="9">On the <emph>Criteria</emph> tab page, enter the conditions for new
values entered into cells.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id3159208" xml-lang="en-US" l10n="U"
oldref="10">In the <emph>Allow</emph> field, select an option.</paragraph>
