Libre office functions

Libre office functions

Use of LibreOffice for an office automation environment

Using simple formulas for calculations, like for example the sum of a range of cells, can be tedious and complicated. In the example below we calculate the sum of the prices using a simple formula.

​The best desktop office suite, LibreOffice, gets better

​The best desktop office suite, LibreOffice, gets better

LibreOffice also boasts improvements for importing old Microsoft Office documents in binary formats: DOC, XLS, and PPT files. It also does a better job of importing RTF files and Microsoft Visio projects. The program also now supports importing Microsoft Write (.wri) documents and Apple Keynote 6 (.key) presentations, and Gnumeric spreadsheet files.

Use of LibreOffice for an office automation environment

Use of LibreOffice for an office automation environment

The VLOOKUP function (short for Vertical LOOKUP) is a built-in Calc function that is designed to work with data that is organized into columns. For a specified value, the function finds (or looks up) the value in one column of data, and returns the corresponding value from another column. Once you understand how VLOOKUP works and how to use it you will be able to create more sophisticated spreadsheets and further automate your work.

How to Use the Built-in Calculator in LibreOffice Writer

How to Use the Built-in Calculator in LibreOffice Writer

At the time of writing this Introduction (January 2020), the Calc Functions wiki pages are under development. They will be populated as time allows. Initially each function’s page will include an information box near the top containing the text “Under construction. For now, see the system Help files.” When a page has been fully populated and reviewed, this information box will be removed.

String Processing in LibreOffice Calc Macro with Examples

String Processing in LibreOffice Calc Macro with Examples

In this tutorial, we will show how to do various common string processing using macro in LibreOffice. We will use LibreOffice Calc cells to use the strings for this tutorial. These processings are essential for any macro development.

How to start writing macros in LibreOffice Basic

How to start writing macros in LibreOffice Basic

A variable is declared using the statement Dim. You can declare several variables simultaneously, even different types, if you separate their names with commas. To determine the type of a variable with an explicit declaration, you can use either a corresponding keyword or a type-declaration sign after the name. If a type-declaration sign or a keyword is not used after the variable, then the Variant type is automatically assigned to it. For example:

Manual installation of the CoolProp Python package¶

Manual installation of the CoolProp Python package¶

The LibreOffice extension itself is platform-independent. In the background the extension uses the Python CoolProp package for all calculations. Thus, the CoolProp Python package must be installed for the Python interpreter that is used by LibreOffice.

LibreOffice 7.0 is Finally Available Now! Here are the Key Changes in this Major Release

CONS: One of the major drawbacks in using LibreOffice is that it was first launched in 2010 and the vendor does not have dedicated support available. Pretty much all you can get is a response from the community.

DIY: Add formulas to LibreOffice documents with LibreOffice Math

Because LibreOffice sees itself as upholding the tradition of the “legacy” OpenOffice, the Foundation has simply continued versioning, reaching release 4.1 when this issue went to press. The latest version offers some useful innovations – especially for the Writer word processing tool.