diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2017-05-19 11:12:14 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@edx.srv.br> | 2017-05-19 21:10:21 +0200 |
commit | eb145d19480d245228dc6b1032a925adbff8ea78 (patch) | |
tree | a676d273fb664649951bb95111f508518c108565 /source/text/sbasic/shared/special_vba_func.xhp | |
parent | 7c9323ff02e580187576204b014e04fa6f732c07 (diff) |
tdf#84675 Help VBA functions AscW, ChrW, InStrRev
These functions are enabled whith Option VBASupport 1
fix bookmark
Fix metas
Fix makefile & add InStrRev
Bookmarking
Fix category for DDB
Change-Id: I12fed1cd521ffb846d2994323013e8dcc127381f
Reviewed-on: https://gerrit.libreoffice.org/37826
Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
Diffstat (limited to 'source/text/sbasic/shared/special_vba_func.xhp')
-rw-r--r-- | source/text/sbasic/shared/special_vba_func.xhp | 160 |
1 files changed, 160 insertions, 0 deletions
diff --git a/source/text/sbasic/shared/special_vba_func.xhp b/source/text/sbasic/shared/special_vba_func.xhp new file mode 100644 index 0000000000..541870cea2 --- /dev/null +++ b/source/text/sbasic/shared/special_vba_func.xhp @@ -0,0 +1,160 @@ +<?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/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> + +<meta> + <topic id="textsbasicsharedspecial_vba_funcxml"> + <title id="tit" xml-lang="en-US">Exclusive VBA functions</title> + <filename>/text/sbasic/shared/special_vba_func.xhp</filename> + </topic> +</meta> + +<body> + + +<section id="exclusive_vba_functions"> +<bookmark xml-lang="en-US" branch="index" id="bm_id051920170350145208"> + <bookmark_value>VBA Functions</bookmark_value> +</bookmark> + + +<paragraph id="hd_id051820170313205718" role="heading" level="1" xml-lang="en-US"><variable id="exclusivevba"><link href="text/sbasic/shared/special_vba_func.xhp">Exclusive VBA functions</link></variable></paragraph> +<paragraph id="par_id051820170314436068" role="paragraph" xml-lang="en-US"><ahelp hid=".">%PRODUCTNAME Basic supports these functions when VBA support is enabled</ahelp></paragraph> +</section> +<paragraph id="hd_id051820170407499827" role="paragraph" xml-lang="en-US">The following VBA functions are enabled when <item type="literal">Option VBASupport 1</item> is the first line of a %PRODUCTNAME Basic module. </paragraph> +<bookmark xml-lang="en-US" branch="index" id="bm_id05192017035621676"> + <bookmark_value>VBA Functions;Text Functions</bookmark_value> +</bookmark> + + +<paragraph id="par_id051820170355592834" role="heading" level="3" xml-lang="en-US">Text functions</paragraph> + +<list type="unordered"> + <listitem> + <paragraph id="par_id051820170314431250" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/03120111.xhp">AscW</link></paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170331279953" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/03120112.xhp">ChrW</link></paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170331274373" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/03120411.xhp">InStrRev</link></paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335291322" role="paragraph" xml-lang="en-US">StrReverse</paragraph> + </listitem></list> +<bookmark xml-lang="en-US" branch="index" id="bm_id051920170357078705"> + <bookmark_value>VBA Functions;Financial Functions</bookmark_value> +</bookmark> + + +<paragraph id="par_id051820170355592581" role="heading" level="3" xml-lang="en-US">Financial functions</paragraph> + +<list type="unordered"> + <listitem> + <paragraph id="par_id051820170331271603" role="paragraph" xml-lang="en-US">DDB</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170331278736" role="paragraph" xml-lang="en-US">FV</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170331278779" role="paragraph" xml-lang="en-US">IPmt</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335282035" role="paragraph" xml-lang="en-US">IRR</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335284205" role="paragraph" xml-lang="en-US">MIRR</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335297182" role="paragraph" xml-lang="en-US">NPer</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335299474" role="paragraph" xml-lang="en-US">NPV</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335299272" role="paragraph" xml-lang="en-US">Pmt</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335298807" role="paragraph" xml-lang="en-US">PPmt</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335294050" role="paragraph" xml-lang="en-US">PV</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335292174" role="paragraph" xml-lang="en-US">Rate</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335295504" role="paragraph" xml-lang="en-US">SLN</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335294432" role="paragraph" xml-lang="en-US">SYD</paragraph> + </listitem></list> +<bookmark xml-lang="en-US" branch="index" id="bm_id051920170357347041"> + <bookmark_value>VBA Functions;Date and Time Functions</bookmark_value> +</bookmark> + + +<paragraph id="par_id051820170356005357" role="heading" level="3" xml-lang="en-US">Date and time functions</paragraph> + +<list type="unordered"> + <listitem> + <paragraph id="par_id051820170331271717" role="paragraph" xml-lang="en-US">FormatDateTime</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335292276" role="paragraph" xml-lang="en-US">WeekdayName</paragraph> + </listitem></list> +<bookmark xml-lang="en-US" branch="index" id="bm_id051920170358002074"> + <bookmark_value>VBA Functions;I/O Functions</bookmark_value> +</bookmark> + + +<paragraph id="par_id051820170356006501" role="heading" level="3" xml-lang="en-US">I/O Functions</paragraph> + +<list type="unordered"> + <listitem> + <paragraph id="par_id05182017033127432" role="paragraph" xml-lang="en-US">Input</paragraph> + </listitem></list> +<bookmark xml-lang="en-US" branch="index" id="bm_id051920170358346963"> + <bookmark_value>VBA Functions;Mathematical Functions</bookmark_value> +</bookmark> + + +<paragraph id="par_id051820170356005221" role="heading" level="3" xml-lang="en-US">Mathematical Functions</paragraph> + +<list type="unordered"> + <listitem> + <paragraph id="par_id051820170335293060" role="paragraph" xml-lang="en-US">Round</paragraph> + </listitem></list> +<bookmark xml-lang="en-US" branch="index" id="bm_id051920170359045662"> + <bookmark_value>VBA Functions;Object Functions</bookmark_value> +</bookmark> + + +<paragraph id="hd_id051920170347039686" role="heading" level="3" xml-lang="en-US">Object Functions</paragraph> + +<list type="unordered"> + <listitem> + <paragraph id="par_id051820170335289499" role="paragraph" xml-lang="en-US">Me</paragraph> + </listitem> + <listitem> + <paragraph id="par_id051820170335293856" role="paragraph" xml-lang="en-US">RTL</paragraph> + </listitem></list> +</body> + +</helpdocument>
\ No newline at end of file |