# 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. |

COLORReturn a value calculated by combining R G and B and the alpha channel, in the RGBA color system. |

CONVERT_ADDConverts a number from one measurement system to another. |

CUMIPMT_ADDReturns the total interest paid on a loan in specified periodic payments. |

CUMPRINC_ADDReturns the total capital repaid on a loan in specified periodic payments. |

CURRENTReturns the current (to date) result of evaluating the formula. |

DAYSINMONTHReturns the number of days in a month. |

DAYSINYEARReturns the number of days in a year. |

DDEReturns data from a DDE-based link. |

DURATION_ADDReturns the Macaulay duration of a security. |

EASTERSUNDAYReturns the date of Easter Sunday in a given year. |

EFFECT_ADDReturns the effective compounded interest rate given a nominal interest rate. |

EFFECTIVEReturns the net annual interest rate for a nominal interest rate. |

ERRORTYPEReturns the number corresponding to an error value occurring in a different cell. |

FORMULAReturns the formula used in a cell as a text string. |

GCD_ADDReturns the greatest common divisor of two or more integers. (inc negative numbers) |

ISEVEN_ADDReturns 1 if the value is an even number, or 0 if the value is odd. |

ISLEAPYEARTests if a date is in a leap year. |

ISODD_ADDReturns 1 if the value is an odd number, or 0 if the value is even. |

LCM_ADDReturns the least common multiple of one or more integers. |

MONTHSReturns the number of months between two dates. |

NOMINAL_ADDReturns a nominal interest rate given the effective compounded interest rate. |

RAND.NVGenerates a uniformly distributed random number in the range 0 (inclusive) to 1 (exclusive). (non volatile) |

RANDBETWEEN.NVGenerates a random integer that lies in a specified range. (non volatile) |

RAWSUBTRACTCan be used to compare whether a result exactly matches an expected number |

ROT13Provides a very weak encryption that may be used to obfuscate the casual reader. |

STYLEApplies a style (for example, a color) to a cell. |

WEEKNUM_ADDReturns the non-ISO week number of a given date. |

WEEKSReturns the number of weeks between two dates. |

WEEKSINYEARReturns the number of weeks in a year. |

YEARSReturns the number of years between two dates. |

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext