Exercise <exercise_number> - Meta
This is the sheet where you put all the general information of spreadsheets. This is information
that can be described as key-value pairs (for example
title: Sheets course). The information is
described in column
A and column
A holds the keys (like
B holds the
Sheets course). This might look something like this:
Specifically, the following fields can be set:
- title: title of the exercise - plain text
- assignment: assignment of the exercise - markdown rendered text
- instructions: instructions of the exercise - markdown rendered text, for instructions we always use between 2-4 bullet points
- hint: hint of the exercise - markdown rendered text, for a hint we always use between 2-4 bullet points
- highlight: specifies which parts of the sheet are highlighted when the user lands on the
exercise - one range (e.g.
F5:G6, ...) or a list of ranges, separated by a semicolon (e.g.
- success_message: success_message of the exercise. This will be shown when an exercises is completed.
- type: the type of the exercise. More on this in the section about other
exercises. Defaults to
data_selectors: this is a field that gives you control over what data is preserved between exercises. As we mentioned before, not all data is preserved between exercises (that's what we need a Golden Copy for). More info on this will follow in the part about the solution sheet. The
data_selectorsfield lets you control which data is preserved. The value should be a list of keywords, separated by a comma (
values, formulas. The keywords are:
- values: the raw values in each cell, no formulas
- formulas: the formulas in each cell
- numberFormat: the number format in each cell. This controls whether
0is shown as
0.00, for example
- pivotTables: all pivot tables in the sheet
- charts: all charts in the sheet
styles: all style information in the sheet. This includes column widths, row widths, borders, and number format. It does not include merging cells or conditional formatting. Note that including styles will cause the
highlightfield to be ignored. This keyword is a superset of
numberFormat. You can use them both, but using only
styleswill have the same effect.
data_selectorsare set, the default is
values, formulas, numberFormat, pivotTables, charts.