From 9d965444a9b787726e67c6eb5bbcb8ca9a5de8d2 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Fri, 16 Jun 2017 00:50:10 -0300 Subject: tdf#84675 Add VBA functions to tree file Add current VBA functions to the tree (Contents tab) Change-Id: I433cd9a77fd1fe6a15ea6778a475a96840299a3c Reviewed-on: https://gerrit.libreoffice.org/38857 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/auxiliary/sbasic.tree | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) diff --git a/source/auxiliary/sbasic.tree b/source/auxiliary/sbasic.tree index 7818c21ff4..9448d65874 100644 --- a/source/auxiliary/sbasic.tree +++ b/source/auxiliary/sbasic.tree @@ -30,6 +30,7 @@ Watch Window Macro Toolbar Macro +Working with VBA Macros Using Procedures and Functions @@ -44,8 +45,10 @@ Numeric Functions Controlling Program Execution Variables +Basic Constants Comparison Operators Strings +Exclusive VBA functions Other Commands @@ -53,6 +56,7 @@ AND Operator [Runtime] Array Function [Runtime] Asc Function [Runtime] +AscW Function [Runtime VBA] Atn Function [Runtime] Beep Statement [Runtime] Blue Function [Runtime] @@ -77,6 +81,7 @@ ChDrive Statement [Runtime] Choose Function [Runtime] Chr Function [Runtime] +ChrW Function [Runtime - VBA] Close Statement [Runtime] Comparison Operators [Runtime] Const Statement [Runtime] @@ -93,6 +98,7 @@ DateValue Function [Runtime] Date Statement [Runtime] Day Function [Runtime] +DDB Function [Runtime - VBA] Declare Statement [Runtime] DefBool Statement [Runtime] DefDate Statement [Runtime] @@ -127,10 +133,11 @@ Fix Function [Runtime] For...Next Statement [Runtime] Format Function [Runtime] -FreeFile Function[Runtime] +FreeFile Function [Runtime] FreeLibrary Function [Runtime] Function Statement [Runtime] Further Statements +FV Function [Runtime -VBA] Generating Random Numbers GetAttr Function [Runtime] GetProcessServiceManager Function [Runtime] @@ -148,9 +155,11 @@ If...Then...Else Statement [Runtime] Imp-Operator [Runtime] InStr Function [Runtime] +InStrRev Function [Runtime - VBA] InputBox Function [Runtime] Input# Statement [Runtime] Int Function [Runtime] +IPmt Function [Runtime - VBA] IsArray Function [Runtime] IsDate Function [Runtime] IsEmpty Function [Runtime] @@ -189,6 +198,7 @@ Open Statement [Runtime] Option Base Statement [Runtime] Option Explicit Statement [Runtime] +Option VBASupport Statement [Runtime] Optional (in Function Statement) [Runtime] Or-Operator [Runtime] Print Statement [Runtime] @@ -223,6 +233,7 @@ Stop Statement [Runtime] StrComp Function [Runtime] Str Function [Runtime] +StrReverse Function [Runtime - VBA] String Function [Runtime] Sub Statement [Runtime] Switch Function [Runtime] -- cgit v1.2.3