Collabora Office 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 Collabora Office Basic module.
Text functions
Returns the Unicode value of the first character in a string expression.
Returns the Unicode character that corresponds to the specified character code.
Returns the position of a string within another string, starting from the right side of the string.
Returns the string with the character order reversed.
Financial functions
Returns the depreciation of an asset for a specified period using the arithmetic-declining method.
Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).
Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.
Calculates the internal rate of return for an investment.
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.
Object Functions
About Us | Privacy Policy | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Mozilla Public License v2.0 . “LibreOffice” and “The Document Foundation” are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in TDF's trademark policy . Collabora Office is derived from LibreOffice which was based on OpenOffice.org.