diff options
author | Dione Maddern <dionemaddern@gmail.com> | 2024-07-03 16:17:43 +0200 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-07-11 15:37:39 +0200 |
commit | b719a26a02e1789d393a33156ab43a6b9d43b094 (patch) | |
tree | 9b67dbca8e34b21c2af7b1813377aa56df57b607 /source/text/scalc/01/05120000.xhp | |
parent | 1a7045ca49e06f1e84bee74cdac6d8d6a399ddd8 (diff) |
Consolidate help pages for the Styles Sidebar deck into one page
Create new page text/shared/01/styles.xhp
Delete pages
- text/scalc/01/05100000.xhp
- text/simpress/01/05100000.xhp
- text/swriter/01/05140000.xhp
In AllLangHelp_scalc
- Remove reference to text/scalc/01/05100000.xhp
In AllLangHelp_shared
- Add entry for text/shared/01/styles.xhp
In AllLangHelp_simpress
- Remove reference to text/simpress/01/05100000.xhp
In AllLangHelp_swriter.mk
- Remove reference to text/simpress/01/05100000.xhp
In source/text/scalc/01/cell_styles.xhp
- Add variable tags to H1 to allow the page to be more easily linked from other pages.
In text/swriter/01/05130000.xhp
- Add variable and link tags to H1 so that the page can be more easily linked from other pages.
Replace links to deleted page text/scalc/01/05100000.xhp with links to text/shared/01/styles.xhp in:
- text/scalc/01/05120000.xhp
- text/scalc/main0103.xhp
- text/shared/01/05140100.xhp
- text/shared/02/01230000.xhp
Replace links to deleted page text/simpress/01/05100000.xhp with links to text/shared/01/styles.xhp in:
- text/sdraw/main0103.xhp
- text/sdraw/main_format.xhp
- text/shared/01/05140100.xhp
- text/shared/02/01230000.xhp
- text/simpress/guide/masterpage.xhp
- text/simpress/main0103.xhp
Replace links to deleted page text/swriter/01/05140000.xhp with links to text/shared/01/styles.xhp in:
- text/shared/01/05030000.xhp
- text/shared/01/05040100.xhp
- text/shared/01/05060000.xhp
- text/shared/02/02010000.xhp
- text/shared/menu/style_menu.xhp
- text/swriter/01/05030800.xhp
- text/swriter/01/05130000.xhp
- text/swriter/01/05130004.xhp
- text/swriter/main0103.xhp
- text/swriter/main0503.xhp
Change-Id: I20fc2a142107b3984abf1491459f3f485cd01f46
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169950
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/05120000.xhp')
-rw-r--r-- | source/text/scalc/01/05120000.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp index 2a8940be32..13ae420e7b 100644 --- a/source/text/scalc/01/05120000.xhp +++ b/source/text/scalc/01/05120000.xhp @@ -34,7 +34,7 @@ <h1 id="hd_id51665407876959"><variable id="ConditionalFormattingh1"><link href="text/scalc/01/05120000.xhp">Conditional Formatting</link></variable></h1> <paragraph id="par_id3163710" role="paragraph"><variable id="bedingtetext"><ahelp hid=".">Use <emph>Conditional Formatting</emph> to define range-based conditions that determine which <link href="text/scalc/01/cell_styles.xhp">cell style</link> will be applied to each cell in a given range based on its contents.</ahelp></variable></paragraph> </section> - <paragraph role="paragraph" id="par_id411701538725496">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"><emph>Formatting Bar</emph></link> or the <link href="text/scalc/01/05100000.xhp"><emph>Styles</emph> sidebar</link>.</paragraph> + <paragraph role="paragraph" id="par_id411701538725496">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"><emph>Formatting Bar</emph></link> or the <link href="text/shared/01/styles.xhp"><emph>Styles</emph> sidebar</link>.</paragraph> <paragraph 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> <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> |