AllLangHelp_scalc.mk | 2 +
source/text/scalc/00/00000403.xhp | 47 ++++++++++++++++++++++++++++--
source/text/scalc/01/03080000.xhp | 28 ++++++++---------
source/text/scalc/01/ToggleFormula.xhp | 31 +++++++++++++++++++
source/text/scalc/01/ViewHiddenColRow.xhp | 33 +++++++++++++++++++++
source/text/scalc/main0103.xhp | 5 +--
6 files changed, 127 insertions(+), 19 deletions(-)
New commits:
commit 1a8338a2bf045393580e0db745e04b47624e4fea
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Oct 28 12:38:01 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Oct 29 13:28:52 2023 +0100
tdf#155876 UI cmds Calc-View menu (08)
+ refactoring
Change-Id: I0f8fa1f36ff535fd21dd0aaab468b122c359c5fc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158595
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index ec54caffbe..1330d68b3b 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -317,10 +317,12 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/ODFF \
helpcontent2/source/text/scalc/01/TableSelectAll \
helpcontent2/source/text/scalc/01/text2columns \
+ helpcontent2/source/text/scalc/01/ToggleFormula \
helpcontent2/source/text/scalc/01/ToggleSheetGrid \
helpcontent2/source/text/scalc/01/SelectUnprotectedCells \
helpcontent2/source/text/scalc/01/SelectVisibleColumns \
helpcontent2/source/text/scalc/01/SelectVisibleRows \
+ helpcontent2/source/text/scalc/01/ViewHiddenColRow \
helpcontent2/source/text/scalc/01/zoom \
helpcontent2/source/text/scalc/01/xml_source \
helpcontent2/source/text/scalc/02/06010000 \
diff --git a/source/text/scalc/00/00000403.xhp
b/source/text/scalc/00/00000403.xhp
index 83d704ec7a..86a5717177 100644
--- a/source/text/scalc/00/00000403.xhp
+++ b/source/text/scalc/00/00000403.xhp
@@ -44,9 +44,10 @@
</tablecell>
</tablerow>
</table>
+ <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id491698503663315"><menuitem>View Grid
Lines</menuitem></paragraph>
</section>
-
<section id="viewheaders">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph id="par_id3150275" role="paragraph"><variable id="aspze">Choose
<emph>View - View Headers</emph>.</variable></paragraph>
@@ -66,7 +67,25 @@
</table>
</section>
-<paragraph id="par_id3154514" role="paragraph"><variable id="awehe">Choose
<emph>View - Value Highlighting</emph>.</variable></paragraph>
+<section id="awehe1">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id3154514" role="paragraph"><variable id="awehe">Choose
<emph>View - Value Highlighting</emph>.</variable></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id31698502209561">Choose
<menuitem>View - Value Highlighting</menuitem></paragraph>
+ <paragraph role="paragraph" id="par_id841698502212650">On the
<menuitem>View</menuitem> menu of the <menuitem>View</menuitem> tab, choose
<menuitem>Value Highlighting</menuitem>.</paragraph>
+ <table id="tab_id201698502223079">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id271698502223080" role="paragraph"><image
src="cmd/lc_viewvaluehighlighting.svg" id="img_id241698502223081" width="1cm"
height="1cm"><alt id="alt_id991698502223082">Icon Value
Highlighting</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id311698502223084" role="paragraph">Value
Highlighting</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id91698502366801"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ F8</keycode></paragraph>
+</section>
<section id="formulabar">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
@@ -125,6 +144,30 @@
</tablerow>
</table>
</section>
+<section id="hiddenindicator">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id551698503320083">Choose <menuitem>View
- Hidden Row/Column Indicator</menuitem>.</paragraph>
+</section>
+<section id="showformula">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id931698505233736">Choose <menuitem>View
- Show Formula</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id31698506868213">Choose
<menuitem>View - Show Formula</menuitem></paragraph>
+ <paragraph role="paragraph" id="par_id81698506871597">On the
<menuitem>View</menuitem> menu of the <menuitem>View</menuitem> tab, choose
<menuitem>Show Formula</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id511698505490365">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id841698505490366" role="paragraph"><image
src="cmd/lc_toggleformula.svg" id="img_id231698505490367" width="1cm"
height="1cm"><alt id="alt_id701698505490368">Icon Show
Formula</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121698505490370" role="paragraph">Show
Formula</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id71698505976996"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ `</keycode></paragraph>
+</section>
<paragraph id="par_id3155383" role="paragraph"><variable
id="functionlist">Choose <menuitem>View - Function
List</menuitem>.</variable></paragraph>
</body>
diff --git a/source/text/scalc/01/03080000.xhp
b/source/text/scalc/01/03080000.xhp
index e8e5c07392..1140bda407 100644
--- a/source/text/scalc/01/03080000.xhp
+++ b/source/text/scalc/01/03080000.xhp
@@ -20,36 +20,36 @@
<meta>
<topic id="textscalc0103080000xml" indexer="include" status="PUBLISH">
- <title id="tit" xml-lang="en-US">Value Highlighting</title>
+ <title id="tit">Value Highlighting</title>
<filename>/text/scalc/01/03080000.xhp</filename>
</topic>
</meta>
<body>
-
-
-<section id="value_highlighting">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3151384">
+<bookmark branch="index" id="bm_id3151384">
<bookmark_value>spreadsheets; value highlighting</bookmark_value>
<bookmark_value>values;highlighting</bookmark_value>
<bookmark_value>highlighting; values in sheets</bookmark_value>
<bookmark_value>colors;values</bookmark_value>
</bookmark>
+<bookmark branch="hid/.uno:ViewValueHighlighting" id="bm_id3145068"
localize="false"/>
-<bookmark xml-lang="en-US" branch="hid/.uno:ViewValueHighlighting"
id="bm_id3145068" localize="false"/>
-
+<section id="value_highlighting">
<h1 id="hd_id3151384"><link href="text/scalc/01/03080000.xhp">Value
Highlighting</link></h1>
-<paragraph id="par_id3154366" role="paragraph" xml-lang="en-US"><ahelp
hid=".">Displays cell contents in different colors, depending on
type.</ahelp></paragraph>
+<paragraph id="par_id3154366" role="paragraph"><ahelp hid=".">Displays cell
contents in different colors, depending on type.</ahelp></paragraph>
</section>
-<paragraph id="par_id3125863" role="paragraph" xml-lang="en-US">To remove the
highlighting, unmark the menu entry.</paragraph>
+<paragraph id="par_id3125863" role="paragraph">To remove the highlighting,
unmark the menu entry.</paragraph>
<section id="howtoget">
-<embed href="text/scalc/00/00000403.xhp#awehe"/>
+<embed href="text/scalc/00/00000403.xhp#awehe1"/>
+</section>
+<paragraph id="par_id3145784" role="paragraph">By default:</paragraph>
+<paragraph id="par_id3145785" role="paragraph">Text cells are formatted in
black, formulas in green, number cells in blue, and protected cells are shown
with light grey background, no matter how their display is
formatted.</paragraph>
+<paragraph id="par_id3145786" role="paragraph">These colors can be customized
in <switchinline select="sys"><caseinline select="MAC"><item
type="menuitem">%PRODUCTNAME -
Preferences</item></caseinline><defaultinline><item type="menuitem">Tools -
Options</item></defaultinline></switchinline><item type="menuitem"> -
%PRODUCTNAME - Application Colors</item>.</paragraph>
+<warning id="par_id3153188">If this function is active, colors that you define
in the document will not be displayed. When you deactivate the function, the
user-defined colors are displayed again.</warning>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id921698361623602"
localize="false"><embedvar href="text/scalc/main0103.xhp#h1"
markup="ignore"/></paragraph>
</section>
-<paragraph id="par_id3145784" role="paragraph" xml-lang="en-US">By
default:</paragraph>
-<paragraph id="par_id3145785" role="paragraph" xml-lang="en-US">Text cells are
formatted in black, formulas in green, number cells in blue, and protected
cells are shown with light grey background, no matter how their display is
formatted.</paragraph>
-<paragraph id="par_id3145786" role="paragraph" xml-lang="en-US">These colors
can be customized in <switchinline select="sys"><caseinline select="MAC"><item
type="menuitem">%PRODUCTNAME -
Preferences</item></caseinline><defaultinline><item type="menuitem">Tools -
Options</item></defaultinline></switchinline><item type="menuitem"> -
%PRODUCTNAME - Application Colors</item>.</paragraph>
-<paragraph id="par_id3153188" role="warning" xml-lang="en-US">If this function
is active, colors that you define in the document will not be displayed. When
you deactivate the function, the user-defined colors are displayed
again.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/ToggleFormula.xhp
b/source/text/scalc/01/ToggleFormula.xhp
new file mode 100644
index 0000000000..6aa5b2a1f6
--- /dev/null
+++ b/source/text/scalc/01/ToggleFormula.xhp
@@ -0,0 +1,31 @@
+<?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="textscalc01ToggleFormulaxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Show Formula</title>
+ <filename>/text/scalc/01/ToggleFormula.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+<bookmark branch="hid/.uno:ToggleFormula" id="bm_id861698504900560"
localize="false"/>
+ <section id="showformula">
+ <h1 id="hd_id581698505022699"><variable id="h1"><link
href="text/scalc/01/ToggleFormula.xhp">Show Formula</link></variable></h1>
+ <paragraph id="par_id03302017024610704" role="paragraph">Display the
cell formula expression instead of the calculated result.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000403.xhp#showformula"/>
+ </section>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id921698361623602"
localize="false"><embedvar href="text/scalc/main0103.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/ViewHiddenColRow.xhp
b/source/text/scalc/01/ViewHiddenColRow.xhp
new file mode 100644
index 0000000000..7f1795df2f
--- /dev/null
+++ b/source/text/scalc/01/ViewHiddenColRow.xhp
@@ -0,0 +1,33 @@
+<?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="textscalc01ViewHiddenColRowxhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Hidden Row/Column Indicator</title>
+ <filename>/text/scalc/01/ViewHiddenColRow.xhp</filename>
+ </topic>
+ </meta>
+<body>
+ <bookmark branch="hid/.uno:ViewHiddenColRow" id="bm_id781698502772000"
localize="false"/>
+
+ <section id="hiddenindicator">
+ <h1 id="hd_id101698502804412"><variable id="h1"><link
href="text/scalc/01/ViewHiddenColRow.xhp">Hidden Row/Column
Indicator</link></variable></h1>
+ <paragraph id="par_id891698502804413" role="paragraph">Toggles the
display of tic marks where columns or rows are hidden.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000403.xhp#hiddenindicator"/>
+ </section>
+ <note id="par_id281698504591415">The tic marks disappears when the column
or row is visible again.</note>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id921698361623602"
localize="false"><embedvar href="text/scalc/main0103.xhp#h1"
markup="ignore"/></paragraph>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0103.xhp b/source/text/scalc/main0103.xhp
index 3f419afb24..5c78233bda 100644
--- a/source/text/scalc/main0103.xhp
+++ b/source/text/scalc/main0103.xhp
@@ -43,9 +43,8 @@
<embed href="text/shared/01/grid_and_helplines.xhp#grid_and_help_lines"/>
<embed href="text/scalc/01/03080000.xhp#value_highlighting"/>
-
-<h2 id="hd_id033020170228348624">Show Formula</h2>
-<paragraph id="par_id03302017024610704" role="paragraph">Display the cell
formula expression instead of the calculated result.</paragraph>
+<embed href="text/scalc/01/ViewHiddenColRow.xhp#hiddenindicator"/>
+<embed href="text/scalc/01/ToggleFormula.xhp#showformula"/>
<h2 id="hd_id241636195404363">Comments</h2>
<paragraph role="paragraph" id="par_id101636195413295">Display the <link
href="text/shared/01/04050000.xhp">cell comments</link> for the current
spreadsheet document.</paragraph>
