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.
You can also conditionally format cells using Blockpad Style Rules.
Blockpad specific features
Blockpad spreadsheet formulas have all the features of dynamic equations described in Calculations. So, you can do things like math with units.
You can use a formula to assign a name to a cell, then use that name to reference it.
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.
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.
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 (comma-delimited) (*.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.
Mini-spreadsheets in a document
Blockpad also supports mini-spreadsheet 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 auto-updated 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
- Item-by-item 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
- Mini-spreadsheets in a document
- Reports in a file
- Header and footer
- Page layout properties
- Document navigation
- Document-wide formatting
- Start a drawing
- Drawing objects
- Lines, points, and shapes
- Text labels
- Linear dimension labels
- 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, built-in, 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
- Module functions
- Accessing Blockpad
- Using the app
- The online environment
- The desktop environment
- Other file types
- Program updates
- Company management