Tip: Ignoring elements

Sometimes you want to ignore elements of your spreadsheet to store notes, equations or hide temporary values. With MetaSheets you can literally comment out columns, rows or sheets (tabs). Once commented out these elements will not be compiled into MetaSheet’s generated class file.

Ignoring rows or columns

To ignore an entire column place a // in front of the column label (label are always in the first row). The same applies to rows and if your first column is of type string, simply add a // in front of the identifier to ignore that row.

Ignoring sheets

You can also ignore entire sheets (tabs) of your spreadsheet by simply adding a // in front of the sheet name. Of course you can still reference values from these sheets within your spreadsheet but the sheet itself will not be included itself.

Better annotations

From personal experience I would advise to not add ignored rows and columns for annotation purposes. Instead use colors, conditional formatting or add notes (Ctrl + Alt + M) to communicate with the rest of the team. Adding an ‘@’ character followed by a team members name will even send them an email.

In the above image you can see color separation of themed ID’s and adding a comment.