summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--AllLangHelp_scalc.mk2
-rw-r--r--source/text/scalc/00/00000403.xhp47
-rw-r--r--source/text/scalc/01/03080000.xhp28
-rw-r--r--source/text/scalc/01/ToggleFormula.xhp31
-rw-r--r--source/text/scalc/01/ViewHiddenColRow.xhp33
-rw-r--r--source/text/scalc/main0103.xhp5
6 files changed, 127 insertions, 19 deletions
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>
generated by cgit (git 2.34.1) at 2025-01-10 07:03:56 +0000