summaryrefslogtreecommitdiff
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
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>
-rw-r--r--AllLangHelp_scalc.mk1
-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
-rw-r--r--source/text/shared/optionen/01060300.xhp1
5 files changed, 44 insertions, 1 deletions
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">