Your spreadsheets will be accessible using any OpenDocument-compliant software. This XML-based format means that your files can be read even if the recipient is not a Calc user. You can save your spreadsheets in OpenDocument format, the new international standard for documents. This collaboration feature helps avoid editing conflicts. The spreadsheet owner can then easily integrate the new data, in just a few clicks. You can share a spreadsheet, so that other users can easily add their data to it. You can do collaborative work on spreadsheets, thanks to Calc's multiple-user support. LibreOffice Calc's solver component lets you solve optimization problems in which the optimum value of a particular spreadsheet cell has to be calculated based on constraints provided in other cells. Professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.Īdvanced DataPilot technology makes it easy to pull-in raw data from corporate databases, and then cross-tabulate, summarise, and convert it into meaningful information.

Newcomers find it intuitive and easy to learn. It helps others to know there was an accepted answer.LibreOffice Calc is the spreadsheet program you've always needed. If this answers your question please tick the (upper left area of answer). It is mostly for Python but shows how to directly access an open Calc document from a terminal. If you are looking to interact with Calc from a terminal, see this post → click here. Or on some systems: soffice 'macro:///(4)'ĭisplays the proper variable and message in a message box.Īnother note, when executing the macro from terminal and all of LO is closed, you will briefly see the LO splash screen displayed. Run from terminal as: libreoffice6.0 'macro:///(4)'

Īlso, this simple Sub: Sub FindSheet(aNumber) Subs work without or without parameters but it seems Functions will not (unless I am missing something).Ī sample of one is in my answer on this post → Base: Page header/footer not generated. It must be in the Standard library of My Macros. Executing macros from a terminal is not based upon the module the macro is associated with but rather where the actual macro resides.

Online libreoffice calc