AllLangHelp_sbasic.mk | 1 source/auxiliary/sbasic.tree | 1 source/text/sbasic/shared/main0601.xhp | 1 source/text/sbasic/shared/vba_objects.xhp | 178 ++++++++++++++++++++++++ source/text/scalc/01/04060118.xhp | 2 source/text/shared/optionen/01040200.xhp | 2 source/text/swriter/00/00000403.xhp | 2 source/text/swriter/guide/header_pagestyles.xhp | 2 8 files changed, 185 insertions(+), 4 deletions(-)
New commits: commit f2bf7ec5f1192052bc00bdb113885a41e6fb901b Author: Olivier Hallot <[email protected]> AuthorDate: Sat Jul 6 23:04:21 2024 +0200 Commit: Olivier Hallot <[email protected]> CommitDate: Sun Jul 7 17:08:23 2024 +0200 Fix example for COUPDAYS. Change-Id: Id63a3d2a80aa0c829d1507185467ff575beaac3a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170036 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/scalc/01/04060118.xhp b/source/text/scalc/01/04060118.xhp index 6857419ff2..d32fbc13e3 100644 --- a/source/text/scalc/01/04060118.xhp +++ b/source/text/scalc/01/04060118.xhp @@ -402,7 +402,7 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3147530" role="paragraph">A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days are there in the interest period in which the settlement date falls?</paragraph> -<paragraph id="par_id3156338" role="paragraph"><input>=COUPDAYS("2001-01-25"; "2001-11-15"; 2; 3)</input> returns 181.</paragraph> +<paragraph id="par_id3156338" role="paragraph"><input>=COUPDAYS("2001-01-25"; "2001-11-15"; 2; 3)</input> returns 182.5.</paragraph> </section> <section id="coupdaysnc"> commit a1ed29aa5320041c72f025e43a9eeabe3bdc2289 Author: Julien Nabet <[email protected]> AuthorDate: Sun Jul 7 12:37:21 2024 +0200 Commit: Julien Nabet <[email protected]> CommitDate: Sun Jul 7 14:15:10 2024 +0200 Fix dup in sbasic/shared/vba_objects.xhp Change-Id: Ia9019ca5f5129f5d2741941df19622de5ee403eb Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170109 Tested-by: Jenkins Reviewed-by: Julien Nabet <[email protected]> diff --git a/source/text/sbasic/shared/vba_objects.xhp b/source/text/sbasic/shared/vba_objects.xhp index 1c74b2f919..02537694cc 100644 --- a/source/text/sbasic/shared/vba_objects.xhp +++ b/source/text/sbasic/shared/vba_objects.xhp @@ -121,7 +121,7 @@ </section> <section id="xlsRows"> -<bookmark branch="index" id="bm_id051920181457078705"> +<bookmark branch="index" id="bm_id051920181457078706"> <bookmark_value>VBA Excel Model;Rows</bookmark_value> </bookmark> <h3 id="hd_id952719839364374" localize="false">Rows</h3> @@ -130,7 +130,7 @@ </section> <section id="xlsWorkbook"> -<bookmark branch="index" id="bm_id051920181457078705"> +<bookmark branch="index" id="bm_id051920181457078707"> <bookmark_value>VBA Excel Model;Workbook</bookmark_value> </bookmark> <h3 id="hd_id063719839364374" localize="false">Workbook</h3> @@ -142,7 +142,7 @@ </section> <section id="xlsWorksheet"> -<bookmark branch="index" id="bm_id051920181457078705"> +<bookmark branch="index" id="bm_id051920181457078708"> <bookmark_value>VBA Excel Model;Worksheet</bookmark_value> </bookmark> <h3 id="hd_id174719839364374" localize="false">Worksheet</h3> commit ce6b950180c0174cd1b73b37b9fbf7310fe56dbf Author: Andrea Gelmini <[email protected]> AuthorDate: Sun Jul 7 09:19:09 2024 +0200 Commit: Julien Nabet <[email protected]> CommitDate: Sun Jul 7 10:17:00 2024 +0200 Fix typo Change-Id: Ie15138e64d647d669a57a4cfa7c530cd43ad294a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170085 Tested-by: Jenkins Reviewed-by: Julien Nabet <[email protected]> diff --git a/source/text/sbasic/shared/vba_objects.xhp b/source/text/sbasic/shared/vba_objects.xhp index 0fdb9637d2..1c74b2f919 100644 --- a/source/text/sbasic/shared/vba_objects.xhp +++ b/source/text/sbasic/shared/vba_objects.xhp @@ -23,7 +23,7 @@ <bookmark_value>VBA Model;Supported objects</bookmark_value> </bookmark> <h1 id="hd_id051820170313205718"><variable id="Title"><link href="text/sbasic/shared/vba_objects.xhp">VBA supported Data Model</link></variable></h1> -<paragraph id="par_id051820170314436068" role="paragraph">%PRODUCTNAME Basic adds this set of functionalies when VBA Office support is active.</paragraph> +<paragraph id="par_id051820170314436068" role="paragraph">%PRODUCTNAME Basic adds this set of functionalities when VBA Office support is active.</paragraph> </section> <paragraph id="hd_id051820170407499827" role="paragraph">These exclusive %PRODUCTNAME VBA objects properties and methods are enabled when:</paragraph> commit e859581bf5302296634127cd7bb6576f6e3ec932 Author: Alain Romedenne <[email protected]> AuthorDate: Fri Jun 7 10:13:07 2024 +0200 Commit: Olivier Hallot <[email protected]> CommitDate: Sat Jul 6 21:31:28 2024 +0200 tdf#149786 tdf#161495 VBA objects & properties & methods (WiP) - ActiveSheet object - (Calc).ExportAsfixedFormat method This initiates a documentation help page intended to aggregate MSOffice VBA objects features that are currently supported. Change-Id: I679e9a64923b69fd0d1a5ac99d39651fd8353fc7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/168530 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk index 00484ce127..7c1670d4f0 100644 --- a/AllLangHelp_sbasic.mk +++ b/AllLangHelp_sbasic.mk @@ -432,6 +432,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\ helpcontent2/source/text/sbasic/shared/thisdbdoc \ helpcontent2/source/text/sbasic/shared/uno_objects \ helpcontent2/source/text/sbasic/shared/vbasupport \ + helpcontent2/source/text/sbasic/shared/vba_objects \ helpcontent2/source/text/sbasic/python/main0000 \ helpcontent2/source/text/sbasic/python/python_2_basic \ helpcontent2/source/text/sbasic/python/python_dialogs \ diff --git a/source/auxiliary/sbasic.tree b/source/auxiliary/sbasic.tree index 679d849a15..ed9ac472c2 100644 --- a/source/auxiliary/sbasic.tree +++ b/source/auxiliary/sbasic.tree @@ -57,6 +57,7 @@ <topic id="sbasic/text/sbasic/shared/uno_objects.xhp">UNO Objects, Functions and Services</topic> <topic id="sbasic/text/sbasic/shared/calc_functions.xhp">Calling Calc functions</topic> <topic id="sbasic/text/sbasic/shared/special_vba_func.xhp">Exclusive VBA functions</topic> + <topic id="sbasic/text/sbasic/shared/vba_objects.xhp">VBA Supported Model</topic> <topic id="sbasic/text/sbasic/shared/03090400.xhp">Further Statements</topic> </node> <node id="07010201" title="Alphabetic List of Functions, Statements and Operators"> diff --git a/source/text/sbasic/shared/main0601.xhp b/source/text/sbasic/shared/main0601.xhp index 289dfb5ba5..72e3c47c1b 100644 --- a/source/text/sbasic/shared/main0601.xhp +++ b/source/text/sbasic/shared/main0601.xhp @@ -50,6 +50,7 @@ <h3 id="hd_id05182017030838384">Working with VBA Macros</h3> <embed href="text/sbasic/shared/vbasupport.xhp#vbamacros"/> <embed href="text/sbasic/shared/special_vba_func.xhp#exclusivevba"/> +<embed href="text/sbasic/shared/vba_objects.xhp#Title"/> <h3 id="hd_id191548155077269">Working with Macros in Python</h3> diff --git a/source/text/sbasic/shared/vba_objects.xhp b/source/text/sbasic/shared/vba_objects.xhp new file mode 100644 index 0000000000..0fdb9637d2 --- /dev/null +++ b/source/text/sbasic/shared/vba_objects.xhp @@ -0,0 +1,178 @@ +<?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 https://mozilla.org/MPL/2.0/. + * +--> + +<meta> + <topic id="textsbasicsharedvba_objectsxml" indexer="include" status="PUBLISH"> + <title id="tit" >VBA Supported Objects</title> + <filename>/text/sbasic/shared/vba_objects.xhp</filename> + </topic> +</meta> +<body> + +<section id="exclusive_vba_objects"> + <bookmark branch="index" id="bm_id051920170350145208"> + <bookmark_value>VBA Model;Introduction</bookmark_value> + <bookmark_value>VBA Model;Supported objects</bookmark_value> + </bookmark> +<h1 id="hd_id051820170313205718"><variable id="Title"><link href="text/sbasic/shared/vba_objects.xhp">VBA supported Data Model</link></variable></h1> +<paragraph id="par_id051820170314436068" role="paragraph">%PRODUCTNAME Basic adds this set of functionalies when VBA Office support is active.</paragraph> +</section> + +<paragraph id="hd_id051820170407499827" role="paragraph">These exclusive %PRODUCTNAME VBA objects properties and methods are enabled when:</paragraph> +<list type="unordered"> + <listitem> + <paragraph id="par_id731719825012469" role="listitem">• A Basic module is set with <literal>VBAModule</literal> special attribute.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id851719825107422" role="listitem">• <item type="literal">Option VBASupport 1</item> compiler statement is placed before the first macro of the VBA Basic module.</paragraph> + </listitem> +</list> +<paragraph role="paragraph" id="par_id201719827126856">A few VBA objects are supported for <link href="text/sbasic/shared/vba_objects.xhp#xlsm">Excel</link>, <link href="text/sbasic/shared/vba_objects.xhp#pptm">Powerpoint</link> and <link href="text/sbasic/shared/vba_objects.xhp#docm">Word</link> application files. Limited properties and methods are available for VBA objects.</paragraph> +<embed href="text/shared/need_help.xhp#needhelp"/> + +<section id="VBACommon"> +<bookmark branch="index" id="bm_id71543455697570"> +<bookmark_value>VBA Model;Err object</bookmark_value> +</bookmark> +<h2 id="hd_id31543446449360">Common objects</h2> +</section> + +<comment> MSOffice Excel --------------------------------------------------------------------------------------</comment> + +<h2 id="par_id051820170355592581">Excel Objects, Properties and Methods</h2> + <table id="tab_id801719842343187"> + <tablerow> + <tablecell colspan="3"> + <paragraph id="par_id981719842343187" role="tablehead">Excel supported VBA objects</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell><paragraph id="par_id761719842343187" role="tablecontent" localize="false"> + <link href="text/sbasic/shared/vba_objects.xhp#xlsApplication">Application</link><br/> + <link href="text/sbasic/shared/vba_objects.xhp#xlsColumns">Columns</link><br/> + </paragraph></tablecell> + <tablecell><paragraph id="par_id951719842343187" role="tablecontent" localize="false"> + <link href="text/sbasic/shared/vba_objects.xhp#xlsRange">Range</link><br/> + <link href="text/sbasic/shared/vba_objects.xhp#xlsRows">Rows</link><br/> + </paragraph></tablecell> + <tablecell><paragraph id="par_id141719842343187" role="tablecontent" localize="false"> + <link href="text/sbasic/shared/vba_objects.xhp#xlsWorkbook">Workbook</link><br/> + <link href="text/sbasic/shared/vba_objects.xhp#xlsWorksheet">Worksheet</link><br/> + </paragraph></tablecell> + </tablerow> +</table> + +<section id="xlsApplication"> +<bookmark branch="index" id="bm_id051920170357078705"> +<bookmark_value>VBA Excel Model;Application</bookmark_value> +</bookmark> +<h3 id="hd_id61719826422710">Application</h3> + <paragraph role="paragraph" id="par_id641719824037432"><emph>Properties</emph></paragraph> + + <list type="unordered"> + <listitem><paragraph id="par_id341719823872468" role="listitem" localize="false">ActiveCell : <link href="text/sbasic/shared/vba_objects.xhp#xlsRange">Range</link></paragraph></listitem> + <listitem><paragraph id="par_id341719834972468" role="listitem" localize="false">ActiveSheet : <link href="text/sbasic/shared/vba_objects.xhp#xlsWoksheet">Worksheet</link></paragraph></listitem> + <listitem><paragraph id="par_id341820823872468" role="listitem" localize="false">ActiveWorkbook : <link href="text/sbasic/shared/vba_objects.xhp#xlsWorkbook">Workbook</link></paragraph></listitem> + <listitem><paragraph id="par_id452719823872468" role="listitem" localize="false">DefaultFilePath : String</paragraph></listitem> + <listitem><paragraph id="par_id563719823872468" role="listitem" localize="false">DisplayAlerts : Boolean</paragraph></listitem> + <listitem><paragraph id="par_id674719823872468" role="listitem" localize="false">LibraryPath : String</paragraph></listitem> + <listitem><paragraph id="par_id675829823872468" role="listitem" localize="false">Name : String</paragraph></listitem> + <listitem><paragraph id="par_id785719823872468" role="listitem">PathSeparator : String - see <link href="text/sbasic/shared/GetPathSeparator.xhp">GetPathSeparator</link> function</paragraph></listitem> + </list> + <paragraph role="paragraph" id="par_id281719824053043"><emph>Methods</emph></paragraph> + <list type="unordered"> + <listitem><paragraph id="par_id491719824275851" role="listitem" localize="false">Quit</paragraph></listitem> + </list> +</section> + +<section id="xlsCell"> +<h3 id="hd_id361719826690873">Columns</h3> + <paragraph role="paragraph" id="par_id811719824767080"><emph>Properties</emph></paragraph> + <list type="unordered"> + <listitem><paragraph id="par_id501719825375862" role="listitem" localize="false">Address : String</paragraph></listitem> + </list> + <paragraph role="paragraph" id="par_id561719824768137"><emph>Methods</emph></paragraph> + <list type="unordered"> + <listitem><paragraph id="par_id141719826728738" role="listitem" localize="false">Item(ndx : Variant) : Column</paragraph></listitem> + </list> +</section> + +<section id="xlsRange"> +<bookmark branch="index" id="bm_id051920181457078705"> +<bookmark_value>VBA Excel Model;Range</bookmark_value> +</bookmark> +<h3 id="hd_id841719839364374" localize="false">Range</h3> + <paragraph role="paragraph" id="par_id851719824771480"><emph>Properties</emph></paragraph> + <paragraph role="paragraph" id="par_id591719824772015"><emph>Methods</emph></paragraph> + <list type="unordered"> + <listitem> + <paragraph id="par_id751720021450554" role="listitem" localize="false"><variable id="ExportAsFixedFormat"></variable><link href="text/sbasic/shared/exportasfixedformat.xhp">ExportAsFixedFormat</link>(Optional Type : Integer = xlTypePDF, Optional FileName : String, Optional Quality : Integer = xlQualityStandard, Optional IncludeDocProperties : Boolean, Optional IgnorePrintAreas = Boolean, Optional OpenAfterPublish : Boolean)</paragraph> + </listitem> +</list> + +</section> + +<section id="xlsRows"> +<bookmark branch="index" id="bm_id051920181457078705"> +<bookmark_value>VBA Excel Model;Rows</bookmark_value> +</bookmark> +<h3 id="hd_id952719839364374" localize="false">Rows</h3> + <paragraph role="paragraph" id="par_id851719824782580"><emph>Properties</emph></paragraph> + <paragraph role="paragraph" id="par_id591719824883015"><emph>Methods</emph></paragraph> +</section> + +<section id="xlsWorkbook"> +<bookmark branch="index" id="bm_id051920181457078705"> +<bookmark_value>VBA Excel Model;Workbook</bookmark_value> +</bookmark> +<h3 id="hd_id063719839364374" localize="false">Workbook</h3> + <paragraph role="paragraph" id="par_id851710934771480"><emph>Properties</emph></paragraph> + <paragraph role="paragraph" id="par_id591710934772015"><emph>Methods</emph></paragraph> + <list type="unordered"> + <listitem><paragraph id="par_id252719827838738" role="listitem"><embedvar href="text/sbasic/shared/vba_objects.xhp#ExportAsFixedFormat"/></paragraph></listitem> + </list> +</section> + +<section id="xlsWorksheet"> +<bookmark branch="index" id="bm_id051920181457078705"> +<bookmark_value>VBA Excel Model;Worksheet</bookmark_value> +</bookmark> +<h3 id="hd_id174719839364374" localize="false">Worksheet</h3> + <paragraph role="paragraph" id="par_id862810934771480"><emph>Properties</emph></paragraph> + <paragraph role="paragraph" id="par_id591721034772015"><emph>Methods</emph></paragraph> + <list type="unordered"> + <listitem><paragraph id="par_id252820927838738" role="listitem"><embedvar href="text/sbasic/shared/vba_objects.xhp#ExportAsFixedFormat"/></paragraph></listitem> + </list></section> + +<comment> MSOffice Powerpoint ---------------------------------------------------------------------------------</comment> + +<bookmark branch="index" id="bm_id051920170358002074"> +<bookmark_value>VBA Powerpoint Model;Application</bookmark_value> +</bookmark> +<h2 id="par_id051820170356006501">PowerPoint Objects, Properties and Methods</h2> + +<comment> MSOffice Word ---------------------------------------------------------------------------------------</comment> + +<bookmark branch="index" id="bm_id051920170359045662"> +<bookmark_value>VBA Word;Application</bookmark_value> +</bookmark> +<h2 id="hd_id051920170347039686">Word Objects, Properties and Methods</h2> + + +<section id="relatedtopics"> +<paragraph id="par_id051720170424259343" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/vbasupport.xhp">VBA support in %PRODUCTNAME</link></paragraph> +<paragraph id="par_id051720171119254111" role="paragraph" xml-lang="en-US"><link href="text/shared/optionen/01130100.xhp">VBA Properties</link></paragraph> +<embed href="text/sbasic/shared/special_vba_func.xhp#exclusivevba"/> +<embed href="text/sbasic/shared/03103350.xhp#vbasupportstatement"/> +</section> + +</body> +</helpdocument> commit 5e39c70b93559a266ba9f68344fe8c4c3f2feacf Author: Ilmari Lauhakangas <[email protected]> AuthorDate: Mon Jul 1 13:52:18 2024 +0300 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Jul 1 13:13:21 2024 +0200 Update menu item path to Field Hidden Paragraphs Change-Id: I6f89dcd355ac8cea53b8e94137a6c3b2faade74b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169801 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/shared/optionen/01040200.xhp b/source/text/shared/optionen/01040200.xhp index a72ea5f7b9..44d48ca5b8 100644 --- a/source/text/shared/optionen/01040200.xhp +++ b/source/text/shared/optionen/01040200.xhp @@ -82,7 +82,7 @@ <paragraph role="paragraph" id="par_id3149413"><ahelp hid="modules/swriter/ui/optformataidspage/hiddentextfield">Displays text that is hidden by <emph>Conditional Text</emph> or <emph>Hidden Text</emph> fields.</ahelp></paragraph> <bookmark branch="hid/modules/swriter/ui/optformataidspage/hiddenparafield" id="bm_id468764" localize="false"/> <h3 id="hd_id3149300">Hidden paragraphs</h3> -<paragraph role="paragraph" id="par_id3149418"><ahelp hid="modules/swriter/ui/optformataidspage/hiddenparafield">Display paragraphs that contain a <emph>Hidden Paragraph</emph> field.</ahelp> This option has the same function as the menu command <switchinline select="appl"><caseinline select="WRITER"><link href="text/swriter/01/03140000.xhp"><menuitem>View - Field Hidden Paragraphs</menuitem></link></caseinline><defaultinline>View - Hidden Paragraphs</defaultinline></switchinline>.</paragraph> +<paragraph role="paragraph" id="par_id3149418"><ahelp hid="modules/swriter/ui/optformataidspage/hiddenparafield">Display paragraphs that contain a <emph>Hidden Paragraph</emph> field.</ahelp> This option has the same function as the menu command <link href="text/swriter/01/03140000.xhp"><menuitem>View - Field Hidden Paragraphs</menuitem></link>.</paragraph> <h2 id="hd_id541711370751566">Display tracked changes</h2> <bookmark branch="hid/modules/swriter/ui/viewoptionspage/changesinmargin" id="bm_id221711385765261" localize="false"/> <h3 id="hd_id641711371294636">Tracked deletions in margin</h3> diff --git a/source/text/swriter/00/00000403.xhp b/source/text/swriter/00/00000403.xhp index 88af2dbbd3..8febf1a55c 100644 --- a/source/text/swriter/00/00000403.xhp +++ b/source/text/swriter/00/00000403.xhp @@ -165,7 +165,7 @@ <section id="hidden_para"> <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> - <paragraph id="par_id3149808" role="paragraph" xml-lang="en-US">Choose <menuitem>View - Hidden Paragraphs</menuitem></paragraph> + <paragraph id="par_id3149808" role="paragraph" xml-lang="en-US">Choose <menuitem>View - Field Hidden Paragraphs</menuitem></paragraph> </section> </body> commit 8351b40030008eec294de3712fc1b67d99d00931 Author: Olivier Hallot <[email protected]> AuthorDate: Fri Jun 28 14:36:11 2024 +0200 Commit: Olivier Hallot <[email protected]> CommitDate: Fri Jun 28 15:42:48 2024 +0200 Organizer -> General in Help pages Change-Id: Ibe5a9e819138b964a5f7336f9d4a71c5d43dc1bb Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169683 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/swriter/guide/header_pagestyles.xhp b/source/text/swriter/guide/header_pagestyles.xhp index b24542d08a..11a7fbb467 100644 --- a/source/text/swriter/guide/header_pagestyles.xhp +++ b/source/text/swriter/guide/header_pagestyles.xhp @@ -69,7 +69,7 @@ <paragraph id="par_id3150748" role="listitem">In the <menuitem>Page Styles</menuitem> dialog, click the <menuitem>Header</menuitem> tab.</paragraph> </listitem> <listitem> - <paragraph id="par_id3153172" role="listitem">Select <menuitem>Header on</menuitem> and click the <menuitem>Organizer</menuitem> tab.</paragraph> + <paragraph id="par_id3153172" role="listitem">Select <menuitem>Header on</menuitem> and click the <menuitem>General</menuitem> tab.</paragraph> </listitem> <listitem> <paragraph id="par_id3147061" role="listitem">In the <menuitem>Next Style</menuitem> box, select "Right Page".</paragraph>
