Collabora Office 24.04 Help
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.
Specifies that the module is a class module that contains members, properties, procedures and functions.
Specifies that Collabora Office Basic will support some VBA statements, functions and objects.
Define enumerations or non UNO constant groups. An enumeration is a value list that facilitates programming and eases code logic review.
Returns the position of a string within another string, starting from the right side of the string.
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 Net Present Value of an investment, based on a supplied discount rate, and a series of deposits and withdrawals.
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 straight-line depreciation of an asset for one period. The amount of the depreciation is constant during the depreciation period.
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.
Returns a string with a number formatting applied to a numeric expression. A percent sign is appended to the returned string.
Returns a string indicating where a number occurs within a calculated series of ranges.