Clear Sheet

Clears a Simul8 spreadsheet, deleting all data and any formatting features, graphs, buttons or other features.

Parameters

• Spreadsheet - Spreadsheet to be cleared. Set [c,r] to [1,1].

Comments
Simul8 spreadsheets do not get initialized, meaning that their content remains when a simulation is Reset. This is occasionally undesirable so Clear Sheet is a way of emptying all content.

Clear Sheet    ss_Example[1,1]

This example clears all contents from sheet “ss_Example” including graphs, headings and data.

• Copy Sheet Area
• Copy Sheet Column
• Copy Sheet Row
• Count Sheet Area
• Count Sheet Area Non Zero
• Sum Sheet Area
• Search Sheet Area
• Clear Sheet
• Clear Sheet Area
• Clear Sheet Data Only
• Insert Row
• Insert Column
• Insert Cell Vertical
• Insert Cell Horizontal
• Delete Row
• Delete Column
• Delete Cell Vertical
• Delete Cell Horizontal

• Simul8 Spreadsheets