AllLangHelp_scalc.mk | 3 +
source/text/scalc/00/00000404.xhp | 53 +++++++++++++++++++++++++++++
source/text/scalc/01/FieldMenu.xhp | 37 ++++++++++++++++++++
source/text/scalc/01/InsertCurrentDate.xhp | 33 ++++++++++++++++++
source/text/scalc/01/InsertCurrentTime.xhp | 33 ++++++++++++++++++
source/text/scalc/main0104.xhp | 11 +-----
6 files changed, 162 insertions(+), 8 deletions(-)
New commits:
commit 0ca63be69ab23e8f420825d381bfb8e6a058ac58
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Nov 1 14:42:03 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Nov 1 20:33:55 2023 +0100
tdf#155876 UI cmds Calc-Insert menu (17)
+ refactoring of Insert Field menu
Change-Id: I72dcab2a45ddfe78025ceba699aa8b1428d4bdb4
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158772
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 8dff41342e..e848307a37 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -192,6 +192,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/EditSelectMenu \
helpcontent2/source/text/scalc/01/events_sheet \
helpcontent2/source/text/scalc/01/ex_data_stat_func \
+ helpcontent2/source/text/scalc/01/FieldMenu \
helpcontent2/source/text/scalc/01/format_graphic \
helpcontent2/source/text/scalc/01/formula2value \
helpcontent2/source/text/scalc/01/ful_func \
diff --git a/source/text/scalc/00/00000404.xhp
b/source/text/scalc/00/00000404.xhp
index a3ccef1a6b..3b13884053 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -29,6 +29,18 @@
</meta>
<body>
<h1 id="hd_id3149346">Insert Menu</h1>
+<section id="fieldmenu">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id991698859519603">Choose
<menuitem>Insert - Field</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id571698859523827">Choose
<menuitem>Insert - Field - Date</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id821698859529924">Choose
<menuitem>Insert - Field - Sheet Name</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id111698859534268">Choose
<menuitem>Insert - Field - Document Title</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id881698859538595">Choose
<menuitem>Insert - Field</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id501698859543375">Choose
<menuitem>Insert - Field - Date</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id801698859547630">Choose
<menuitem>Insert - Field - Sheet Name</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id541698859552582">Choose
<menuitem>Insert - Field - Document Title</menuitem>.</paragraph>
+</section>
<section id="inserttime">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
diff --git a/source/text/scalc/01/FieldMenu.xhp
b/source/text/scalc/01/FieldMenu.xhp
new file mode 100644
index 0000000000..bed6bef169
--- /dev/null
+++ b/source/text/scalc/01/FieldMenu.xhp
@@ -0,0 +1,37 @@
+<?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="textscalc01FieldMenuxhp" indexer="include" status="PUBLISH">
+ <title id="tit">Field Menu</title>
+ <filename>/text/scalc/01/FieldMenu.xhp</filename>
+ </topic>
+ </meta>
+<body>
+<bookmark branch="hid/.uno:FieldMenu" id="bm_id791698858901567"
localize="false"/>
+ <section id="fieldmenu">
+ <h1 id="hd_id891698859099735"><variable id="h1"><link
href="text/scalc/01/FieldMenu.xhp">Field</link></variable></h1>
+ <paragraph role="paragraph" id="par_id391577296078546">Opens a submenu
for selecting the date, sheet name or document title in the cell.</paragraph>
+ </section>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000404.xhp#fieldmenu"/>
+</section>
+<bookmark branch="hid/.uno:InsertFieldDateVariable" id="bm_id921698859819993"
localize="false"/>
+<h2 id="hd_id631698859855352">Date</h2>
+<paragraph role="paragraph" id="par_id271698860260863">Insert the date in the
cell. The date is variable.</paragraph>
+<bookmark branch="hid/.uno:InsertFieldSheet" id="bm_id711698859824194"
localize="false"/>
+<h2 id="hd_id951698859859564">Sheet Name</h2>
+<paragraph role="paragraph" id="par_id441698860211297">Insert the sheet name
in the cell which it belongs.</paragraph>
+<bookmark branch="hid/.uno:InsertFieldDocTitle" id="bm_id771698859828803"
localize="false"/>
+<h2 id="hd_id881698859863735">Document Title</h2>
+<paragraph role="paragraph" id="par_id51698860141070">Insert the document
title in the cell. The document title is set in the document properties in
<menuitem>File - Properties - Description</menuitem> tab.</paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0104.xhp b/source/text/scalc/main0104.xhp
index 423cce7e9f..94e096428b 100644
--- a/source/text/scalc/main0104.xhp
+++ b/source/text/scalc/main0104.xhp
@@ -50,9 +50,7 @@
<embed href="text/scalc/01/InsertCurrentDate.xhp#insertdate"/>
<embed href="text/scalc/01/InsertCurrentTime.xhp#inserttime"/>
-
-<h2 id="hd_id621577296064493">Field</h2>
-<paragraph role="paragraph" id="par_id391577296078546">Opens a submenu for
selecting the date, sheet name or document title in the cell.</paragraph>
+<embed href="text/scalc/01/FieldMenu.xhp#fieldmenu"/>
<embed href="text/scalc/01/02120000.xhp#headers_footers"/>
<embed href="text/shared/menu/insert_form_control.xhp#form_control_submenu"/>
commit b28faac2c5fe5600c97b40ba65e773b7f75c299c
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Nov 1 14:09:00 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Nov 1 20:33:44 2023 +0100
tdf#155876 UI cmds Calc-Insert menu (16)
+ refactoring of Insert Date and time
Change-Id: I95db763eb928d683b501cc35b06150cf5f061306
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158770
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 1330d68b3b..8dff41342e 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -283,6 +283,8 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_year \
helpcontent2/source/text/scalc/01/func_yearfrac \
helpcontent2/source/text/scalc/01/hide_sheet \
+ helpcontent2/source/text/scalc/01/InsertCurrentDate \
+ helpcontent2/source/text/scalc/01/InsertCurrentTime \
helpcontent2/source/text/scalc/01/JumpToNextTableSel \
helpcontent2/source/text/scalc/01/JumpToPrevTableSel \
helpcontent2/source/text/scalc/01/live_data_stream \
diff --git a/source/text/scalc/00/00000404.xhp
b/source/text/scalc/00/00000404.xhp
index 6badbd4001..a3ccef1a6b 100644
--- a/source/text/scalc/00/00000404.xhp
+++ b/source/text/scalc/00/00000404.xhp
@@ -30,6 +30,47 @@
<body>
<h1 id="hd_id3149346">Insert Menu</h1>
+<section id="inserttime">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id521698857081583">Choose
<menuitem>Insert - Time</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id501698857084857">Choose
<menuitem>Insert - Fields - Time</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id601698857088328">On the
<menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose
<menuitem>Time</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id71698856461426">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id311698857095297" role="paragraph"><image
src="cmd/lc_timefield.svg" id="img_id451698856461428" width="1cm"
height="1cm"><alt id="alt_id251698856461429">Icon Insert
Time</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id831698857100474" role="paragraph">Insert
Time</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id441698857104573"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ Shift + ;</keycode> (semicolon)</paragraph>
+</section>
+<section id="insertdate">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id891698856307267">Choose
<menuitem>Insert - Date</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id581698856407913">Choose
<menuitem>Insert - Fields - Date</menuitem>.</paragraph>
+ <paragraph role="paragraph" id="par_id911698856281237">On the
<menuitem>Insert</menuitem> menu of the <menuitem>Insert</menuitem> tab, choose
<menuitem>Date</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id71698856461426">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id761698856461427" role="paragraph"><image
src="cmd/lc_datefield.svg" id="img_id451698856461428" width="1cm"
height="1cm"><alt id="alt_id251698856461429">Icon Insert
Date</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id61698856461431" role="paragraph">Insert
Date</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ <embed href="text/shared/00/00000004.xhp#from_keyboard"/>
+ <paragraph role="paragraph" id="par_id21698856550818"><switchinline
select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>
+ ;</keycode> (semicolon)</paragraph>
+</section>
+
<section id="sparklines">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph role="paragraph" id="par_id761654173486733">Choose
<menuitem>Insert - Sparkline</menuitem>.</paragraph>
diff --git a/source/text/scalc/01/InsertCurrentDate.xhp
b/source/text/scalc/01/InsertCurrentDate.xhp
new file mode 100644
index 0000000000..a7bb1bbf22
--- /dev/null
+++ b/source/text/scalc/01/InsertCurrentDate.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="textscalc01InsertCurrentDatexhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Insert Date</title>
+ <filename>/text/scalc/01/InsertCurrentDate.xhp</filename>
+ </topic>
+ </meta>
+<body>
+<bookmark branch="hid/.uno:InsertCurrentDate" id="bm_id331698855895220"
localize="false"/>
+<bookmark branch="index" id="bm_id641698857771482">
+<bookmark_value>cell;insert date</bookmark_value>
+<bookmark_value>insert date;in cells</bookmark_value>
+</bookmark>
+<section id="insertdate">
+ <h1 id="hd_id221698855935217"><variable id="h1"><link
href="text/scalc/01/InsertCurrentDate.xhp">Date</link></variable></h1>
+ <paragraph role="paragraph" id="par_id11577295470732">Inserts the current
date in the cell.</paragraph>
+</section>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000404.xhp#insertdate"/>
+</section>
+<note id="par_id271698858088628">The date inserted is static.</note>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/InsertCurrentTime.xhp
b/source/text/scalc/01/InsertCurrentTime.xhp
new file mode 100644
index 0000000000..27d76b846d
--- /dev/null
+++ b/source/text/scalc/01/InsertCurrentTime.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="textscalc01InsertCurrentTimexhp" indexer="include"
status="PUBLISH">
+ <title id="tit">Insert Time</title>
+ <filename>/text/scalc/01/InsertCurrentTime.xhp</filename>
+ </topic>
+ </meta>
+<body>
+<bookmark branch="hid/.uno:InsertCurrentTime" id="bm_id331698855895220"
localize="false"/>
+<bookmark branch="index" id="bm_id181698857668572">
+<bookmark_value>cell;insert time</bookmark_value>
+<bookmark_value>insert time; in cell</bookmark_value>
+</bookmark>
+<section id="inserttime">
+ <h1 id="hd_id221698855935217"><variable id="h1"><link
href="text/scalc/01/InsertCurrentTime.xhp">Time</link></variable></h1>
+ <paragraph role="paragraph" id="par_id91577295463980">Inserts the current
time in the cell.</paragraph>
+</section>
+<section id="howtoget">
+ <embed href="text/scalc/00/00000404.xhp#inserttime"/>
+</section>
+<note id="par_id101698858105477">The time inserted is static.</note>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/main0104.xhp b/source/text/scalc/main0104.xhp
index 377d5ecb60..423cce7e9f 100644
--- a/source/text/scalc/main0104.xhp
+++ b/source/text/scalc/main0104.xhp
@@ -48,11 +48,8 @@
<embed href="text/shared/01/04100000.xhp#special_char"/>
<embed href="text/shared/01/formatting_mark.xhp#formatting_mark"/>
-<h2 id="hd_id761577295440343">Date</h2>
-<paragraph role="paragraph" id="par_id11577295470732">Inserts the current date
in the cell.</paragraph>
-
-<h2 id="hd_id131577295445736">Time</h2>
-<paragraph role="paragraph" id="par_id91577295463980">Inserts the current time
in the cell.</paragraph>
+<embed href="text/scalc/01/InsertCurrentDate.xhp#insertdate"/>
+<embed href="text/scalc/01/InsertCurrentTime.xhp#inserttime"/>
<h2 id="hd_id621577296064493">Field</h2>
<paragraph role="paragraph" id="par_id391577296078546">Opens a submenu for
selecting the date, sheet name or document title in the cell.</paragraph>
