LibreOffice Calc

LibreOffice is the successor to OpenOffice.org.

link - libreoffice.org/discover/libreoffice-vs-openoffice/

New Functions - August 2024

These 9 functions were added in LibreOffice 24.8.

FILTER	Returns the array of data in a range that satisfies multiple conditions.
LET	Returns the result of a formula that can use variables.
RANDARRAY	Returns the array of random numbers between 0 and 1.
SEQUENCE	Returns the array of sequential numbers.
SORT	Returns the array of data in a range that has been sorted.
SORTBY	Returns the array of data in a range that has been sorted based on the values in a corresponding range.
UNIQUE	Returns the array of unique values in a list, table or cell range.
XLOOKUP	Returns the value in the same row after finding a matching value in any column.
XMATCH	Returns the position of a value in a list, table or cell range.

FILTER Returns the array of data in a range that satisfies multiple conditions.
LET Returns the result of a formula that can use variables.
RANDARRAY Returns the array of random numbers between 0 and 1.
SEQUENCE Returns the array of sequential numbers.
SORT Returns the array of data in a range that has been sorted.
SORTBY Returns the array of data in a range that has been sorted based on the values in a corresponding range.
UNIQUE Returns the array of unique values in a list, table or cell range.
XLOOKUP Returns the value in the same row after finding a matching value in any column.
XMATCH Returns the position of a value in a list, table or cell range.

LibreOffice Only Functions

The following functions are only available in LibreOffice Calc.

COLOR	Return a value calculated by combining R G and B and the alpha channel, in the RGBA color system.
CONVERT_ADD	Converts a number from one measurement system to another.
CUMIPMT_ADD	Returns the total interest paid on a loan in specified periodic payments.
CUMPRINC_ADD	Returns the total capital repaid on a loan in specified periodic payments.
CURRENT	Returns the current (to date) result of evaluating the formula.
DAYSINMONTH	Returns the number of days in a month.
DAYSINYEAR	Returns the number of days in a year.
DDE	Returns data from a DDE-based link.
DURATION_ADD	Returns the Macaulay duration of a security.
EASTERSUNDAY	Returns the date of Easter Sunday in a given year.
EFFECT_ADD	Returns the effective compounded interest rate given a nominal interest rate.
EFFECTIVE	Returns the net annual interest rate for a nominal interest rate.
ERRORTYPE	Returns the number corresponding to an error value occurring in a different cell.
FORMULA	Returns the formula used in a cell as a text string.
GCD_ADD	Returns the greatest common divisor of two or more integers. (inc negative numbers)
ISEVEN_ADD	Returns 1 if the value is an even number, or 0 if the value is odd.
ISLEAPYEAR	Tests if a date is in a leap year.
ISODD_ADD	Returns 1 if the value is an odd number, or 0 if the value is even.
LCM_ADD	Returns the least common multiple of one or more integers.
MONTHS	Returns the number of months between two dates.
NOMINAL_ADD	Returns a nominal interest rate given the effective compounded interest rate.
RAND.NV	Generates a uniformly distributed random number in the range 0 (inclusive) to 1 (exclusive). (non volatile)
RANDBETWEEN.NV	Generates a random integer that lies in a specified range. (non volatile)
RAWSUBTRACT	Can be used to compare whether a result exactly matches an expected number
ROT13	Provides a very weak encryption that may be used to obfuscate the casual reader.
STYLE	Applies a style (for example, a color) to a cell.
WEEKNUM_ADD	Returns the non-ISO week number of a given date.
WEEKS	Returns the number of weeks between two dates.
WEEKSINYEAR	Returns the number of weeks in a year.
YEARS	Returns the number of years between two dates.

COLOR Return a value calculated by combining R G and B and the alpha channel, in the RGBA color system.
CONVERT_ADD Converts a number from one measurement system to another.
CUMIPMT_ADD Returns the total interest paid on a loan in specified periodic payments.
CUMPRINC_ADD Returns the total capital repaid on a loan in specified periodic payments.
CURRENT Returns the current (to date) result of evaluating the formula.
DAYSINMONTH Returns the number of days in a month.
DAYSINYEAR Returns the number of days in a year.
DDE Returns data from a DDE-based link.
DURATION_ADD Returns the Macaulay duration of a security.
EASTERSUNDAY Returns the date of Easter Sunday in a given year.
EFFECT_ADD Returns the effective compounded interest rate given a nominal interest rate.
EFFECTIVE Returns the net annual interest rate for a nominal interest rate.
ERRORTYPE Returns the number corresponding to an error value occurring in a different cell.
FORMULA Returns the formula used in a cell as a text string.
GCD_ADD Returns the greatest common divisor of two or more integers. (inc negative numbers)
ISEVEN_ADD Returns 1 if the value is an even number, or 0 if the value is odd.
ISLEAPYEAR Tests if a date is in a leap year.
ISODD_ADD Returns 1 if the value is an odd number, or 0 if the value is even.
LCM_ADD Returns the least common multiple of one or more integers.
MONTHS Returns the number of months between two dates.
NOMINAL_ADD Returns a nominal interest rate given the effective compounded interest rate.
RAND.NV Generates a uniformly distributed random number in the range 0 (inclusive) to 1 (exclusive). (non volatile)
RANDBETWEEN.NV Generates a random integer that lies in a specified range. (non volatile)
RAWSUBTRACT Can be used to compare whether a result exactly matches an expected number
ROT13 Provides a very weak encryption that may be used to obfuscate the casual reader.
STYLE Applies a style (for example, a color) to a cell.
WEEKNUM_ADD Returns the non-ISO week number of a given date.
WEEKS Returns the number of weeks between two dates.
WEEKSINYEAR Returns the number of weeks in a year.
YEARS Returns the number of years between two dates.