1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
|
<?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" indexer="include" status="PUBLISH">
<title id="tit">Exclusive VBA functions</title>
<filename>/text/sbasic/shared/special_vba_func.xhp</filename>
</topic>
</meta>
<body>
<section id="exclusive_vba_functions">
<bookmark branch="index" id="bm_id051920170350145208">
<bookmark_value>VBA Functions;Introduction</bookmark_value>
</bookmark>
<h1 id="hd_id051820170313205718"><variable id="exclusivevba"><link href="text/sbasic/shared/special_vba_func.xhp">Exclusive VBA Functions and Statements</link></variable></h1>
<paragraph id="par_id051820170314436068" role="paragraph"><ahelp hid=".">%PRODUCTNAME Basic adds this set of functions when VBA support is enabled.</ahelp></paragraph>
</section>
<paragraph id="hd_id051820170407499827" role="paragraph">These exclusive VBA functions are enabled when the statement <item type="literal">Option VBASupport 1</item> is placed before the first macro of a %PRODUCTNAME Basic module. </paragraph>
<section id="vbastatements">
<bookmark branch="index" id="bm_id71543455697570">
<bookmark_value>VBA Statements</bookmark_value>
</bookmark>
<h2 id="hd_id31543446449360">VBA Statements</h2>
<comment> Option Compatible is not a VBA statement, it extends LibreOffice Basic constructs. </comment>
<embed href="text/sbasic/shared/classmodule.xhp#classmodulefunction"/>
<embed href="text/sbasic/shared/03103350.xhp#optionVBASupport"/>
<embed href="text/sbasic/shared/enum.xhp#enumheading"/>
</section>
<section id="VBAString">
<bookmark branch="index" id="bm_id05192017035621676">
<bookmark_value>VBA Functions;Text Functions</bookmark_value>
</bookmark>
<h2 id="par_id051820170355592834">Text functions</h2>
<embed href="text/sbasic/shared/03120111.xhp#ascw"/>
<embed href="text/sbasic/shared/03120112.xhp#chrw"/>
<embed href="text/sbasic/shared/03120411.xhp#instrrev"/>
<embed href="text/sbasic/shared/03120412.xhp#strreverse"/>
<embed href="text/sbasic/shared/strconv.xhp#vbastrconv"/>
</section>
<section id="VBAFinancial">
<bookmark branch="index" id="bm_id051920170357078705">
<bookmark_value>VBA Functions;Financial Functions</bookmark_value>
</bookmark>
<h2 id="par_id051820170355592581">Financial functions</h2>
<embed href="text/sbasic/shared/03140000.xhp#ddb"/>
<embed href="text/sbasic/shared/03140001.xhp#fv"/>
<embed href="text/sbasic/shared/03140002.xhp#ipmt"/>
<embed href="text/sbasic/shared/03140003.xhp#irr"/>
<embed href="text/sbasic/shared/03140004.xhp#mirr"/>
<embed href="text/sbasic/shared/03140005.xhp#nper"/>
<embed href="text/sbasic/shared/03140006.xhp#npv"/>
<embed href="text/sbasic/shared/03140007.xhp#pmt"/>
<embed href="text/sbasic/shared/03140008.xhp#ppmt"/>
<embed href="text/sbasic/shared/03140009.xhp#pv"/>
<embed href="text/sbasic/shared/03140010.xhp#rate"/>
<embed href="text/sbasic/shared/03140011.xhp#sln"/>
<embed href="text/sbasic/shared/03140012.xhp#syd"/>
</section>
<section id="VBADateTime">
<bookmark branch="index" id="bm_id051920170358102074">
<bookmark_value>VBA Functions;Date and Time Functions</bookmark_value>
</bookmark>
<h2 id="par_id051820170356005357">Date and time functions</h2>
<embed href="text/sbasic/shared/03150000.xhp#FormatDateTime"/>
<embed href="text/sbasic/shared/03150002.xhp#MonthName"/>
<embed href="text/sbasic/shared/03150001.xhp#WeekdayName"/>
</section>
<section id="VBAIO">
<bookmark branch="index" id="bm_id051920170358002074">
<bookmark_value>VBA Functions;I/O Functions</bookmark_value>
</bookmark>
<h2 id="par_id051820170356006501">I/O Functions</h2>
<embed href="text/sbasic/shared/03160000.xhp#Input"/>
<embed href="text/sbasic/shared/exportasfixedformat.xhp#exportasfixedformat"/>
</section>
<section id="VBAMath">
<bookmark branch="index" id="bm_id051920170358346963">
<bookmark_value>VBA Functions;Mathematical Functions</bookmark_value>
<bookmark_value>VBA Functions;formatting numbers</bookmark_value>
<bookmark_value>VBA Functions;partitioning numbers</bookmark_value>
</bookmark>
<h2 id="par_id051820170356005221">Mathematical Functions</h2>
<embed href="text/sbasic/shared/03170000.xhp#Round"/>
<embed href="text/sbasic/shared/03170010.xhp#formatnumber"/>
<embed href="text/sbasic/shared/03170020.xhp#formatPercent"/>
<embed href="text/sbasic/shared/partition.xhp#vbapartition"/>
</section>
<section id="VBAObject">
<bookmark branch="index" id="bm_id051920170359045662">
<bookmark_value>VBA Functions;Object Properties and Methods</bookmark_value>
</bookmark>
<h2 id="hd_id051920170347039686">Object Properties and Methods</h2>
<embed href="text/sbasic/shared/ErrVBA.xhp#VBAErrObject"/>
</section>
<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/vba_objects.xhp#Title"/>
<embed href="text/sbasic/shared/03103350.xhp#vbasupportstatement"/>
</section>
</body>
</helpdocument>
|
