Exclusive VBA Functions and Statements
LibreOffice Basic adds this set of functions when VBA support is enabled.
These exclusive VBA functions are enabled when the statement Option VBASupport 1 is placed before the first macro of a LibreOffice Basic module.
VBA Statements
Option Compatible turns on the VBA-compatible Basic compiler mode at the module level.
Specifies that the module is a class module that contains members, properties, procedures and functions.
Define enumerations or non UNO constant groups. An enumeration is a value list that facilitates programming and eases code logic review.
Text functions
A karakterlánc kifejezés első karakterének Unicode értékét adja vissza.
Visszaadja a megadott karakterkódnak megfelelő Unicode karaktert.
Returns the position of a string within another string, starting from the right side of the string.
Fordított sorrendben adja vissza karakterláncot.
Financial functions
Egy tárgyi eszköz értékcsökkenését számítja ki adott időszakra, az évek számjegyösszegével dolgozó módszer alapján.
A befektetés jövőértékét adja vissza, periodikus, állandó kifizetések és állandó kamatláb alapján (jövőérték).
Kiszámítja a rendszeres befizetésekkel és állandó kamatlábbal tett befektetés periodikus törlesztését.
Kiszámítja egy befektetés belső megtérülési rátáját.
Calculates the modified internal rate of return of a series of investments.
Calculates the number of periods for a loan or investment.
Calculates the Net Present Value of an investment, based on a supplied discount rate, and a series of deposits and withdrawals.
Calculates the constant periodic payments for a loan or investment.
Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate.
Returns the Present Value of an investment resulting from a series of regular payments.
Returns the interest rate of a loan or an investment.
Returns the straight-line depreciation of an asset for one period. The amount of the depreciation is constant during the depreciation period.
Returns the arithmetic-declining depreciation rate.
Date and time functions
Applies a date and/or time format to a date expression and returns the result as a string.
The MonthName function returns the localized month name of a specified month number.
The WeekdayName function returns the weekday name of a specified day of the week.
I/O Functions
Returns the open stream of an Input or Binary file (String).
Mathematical Functions
The Round function returns a number rounded to a specified number of digits.
Returns a string with a number formatting applied to a numeric expression.
Returns a string indicating where a number occurs within a calculated series of ranges.
Object Properties and Methods
Use VBA Err object to raise or handle runtime errors.