Custom LibreOffice Calc functions StripPinyin This code defines a function called StripPinyin which takes a string argument and returns a modified version of the string with pinyin tones removed. It ...

A function is a pre-defined calculation entered in a cell to help you analyze or manipulate data in a spreadsheet. All you have to do is add the arguments, and the calculation is automatically made ...

Once you are comfortable with inputting functions and formulas, the next step is to learn how to automate the processes. Calc includes over half a dozen tools to help you manipulate functions and ...

General considerations All "date" results are given as a long integer. Choose the format of the cell as a "date" format with a long year to see the result as an ordinary (i.e. julio-gregorian) date.

Calc, LibreOffice's equivalent to the Microsoft Excel spreadsheet application, has no fewer than 14 new functions with version 25.8. Since it's the part of LibreOffice I use the most, these ...