Spreadsheets
Spreadsheet in a file
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.
Insert a spreadsheet in a file:
 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.
Sort and filter
You can sort and filter ranges in a spreadsheet. Learn more in the links to the Blockpad website below.
Conditional formatting
You can also conditionally format cells using Blockpad Style Rules.
Blockpad specific features
Units
Blockpad spreadsheet formulas have all the features of dynamic equations described in Calculations. So, you can do things like math with units.
Named cells
You can use a formula to assign a name to a cell, then use that name to reference it.
Custom functions
You can create your own functions and use them in the spreadsheet.
Reference document values
You can also reference values from other locations in the file.
Multiline cells
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.
Show formula
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.
Control cell formula visibility:
 Select a cell with a formula.
 Open the properties window.
 Near the bottom, under Formula, toggle Show Formula, Show Name, or Show Result.
Open a CSV
You can open a .csv file as a spreadsheet in Blockpad, then use it for your calculations.
Open a .csv file as a spreadsheet:
 Select File>Open in the toolbar.
 In the bottom right of the window that appears, change "All supported files (*bpad, ...)" to "CSV (commadelimited) (*.csv)".
 Navigate to file you wish to open, select it, and click Open.
 Click the Edit as Blockpad file button.
 Treat the spreadsheet contents like any other Blockpad spreadsheet content.
Often old csv files have numbers with no units assigned. For a quick way to assign units to these tables, see the section about it in the scripts deep dive.
Minispreadsheets in a document
Blockpad also supports minispreadsheet tables inside of a document. See the section on tables in calculations for more information.
Table of Contents

 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 autoupdated references
 Built in values
 Visual editor
 Math layout options
 Show steps and more
 Value formatting

 Text values
 Date and time arithmetic
 Logic and Boolean values
 Matrices and arrays
 Enter an array or matrix
 Array names
 Matrix calculations
 Itembyitem calculations
 Arrays  more than just numbers
 Array formulas in spreadsheets
 Array parentheses lookup
 Assign individual value names
 Advanced array functions
 Complex numbers
 Spreadsheet in a file
 Sort and filter
 Conditional formatting
 Blockpad specific features
 Open a CSV file
 Minispreadsheets in a document
 Reports in a file
 Header and footer
 Page layout properties
 Comments
 Document navigation
 Documentwide formatting
 Start a drawing
 Drawing objects
 Lines, points, and shapes
 Text labels
 Linear dimension labels
 Textboxes
 Images
 Selecting multiple objects
 Ordering objects
 Using the point snapping
 Points you can snap to
 Horizontal and vertical from points
 Parallel or perpendicular lines
 Point snap options
 Transformations  resizing and moving
 Format drawings
 Keyboard input and canvas scales
 Notebooks in a file
 Reference values from other top level frames
 Working in a notebook
 Notebook pages
 Top level frames
 Frames in Frames
 Value containers and location
 Frames and sections are containers
 Containers inside containers
 Dot notation to specify a value in a container
 Capture values
 What is a block?
 Block example
 Use the block results
 Block inputs
 View block as table
 Block instances and block definitions
 More examples
 Create a block
 When to make a block
 Make a block with Blockpad calculations
 Update a block definition
 Create a block using scripts
 Block tables
 Examples library
 Use library items in a document
 Use the long form library item name
 Assign a shortcut name to the library
 Include a library in a file
 Use a library number value
 Use a library function
 Use items in a library frame
 Use a library data table as function
 Use library blocks
 Core, builtin, and subscription libraries
 Create personal libraries
 Save items to your library
 Manage your library online
 Library subscriptions
 Console basics
 Read values from the console
 Overwrite values from the console
 Use read and write to manipulate values
 Assign units to numbers in a cell range
 Stemscript basics for scripts
 Macros
 Module functions