Jump to content

Macros/Calc

From The Document Foundation Wiki



The following macros can be used with LibreOffice Calc:

No. Example Basic Python
001 Copy content cell from Spreadsheet to other Go Go
002 Copy row data from sheet to other Go Go
016 Export a table as PDF Go ToDo
017 Spreadsheet population Go ToDo
018 Put a formula into a cell ToDo Go
019 Create a new named range Go ToDo
020 Using relative references with named expressions Go ToDo
021 Create named ranges from labels Go ToDo
022 Create a new database range Go ToDo
023 Sort a table using one column Go ToDo
024 Sort a table using multiple columns Go ToDo
025 Retrieve sorting information for cell range Go ToDo
026 Create a standard filter Go ToDo
027 Clear all filters for a sheet Go ToDo
028 Filtering multiple columns and using regular expressions Go ToDo
029 Create an advanced filter Go ToDo
030 Copy advanced filter results to different location Go ToDo
031 Find all occurrences of current selection (post #9) [| Go] 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