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.hallot@libreoffice.org>
author: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-05-25 15:38:08 -0300
committer: Olivier Hallot <olivier.hallot@libreoffice.org> 2023-05-25 22:12:55 +0200
commit: 9b8794b4b681e2c4f148ca626c766d961e0e3078 (patch)
tree: 1f29938df668649ae4f25a8c924bfb095cc786ec /source
parent: 027d282ebbf0cd889772eb646b756f7ee374105b (diff)
3 files changed, 131 insertions, 3 deletions
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>
author	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-05-25 15:38:08 -0300
committer	Olivier Hallot <olivier.hallot@libreoffice.org>	2023-05-25 22:12:55 +0200
commit	9b8794b4b681e2c4f148ca626c766d961e0e3078 (patch)
tree	1f29938df668649ae4f25a8c924bfb095cc786ec /source
parent	027d282ebbf0cd889772eb646b756f7ee374105b (diff)