[Libreoffice-commits] help.git: source/text
Olivier Hallot (via logerrit)
logerrit at kemper.freedesktop.org
Fri Jun 25 22:53:16 UTC 2021
source/text/scalc/01/05120000.xhp | 29 ++++++++++++++++-------------
1 file changed, 16 insertions(+), 13 deletions(-)
New commits:
commit 0a0327f63e2825b25c5b3a5e8c34ca97e4911ef4
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Fri Jun 25 16:59:21 2021 -0300
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Sat Jun 26 00:52:24 2021 +0200
tdf#114525 Bookmarks for Calc conditional formatting
Plus some refactor
Change-Id: Ib2d3740e51be437e806e199b2c3978b12d210792
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/117917
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp
index 7aae88576..ae62356fa 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -31,24 +31,27 @@
<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"/>
-<paragraph xml-lang="en-US" id="hd_id3155132" role="heading" level="1">Conditional Formatting</paragraph>
+<h1 id="hd_id3155132">Conditional Formatting</h1>
<paragraph xml-lang="en-US" id="par_id3163710" role="paragraph"><variable id="bedingtetext"><ahelp hid=".">Choose <emph>Conditional Formatting</emph> to define format styles depending on certain conditions.</ahelp>
</variable> If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. There are several types of conditional formatting that can be used.</paragraph>
<paragraph xml-lang="en-US" id="par_id3163711" role="paragraph">You can enter several conditions that query the contents of cell values or formulas. The conditions are evaluated from the first to the last. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style is used. If this style does not match, then the next condition is evaluated and so on.</paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#bedingte"/>
</section>
- <paragraph xml-lang="en-US" id="par_id2414014" role="warning">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</paragraph>
+ <warning id="par_id2414014">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</warning>
<bookmark xml-lang="en-US" branch="index" id="bm_id3153189"><bookmark_value>conditional formatting; conditions</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/list" id="bm_id5008050" localize="false"/>
- <paragraph xml-lang="en-US" id="par_id3149413" role="paragraph"><ahelp hid="." visibility="hidden">List of the conditions defined for the cell range in order of evaluation.</ahelp></paragraph>
+<h2 id="hd_id71624649758112">Condition list</h2>
+ <paragraph xml-lang="en-US" id="par_id3149413" role="paragraph">List of the conditions defined for the cell range in order of evaluation. You can define as many conditions as you want.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/up" id="bm_id5008053" localize="false"/>
- <paragraph xml-lang="en-US" id="par_id3149414" role="paragraph"><ahelp hid="." visibility="hidden">Increase priority of the selected condition.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/down" id="bm_id5008054" localize="false"/>
- <paragraph xml-lang="en-US" id="par_id3149415" role="paragraph"><ahelp hid="." visibility="hidden">Decrease priority of the selected condition.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="hd_id31531891" role="heading" level="2">Condition</paragraph>
- <paragraph xml-lang="en-US" id="par_id31494131" role="paragraph">You can define as many conditions as you want.</paragraph>
+<h3 id="hd_id41624649786605">Up</h3>
+<paragraph xml-lang="en-US" id="par_id3149414" role="paragraph"><ahelp hid=".">Increase priority of the selected condition.</ahelp></paragraph>
+ <h3 id="hd_id861624649792266">Down</h3>
+ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/down" id="bm_id5008054" localize="false"/>
+ <paragraph xml-lang="en-US" id="par_id3149415" role="paragraph"><ahelp hid=".">Decrease priority of the selected condition.</ahelp></paragraph>
+
+<h2 id="hd_id31531891">Condition list entry</h2>
<paragraph xml-lang="en-US" id="par_id31494132" role="paragraph">Specify if conditional formatting is dependent on one of the entry listed on the drop down box:</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/add" id="bm_id5008051" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/delete" id="bm_id5008052" localize="false"/>
@@ -84,14 +87,14 @@
</listitem>
</list>
-<paragraph xml-lang="en-US" id="hd_id3147394" role="heading" level="2">Color Scale</paragraph>
+<h2 id="hd_id3147394">Color Scale</h2>
<paragraph xml-lang="en-US" id="par_id3155602" role="paragraph">This is the same dialog box as if you select <emph>All cells</emph> in the first sub menu entry <emph>Condition</emph>.
Apply a color scale to a range consist of displaying a bicolor or tricolor gradient on this range depending on the value of each cell. A typical example might be an array of temperatures, lower blue colored, warmer red with a gradient nuances to the intermediate values.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155603" role="paragraph">You must choose the two "extreme" colors indicate the method of calculation. The calculation of the color applied will be made in relation to: Min - Max - Percentile - Value - Percent - Formula.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155604" role="paragraph">The choices Min and Max are sufficient to themselves as found in the range. Other options need to be specified by a value (Percentile, Value, Percentage) or a cell reference or formula (Formula).</paragraph>
<paragraph xml-lang="en-US" id="par_id3155605" role="paragraph">For a detailed explanation and examples, please visit <link href="https://wiki.documentfoundation.org/Faq/Calc/142">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki.</paragraph>
-<paragraph id="par_id991609782427459" role="heading" level="2">Data Bar</paragraph>
+<h2 id="par_id991609782427459">Data Bar</h2>
<paragraph role="paragraph" id="par_id41609780964157">Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell. Default is blue for positive and red for negative. </paragraph>
<paragraph role="paragraph" id="par_id931609781970981">The calculation of the area of fill is based on Min - Max - Percentile - Value - Percent - Formula.</paragraph>
<paragraph role="paragraph" id="par_id981609782003841">The choices Min and Max are sufficient to themselves as found in the range. Other options need to be specified by a value (Percentile, Value, Percentage) or a cell reference or formula (Formula).</paragraph>
@@ -108,7 +111,7 @@ Apply a color scale to a range consist of displaying a bicolor or tricolor gradi
</listitem>
</list>
-<paragraph xml-lang="en-US" id="hd_id3153709" role="heading" level="2">Icon Set</paragraph>
+<h2 id="hd_id3153709">Icon Set</h2>
<paragraph xml-lang="en-US" id="par_id3153764" role="paragraph">It is desired to plot the position of a value relative to the thresholds. The set of icons will help to indicate the thresholds and choose the type of icons. Available icon sets are:</paragraph>
<list type="unordered">
<listitem>
@@ -139,7 +142,7 @@ Apply a color scale to a range consist of displaying a bicolor or tricolor gradi
<paragraph xml-lang="en-US" id="par_id3153765" role="paragraph">Conditions to display each icon can be specified relative to a value (Value), a percentage of the number of values in the range (Percentage) as a percentage of range values (Percentile) or formula (Formula).</paragraph>
<paragraph xml-lang="en-US" id="par_id3155606" role="paragraph">For a detailed explanation and examples, please visit <link href="https://wiki.documentfoundation.org/Faq/Calc/141">How to use Icon Set Conditional Formatting page</link> in TDF Wiki.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3156384" role="heading" level="2">Dates</paragraph>
+<h2 id="hd_id3156384">Dates</h2>
<paragraph xml-lang="en-US" id="par_id3145228" role="paragraph">This option will apply a defined style depending on a date that you choose in the drop down box: Today - Yesterday - Tomorrow - Last 7 days - This week - Last week.</paragraph>
<list type="unordered">
<listitem>
@@ -155,7 +158,7 @@ Apply a color scale to a range consist of displaying a bicolor or tricolor gradi
<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"/>
-<paragraph xml-lang="en-US" id="hd_id3153384" role="heading" level="2">Manage Conditional Formatting</paragraph>
+<h2 id="hd_id3153384">Manage Conditional Formatting</h2>
<paragraph xml-lang="en-US" id="par_id3155906" role="paragraph"><ahelp hid=".">This dialog allows you to see all the conditional formatting defined in the spreadsheet.</ahelp></paragraph>
<section id="howtoget">
More information about the Libreoffice-commits
mailing list