Clear Sheet Data Only

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.

Example

<code>Clear Sheet Data Only ss_Example[1,1]</code> This example clear the spread sheet "ss_Example" from all data, but keeping the formatting intact.

Related Commands

• 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

See Also

• Simul8 Spreadsheets