A spreadsheet frame works and acts exactly like a spreadsheet, but with Blockpad formula features.

Plus, you can reference document values from a spreadsheet, so your calculations can be connected.

- Click the insert button.
- Select spreadsheet.
- Click OK.

For the basics, you can have tables of text and numbers.

You can have cells with formulas for math calculations, and use normal spreadsheet functions inside of them.

You can sort and filter ranges in a spreadsheet. Learn more in the links to the Blockpad website below.

You can also conditionally format cells using Blockpad Style Rules.

Blockpad spreadsheet formulas have all the features of dynamic equations described in Calculations. So, you can do things like math with units.

You can assign names to values and use them in other places.

And create your own functions.

You can also reference values from other locations in the file.

You can change a cell to be multiline, where you can do anything that can be done in a report. See multiline cells in Calculations to learn how.

In spreadsheets some things are not displayed in a formula after entering. In a spreadsheet cell, the formula is automatically hidden. Only the result and the assigned name are shown. If there is not an assigned name, then only the result is shown.

You can show and hide formulas and results, just like in dynamic equations.

- Select a cell with a formula.
- Open the properties window.
- Near the bottom, under
*Formula*, toggle*Show Formula*,*Show Name*, or*Show Result*.

Blockpad also supports mini-spreadsheet tables inside of a document. See the section on tables in calculations for more information.

- Start a new document
- Dynamic equations
- Unit tracking
- Value names
- Reference unnamed values
- Text values
- Other value types
- Referencing a value
- Value name rules
- Names used multiple times
- Renaming and auto-updated references
- Built in values
- Show steps and more
- Value formatting
- Tables
- Fields
- Functions
- Equation solving
- Date and time arithmetic
- Logic and Boolean values
- Matrices and arrays
- Enter an array or matrix
- Array names
- Matrix calculations
- Arrays - more than just numbers
- Array formulas in spreadsheets
- Array parentheses lookup
- Advanced array functions
- Complex numbers