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.hallot@libreoffice.org>
author: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-12-02 22:11:09 -0300
committer: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-12-03 10:50:56 +0100
commit: c099ceeaf1cb4651bbca712ba19d16ee4206ab0f (patch)
tree: 93a19cfab6bd76d033fe6de5cea52d062a495ba1 /source
parent: 3b321caecd0c27ae01afb12924f4f2cb12593dd8 (diff)
8 files changed, 136 insertions, 78 deletions
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>
author	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-12-02 22:11:09 -0300
committer	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-12-03 10:50:56 +0100
commit	c099ceeaf1cb4651bbca712ba19d16ee4206ab0f (patch)
tree	93a19cfab6bd76d033fe6de5cea52d062a495ba1 /source
parent	3b321caecd0c27ae01afb12924f4f2cb12593dd8 (diff)