Macros for LibreOffice Calc
Appearance
< Macros
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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.