summaryrefslogtreecommitdiff
path: root/source/text/scalc
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2023-10-17 17:14:51 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2023-10-17 23:04:17 +0200
commit7d08444f187ddea8a983565fc2c7fb8b2a38176c (patch)
tree7de495523040d9c13ea7dfc998a4b7f05dbdf61a /source/text/scalc
parente3fa34a71832b722a496534970be68e63ff1c0b8 (diff)
tdf#155876 UI cmds Calc (04)
+ refactoring + Edit - cell edit mode Change-Id: I43bcbd6f0467f0e923450a3b74b197b7166db15c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158095 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
-rw-r--r--source/text/scalc/00/00000402.xhp6
-rw-r--r--source/text/scalc/01/SetInputMode.xhp36
-rw-r--r--source/text/scalc/main0102.xhp1
3 files changed, 43 insertions, 0 deletions
diff --git a/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp
index 670c386a3a..5fc250c4ff 100644
--- a/source/text/scalc/00/00000402.xhp
+++ b/source/text/scalc/00/00000402.xhp
@@ -154,6 +154,12 @@
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id821697551802937">Choose <menuitem>Edit - Select - Select Visible Columns</menuitem>.</paragraph>
</section>
+<section id="celleditmode">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id761697569873060">Choose <menuitem>Edit - Cell Edit Mode</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id131697569897269" localize="false"><keycode>F2</keycode></paragraph>
+</section>
<paragraph id="par_id3155555" role="paragraph" xml-lang="en-US"><variable id="kopffuss">Choose <emph>Insert - Headers and Footers</emph>.</variable></paragraph>
<paragraph id="par_id3159233" role="paragraph" xml-lang="en-US"><variable id="bkopfzeile">Choose <emph>Insert - Headers and Footers - Header and Footer</emph> tabs.</variable></paragraph>
diff --git a/source/text/scalc/01/SetInputMode.xhp b/source/text/scalc/01/SetInputMode.xhp
new file mode 100644
index 0000000000..1c4d0418ae
--- /dev/null
+++ b/source/text/scalc/01/SetInputMode.xhp
@@ -0,0 +1,36 @@
+<?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="textscalc01SetInputModexhp" indexer="include" status="PUBLISH">
+ <title id="tit">Cell Edit Mode</title>
+ <filename>/text/scalc/01/SetInputMode.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+<bookmark branch="hid/.uno:SetInputMode" id="bm_id351697565841563" localize="false"/>
+<bookmark branch="index" id="bm_id721697573174462">
+ <bookmark_value>cell edit mode</bookmark_value>
+ <bookmark_value>F2;cell edit mode</bookmark_value>
+</bookmark>
+ <section id="celleditmode">
+ <h1 id="hd_id561697565904644"><variable id="h1"><link href="text/scalc/01/SetInputMode.xhp">Cell Edit Mode</link></variable></h1>
+ <paragraph id="par_id21697565904648" role="paragraph">Enable direct cell content editing.</paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000402.xhp#celleditmode"/>
+ </section>
+ <paragraph role="paragraph" id="par_id741697572331227">The cell edit mode enabled on a cell with formula displays the formula expression instead of the result of the formula calculation.</paragraph>
+ <paragraph role="paragraph" id="par_id51697573038463">In this mode, references to other cells are displayed in colors and the referenced cells have their borders highlighted with the same color. The highlighted cell displays handles on the corners to allow by dragging the handles, to extend the highlighted reference. The formula is automatically updated with the expression of the reference.</paragraph>
+ <paragraph role="paragraph" id="par_id1001697572337079">For example, a cell with formula <literal>=A1+B1</literal> displays <literal>A1</literal> in color 1 and <literal>B1</literal> in color 2 (colors are defined internally). The cell A1 is highlighted in color 1 and B1 is highlighted in color 2.</paragraph>
+ <paragraph role="paragraph" id="par_id861697572403097">Press <keycode>Enter</keycode> to end the cell edit mode.</paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0102.xhp b/source/text/scalc/main0102.xhp
index 4e83358605..74c251bae1 100644
--- a/source/text/scalc/main0102.xhp
+++ b/source/text/scalc/main0102.xhp
@@ -46,6 +46,7 @@
<embed href="text/shared/01/menu_edit_find.xhp#find"/>
<embed href="text/shared/01/02100000.xhp#find_and_replace"/>
<embed href="text/shared/01/02230000.xhp#track_changes"/>
+<embed href="text/scalc/01/SetInputMode.xhp#celleditmode"/>
<embed href="text/shared/01/02240000.xhp#compare_document"/>
<embed href="text/shared/01/02230500.xhp#merge_documents"/>