AllLangHelp_scalc.mk | 1
source/text/scalc/00/sheet_menu.xhp | 25 +++++++-
source/text/scalc/01/events_sheet.xhp | 103 ++++++++++++++++++++++++++++++++++
source/text/shared/01/06140500.xhp | 6 +
4 files changed, 132 insertions(+), 3 deletions(-)
New commits:
commit 9b8794b4b681e2c4f148ca626c766d961e0e3078
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu May 25 15:38:08 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu May 25 22:12:55 2023 +0200
Add Sheet Events Help page, update command paths
Change-Id: I90d0b82c143d467e48aed65bb422c0323875ece2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152285
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 87956ac0c1..9165ee3fbb 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -193,6 +193,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/databar_more_options \
helpcontent2/source/text/scalc/01/default_number_formats \
helpcontent2/source/text/scalc/01/duplicate_sheet \
+ helpcontent2/source/text/scalc/01/events_sheet \
helpcontent2/source/text/scalc/01/ex_data_stat_func \
helpcontent2/source/text/scalc/01/format_graphic \
helpcontent2/source/text/scalc/01/formula2value \
diff --git a/source/text/scalc/00/sheet_menu.xhp
b/source/text/scalc/00/sheet_menu.xhp
index baafdb1132..7ddb37c708 100644
--- a/source/text/scalc/00/sheet_menu.xhp
+++ b/source/text/scalc/00/sheet_menu.xhp
@@ -182,8 +182,8 @@
</tablerow>
</table>
</section>
-<comment>Move or copy sheet</comment>
+<comment>Move or copy sheet</comment>
<section id="move_or_copy_sheet">
<embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
<paragraph id="par_id3146119" role="paragraph">Choose <emph>Sheet - Move or
Copy Sheet</emph>.</paragraph>
@@ -227,6 +227,29 @@
</table>
</section>
+<comment>Sheet events</comment>
+<section id="sheetevents">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph role="paragraph" id="par_id621685036766205">Choose
<menuitem>Sheet - Sheet Events</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id681685036795260">Choose
<menuitem>Layout - Sheet Events</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_sheet_bar"/>
+ <paragraph role="paragraph" id="par_id631685036821963">Choose
<menuitem>Sheet Events</menuitem></paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id391685036844839">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id461685036844841" role="paragraph">
+ <image src="cmd/lc_animationeffects.svg" id="img_id221685036844842"
width="1cm" height="1cm"><alt id="alt_id271685036844843">Icon Sheet
Events</alt></image>
+ </paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id421685036844845" role="paragraph">Sheet
Events</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+</section>
+
<paragraph id="par_id160220162106567373" role="paragraph"><variable
id="insert_rows_above">Choose <emph>Sheet - Insert Rows - Rows
Above</emph>.</variable></paragraph>
<paragraph id="par_id160220162109048207" role="paragraph"><variable
id="insert_rows_below">Choose <emph>Sheet - Insert Rows - Rows
Below</emph>.</variable></paragraph>
<paragraph id="par_id160220162107055028" role="paragraph"><variable
id="insert_columns_left">Choose <emph>Sheet - Insert Columns - Columns
Before</emph>.</variable></paragraph>
diff --git a/source/text/scalc/01/events_sheet.xhp
b/source/text/scalc/01/events_sheet.xhp
new file mode 100644
index 0000000000..0624409b8d
--- /dev/null
+++ b/source/text/scalc/01/events_sheet.xhp
@@ -0,0 +1,103 @@
+<?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="sheetevents" indexer="include" status="PUBLISH">
+ <title id="tit">Sheet Events</title>
+ <filename>/text/scalc/01/events_sheet.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark branch="index" id="bm_id81685035133668">
+ <bookmark_value>sheet;events</bookmark_value>
+ <bookmark_value>events;sheet only</bookmark_value>
+</bookmark>
+<section id="sheetevents">
+ <h1 id="hd_id841685031890653"><variable id="h1"><link
href="text/scalc/01/events_sheet.xhp">Sheet Events</link></variable></h1>
+ <paragraph id="par_id671685031890655" role="paragraph">%PRODUCTNAME Calc
specific sheet events. You can assign a macro to each sheet event.</paragraph>
+</section>
+<section id="howtoget">
+ <embed href="text/scalc/00/sheet_menu.xhp#sheetevents"/>
+</section>
+<paragraph role="paragraph" id="par_id451685032666328">The following table
describes the events available in %PRODUCTNAME spreadsheets.</paragraph>
+
+<table id="tab_id61685032748193">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id961685032748193"
role="tablehead">Event</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id731685032748193"
role="tablehead">Description</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id531685032748194" role="tablecontent">Activate
Document</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id51685032748194" role="tablecontent">Worksheet
has been activated (made visible). </paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id641685032856321"
role="tablecontent">Deactivate Document</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121685032856321"
role="tablecontent">Worksheet has been deactivated (made not visible).
</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id501685032920132"
role="tablecontent">Selection changed</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id261685032920133"
role="tablecontent">Selection in sheet has been changed.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id91685032963484" role="tablecontent">Double
click</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id281685032963485" role="tablecontent">Double
click in the sheet.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id871685033010062" role="tablecontent">Right
Click</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id131685033010062" role="tablecontent">Right
click in the sheet.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id331685033039088" role="tablecontent">Formulas
calculated</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id161685033039088" role="tablecontent">Cells in
sheet have been recalculated.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id521685033082599" role="tablecontent">Contents
changed</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id21685033082599" role="tablecontent">Cells in
sheet have been changed.</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id591685032723771"
localize="false"><embedvar href="text/shared/01/06140500.xhp#h1"
markup="ignore"/></paragraph>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/shared/01/06140500.xhp
b/source/text/shared/01/06140500.xhp
index c5fd4deb87..c94993700b 100644
--- a/source/text/shared/01/06140500.xhp
+++ b/source/text/shared/01/06140500.xhp
@@ -34,7 +34,7 @@
<bookmark branch="hid/cui/ui/macroassignpage/@@nowidget@@"
id="bm_id1163922276" localize="false"/>
<bookmark branch="hid/cui/ui/macroassigndialog/MacroAssignDialog"
id="bm_id1163922277" localize="false"/>
<bookmark branch="hid/cui/ui/macroassigndialog/@@nowidget@@"
id="bm_id1163922277" localize="false"/>
- <h1 id="hd_id3152427"><link
href="text/shared/01/06140500.xhp">Events</link></h1>
+ <h1 id="hd_id3152427"><variable id="h1"><link
href="text/shared/01/06140500.xhp">Events</link></variable></h1>
<paragraph role="paragraph" id="par_id3152937"><variable
id="assignaction"><ahelp hid=".">Assigns macros to program events. The assigned
macro runs automatically every time the selected event
occurs.</ahelp></variable></paragraph>
</section>
<section id="howtoget">
@@ -43,7 +43,7 @@
</section>
<switch select="appl">
<case select="CALC">
- <note id="par_id317748820">The dialog box has reduced functionality when
called from the Edit-Sheet menu of a spreadsheet.</note>
+ <embed href="text/scalc/01/events_sheet.xhp#sheetevents"/>
</case>
</switch>
<bookmark branch="hid/cui/ui/eventsconfigpage/savein" id="bm_id1163975"
localize="false"/><h2 id="par_idN1060A">Save In</h2>
@@ -57,6 +57,7 @@
<bookmark branch="hid/cui/ui/eventsconfigpage/macro" id="bm_id752891"
localize="false"/>
<h2 id="hd_id3159258">Assign Macro</h2>
<paragraph role="paragraph" id="par_id3156152"><ahelp hid=".">Opens the <link
href="text/shared/01/06130020.xhp">Macro Selector</link> to assign a macro to
the selected event.</ahelp></paragraph>
+<bookmark branch="hid/ cui/ui/assigncomponentdialog/@@nowidget@@"
id="bm_id411685039364972" localize="false"/>
<h2 id="hd_id751568966764822">Assign Component...</h2>
<paragraph role="paragraph" id="par_id111568966885228">Opens the
<literal>Assign Component</literal> dialog to set a <link
href="text/sbasic/python/python_handler.xhp">custom UNO command</link> for the
selected event.</paragraph>
<note id="par_id291568910019716">Component assignment is proposed for controls
in the Dialog Editor.</note>
@@ -68,6 +69,7 @@
<paragraph role="paragraph" id="par_id3159147"><link
href="text/swriter/01/05060700.xhp">List of events</link></paragraph>
<embed href="text/shared/guide/configure_overview.xhp#configure_overview"/>
<paragraph role="paragraph" id="par_id831568910303156"><link
href="text/sbasic/python/python_handler.xhp">Creating a Dialog
Handler</link></paragraph>
+ <paragraph role="paragraph" id="par_id731685035928996"
localize="false"><embedvar href="text/scalc/01/events_sheet.xhp#h1"
markup="ignore"/></paragraph>
</section>
</body>
</helpdocument>
