Set Clear After Insert

Clears the formatting and other properties of a cell being written to when using the Insert write mode.

 

Input Arguments

 

0

Integer

Workbook Handle

The handle for the workbook returned from the Open Workbook File command.

1

Boolean

Clear Comments

Indicates if comments should be cleared from the

cell.

2

Boolean

Clear Formulas

Indicates if formulae should be cleared from the cell.

3

Boolean

Clear Formats

Indicates if formatting should be cleared from the

cell.

4

Boolean

Clear Notes

Indicates if notes should be cleared from the cell.

5

Boolean

Clear Outline

Indicates if outlines should be cleared from the cell.

 

Return Arguments

None.

 

Returned Status

 

SUCCESS

The insert behavior was set appropriately.

FAILURE

The workbook handle was invalid.

 

Remarks

When the write mode is set to Insert, the existing formats and other cell properties remain in the cell being written. Often, it is desired to clear out the existing formatting, formulas, and other properties of the cell such that the newly written cell is in a “default” configuration. This command makes that possible.