AllLangHelp_scalc.mk | 1
source/text/scalc/00/00000405.xhp | 28 +++++++++++++++
source/text/scalc/01/05120000.xhp | 49 ++++++++++++++-------------
source/text/scalc/01/FormatSparklineMenu.xhp | 48 ++++++++++++++++++++++++++
source/text/scalc/02/06080000.xhp | 29 +++------------
source/text/scalc/guide/design.xhp | 45 +++++++++---------------
source/text/scalc/main0105.xhp | 10 +++--
source/text/shared/01/themesdialog.xhp | 3 +
source/text/swriter/01/format_object.xhp | 2 -
9 files changed, 137 insertions(+), 78 deletions(-)
New commits:
commit c099ceeaf1cb4651bbca712ba19d16ee4206ab0f
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Dec 2 22:11:09 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Dec 3 10:50:56 2023 +0100
tdf#155876 UI cmds Calc-Format menu (24)
+ Sparklines and more
+ refactoring
Change-Id: Ie320018d7c3cf13d25bed7f6d7b6af4b2c9f9b26
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160251
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index e848307a37..3344595ebb 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -195,6 +195,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/FieldMenu \
helpcontent2/source/text/scalc/01/format_graphic \
helpcontent2/source/text/scalc/01/formula2value \
+ helpcontent2/source/text/scalc/01/FormatSparklineMenu \
helpcontent2/source/text/scalc/01/ful_func \
helpcontent2/source/text/scalc/01/func_aggregate \
helpcontent2/source/text/scalc/01/func_arabic \
diff --git a/source/text/scalc/00/00000405.xhp
b/source/text/scalc/00/00000405.xhp
index 197c0f8984..4d0bce96ba 100644
--- a/source/text/scalc/00/00000405.xhp
+++ b/source/text/scalc/00/00000405.xhp
@@ -29,6 +29,34 @@
</meta>
<body>
<h1 id="hd_id3150769">Format Menu</h1>
+<section id="formatsparklinemenu">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id321701545027940">Choose
<menuitem>Format - Sparklines</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_context"/>
+ <paragraph role="paragraph" id="par_id491701553926646">In a cell with
sparklines, choose <menuitem>Sparklines</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id21701561553735">On the
<menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose
<menuitem>Sparklines</menuitem>.</paragraph>
+</section>
+<section id="themes">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id81701536119142">Choose
<menuitem>Format - Spreadsheet Themes</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id611701536216717">Choose
<menuitem>Layout - Spreadsheet Themes</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <section id="sythemes">
+ <table id="tbl_id3153968">
+ <tablerow>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3155132" xml-lang="en-US">
+ <image id="img_id3145785" src="cmd/lc_choosedesign.svg"
width="1cm" height="1cm"><alt id="alt_id3145785">Icon
Themes</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph role="paragraph" id="par_id3153953">Choose
Themes</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
+</section>
<section id="numberformat">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id181698927976688">Choose
<menuitem>Format - Number Format</menuitem>.</paragraph>
diff --git a/source/text/scalc/01/05120000.xhp
b/source/text/scalc/01/05120000.xhp
index 4e41c6dc61..2a8940be32 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -21,18 +21,21 @@
<meta>
<topic id="textscalc0105120000xml" indexer="include">
- <title xml-lang="en-US" id="tit">Conditional
Formatting</title>
+ <title id="tit">Conditional Formatting</title>
<filename>/text/scalc/01/05120000.xhp</filename>
</topic>
</meta>
<body>
- <bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatDialog"
id="bm_id5008046" localize="false"/>
- <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_id51665407876959"><variable
id="ConditionalFormattingh1"><link
href="text/scalc/01/05120000.xhp">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 <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> 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 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>
+ <bookmark branch="hid/.uno:ConditionalFormatDialog" id="bm_id5008046"
localize="false"/>
+ <bookmark branch="hid/.uno:ConditionalFormatMenu" id="bm_id5008047"
localize="false"/>
+ <bookmark
branch="hid/modules/scalc/ui/conditionalformatdialog/ConditionalFormatDialog"
id="bm_id3152518" localize="false"/>
+ <bookmark
branch="hid/modules/scalc/ui/conditionalformatdialog/@@nowidget@@"
id="bm_id3152518" localize="false"/>
+ <section id="condformat">
+ <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 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>
@@ -41,30 +44,30 @@
<embed href="text/scalc/00/00000405.xhp#s_conditionalcondition"/>
</section>
<h3 id="hd_id431662926282555">Range</h3>
- <paragraph xml-lang="en-US" id="par_id31494138" role="paragraph">Defines
the range of cells concerned by the conditional formatting. Click on the
<emph>Shrink</emph> button to minimize the dialog box. Click again on the
button to come back to the dialog box once the range is selected.</paragraph>
+ <paragraph id="par_id31494138" role="paragraph">Defines the range of
cells concerned by the conditional formatting. Click on the <emph>Shrink</emph>
button to minimize the dialog box. Click again on the button to come back to
the dialog box once the range is selected.</paragraph>
- <bookmark xml-lang="en-US" branch="index"
id="bm_id3153189"><bookmark_value>conditional formatting;
conditions</bookmark_value>
+ <bookmark 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"/>
+ <bookmark branch="hid/modules/scalc/ui/conditionalformatdialog/list"
id="bm_id5008050" localize="false"/>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/edassign"
id="bm_id5008055" localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/conditionalformatdialog/edassign"
id="bm_id5008055" localize="false"/>
<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 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 branch="hid/modules/scalc/ui/conditionalformatdialog/up"
id="bm_id5008053" localize="false"/>
<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>
+ <paragraph 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>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/add" id="bm_id5008051"
localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/conditionalformatdialog/down"
id="bm_id5008054" localize="false"/>
+ <paragraph id="par_id3149415" role="paragraph"><ahelp hid=".">Decrease
priority of the selected condition.</ahelp></paragraph>
+ <bookmark branch="hid/modules/scalc/ui/conditionalformatdialog/add"
id="bm_id5008051" localize="false"/>
<h3 id="hd_id71662926011736">Add</h3>
<paragraph role="paragraph" id="par_id721662926016039">Adds the
condition to the condition list.</paragraph>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalformatdialog/delete" id="bm_id5008052"
localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/conditionalformatdialog/delete"
id="bm_id5008052" localize="false"/>
<h3 id="hd_id401662926020291">Delete</h3>
<paragraph role="paragraph" id="par_id301662926026944">Deletes the
condition from the condition list.</paragraph>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/conditionalentry/type" id="bm_id941662938267119"
localize="false"/>
+ <bookmark branch="hid/modules/scalc/ui/conditionalentry/type"
id="bm_id941662938267119" localize="false"/>
<h2 id="hd_id31531891">Condition list entries</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>
+ <paragraph id="par_id31494132" role="paragraph">Specify if conditional
formatting is dependent on one of the entry listed on the drop down
box.</paragraph>
<embed href="text/scalc/01/05120100.xhp#cellvalueis"/>
<embed href="text/scalc/01/05120200.xhp#formulais"/>
@@ -73,12 +76,12 @@
<embed href="text/scalc/01/05120400.xhp#colorscale"/>
<embed href="text/scalc/01/05120400.xhp#databar"/>
<embed href="text/scalc/01/05120400.xhp#iconset"/>
- <bookmark xml-lang="en-US"
branch="modules/scalc/ui/conditionalentry/style" id="bm_id241662938779751"
localize="false"/>
+ <bookmark branch="modules/scalc/ui/conditionalentry/style"
id="bm_id241662938779751" localize="false"/>
<h2 id="hd_id431662938949798">Apply Style</h2>
<paragraph role="paragraph" id="par_id971662939043786">Select the cell
style to apply when the condition is verified. Select <emph>New Style</emph> to
open the <link href="text/scalc/01/cell_styles.xhp">Cell Style dialog</link>
and define the style properties.</paragraph>
<embed href="text/scalc/01/05120500.xhp#manageconditions"/>
<section id="relatedtopics">
- <paragraph xml-lang="en-US" id="par_idN107E1" role="paragraph"
localize="false">
+ <paragraph id="par_idN107E1" role="paragraph" localize="false">
<embedvar
href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/>
</paragraph>
</section>
diff --git a/source/text/scalc/01/FormatSparklineMenu.xhp
b/source/text/scalc/01/FormatSparklineMenu.xhp
new file mode 100644
index 0000000000..d0708000d8
--- /dev/null
+++ b/source/text/scalc/01/FormatSparklineMenu.xhp
@@ -0,0 +1,48 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="textscalc01FormatSparklineMenuxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">FormatSparklineMenu</title>
+ <filename>/text/scalc/01/FormatSparklineMenu.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <bookmark branch="hid/.uno:FormatSparklineMenu" id="bm_id361701544836648"
localize="false"/>
+ <section id="formatsparklinemenu">
+ <h1 id="hd_id171701544913091"><variable id="h1"><link
href="text/scalc/01/FormatSparklineMenu.xhp">Sparkline</link></variable></h1>
+ <paragraph id="par_id341701544913094" role="paragraph">Opens a menu
for sparklines formatting.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#formatsparklinemenu"/>
+ </section>
+ <embed href="text/scalc/01/sparklines.xhp#sparklinesh1"/>
+ <bookmark branch="hid/.uno:DeleteSparkline" id="bm_id591701553428946"
localize="false"/>
+ <h2 id="hd_id291701553478320">Delete Sparkline</h2>
+ <paragraph role="paragraph" id="par_id351701562068834">Deletes the
sparkline of the current cell, if any.</paragraph>
+ <bookmark branch="hid/.uno:DeleteSparklineGroup" id="bm_id561701553443560"
localize="false"/>
+ <h2 id="hd_id781701553493248">Delete Sparkline Group</h2>
+ <paragraph role="paragraph" id="par_id381701562072857">Deletes all
sparklines of the group at the current cell or selection.</paragraph>
+ <bookmark branch="hid/.uno:EditSparklineGroup" id="bm_id821701553450018"
localize="false"/>
+ <h2 id="hd_id521701553498239">Edit Sparkline Group</h2>
+ <paragraph role="paragraph" id="par_id801701562077297">Edits the
properties of the sparkline group. The properties applies to all sparklines in
the group.</paragraph>
+ <bookmark branch="hid/.uno:EditSparkline" id="bm_id151701553460496"
localize="false"/>
+ <h2 id="hd_id311701553503214">Edit Sparkline</h2>
+ <paragraph role="paragraph" id="par_id241701562081481">Edits the
properties of the sparkline at the current cell, if any.</paragraph>
+ <bookmark branch="hid/.uno:GroupSparklines" id="bm_id131701553466738"
localize="false"/>
+ <h2 id="hd_id651701553509911">Group Sparklines</h2>
+ <paragraph role="paragraph" id="par_id141701562085848">Creates a group for
all sparklines selected.</paragraph>
+ <bookmark branch="hid/.uno:UngroupSparklines" id="bm_id171701553526296"
localize="false"/>
+ <h2 id="hd_id721701553532678">Ungroup Sparklines</h2>
+ <paragraph role="paragraph" id="par_id571701562089666">Ungroup the
sparkines previously grouped.</paragraph>
+</body>
+</helpdocument>
+
diff --git a/source/text/scalc/02/06080000.xhp
b/source/text/scalc/02/06080000.xhp
index 1c088e6818..e9d5f19c67 100644
--- a/source/text/scalc/02/06080000.xhp
+++ b/source/text/scalc/02/06080000.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,11 +16,10 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textscalc0206080000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Theme Selection</title>
+<title id="tit">Theme Selection</title>
<filename>/text/scalc/02/06080000.xhp</filename>
</topic>
<history>
@@ -30,27 +27,15 @@
</history>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="hid/.uno:ChooseDesign" id="bm_id3147335"
localize="false"/>
+<bookmark branch="hid/.uno:ChooseDesign" id="bm_id3147335" localize="false"/>
<h1 id="hd_id3153087"><link href="text/scalc/02/06080000.xhp">Theme
Selection</link></h1>
-<paragraph role="paragraph" id="par_id3154515" xml-lang="en-US"><variable
id="thementext"><ahelp hid=".uno:ChooseDesign">Applies a formatting style to
the selected cells.</ahelp>
+<paragraph role="paragraph" id="par_id3154515"><variable
id="thementext"><ahelp hid=".uno:ChooseDesign">Applies a formatting style to
the selected cells.</ahelp>
</variable> The styles include font, border, and background color
information.</paragraph>
-<section id="sythemes">
-<table id="tbl_id3153968">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3155132" xml-lang="en-US">
-<image id="img_id3145785" src="cmd/sc_choosedesign.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3145785" xml-lang="en-US">Icon</alt>
- </image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3153953" xml-lang="en-US">Choose
Themes</paragraph>
-</tablecell>
-</tablerow>
-</table>
-
+<section id="howtoget">
+ <embed href="text/scalc/00/00000405.xhp#themes"/>
</section>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGSTYLES_LISTBOX"
id="bm_id3153159" localize="false"/>
-<paragraph role="paragraph" id="par_id3147127" xml-lang="en-US"><ahelp
hid="HID_DLGSTYLES_LISTBOX">Click the formatting theme that you want to apply,
and then click <emph>OK</emph>.</ahelp></paragraph>
+<bookmark branch="hid/WIZARDS_HID_DLGSTYLES_LISTBOX" id="bm_id3153159"
localize="false"/>
+<paragraph role="paragraph" id="par_id3147127"><ahelp
hid="HID_DLGSTYLES_LISTBOX">Click the formatting theme that you want to apply,
and then click <emph>OK</emph>.</ahelp></paragraph>
<embed href="text/scalc/guide/design.xhp#design"/>
</body>
</helpdocument>
diff --git a/source/text/scalc/guide/design.xhp
b/source/text/scalc/guide/design.xhp
index 912d397a38..402e61ba34 100644
--- a/source/text/scalc/guide/design.xhp
+++ b/source/text/scalc/guide/design.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,20 +16,15 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
- <helpdocument version="1.0">
+<helpdocument version="1.0">
<meta>
<topic id="textscalcguidedesignxml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Selecting Themes for Sheets</title>
+<title id="tit">Selecting Themes for Sheets</title>
<filename>/text/scalc/guide/design.xhp</filename>
</topic>
</meta>
<body>
-
-
-
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3150791"><bookmark_value>theme selection for sheets</bookmark_value>
+<bookmark branch="index" id="bm_id3150791"><bookmark_value>theme selection for
sheets</bookmark_value>
<bookmark_value>layout;spreadsheets</bookmark_value>
<bookmark_value>cell styles; selecting</bookmark_value>
<bookmark_value>selecting;formatting themes</bookmark_value>
@@ -41,32 +33,31 @@
<bookmark_value>formatting;themes for sheets</bookmark_value>
</bookmark>
<comment>mw deleted "applying;"</comment>
- <paragraph xml-lang="en-US" id="hd_id3150791" role="heading"
level="1"><variable id="design"><link
href="text/scalc/guide/design.xhp">Selecting Themes for Sheets</link>
-</variable></paragraph>
- <paragraph xml-lang="en-US" id="par_id3145786"
role="paragraph">$[officename] Calc comes with a predefined set of formatting
themes that you can apply to your spreadsheets.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154490" role="paragraph">It is not
possible to add themes to Calc, and they cannot be modified. However, you can
modify their styles after you apply them to a spreadsheet.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154757" role="paragraph">Before you
format a sheet with a theme, you have to apply at least one custom cell style
to the cells on the sheet. You can then change the cell formatting by selecting
and applying a theme in the <emph>Theme Selection</emph> dialog.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156382" role="paragraph">To apply a
custom cell style to a cell, you can open the Styles window and, in its lower
list box, set the Custom Styles view. A list of the existing custom defined
cell styles will be displayed. Double click a name from the Styles window to
apply this style to the selected cells.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153963" role="paragraph">To apply a
theme to a spreadsheet:</paragraph>
+ <h1 id="hd_id3150791"><variable id="design"><link
href="text/scalc/guide/design.xhp">Selecting Themes for Sheets</link>
+</variable></h1>
+ <paragraph id="par_id3145786" role="paragraph">$[officename] Calc comes with
a predefined set of formatting themes that you can apply to your
spreadsheets.</paragraph>
+ <paragraph id="par_id3154490" role="paragraph">It is not possible to add
themes to Calc, and they cannot be modified. However, you can modify their
styles after you apply them to a spreadsheet.</paragraph>
+ <paragraph id="par_id3154757" role="paragraph">Before you format a sheet
with a theme, you have to apply at least one custom cell style to the cells on
the sheet. You can then change the cell formatting by selecting and applying a
theme in the <emph>Theme Selection</emph> dialog.</paragraph>
+ <paragraph id="par_id3156382" role="paragraph">To apply a custom cell style
to a cell, you can open the Styles window and, in its lower list box, set the
Custom Styles view. A list of the existing custom defined cell styles will be
displayed. Double click a name from the Styles window to apply this style to
the selected cells.</paragraph>
+ <paragraph id="par_id3153963" role="paragraph">To apply a theme to a
spreadsheet:</paragraph>
<list type="ordered">
<listitem>
- <paragraph xml-lang="en-US" id="par_id3146920" role="listitem">Click the
<emph>Choose Themes</emph> icon in the <emph>Tools</emph> bar. </paragraph>
- <embed href="text/scalc/02/06080000.xhp#sythemes"/>
- <paragraph xml-lang="en-US" id="par_id3148488" role="listitem">The
<emph>Theme Selection</emph> dialog appears. This dialog lists the available
themes for the whole spreadsheet and the Styles window lists the custom styles
for specific cells.</paragraph>
+ <paragraph id="par_id3146920" role="listitem">Click the <emph>Choose
Themes</emph> icon in the <emph>Tools</emph> bar. </paragraph>
+ <embed href="text/scalc/00/00000405.xhp#sythemes"/>
+ <paragraph id="par_id3148488" role="listitem">The <emph>Theme
Selection</emph> dialog appears. This dialog lists the available themes for the
whole spreadsheet and the Styles window lists the custom styles for specific
cells.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3155114" role="listitem">In the
<emph>Theme Selection </emph>dialog, select the theme that you want to apply to
the spreadsheet.</paragraph>
+ <paragraph id="par_id3155114" role="listitem">In the <emph>Theme Selection
</emph>dialog, select the theme that you want to apply to the
spreadsheet.</paragraph>
</listitem>
<listitem>
- <paragraph xml-lang="en-US" id="par_id3150090" role="listitem">Click
OK</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150201" role="listitem">As soon as
you select another theme in the <emph>Theme Selection</emph> dialog, some of
the properties of the custom style will be applied to the current spreadsheet.
The modifications will be immediately visible in your spreadsheet.</paragraph>
+ <paragraph id="par_id3150090" role="listitem">Click OK</paragraph>
+ <paragraph id="par_id3150201" role="listitem">As soon as you select
another theme in the <emph>Theme Selection</emph> dialog, some of the
properties of the custom style will be applied to the current spreadsheet. The
modifications will be immediately visible in your spreadsheet.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
-
<embed href="text/scalc/guide/autoformat.xhp#autoformat"/>
- <paragraph xml-lang="en-US" id="par_id3146979" role="paragraph"><link
href="text/scalc/02/06080000.xhp">Theme selection</link></paragraph>
-
+ <paragraph id="par_id3146979" role="paragraph"><link
href="text/scalc/02/06080000.xhp">Theme selection</link></paragraph>
+
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/main0105.xhp b/source/text/scalc/main0105.xhp
index f37dfd6e4c..25355bff21 100644
--- a/source/text/scalc/main0105.xhp
+++ b/source/text/scalc/main0105.xhp
@@ -45,12 +45,14 @@
<embed href="text/shared/01/05030000.xhp#paragraph"/>
<embed href="text/scalc/01/05070000.xhp#pagestyle"/>
<embed href="text/scalc/01/05080000.xhp#printranges"/>
+<embed href="text/scalc/01/05120000.xhp#condformat"/>
+<embed href="text/shared/01/AutoFormat.xhp#autoformat"/>
+<embed href="text/scalc/01/FormatSparklineMenu.xhp#formatsparklinemenu"/>
+<embed href="text/shared/menu/submenu_image.xhp#submenu_image"/>
-<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/swriter/01/format_object.xhp#object"/>
+
<embed href="text/shared/01/05260000.xhp#anchoring"/>
<embed href="text/shared/01/05070000.xhp#alignment"/>
<embed href="text/shared/01/05080000.xhp#alignment"/>
diff --git a/source/text/shared/01/themesdialog.xhp
b/source/text/shared/01/themesdialog.xhp
index a94edbc9a5..c374955425 100644
--- a/source/text/shared/01/themesdialog.xhp
+++ b/source/text/shared/01/themesdialog.xhp
@@ -15,9 +15,10 @@
</topic>
</meta>
<body>
+<bookmark branch="hid/.uno:ThemeDialog" id="bm_id61701537134689"
localize="false"/>
<bookmark id="bm_id771690371241991"
branch="hid/svx/ui/themedialog/ThemeDialog" localize="false"/>
<bookmark id="bm_id771690371241992"
branch="hid/svx/ui/themedialog/@@nowidget@@" localize="false"/>
-<bookmark xml-lang="en-US" branch="index" id="bm_id971691113956654">
+<bookmark branch="index" id="bm_id971691113956654">
<bookmark_value>document themes;choosing</bookmark_value>
<bookmark_value>applying document themes</bookmark_value>
</bookmark>
diff --git a/source/text/swriter/01/format_object.xhp
b/source/text/swriter/01/format_object.xhp
index 22320fa4be..2af76e8423 100644
--- a/source/text/swriter/01/format_object.xhp
+++ b/source/text/swriter/01/format_object.xhp
@@ -27,9 +27,9 @@
</history>
</meta>
<body>
-<section id="object">
<bookmark branch="hid/.uno:DrawGraphicMenu" id="bm_id5739310"
localize="false"/>
<bookmark branch="hid/.uno:FormatObjectMenu" id="bm_id301692832205444"
localize="false"/>
+<section id="object">
<h1 id="par_idN10548" ><link href="text/swriter/01/format_object.xhp">Text Box
and Shape</link></h1>
<paragraph role="paragraph" id="par_idN10558" ><ahelp hid=".">Opens a submenu
to edit the properties of the selected textbox or shape.</ahelp></paragraph>
</section>
