AllLangHelp_scalc.mk | 1
source/text/scalc/00/00000402.xhp | 6 +++++
source/text/scalc/01/SetInputMode.xhp | 36 +++++++++++++++++++++++++++++++
source/text/scalc/main0102.xhp | 1
source/text/shared/optionen/01060300.xhp | 1
5 files changed, 44 insertions(+), 1 deletion(-)
New commits:
commit 7d08444f187ddea8a983565fc2c7fb8b2a38176c
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Tue Oct 17 17:14:51 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Oct 17 23:04:17 2023 +0200
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.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 5dc4e85648..c553800518 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -291,6 +291,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/SelectColumn \
helpcontent2/source/text/scalc/01/SelectData \
helpcontent2/source/text/scalc/01/SelectRow \
+ helpcontent2/source/text/scalc/01/SetInputMode \
helpcontent2/source/text/scalc/01/shared_spreadsheet \
helpcontent2/source/text/scalc/01/sheet_tab_color \
helpcontent2/source/text/scalc/01/solver \
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"/>
diff --git a/source/text/shared/optionen/01060300.xhp
b/source/text/shared/optionen/01060300.xhp
index ffb349e13e..01e459681f 100644
--- a/source/text/shared/optionen/01060300.xhp
+++ b/source/text/shared/optionen/01060300.xhp
@@ -66,7 +66,6 @@
<ahelp hid="modules/scalc/ui/scgeneralpage/alignlb">Determines the
direction that the cursor in the spreadsheet will move after you press the
Enter key.</ahelp>
</paragraph>
<bookmark branch="hid/modules/scalc/ui/scgeneralpage/editmodecb"
id="bm_id3151245" localize="false"/>
- <bookmark branch="hid/.uno:SetInputMode" id="bm_id3079317"
localize="false"/>
<comment>see i53756</comment>
<h3 id="hd_id3154307">Press Enter to switch to edit mode</h3>
<paragraph role="paragraph" id="par_id3148943">
