source/text/scalc/01/05120000.xhp | 2
source/text/scalc/01/05120100.xhp | 183 +++++++++++++-------------------------
source/text/scalc/01/05120200.xhp | 23 ++--
source/text/scalc/01/05120300.xhp | 3
source/text/scalc/01/05120400.xhp | 1
source/text/scalc/01/05120500.xhp | 4
6 files changed, 88 insertions(+), 128 deletions(-)
New commits:
commit 91c56d486085c7a08ce05241bbf617a05932318f
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Oct 10 10:31:58 2022 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Oct 11 12:08:19 2022 +0200
Turn conditional formatting help pages more friendly
Change-Id: I6511663d80942720c5b9f1053e611f1f5209968c
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141159
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/05120000.xhp
b/source/text/scalc/01/05120000.xhp
index 6e413af55..180b9f625 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -30,7 +30,7 @@
<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatMenu"
id="bm_id5008047" localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/ConditionalFormatDialog"
id="bm_id3152518" localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/@@nowidget@@"
id="bm_id3152518" localize="false"/>
- <h1 id="hd_id3155132">Conditional Formatting</h1>
+ <h1 id="hd_id51665407876959"><variable
id="ConditionalFormattingh1"><link href="text/scalc/01/05120000.xhp"
name="Conditional Formatting">Conditional Formatting</link></variable></h1>
<paragraph xml-lang="en-US" id="par_id3163710"
role="paragraph"><variable id="bedingtetext"><ahelp hid=".">Use
<emph>Conditional Formatting</emph> to define range-based conditions that
determine which cell style will be applied to each cell in a given range based
on its contents.</ahelp></variable> The cell style corresponding to the first
condition that evaluates to <emph>true</emph> is applied. Cell styles applied
through Conditional Formatting override cell styles applied manually using the
<link href="text/scalc/main0202.xhp" name="FormattingBar_link"><emph>Formatting
Bar</emph></link> or the <emph>Styles</emph> sidebar.</paragraph>
<paragraph xml-lang="en-US" id="par_id3163711" role="paragraph">You can
enter several conditions that query the cell values or results of formulas. The
conditions are evaluated from first to the last. If <emph>Condition 1</emph> is
true based on the current cell contents, the corresponding cell style is
applied. Otherwise, <emph>Condition 2</emph> is evaluated to determine if its
corresponding style will be applied. If none of the conditions match cell
contents, then no changes are made to the cell format.</paragraph>
<paragraph role="paragraph" id="par_id431642031216368">Conditional
formats do not overwrite cell styles and direct formatting applied manually.
They remain saved as cell properties and are applied when the cell matches no
conditions or when you remove all conditional formats.</paragraph>
diff --git a/source/text/scalc/01/05120100.xhp
b/source/text/scalc/01/05120100.xhp
index 6e500c3af..d77d69a0e 100644
--- a/source/text/scalc/01/05120100.xhp
+++ b/source/text/scalc/01/05120100.xhp
@@ -26,14 +26,12 @@
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#s_conditionalcondition"/>
</section>
+ <h2 id="hd_id951665406076405">Conditions for Text and Numbers</h2>
<table id="tab_id211662913907277">
<tablerow>
<tablecell>
<paragraph id="par_id181662913907279" role="tablehead"
xml-lang="en-US">Condition</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id221663406419144" role="tablehead"
xml-lang="en-US" >Applies on</paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id941662913907280" role="tablehead"
xml-lang="en-US">Description</paragraph>
</tablecell>
@@ -42,75 +40,98 @@
<tablecell>
<paragraph id="par_id31662913907282" role="tablecontent"
xml-lang="en-US">is equal to</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id321663406539530" role="tablecontent"
xml-lang="en-US" ><variable id="numbertext">Numbers and
text</variable></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id881662913907284" role="tablecontent"
xml-lang="en-US">The cell value equals the user defined value in text box in
the right. Use text inside quotes if you compare text values.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id271662914239763" role="tablecontent"
xml-lang="en-US" >is less than</paragraph>
+ <paragraph id="par_id831662914760085" role="tablecontent"
xml-lang="en-US" >is not equal to</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id301662914760087" role="tablecontent"
xml-lang="en-US" >The cell value is not equal (different) to the user defined
value in the text box in the right. Use text inside quotes if you compare text
values.</paragraph>
</tablecell>
+ </tablerow>
+ <tablerow>
<tablecell>
- <paragraph id="par_id121663406585137" role="tablecontent"
xml-lang="en-US" ><variable id="numbers">Numbers</variable></paragraph>
+ <paragraph id="par_id151662920861587" role="tablecontent"
xml-lang="en-US" >begins with</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id501662914239764" role="tablecontent"
xml-lang="en-US" >The cell value is strictly less than the user defined value
in the text box in the right.</paragraph>
+ <paragraph id="par_id341662920861588" role="tablecontent"
xml-lang="en-US" >The cell contents begins with the text or number defined in
the text box on the right.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id701662914433053" role="tablecontent"
xml-lang="en-US" >is greater than</paragraph>
+ <paragraph id="par_id361662922600585" role="tablecontent"
xml-lang="en-US" >ends with</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id201663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id461662914433054" role="tablecontent"
xml-lang="en-US" >The cell value is strictly greater than the user defined
value in the text box in the right.</paragraph>
+ <paragraph id="par_id801662922600586" role="tablecontent"
xml-lang="en-US" >The cell contents ends with the text or number defined in the
right text box.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id421662914480517" role="tablecontent"
xml-lang="en-US" >is less than or equal to</paragraph>
+ <paragraph id="par_id151662922939292" role="tablecontent"
xml-lang="en-US" >contains</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id251662922939293" role="tablecontent"
xml-lang="en-US" >The cell contents contains the text or number defined in the
right text box.</paragraph>
</tablecell>
+ </tablerow>
+ <tablerow>
<tablecell>
- <paragraph id="par_id301663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
+ <paragraph id="par_id291662923021542" role="tablecontent"
xml-lang="en-US" >does not contain</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id631662914480518" role="tablecontent"
xml-lang="en-US" >The cell value is less than or equal to the user defined
value in the text box in the right.</paragraph>
+ <paragraph id="par_id541662923021543" role="tablecontent"
xml-lang="en-US" >The cell contents does not contains the text or number
defined in the text box on the right.</paragraph>
</tablecell>
</tablerow>
+ </table>
+ <note id="par_id801662922586796"><variable id="text_comparison">The
condition applies to the internal text conversion of the cell contents. Numeric
values are compared with their equivalent text representation. Numeric cell
formats (currency, scientific, user-defined ... ) are not considered for
comparisons.</variable></note>
+
+ <h2 id="hd_id111665406111372">Conditions on Numbers only</h2>
+ <table id="tab_id321665406132471">
<tablerow>
<tablecell>
- <paragraph id="par_id651662914713102" role="tablecontent"
xml-lang="en-US" >is greater than or equal to</paragraph>
+ <paragraph id="par_id991665406132471"
role="tablehead">Condition</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id401663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
+ <paragraph id="par_id191665406132471"
role="tablehead">Description</paragraph>
</tablecell>
+ </tablerow>
+ <tablerow>
<tablecell>
- <paragraph id="par_id251662914713103" role="tablecontent"
xml-lang="en-US" >The cell value is greater than or equal to the user defined
value in the text box in the right.</paragraph>
+ <paragraph id="par_id271662914239763" role="tablecontent"
xml-lang="en-US" >is less than</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501662914239764" role="tablecontent"
xml-lang="en-US" >The cell value is strictly less than the user defined value
in the text box in the right.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id831662914760085" role="tablecontent"
xml-lang="en-US" >is not equal to</paragraph>
+ <paragraph id="par_id701662914433053" role="tablecontent"
xml-lang="en-US" >is greater than</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id501663406628969" role="tablecontent"
xml-lang="en-US" localize="false">
- <embedvar href="text/scalc/01/05120100.xhp#numbertext"
markup="ignore"/></paragraph>
+ <paragraph id="par_id461662914433054" role="tablecontent"
xml-lang="en-US" >The cell value is strictly greater than the user defined
value in the text box in the right.</paragraph>
</tablecell>
+ </tablerow>
+ <tablerow>
<tablecell>
- <paragraph id="par_id301662914760087" role="tablecontent"
xml-lang="en-US" >The cell value is not equal (different) to the user defined
value in the text box in the right. Use text inside quotes if you compare text
values.</paragraph>
+ <paragraph id="par_id421662914480517" role="tablecontent"
xml-lang="en-US" >is less than or equal to</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id631662914480518" role="tablecontent"
xml-lang="en-US" >The cell value is less than or equal to the user defined
value in the text box in the right.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id81662914901503" role="tablecontent"
xml-lang="en-US" >is between</paragraph>
+ <paragraph id="par_id651662914713102" role="tablecontent"
xml-lang="en-US" >is greater than or equal to</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id601663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
+ <paragraph id="par_id251662914713103" role="tablecontent"
xml-lang="en-US" >The cell value is greater than or equal to the user defined
value in the text box in the right.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id81662914901503" role="tablecontent"
xml-lang="en-US" >is between</paragraph>
</tablecell>
<tablecell>
<paragraph id="par_id21662914901504" role="tablecontent"
xml-lang="en-US" >The cell value is between the two values defined in the text
boxes on the right - lower and upper values - including the boundary values
themselves.</paragraph>
@@ -120,9 +141,6 @@
<tablecell>
<paragraph id="par_id411662915178872" role="tablecontent"
xml-lang="en-US" >is not between</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id701663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id861662915178873" role="tablecontent"
xml-lang="en-US" >The cell value is not between the two values defined in the
text boxes on the right - lower and upper values - including the boundary
values themselves.</paragraph>
</tablecell>
@@ -131,9 +149,6 @@
<tablecell>
<paragraph id="par_id731662915275926" role="tablecontent"
xml-lang="en-US" >is duplicate</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id801663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id881662915275927" role="tablecontent"
xml-lang="en-US" >The cell and at least one other cell in the range have equal
contents.</paragraph>
</tablecell>
@@ -142,9 +157,6 @@
<tablecell>
<paragraph id="par_id381662915857686" role="tablecontent"
xml-lang="en-US" >is not duplicate</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id901663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id341662915857687" role="tablecontent"
xml-lang="en-US" >The cell contents is unique in the range.</paragraph>
</tablecell>
@@ -153,9 +165,6 @@
<tablecell>
<paragraph id="par_id1001662915996409" role="tablecontent"
xml-lang="en-US" >is in top N elements</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id101663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id571662915996410" role="tablecontent"
xml-lang="en-US" >The cell value is between the maximum value in the range and
the N<sup>th</sup> greater element of the same. Enter the value of N in the
text box on the right.</paragraph>
</tablecell>
@@ -164,9 +173,6 @@
<tablecell>
<paragraph id="par_id341662916338175" role="tablecontent"
xml-lang="en-US" >is in bottom N elements</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id111663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id11662916338177" role="tablecontent"
xml-lang="en-US" >The cell value is between the minimum value in the range and
the N<sup>th</sup> lower element of the same. Enter the value of N in the text
box on the right.</paragraph>
</tablecell>
@@ -175,9 +181,6 @@
<tablecell>
<paragraph id="par_id181662916407095" role="tablecontent"
xml-lang="en-US" >is in top N percent</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id121663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id911662916407097" role="tablecontent"
xml-lang="en-US" >The <emph>cell range index value is in the top N
percent</emph> of the number of cells in the range. For example, in a 20 cells
range and N equals 20, the style is applied to the 4 last cells of the range.
Enter the value of N in the text box on the right.</paragraph>
</tablecell>
@@ -186,9 +189,6 @@
<tablecell>
<paragraph id="par_id421662917285432" role="tablecontent"
xml-lang="en-US" >is in bottom N percent</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id121663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id111662917285433" role="tablecontent"
xml-lang="en-US" >The <emph>cell range index value is in the bottom N
percent</emph> of the number of cells in the range. For example, in a 20 cells
range and N equals 20, the style is applied to the 4 first cells of the range.
Enter the value of N in the text box on the right.</paragraph>
</tablecell>
@@ -197,121 +197,72 @@
<tablecell>
<paragraph id="par_id861662917382735" role="tablecontent"
xml-lang="en-US" >is above average</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id131663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id811662917382736" role="tablecontent"
xml-lang="en-US" >The cell value is strictly greater than the average of the
cell range values.</paragraph>
- <embed
href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+ <paragraph role="paragraph"
id="par_id701665407334603"><variable id="seenotebelow">See note
below.</variable></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id421662919561954" role="tablecontent"
xml-lang="en-US" >is below average</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id141663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id661662919561956" role="tablecontent"
xml-lang="en-US" >The cell value is strictly less than the average of the cell
range values.</paragraph>
- <embed
href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+ <paragraph role="paragraph" id="par_id871665407380004"
localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow"
markup="ignore"/></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id831662919693474" role="tablecontent"
xml-lang="en-US" >is above or equal average</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id151663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id71662919693475" role="tablecontent"
xml-lang="en-US" >The cell value is greater or equal than the average of the
cell range values.</paragraph>
- <embed
href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+ <paragraph role="paragraph" id="par_id871665407380005"
localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow"
markup="ignore"/></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
<paragraph id="par_id521662919771410" role="tablecontent"
xml-lang="en-US" >is below or equal average</paragraph>
</tablecell>
- <tablecell>
- <paragraph id="par_id161663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph>
- </tablecell>
<tablecell>
<paragraph id="par_id131662919771411" role="tablecontent"
xml-lang="en-US" >The cell value is less or equal than the average of the cell
range values.</paragraph>
- <embed
href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id451662919849856" role="tablecontent"
xml-lang="en-US" >is error</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id171663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id911662919849857" role="tablecontent"
xml-lang="en-US" >The cell is in the error condition defined in the text box on
the right. <link href="text/scalc/05/02140000.xhp" name="calc errors">List of
Calc errors</link>.</paragraph>
- <tip id="par_id61662920733334">A cell that references another
cell with an error condition is not in error itself.</tip>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id961662920774180" role="tablecontent"
xml-lang="en-US" >is not error</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id181663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id381662920774181" role="tablecontent"
xml-lang="en-US" >The cell is not in the error condition defined in the text
box on the right. <link href="text/scalc/05/02140000.xhp" name="calc
errors">List of Calc errors</link></paragraph>
+ <paragraph role="paragraph" id="par_id871665407380006"
localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow"
markup="ignore"/></paragraph>
+
</tablecell>
</tablerow>
+ </table>
+ <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
+
+ <h2 id="hd_id301665406258582">Conditions on Errors in Cells.</h2>
+ <table id="tab_id1001665406273943">
<tablerow>
<tablecell>
- <paragraph id="par_id151662920861587" role="tablecontent"
xml-lang="en-US" >begins with</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id191663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
+ <paragraph id="par_id451665406273943"
role="tablehead">Condition</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id341662920861588" role="tablecontent"
xml-lang="en-US" >The cell contents begins with the text or number defined in
the text box on the right.</paragraph>
- <note id="par_id801662922586796"><variable
id="text_comparison">The condition applies to the internal text conversion of
the cell contents. Numeric values are compared with their equivalent text
representation. Numeric cell formats (currency, scientific, user-defined ... )
are not considered for comparisons.</variable></note>
+ <paragraph id="par_id71665406273943"
role="tablehead">Description</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id361662922600585" role="tablecontent"
xml-lang="en-US" >ends with</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id201663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id801662922600586" role="tablecontent"
xml-lang="en-US" >The cell contents ends with the text or number defined in the
right text box.</paragraph>
- <note localize="false" id="par_id221662923585290"><embedvar
href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note>
- </tablecell>
- </tablerow>
- <tablerow>
- <tablecell>
- <paragraph id="par_id151662922939292" role="tablecontent"
xml-lang="en-US" >contains</paragraph>
+ <paragraph id="par_id451662919849856" role="tablecontent"
xml-lang="en-US" >is error</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id211663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id251662922939293" role="tablecontent"
xml-lang="en-US" >The cell contents contains the text or number defined in the
right text box.</paragraph>
- <note localize="false" id="par_id221662923585291"><embedvar
href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note>
+ <paragraph id="par_id911662919849857" role="tablecontent"
xml-lang="en-US" >The cell is in the error condition defined in the text box on
the right. See <link href="text/scalc/05/02140000.xhp" name="calc errors">List
of Calc errors</link>.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id291662923021542" role="tablecontent"
xml-lang="en-US" >does not contain</paragraph>
- </tablecell>
- <tablecell>
- <paragraph id="par_id221663406628969" role="tablecontent"
localize="false" xml-lang="en-US" ><embedvar
href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph>
+ <paragraph id="par_id961662920774180" role="tablecontent"
xml-lang="en-US" >is not error</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id541662923021543" role="tablecontent"
xml-lang="en-US" >The cell contents does not contains the text or number
defined in the text box on the right.</paragraph>
- <note localize="false" id="par_id221662923585292"><embedvar
href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note>
+ <paragraph id="par_id381662920774181" role="tablecontent"
xml-lang="en-US" >The cell is not in the error condition defined in the text
box on the right. See <link href="text/scalc/05/02140000.xhp" name="calc
errors">List of Calc errors</link></paragraph>
</tablecell>
</tablerow>
</table>
+ <tip id="par_id61662920733334">A cell that references another cell with an
error condition is not in error itself.</tip>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id471665407993996"><embedvar
href="text/scalc/01/05120000.xhp#ConditionalFormattingh1"
markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/05120200.xhp
b/source/text/scalc/01/05120200.xhp
index 0ca166372..ebb624f72 100644
--- a/source/text/scalc/01/05120200.xhp
+++ b/source/text/scalc/01/05120200.xhp
@@ -11,16 +11,19 @@
<meta>
<topic id="pageconditionalformattingformulais" indexer="include"
status="PUBLISH">
- <title id="tit" xml-lang="en-US">Conditional Formatting - Formula
is</title>
- <filename>/text/scalc/01/05120200.xhp</filename>
- </topic>
-</meta>
-<body>
-<section id="formulais">
- <h1 id="hd_id471662936567369"><variable id="h1"><link
href="text/scalc/01/05120200.xhp" name="Formula is">Condition - Formula
is</link></variable></h1>
- <paragraph xml-lang="en-US" id="par_id31494139" role="paragraph">Applies
the selected style to the cell when the formula expression in the text box in
the right is <emph>not</emph> zero.</paragraph>
-</section>
+ <title id="tit" xml-lang="en-US">Conditional Formatting - Formula
is</title>
+ <filename>/text/scalc/01/05120200.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="formulais">
+ <h1 id="hd_id471662936567369"><variable id="h1"><link
href="text/scalc/01/05120200.xhp" name="Formula is">Condition - Formula
is</link></variable></h1>
+ <paragraph xml-lang="en-US" id="par_id31494139"
role="paragraph">Applies the selected style to the cell when the formula
expression in the text box in the right is <emph>not</emph> zero.</paragraph>
+ </section>
<paragraph role="paragraph" id="par_id1001662932287796">The formula is
expressed similar to a test condition evaluating to <literal>TRUE</literal> or
<literal>FALSE</literal>.</paragraph>
<paragraph role="paragraph" id="par_id111662936728630">For example, if C29
has a conditional formatting which formula is
<input>B1>=(DATE(2015;5;4)+TIME(18;0;0))</input> - a logical expression that
evaluates true or false - the style applied to C29 depends on B1
contents.</paragraph>
-</body>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id471665407993996"><embedvar
href="text/scalc/01/05120000.xhp#ConditionalFormattingh1"
markup="ignore"/></paragraph>
+ </section>
+ </body>
</helpdocument>
diff --git a/source/text/scalc/01/05120300.xhp
b/source/text/scalc/01/05120300.xhp
index 3ed829c79..0f00cefb5 100644
--- a/source/text/scalc/01/05120300.xhp
+++ b/source/text/scalc/01/05120300.xhp
@@ -47,5 +47,8 @@
<paragraph id="par_id461662934605639" role="listitem"><emph>This
year, Last year and Next year</emph>: applies the cell style if the cell date
contents is in this year, last year and next year respectively.</paragraph>
</listitem>
</list>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id471665407993996"><embedvar
href="text/scalc/01/05120000.xhp#ConditionalFormattingh1"
markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/05120400.xhp
b/source/text/scalc/01/05120400.xhp
index c5e90c644..9fc6ceabf 100644
--- a/source/text/scalc/01/05120400.xhp
+++ b/source/text/scalc/01/05120400.xhp
@@ -236,6 +236,7 @@
<embed href="text/scalc/01/05120400.xhp#commonconditions"/>
<embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id471665407993996"><embedvar
href="text/scalc/01/05120000.xhp#ConditionalFormattingh1"
markup="ignore"/></paragraph>
<paragraph xml-lang="en-US" id="par_id3155606" role="paragraph"><link
href="https://wiki.documentfoundation.org/Faq/Calc/141";>How to use Icon Set
Conditional Formatting page</link> in TDF Wiki.</paragraph>
<paragraph role="paragraph" id="par_id651663598549283"><link
href="https://wiki.documentfoundation.org/Faq/Calc/142";>How to apply a Color
Scale Conditional Formatting page</link> in TDF Wiki.</paragraph>
</section>
diff --git a/source/text/scalc/01/05120500.xhp
b/source/text/scalc/01/05120500.xhp
index 6706c1c2f..8f74e1418 100644
--- a/source/text/scalc/01/05120500.xhp
+++ b/source/text/scalc/01/05120500.xhp
@@ -31,6 +31,8 @@
<paragraph xml-lang="en-US" id="par_id3155909" role="paragraph">The
<emph>Conditional Formats</emph> list displays the active conditional
formatting rules set in the current spreadsheet. Only the first rule for each
cell range is listed, even if there are multiple rules defined for a given
range.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155908" role="paragraph">If you
have defined a conditional formatting on a cell range and you try now to define
a new conditional formatting on a part of this range, a warning message will be
displayed, asking if you want to edit the existing conditional formatting (on
the whole range) or define a new conditional formatting overlapping it (on the
selected range).</paragraph>
-
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id471665407993996"><embedvar
href="text/scalc/01/05120000.xhp#ConditionalFormattingh1"
markup="ignore"/></paragraph>
+ </section>
</body>
</helpdocument>
