source/text/scalc/00/00000405.xhp | 32 ++++--
source/text/scalc/01/05120100.xhp | 112 +++++++++++----------
source/text/scalc/01/05120300.xhp | 1
source/text/scalc/01/05120400.xhp | 200 +++++++++++++++++++-------------------
source/text/scalc/01/05120500.xhp | 17 +--
source/text/scalc/main0105.xhp | 4
6 files changed, 197 insertions(+), 169 deletions(-)
New commits:
commit 4d8a15e36d381a5d839b878f2058bfba15b3442c
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Nov 22 17:24:11 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Nov 27 21:03:09 2023 +0100
tdf#155876 UI cmds Calc-Format menu (22)
+ Conditional formatting
+ refactoring
Change-Id: I4fcca025ec2d4091f5a7afacf1adcc41e10826b0
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160005
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000405.xhp
b/source/text/scalc/00/00000405.xhp
index 9b9d33525f..197c0f8984 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -207,9 +207,9 @@
</table>
</section>
<section id="editprintrange">
-<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id3153307"><variable id="fodbbe">Choose
<emph>Format - Print Ranges - Edit</emph>.</variable></paragraph>
- <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
<paragraph role="paragraph" id="par_id161700525483226">Choose
<menuitem>Layout - Edit</menuitem> tab.</paragraph>
<paragraph role="paragraph" id="par_id381700525487691">On the
<menuitem>Layout</menuitem> menu of the <menuitem>Layout</menuitem> tab, choose
<menuitem>Print Ranges - Edit</menuitem>.</paragraph>
<embed href="text/shared/00/00000004.xhp#from_toolbars"/>
@@ -225,8 +225,11 @@
</table>
</section>
<section id="s_conditionalcondition">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id3154618"><variable
id="bedingte">Choose <menuitem>Format - Conditional -
Condition</menuitem>.</variable></paragraph>
- <paragraph role="paragraph" id="par_id141663543112100">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id741700682477729">Choose <menuitem>Home
- Conditional - Condition</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
<table id="tab_id771663540244129">
<tablerow>
<tablecell>
@@ -242,8 +245,11 @@
</section>
<section id="s_conditionalcolorscale">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id31663542115011"><variable
id="conditionalcolorscale">Choose <menuitem>Format - Conditional - Color
Scale</menuitem></variable></paragraph>
- <paragraph role="paragraph" id="par_id211663543104186">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id201700683098791">Choose <menuitem>Home
- Conditional - Color Scale</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
<table id="tab_id281663540719712">
<tablerow>
<tablecell>
@@ -259,8 +265,11 @@
</section>
<section id="s_conditionaldatabar">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id491663542108169"><variable
id="conditionaldatabar">Choose <menuitem>Format - Conditional - Data
Bar</menuitem></variable></paragraph>
- <paragraph role="paragraph" id="par_id81663543094977">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id631700683863203">Choose <menuitem>Home
- Conditional - Data Bar</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
<table id="tab_id441663541161942">
<tablerow>
<tablecell>
@@ -276,8 +285,11 @@
</section>
<section id="s_conditionaliconset">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id851663542093712"><variable
id="conditionaliconset">Choose <menuitem>Format - Conditional - Icon
Set</menuitem></variable></paragraph>
- <paragraph role="paragraph" id="par_id501663543087343">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id951700683459372">Choose <menuitem>Home
- Conditional - Icon Set</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
<table id="tab_id621663541228727">
<tablerow>
<tablecell>
@@ -293,8 +305,11 @@
</section>
<section id="s_conditionaldate">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id391663542070705"><variable
id="conditionaldate">Choose <menuitem>Format - Conditional -
Date</menuitem></variable></paragraph>
- <paragraph role="paragraph" id="par_id351663543077670">On the
<emph>Formatting</emph> bar, click</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id291700683578336">Choose <menuitem>Home
- Conditional - Date</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
<table id="tab_id951663541317146">
<tablerow>
<tablecell>
@@ -310,7 +325,10 @@
</section>
<section id="s_conditionalmanage">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id641663542045446"><variable
id="conditionalmanage">Choose <menuitem>Format - Conditional -
Manage</menuitem></variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id801700683657730">Choose <menuitem>Home
- Conditional - Manage</menuitem>.</paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/05120100.xhp
b/source/text/scalc/01/05120100.xhp
index bd604b64b7..e76527b9d3 100644
--- a/source/text/scalc/01/05120100.xhp
+++ b/source/text/scalc/01/05120100.xhp
@@ -11,14 +11,20 @@
<meta>
<topic id="conditionalformattingcellis" indexer="include"
status="PUBLISH">
- <title id="tit" xml-lang="en-US">Conditional Formatting - Cell
value is</title>
+ <title id="tit">Conditional Formatting - Cell value is</title>
<filename>/text/scalc/01/05120100.xhp</filename>
</topic>
</meta>
<body>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalentry/typeis" id="bm_id941662938267119"
localize="false"/>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalentry/val1" id="bm_id811662938541882"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/conditionalentry/typeis"
id="bm_id941662938267119" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/conditionalentry/val1"
id="bm_id811662938541882" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=2"
id="bm_id971700678703173" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=1"
id="bm_id41700678927606" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=0"
id="bm_id201700678931809" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=6"
id="bm_id341700678935943" localize="false"/>
+<bookmark branch="hid/.uno:ConditionalFormatEasy?FormatRule:short=23"
id="bm_id171700678939833" localize="false"/>
+
<section id="cellvalueis">
<h1 id="hd_id431662935550205"><variable id="h1"><link
href="text/scalc/01/05120100.xhp">Condition - Cell value
is</link></variable></h1>
<paragraph role="paragraph" id="par_id11662915615351">Applies a cell
style on the cell or cell range controlled by the condition set in the drop
down list. The formatting is applied to each cell individually and the
condition may depend on other cells values of the selected range.</paragraph>
@@ -30,58 +36,58 @@
<table id="tab_id211662913907277">
<tablerow>
<tablecell>
- <paragraph id="par_id181662913907279" role="tablehead"
xml-lang="en-US">Condition</paragraph>
+ <paragraph id="par_id181662913907279"
role="tablehead">Condition</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id941662913907280" role="tablehead"
xml-lang="en-US">Description</paragraph>
+ <paragraph id="par_id941662913907280"
role="tablehead">Description</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id31662913907282" role="tablecontent"
xml-lang="en-US">is equal to</paragraph>
+ <paragraph id="par_id31662913907282" role="tablecontent">is
equal to</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>
+ <paragraph id="par_id881662913907284" role="tablecontent">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_id831662914760085" role="tablecontent"
xml-lang="en-US" >is not equal to</paragraph>
+ <paragraph id="par_id831662914760085" role="tablecontent">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>
+ <paragraph id="par_id301662914760087" role="tablecontent">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_id151662920861587" role="tablecontent"
xml-lang="en-US" >begins with</paragraph>
+ <paragraph id="par_id151662920861587"
role="tablecontent">begins with</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>
+ <paragraph id="par_id341662920861588" role="tablecontent">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_id361662922600585" role="tablecontent"
xml-lang="en-US" >ends with</paragraph>
+ <paragraph id="par_id361662922600585" role="tablecontent">ends
with</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>
+ <paragraph id="par_id801662922600586" role="tablecontent">The
cell contents ends with the text or number defined in the right text
box.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id151662922939292" role="tablecontent"
xml-lang="en-US" >contains</paragraph>
+ <paragraph id="par_id151662922939292"
role="tablecontent">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>
+ <paragraph id="par_id251662922939293" role="tablecontent">The
cell contents contains the text or number defined in the right text
box.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id291662923021542" role="tablecontent"
xml-lang="en-US" >does not contain</paragraph>
+ <paragraph id="par_id291662923021542" role="tablecontent">does
not contain</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id541662923021543" role="tablecontent"
xml-lang="en-US" >The cell content does not contain the text or number defined
in the text box on the right.</paragraph>
+ <paragraph id="par_id541662923021543" role="tablecontent">The
cell content does not contain the text or number defined in the text box on the
right.</paragraph>
</tablecell>
</tablerow>
</table>
@@ -99,133 +105,133 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id271662914239763" role="tablecontent"
xml-lang="en-US" >is less than</paragraph>
+ <paragraph id="par_id271662914239763" role="tablecontent">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>
+ <paragraph id="par_id501662914239764" role="tablecontent">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_id701662914433053" role="tablecontent"
xml-lang="en-US" >is greater than</paragraph>
+ <paragraph id="par_id701662914433053" role="tablecontent">is
greater than</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_id461662914433054" role="tablecontent">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_id421662914480517" role="tablecontent"
xml-lang="en-US" >is less than or equal to</paragraph>
+ <paragraph id="par_id421662914480517" role="tablecontent">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>
+ <paragraph id="par_id631662914480518" role="tablecontent">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_id651662914713102" role="tablecontent"
xml-lang="en-US" >is greater than or equal to</paragraph>
+ <paragraph id="par_id651662914713102" role="tablecontent">is
greater than or equal to</paragraph>
</tablecell>
<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_id251662914713103" role="tablecontent">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>
+ <paragraph id="par_id81662914901503" role="tablecontent">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>
+ <paragraph id="par_id21662914901504" role="tablecontent">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>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id411662915178872" role="tablecontent"
xml-lang="en-US" >is not between</paragraph>
+ <paragraph id="par_id411662915178872" role="tablecontent">is
not between</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>
+ <paragraph id="par_id861662915178873" role="tablecontent">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>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id731662915275926" role="tablecontent"
xml-lang="en-US" >is duplicate</paragraph>
+ <paragraph id="par_id731662915275926" role="tablecontent">is
duplicate</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>
+ <paragraph id="par_id881662915275927" role="tablecontent">The
cell and at least one other cell in the range have equal contents.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id381662915857686" role="tablecontent"
xml-lang="en-US" >is not duplicate</paragraph>
+ <paragraph id="par_id381662915857686" role="tablecontent">is
not duplicate</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id341662915857687" role="tablecontent"
xml-lang="en-US" >The cell contents is unique in the range.</paragraph>
+ <paragraph id="par_id341662915857687" role="tablecontent">The
cell contents is unique in the range.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1001662915996409" role="tablecontent"
xml-lang="en-US" >is in top N elements</paragraph>
+ <paragraph id="par_id1001662915996409" role="tablecontent">is
in top N elements</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>
+ <paragraph id="par_id571662915996410" role="tablecontent">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>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id341662916338175" role="tablecontent"
xml-lang="en-US" >is in bottom N elements</paragraph>
+ <paragraph id="par_id341662916338175" role="tablecontent">is
in bottom N elements</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>
+ <paragraph id="par_id11662916338177" role="tablecontent">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>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id181662916407095" role="tablecontent"
xml-lang="en-US" >is in top N percent</paragraph>
+ <paragraph id="par_id181662916407095" role="tablecontent">is
in top N percent</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>
+ <paragraph id="par_id911662916407097" role="tablecontent">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>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id421662917285432" role="tablecontent"
xml-lang="en-US" >is in bottom N percent</paragraph>
+ <paragraph id="par_id421662917285432" role="tablecontent">is
in bottom N percent</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>
+ <paragraph id="par_id111662917285433" role="tablecontent">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>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id861662917382735" role="tablecontent"
xml-lang="en-US" >is above average</paragraph>
+ <paragraph id="par_id861662917382735" role="tablecontent">is
above average</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>
+ <paragraph id="par_id811662917382736" role="tablecontent">The
cell value is strictly greater than the average of the cell range
values.</paragraph>
<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>
+ <paragraph id="par_id421662919561954" role="tablecontent">is
below average</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>
+ <paragraph id="par_id661662919561956" role="tablecontent">The
cell value is strictly less than the average of the cell range
values.</paragraph>
<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>
+ <paragraph id="par_id831662919693474" role="tablecontent">is
above or equal average</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>
+ <paragraph id="par_id71662919693475" role="tablecontent">The
cell value is greater or equal than the average of the cell range
values.</paragraph>
<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>
+ <paragraph id="par_id521662919771410" role="tablecontent">is
below or equal average</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>
+ <paragraph id="par_id131662919771411" role="tablecontent">The
cell value is less or equal than the average of the cell range
values.</paragraph>
<paragraph role="paragraph" id="par_id871665407380006"
localize="false"><embedvar href="text/scalc/01/05120100.xhp#seenotebelow"
markup="ignore"/></paragraph>
</tablecell>
@@ -245,18 +251,18 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id451662919849856" role="tablecontent"
xml-lang="en-US" >is error</paragraph>
+ <paragraph id="par_id451662919849856" role="tablecontent">is
error</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. See <link href="text/scalc/05/02140000.xhp">List of Calc
errors</link>.</paragraph>
+ <paragraph id="par_id911662919849857" role="tablecontent">The
cell is in the error condition defined in the text box on the right. See <link
href="text/scalc/05/02140000.xhp">List of Calc errors</link>.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id961662920774180" role="tablecontent"
xml-lang="en-US" >is not error</paragraph>
+ <paragraph id="par_id961662920774180" role="tablecontent">is
not error</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. See <link href="text/scalc/05/02140000.xhp">List of Calc
errors</link></paragraph>
+ <paragraph id="par_id381662920774181" role="tablecontent">The
cell is not in the error condition defined in the text box on the right. See
<link href="text/scalc/05/02140000.xhp">List of Calc errors</link></paragraph>
</tablecell>
</tablerow>
</table>
diff --git a/source/text/scalc/01/05120300.xhp
b/source/text/scalc/01/05120300.xhp
index b51d3f15a0..41b9346c8b 100644
--- a/source/text/scalc/01/05120300.xhp
+++ b/source/text/scalc/01/05120300.xhp
@@ -16,6 +16,7 @@
</topic>
</meta>
<body>
+ <bookmark branch="hid/.uno:CondDateFormatDialog" id="bm_id811700684279931"
localize="false"/>
<section id="dateis">
<h1 id="hd_id321662936831682"><variable id="h1"><link
href="text/scalc/01/05120300.xhp">Condition - Date is</link></variable></h1>
<paragraph role="paragraph" id="par_id31662934883939">Applies the
selected style to the cell when the cell contents is formatted as date and the
condition is one of the available date interval in the dropdown
list.</paragraph>
diff --git a/source/text/scalc/01/05120400.xhp
b/source/text/scalc/01/05120400.xhp
index 660b3d46c5..9e6cddf417 100644
--- a/source/text/scalc/01/05120400.xhp
+++ b/source/text/scalc/01/05120400.xhp
@@ -11,19 +11,19 @@
<meta>
<topic id="conditionalformattingallcells" indexer="include"
status="PUBLISH">
- <title id="tit" xml-lang="en-US">Conditional Formatting - All
cells</title>
+ <title id="tit">Conditional Formatting - All cells</title>
<filename>/text/scalc/01/05120400.xhp</filename>
</topic>
</meta>
<body>
-
+ <bookmark branch="hid/.uno:ColorScaleFormatDialog"
id="bm_id631700682986631" localize="false"/>
<section id="allcells">
<h1 id="hd_id861662937013389"><variable id="h1"><link
href="text/scalc/01/05120400.xhp">Condition - All cells</link></variable></h1>
<paragraph role="paragraph" id="par_id31662915586650">Applies the
conditional formatting to the set of cells defined in the selected range. The
formatting is applied based on the contents of the whole range.</paragraph>
</section>
<section id="colorscale">
<h2 id="hd_id3147394"><link
href="text/scalc/01/05120400.xhp#colorscale">Color Scale</link></h2>
- <paragraph xml-lang="en-US" id="par_id3155602"
role="paragraph">Applies a color scale to a range consisting of displaying a
bicolor or tricolor gradient on this range depending on the value of each
cell.</paragraph>
+ <paragraph id="par_id3155602" role="paragraph">Applies a color scale
to a range consisting of displaying a bicolor or tricolor gradient on this
range depending on the value of each cell.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#s_conditionalcolorscale"/>
@@ -33,26 +33,27 @@
<paragraph role="paragraph" id="par_id231663598294535">The calculation of
the color scale depends on 2 or 3 conditions, defined as follows:</paragraph>
<list type="unordered">
<listitem>
- <paragraph id="par_id701864449697771" role="listitem"><emph>Min
(Max)</emph>: calculates using the minimum (maximum) values in the
range.</paragraph>
+ <paragraph id="par_id701864449697771" role="listitem"><emph>Min
(Max)</emph>: calculates using the minimum (maximum) values in the
range.</paragraph>
</listitem>
</list>
<section id="commonconditions">
<list type="unordered">
<listitem>
- <paragraph id="par_id321663440728295"
role="listitem"><emph>Value</emph>: a fixed value. Enter the value in the text
box.</paragraph>
+ <paragraph id="par_id321663440728295"
role="listitem"><emph>Value</emph>: a fixed value. Enter the value in the text
box.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id611663440697270"
role="listitem"><emph>Percentile</emph>: A percentile is each of the 99 values
which divide the sorted data in 100 equal parts, so that each part represents
1/100 of the sample population. A percentile return the value for a data series
going from the smallest to the largest value in a set of data. For P = 25, the
percentile means the first quartile. P = 50 is also the MEDIAN of the data set.
Enter the percentile value in the text box. Valid values are from 0 to
100.</paragraph>
+ <paragraph id="par_id611663440697270"
role="listitem"><emph>Percentile</emph>: A percentile is each of the 99 values
which divide the sorted data in 100 equal parts, so that each part represents
1/100 of the sample population. A percentile return the value for a data series
going from the smallest to the largest value in a set of data. For P = 25, the
percentile means the first quartile. P = 50 is also the MEDIAN of the data set.
Enter the percentile value in the text box. Valid values are from 0 to
100.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id211663440834104"
role="listitem"><emph>Percent</emph>: a fixed value representing the percentage
of the minimum (maximum) of the length defined by minimum and maximum values in
the range. A minimum of 10% selects the values below 10% of the segment
[Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max].
Valid values are from 0 (zero) to 100. Do not enter a percent (%)
sign.</paragraph>
+ <paragraph id="par_id211663440834104"
role="listitem"><emph>Percent</emph>: a fixed value representing the percentage
of the minimum (maximum) of the length defined by minimum and maximum values in
the range. A minimum of 10% selects the values below 10% of the segment
[Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max].
Valid values are from 0 (zero) to 100. Do not enter a percent (%)
sign.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id961663440848168"
role="listitem"><emph>Formula</emph>: A formula expression starting with the
equal sign (=) that calculates a numeric value. Values can be numbers, dates or
time. Enter the formula expression in the text box.</paragraph>
+ <paragraph id="par_id961663440848168"
role="listitem"><emph>Formula</emph>: A formula expression starting with the
equal sign (=) that calculates a numeric value. Values can be numbers, dates or
time. Enter the formula expression in the text box.</paragraph>
</listitem>
</list>
</section>
<embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
+ <bookmark branch="hid/.uno:DataBarFormatDialog" id="bm_id631700683284747"
localize="false"/>
<section id="databar">
<h2 id="par_id991609782427459"><link
href="text/scalc/01/05120400.xhp#databar">Data Bar</link></h2>
<paragraph role="paragraph" id="par_id41609780964157">Data bar option
fills the cell with solid or gradient color corresponding to the numeric value
in the cell.</paragraph>
@@ -64,10 +65,10 @@
<paragraph role="paragraph" id="par_id931609781970981">The calculation of
the bar area fill is based on the conditions below:</paragraph>
<list type="unordered">
<listitem>
- <paragraph id="par_id281663449673792"
role="listitem"><emph>Automatic</emph>: calculates using the minimum and
maximum values in the range.</paragraph>
+ <paragraph id="par_id281663449673792"
role="listitem"><emph>Automatic</emph>: calculates using the minimum and
maximum values in the range.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id701663449697771" role="listitem"><emph>Min
(Max)</emph>: calculates using the minimum (maximum) values in the
range.</paragraph>
+ <paragraph id="par_id701663449697771" role="listitem"><emph>Min
(Max)</emph>: calculates using the minimum (maximum) values in the
range.</paragraph>
</listitem>
</list>
<embed href="text/scalc/01/05120400.xhp#commonconditions"/>
@@ -80,10 +81,10 @@
<h4 id="hd_id891663453607961">Fill</h4>
<list type="unordered">
<listitem>
- <paragraph id="par_id671663453639829"
role="listitem"><emph>Gradient</emph>: set a color scale between the color of
positive (negative) values and white.</paragraph>
+ <paragraph id="par_id671663453639829"
role="listitem"><emph>Gradient</emph>: set a color scale between the color of
positive (negative) values and white.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id551663453647462"
role="listitem"><emph>Color</emph>: use the positive (negative) color for the
entire data bar, no fade out gradient.</paragraph>
+ <paragraph id="par_id551663453647462"
role="listitem"><emph>Color</emph>: use the positive (negative) color for the
entire data bar, no fade out gradient.</paragraph>
</listitem>
</list>
<h4 id="hd_id701663453750779">Axis</h4>
@@ -91,13 +92,13 @@
<list type="unordered">
<listitem>
- <paragraph id="par_id381663453792294"
role="listitem"><emph>Automatic:</emph> position the vertical axis in the
middle of the maximum and minimum values.</paragraph>
+ <paragraph id="par_id381663453792294"
role="listitem"><emph>Automatic:</emph> position the vertical axis in the
middle of the maximum and minimum values.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id791663453800602"
role="listitem"><emph>Middle:</emph> set the vertical axis in the middle of the
column.</paragraph>
+ <paragraph id="par_id791663453800602"
role="listitem"><emph>Middle:</emph> set the vertical axis in the middle of the
column.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id461663453808288"
role="listitem"><emph>None:</emph> do not display a vertical axis.</paragraph>
+ <paragraph id="par_id461663453808288"
role="listitem"><emph>None:</emph> do not display a vertical axis.</paragraph>
</listitem>
</list>
<h4 id="hd_id511663453851599">Bar Lengths</h4>
@@ -105,9 +106,10 @@
<h4 id="hd_id211663453914830">Display bars only</h4>
<paragraph role="paragraph" id="par_id561663453936590">Do not display
values in the cell, only the data bars.</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#conditionalformatting"/>
+ <bookmark branch="hid/.uno:IconSetFormatDialog" id="bm_id61700683386598"
localize="false"/>
<section id="iconset">
<h2 id="hd_id3153709"><link
href="text/scalc/01/05120400.xhp#iconset">Icon Set</link></h2>
- <paragraph xml-lang="en-US" id="par_id3153764" role="paragraph">Add an
icon to the cell based on the value relative to the specified thresholds.
Several icon sets are available.</paragraph>
+ <paragraph id="par_id3153764" role="paragraph">Add an icon to the cell
based on the value relative to the specified thresholds. Several icon sets are
available.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#s_conditionaliconset"/>
@@ -115,129 +117,129 @@
<h3 id="hd_id191663440362309">Available Icon Sets</h3>
<list type="unordered">
<listitem>
- <paragraph xml-lang="en-US" id="par_id31494140" role="listitem">3,
4 or 5 - arrows</paragraph>
- <paragraph role="paragraph" id="par_id91663429174806"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-colorarrows-up.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id81663429174808">Color arrow up</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-up.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id81663529174808">Color arrow slightly up</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-colorarrows-same.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id81663529174808">Color arrow same</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id81663729174808">Color arrow slightly down</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-colorarrows-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id81663329174808">Color arrow down</alt></image>
+ <paragraph id="par_id31494140" role="listitem">3, 4 or 5 -
arrows</paragraph>
+ <paragraph role="paragraph" id="par_id91663429174806">
+ <image
src="media/icon-themes/sc/res/icon-set-colorarrows-up.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id81663429174808">Color arrow up</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-up.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id81663529174808">Color arrow slightly up</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-colorarrows-same.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id81663529174808">Color arrow same</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-colorarrows-slightly-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id81663729174808">Color arrow slightly down</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-colorarrows-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id81663329174808">Color arrow down</alt></image>
</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id31494141" role="listitem">3,
4 or 5 - gray arrows</paragraph>
- <paragraph role="paragraph" id="par_id91661429174806"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-grayarrows-up.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Gray arrow up</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-up.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Gray arrow slightly up</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-grayarrows-same.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Gray arrow same</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663729174808">Gray arrow slightly down</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-grayarrows-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663329174808">Gray arrow down</alt></image>
+ <paragraph id="par_id31494141" role="listitem">3, 4 or 5 - gray
arrows</paragraph>
+ <paragraph role="paragraph" id="par_id91661429174806">
+ <image
src="media/icon-themes/sc/res/icon-set-grayarrows-up.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Gray arrow up</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-up.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Gray arrow slightly up</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-grayarrows-same.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Gray arrow same</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-grayarrows-slightly-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663729174808">Gray arrow slightly down</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-grayarrows-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663329174808">Gray arrow down</alt></image>
</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id31494142" role="listitem">3
- flags</paragraph>
- <paragraph role="paragraph" id="par_id101663433624185"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-flags-yellow.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Yellow flag</alt></image>
- <image src="media/icon-themes/sc/res/icon-set-flags-red.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Red flag</alt></image>
- <image src="media/icon-themes/sc/res/icon-set-flags-green.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Green flag</alt></image>
+ <paragraph id="par_id31494142" role="listitem">3 -
flags</paragraph>
+ <paragraph role="paragraph" id="par_id101663433624185">
+ <image
src="media/icon-themes/sc/res/icon-set-flags-yellow.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Yellow flag</alt></image>
+ <image src="media/icon-themes/sc/res/icon-set-flags-red.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Red flag</alt></image>
+ <image src="media/icon-themes/sc/res/icon-set-flags-green.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Green flag</alt></image>
</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id31494143" role="listitem">3
- traffic lights 1 and 2 (two different designs)</paragraph>
- <paragraph role="paragraph" id="par_id721663433917655"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-circles1-yellow.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Yellow traffic light 1</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-circles1-red.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Red traffic light 1</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-circles1-green.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Green traffic light 1</alt></image>
+ <paragraph id="par_id31494143" role="listitem">3 - traffic lights
1 and 2 (two different designs)</paragraph>
+ <paragraph role="paragraph" id="par_id721663433917655">
+ <image
src="media/icon-themes/sc/res/icon-set-circles1-yellow.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Yellow traffic light 1</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-circles1-red.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Red traffic light 1</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-circles1-green.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Green traffic light 1</alt></image>
</paragraph>
- <paragraph role="paragraph" id="par_id501663433925207"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-trafficlights-yellow.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Yellow traffic light 2</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-trafficlights-red.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Red traffic light 2</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-trafficlights-green.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Green traffic light 2</alt></image>
+ <paragraph role="paragraph" id="par_id501663433925207">
+ <image
src="media/icon-themes/sc/res/icon-set-trafficlights-yellow.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Yellow traffic light 2</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-trafficlights-red.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Red traffic light 2</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-trafficlights-green.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Green traffic light 2</alt></image>
</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id701663438522480" role="listitem">3 - Smileys
1 and 2</paragraph>
+ <paragraph id="par_id701663438522480" role="listitem">3 - Smileys
1 and 2</paragraph>
<paragraph role="paragraph" id="par_id991663438568052">
- <image
src="media/icon-themes/sc/res/icon-set-positive-yellow-smilie.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Yellow positive smiley</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Yellow neutral smiley</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-negative-yellow-smilie.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Yellow negative smiley</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-positive-yellow-smilie.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Yellow positive smiley</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Yellow neutral smiley</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-negative-yellow-smilie.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Yellow negative smiley</alt></image>
</paragraph>
- <paragraph role="paragraph" id="par_id991663438966721"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-positive-green-smilie.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Green positive smiley</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Yellow neutral smiley</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-negative-red-smilie.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Red negative smiley</alt></image>
+ <paragraph role="paragraph" id="par_id991663438966721">
+ <image
src="media/icon-themes/sc/res/icon-set-positive-green-smilie.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Green positive smiley</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Yellow neutral smiley</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-negative-red-smilie.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Red negative smiley</alt></image>
</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id31494144" role="listitem">3
- symbols </paragraph>
- <paragraph role="paragraph" id="par_id421663434453517"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-shapes-triangle.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Shape triangle</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-shapes-diamond.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Shape diamond</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-shapes-circle.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Shape circle</alt></image>
+ <paragraph id="par_id31494144" role="listitem">3 - symbols
</paragraph>
+ <paragraph role="paragraph" id="par_id421663434453517">
+ <image
src="media/icon-themes/sc/res/icon-set-shapes-triangle.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Shape triangle</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-shapes-diamond.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Shape diamond</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-shapes-circle.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Shape circle</alt></image>
</paragraph>
- <paragraph role="paragraph" id="par_id961663439450424"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-symbols1-exclamation-mark.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Exclamation mark</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-symbols1-cross.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Cross</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-symbols1-check.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Check mark</alt></image>
+ <paragraph role="paragraph" id="par_id961663439450424">
+ <image
src="media/icon-themes/sc/res/icon-set-symbols1-exclamation-mark.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Exclamation mark</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-symbols1-cross.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Cross</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-symbols1-check.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Check mark</alt></image>
</paragraph>
- <paragraph role="paragraph" id="par_id1001663439805133"
xml-lang="en-US">
- <image src="media/icon-themes/sc/res/icon-set-stars-empty.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Empty star</alt></image>
- <image src="media/icon-themes/sc/res/icon-set-stars-half.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Half star</alt></image>
- <image src="media/icon-themes/sc/res/icon-set-stars-full.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Full star</alt></image>
+ <paragraph role="paragraph" id="par_id1001663439805133">
+ <image src="media/icon-themes/sc/res/icon-set-stars-empty.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Empty star</alt></image>
+ <image src="media/icon-themes/sc/res/icon-set-stars-half.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Half star</alt></image>
+ <image src="media/icon-themes/sc/res/icon-set-stars-full.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Full star</alt></image>
</paragraph>
- <paragraph role="paragraph" id="par_id171663440020964"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-triangles-up.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Triangle up</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-triangles-same.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Same</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-triangles-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663529174808">Triangle down</alt></image>
+ <paragraph role="paragraph" id="par_id171663440020964">
+ <image
src="media/icon-themes/sc/res/icon-set-triangles-up.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Triangle up</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-triangles-same.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Same</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-triangles-down.svg"
id="img_id261663429176807" width="1cm" height="1cm"><alt
id="alt_id91663529174808">Triangle down</alt></image>
</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id31494145" role="listitem">4
- circles from red to black</paragraph>
- <paragraph role="paragraph" id="par_id481663434995022"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-circles2-dark-red.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Dark red</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-circles2-light-red.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Light red</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-circles2-light-gray.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Light gray</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-circles2-dark-gray.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Dark gray</alt></image>
+ <paragraph id="par_id31494145" role="listitem">4 - circles from
red to black</paragraph>
+ <paragraph role="paragraph" id="par_id481663434995022">
+ <image
src="media/icon-themes/sc/res/icon-set-circles2-dark-red.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Dark red</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-circles2-light-red.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Light red</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-circles2-light-gray.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Light gray</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-circles2-dark-gray.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Dark gray</alt></image>
</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id31494146" role="listitem">4
or 5 - ratings</paragraph>
- <paragraph role="paragraph" id="par_id631663435728155"
xml-lang="en-US">
- <image src="media/icon-themes/sc/res/icon-set-bars-empty.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Empty bars</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-bars-one-quarter.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">One quarters bars</alt></image>
- <image src="media/icon-themes/sc/res/icon-set-bars-half.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Half bars</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-bars-three-quarters.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Three quarters bars</alt></image>
- <image src="media/icon-themes/sc/res/icon-set-bars-full.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Full bars</alt></image>
+ <paragraph id="par_id31494146" role="listitem">4 or 5 -
ratings</paragraph>
+ <paragraph role="paragraph" id="par_id631663435728155">
+ <image src="media/icon-themes/sc/res/icon-set-bars-empty.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Empty bars</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-bars-one-quarter.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">One quarters bars</alt></image>
+ <image src="media/icon-themes/sc/res/icon-set-bars-half.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Half bars</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-bars-three-quarters.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Three quarters bars</alt></image>
+ <image src="media/icon-themes/sc/res/icon-set-bars-full.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Full bars</alt></image>
</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id31494147" role="ilistitem">5
- quarters</paragraph>
- <paragraph role="paragraph" id="par_id741663436015689"
xml-lang="en-US">
- <image src="media/icon-themes/sc/res/icon-set-pies-empty.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Empty</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-pies-one-quarter.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">One quarter</alt></image>
- <image src="media/icon-themes/sc/res/icon-set-pies-half.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Half</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-pies-three-quarters.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Three quarters</alt></image>
- <image src="media/icon-themes/sc/res/icon-set-pies-full.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Full</alt></image>
+ <paragraph id="par_id31494147" role="ilistitem">5 -
quarters</paragraph>
+ <paragraph role="paragraph" id="par_id741663436015689">
+ <image src="media/icon-themes/sc/res/icon-set-pies-empty.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Empty</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-pies-one-quarter.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">One quarter</alt></image>
+ <image src="media/icon-themes/sc/res/icon-set-pies-half.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Half</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-pies-three-quarters.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Three quarters</alt></image>
+ <image src="media/icon-themes/sc/res/icon-set-pies-full.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Full</alt></image>
</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id821663436639070" role="listitem">5 -
boxes</paragraph>
- <paragraph role="paragraph" id="par_id811663438472751"
xml-lang="en-US">
- <image
src="media/icon-themes/sc/res/icon-set-squares-empty.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Empty</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-squares-one-quarter.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">One quarter</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-squares-half.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Half</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-squares-three-quarters.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Three quarters</alt></image>
- <image
src="media/icon-themes/sc/res/icon-set-squares-full.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt xml-lang="en-US"
id="alt_id91663429174808">Full</alt></image>
+ <paragraph id="par_id821663436639070" role="listitem">5 -
boxes</paragraph>
+ <paragraph role="paragraph" id="par_id811663438472751">
+ <image
src="media/icon-themes/sc/res/icon-set-squares-empty.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Empty</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-squares-one-quarter.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">One quarter</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-squares-half.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Half</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-squares-three-quarters.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Three quarters</alt></image>
+ <image
src="media/icon-themes/sc/res/icon-set-squares-full.svg"
id="img_id261663429174807" width="1cm" height="1cm"><alt
id="alt_id91663429174808">Full</alt></image>
</paragraph>
</listitem>
</list>
<h3 id="hd_id621663440395987">Conditions for thresholds</h3>
- <paragraph xml-lang="en-US" id="par_id3153765" role="paragraph">Conditions
to set the thresholds for each icon can be specified as follows</paragraph>
+ <paragraph id="par_id3153765" role="paragraph">Conditions to set the
thresholds for each icon can be specified as follows</paragraph>
<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"
localize="false"><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_id471665407993996"
localize="false"><embedvar
href="text/scalc/01/05120000.xhp#ConditionalFormattingh1"
markup="ignore"/></paragraph>
+ <paragraph 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>
</body>
diff --git a/source/text/scalc/01/05120500.xhp
b/source/text/scalc/01/05120500.xhp
index 3b2eed4723..ec36ea06ef 100644
--- a/source/text/scalc/01/05120500.xhp
+++ b/source/text/scalc/01/05120500.xhp
@@ -11,26 +11,27 @@
<meta>
<topic id="conditionalformattingmanage" indexer="include"
status="PUBLISH">
- <title id="tit" xml-lang="en-US">Conditional Formatting - Manage
Conditions</title>
+ <title id="tit">Conditional Formatting - Manage Conditions</title>
<filename>/text/scalc/01/05120500.xhp</filename>
</topic>
</meta>
<body>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/condformatmanager/CondFormatManager"
id="bm_id3152598" localize="false"/>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/condformatmanager/@@nowidget@@" id="bm_id3152598"
localize="false"/>
+ <bookmark
branch="hid/modules/scalc/ui/condformatmanager/CondFormatManager"
id="bm_id3152598" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/condformatmanager/@@nowidget@@"
id="bm_id3152598" localize="false"/>
+ <bookmark branch="hid/.uno:ConditionalFormatManagerDialog"
id="bm_id141700683748690" localize="false"/>
<section id="manageconditions">
<h1 id="hd_id391662937414401"><variable id="h1"><link
href="text/scalc/01/05120500.xhp">Manage Conditions</link></variable></h1>
- <paragraph xml-lang="en-US" id="par_id3155906" role="paragraph">Manage
all the conditional formatting defined in the spreadsheet.</paragraph>
+ <paragraph id="par_id3155906" role="paragraph">Manage all the
conditional formatting defined in the spreadsheet.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#s_conditionalmanage"/>
</section>
- <paragraph xml-lang="en-US" id="par_id3155907" role="paragraph">The
<emph>Manage Conditional Formatting</emph> dialog is where you can add, edit or
delete one or several conditional formattings.</paragraph>
+ <paragraph id="par_id3155907" role="paragraph">The <emph>Manage
Conditional Formatting</emph> dialog is where you can add, edit or delete one
or several conditional formattings.</paragraph>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/condformatmanager/CONTAINER" id="bm_id3152603"
localize="false"/>
- <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>
+ <bookmark branch="hid/modules/scalc/ui/condformatmanager/CONTAINER"
id="bm_id3152603" localize="false"/>
+ <paragraph 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>
+ <paragraph 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" localize="false"
id="par_id471665407993996"><embedvar
href="text/scalc/01/05120000.xhp#ConditionalFormattingh1"
markup="ignore"/></paragraph>
</section>
diff --git a/source/text/scalc/main0105.xhp b/source/text/scalc/main0105.xhp
index 0f35fdf2e2..f37dfd6e4c 100644
--- a/source/text/scalc/main0105.xhp
+++ b/source/text/scalc/main0105.xhp
@@ -46,11 +46,11 @@
<embed href="text/scalc/01/05070000.xhp#pagestyle"/>
<embed href="text/scalc/01/05080000.xhp#printranges"/>
-<h2 id="hd_id3157980"><link
href="text/shared/01/AutoFormat.xhp">AutoFormat</link></h2>
-<embed href="text/shared/01/AutoFormat.xhp#autoformattext"/>
<h2 id="hd_id3159206"><link href="text/scalc/01/05120000.xhp">Conditional
Formatting</link></h2>
<embed href="text/scalc/01/05120000.xhp#bedingtetext"/>
+<h2 id="hd_id3157980"><link
href="text/shared/01/AutoFormat.xhp">AutoFormat</link></h2>
+<embed href="text/shared/01/AutoFormat.xhp#autoformattext"/>
<embed href="text/shared/01/05260000.xhp#anchoring"/>
<embed href="text/shared/01/05070000.xhp#alignment"/>
<embed href="text/shared/01/05080000.xhp#alignment"/>
