Clear Sheet Data Only

Clears a Simul8 spreadsheet from all data on the sheet, but keeping formatting intact (remember to tick “Retain format” in the spread sheet view), such as names of columns or rows.

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 Data only is a way of emptying all content.

Clear Sheet Data Only    ss_Example[1,1]

This example clear the spread sheet “ss_Example” from all data, but keeping the formatting intact.

• 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