LibreOffice Calc
LibreOffice is the successor to OpenOffice.org.
link - libreoffice.org/discover/libreoffice-vs-openoffice/
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. |
COLOR
Return a value calculated by combining R G and B and the alpha channel, in the RGBA color system.
link - help.libreoffice.org/latest/ro/text/scalc/01/func_color.html
CONVERT_ADD
Converts a number from one measurement system to another.
CONVERT_OOO
The functions whose names end with _ADD or _EXCEL2003 return the same results as the corresponding Microsoft Excel 2003 functions without the suffix.
Use the functions without suffix to get results based on international standards.
CUMIPMT_ADD
Returns the total interest paid on a loan in specified periodic payments.
link - wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CUMIPMT_ADD_function
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.
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html
DAYSINYEAR
Returns the number of days in a year.
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html
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)
link - wiki.documentfoundation.org/Documentation/Calc_Functions/GCD_EXCEL2003
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html
Microsoft Excel
The GCD function in Excel returns an error if any of the arguments are negative values.
GCD(-8, 16) = #NUM!
LibreOffice Calc
The GCD function in LibreOffice returns a value if any of the arguments are negative values.
GCD(-8; 16) = -8
The GCD_ADD or GCD_EXCEL2003 function in LibreOffice provides an identical function to Excel.
GCD_ADD(-8; 16) = #NUM!
GCD_EXCEL2003(-8; 16) = #NUM!
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.
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html
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.
LCM_EXCEL2003
MONTHS
Returns the number of months between two dates.
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html
NOMINAL_ADD
Returns a nominal interest rate given the effective compounded interest rate.
The NOMINAL_ADD function will return the same value as the NOMINAL function in Excel.
In LibreOffice the NOMINAL function (without the suffix) will return results based on international standards.
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060119.html
RAND.NV
Generates a uniformly distributed random number in the range 0 (inclusive) to 1 (exclusive). (non volatile)
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html
RANDBETWEEN.NV
Generates a random integer that lies in a specified range. (non volatile)
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html
RAWSUBTRACT
Can be used to compare whether a result exactly matches an expected number.
link - help.libreoffice.org/6.1/he/text/scalc/01/func_rawsubtract.html
ROT13
Provides a very weak encryption that may be used to obfuscate the casual reader.
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html
STYLE
Applies a style (for example, a color) to a cell.
link - help.libreoffice.org/latest/en-US/text/scalc/01/func_style.html
WEEKNUM_ADD
Returns the US convention week number of a given date.
The US convention defines the week containing January 1st to be the first week of the year.
link - help.libreoffice.org/latest/en-US/text/scalc/01/func_weeknum.html
WEEKNUM_EXCEL2003
WEEKNUM_OOO
Excel - ISOWEEKNUM
Returns the European convention week number of a given date.
The European convention however defines the first week as the first one containing four or more days.
WEEKS
Returns the number of weeks between two dates.
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html
WEEKSINYEAR
Returns the number of weeks in a year.
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html
YEARS
Returns the number of years between two dates.
link - help.libreoffice.org/latest/en-US/text/scalc/01/04060111.html
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext