Jump to content

Macros pour LibreOffice ''Calc''

From The Document Foundation Wiki
This page is a translated version of the page Macros/Calc and the translation is 1% complete.
Outdated translations are marked like this.



No. Example Basic Python JavaScript
001 Copy content cell from Spreadsheet to other Go Go ToDo
002 Copy row data from sheet to other Go Go ToDo
016 Export a table as PDF Go ToDo ToDo
017 Spreadsheet population Go ToDo ToDo
018 Put a formula into a cell ToDo Go ToDo
019 Create a new named range Go ToDo ToDo
020 Using relative references with named expressions Go ToDo ToDo
021 Create named ranges from labels Go ToDo ToDo
022 Create a new database range Go ToDo ToDo
023 Sort a table using one column Go ToDo ToDo
024 Sort a table using multiple columns Go ToDo ToDo
025 Retrieve sorting information for cell range Go ToDo ToDo
026 Create a standard filter Go ToDo ToDo
027 Clear all filters for a sheet Go ToDo ToDo
028 Filtering multiple columns and using regular expressions Go ToDo ToDo
029 Create an advanced filter Go ToDo ToDo
030 Copy advanced filter results to different location Go ToDo ToDo

(See Macros/Calc/fr for more content.)

LibreOffice Basic

Refer to LibreOffice Basic Help for using Basic as a macro language.

Python

Refer to Python Scripts Help for an introduction to Python as a macro language.

JavaScript

Refer to JavaScript macros - xlated from japanese - for an introduction to JavaScript as a macro language.

To Add

* Hiding/Unhiding sheets based on cell content