LIBREOFFICE CALC PROGRAMMING
Preface to LibreOffice Calc programming
You will be ready for engineering programming after completing this tutorial. Section 12.4 concludes the first part of this tutorial with a bubble sort sample program. It combines many of the elements described in the first part of the manual. It includes, variables, loops, if statements, lists, and functions.
Table of Contents
Chapter 1 - Introduction to LibreOffice Calc Programming
- 1.1 Calc screen
- 1.2 Starting out in Worksheet
- 1.3 Saving your work from Worksheet
- 1.4 Syntax for general form of programs
- 1.5 Basic Editor screen and creating a library
- 1.6 Two basic programs
- 1.7 Basic program parts
- 1.8 Variables
- 1.9 Arrays
Chapter 2 - LibreOffice Calc Basic Loops
- 2.1 For next loop
- 2.2 Do while loop
- 2.3 Comments
- 2.4 Endless loop
- 2.5 Do until loops
Chapter 3 - LibreOffice Calc Basic If Statements
- 3.1 If-then-else
- 3.2 If-then
- 3.3 Nested If-then-else
- 3.4 If-elseif-else
- 3.5 Select case statements
Chapter 4 - LibreOffice Calc Basic Functions vs. Worksheet Formulas & Functions
- 4.1 Worksheet formulas and functions
- 4.2 Custom Basic functions
- 4.3 Brief subroutine discussion
- 4.4 Example custom function
Chapter 5 - LibreOffice Calc Subroutines and Functions
- 5.1 Calling a subroutine and a function
- 5.2 Example program calling a subroutine and function with parameters
- 5.3 Avoid duplicate functions in code window
Chapter 6 - Read Data from and Write data to a Worksheet from Basic Code Window
- 6.1 Reading and writing from single cells
- 6.2 Reading and writing from a list of values
Chapter 7 - LibreOffice Calc Basic programming operators
Chapter 8 - LibreOffice Calc Basic Built-In Functions
- 8.1 Built-in math functions
Chapter 9 - Built-In Basic Functions: Exponential form of Decimals, Log Base 10, Log Bse E, Trigonometric Functions, Format
- 9.1 Exponential forms
- 9.2 Base 10, and natural logarithms
- 9.3 Trigonometric functions
- 9.4 Format numbers
Chapter 10 - LibreOffice Calc Basic Debugging
Chapter 11 - Running Macro Subroutines from the Worksheet
- 11.1 Macro selector box
- 11.2 Creating a worksheet button
- 11.3 Computer Lockups
Chapter 12 - More Example Calc Basic Programs
- 12.1 Passing by value or by reference
- 12.2 Program calling a subroutine with variables and an array as parameters
- 12.3 Local, static variables in a function or subroutine
- Public, global variables in a module and library
- Private variables in a module
- Option explicit
- 12.4 Ascending bubble sort of array fo values with public variables
Chapter 13 - Calc Worksheet Functions and Formulas
- 13.1 Built-in worksheet functions
- 13.2 Worksheet formula example
- 13.3 Worksheet formula from worksheet data
- 13.4 Worksheet formula from named cells
- 13.5 Named cells and subroutines
- 13.6 Named cells and custom basic functions
Chapter 14 - Make a Custom Function from an Existing Function
- 14.1 Copy and paste notes
- 14.2 Basic functions vs. worksheet functions
Chapter 15 - Screenshot of Calc Basic Help Page