Clear Sheet Area

Clears a block of cells in a spread sheet.

Parameters

• Spread sheet[c,r] - Name of the spread sheets that needs to be partially cleared. Please enter the first cell to be cleared between the brackets [].
• Columns - Enter the number of columns that need to be cleared from the starting position.
• Rows - Enter the number of rows that need to be cleared from the starting position.

Comments

The Clear Sheet Area is designed to clear one particular part of a given spread sheet. When multiple parts within the same spread sheet need to be cleared, please use this command several times with the corresponding values.

Clear Sheet Area    ss_Example[2,2] ,  2 ,  3

This example will clear a part of the sheet named “ss_Example”. It will start from the cell at column 2, row 2 and will clear a block of cells of 2 columns wide and 3 rows high. In total six cells will be cleared.

• 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 Data Only
• Insert Row
• Insert Column
• Insert Cell Vertical
• Insert Cell Horizontal
• Delete Row
• Delete Column
• Delete Cell Vertical
• Delete Cell Horizontal

• Simul8 Spreadsheets