Collabora Office 24.04 Súgó
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.
Megadja, hogy a Collabora Office Basic támogat-e a néhány VBA utasítást, függvényt vagy objektumot.
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.
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.
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.