Clears the formatting and other properties of a cell being written to when using the Insert write mode.
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. |
None.
SUCCESS |
The insert behavior was set appropriately. |
FAILURE |
The workbook handle was invalid. |
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.