SpreadsheetDocumentRange.Clear

Syntax:

Clear(<ClearText>, <ClearTheFormatting>, <ClearBorders>)

Parameters:

<ClearText> (optional)

Type: Boolean.
Determines whether to clear text of cells in a spreadsheet document or not. True - clear text, False - do not clear text.
Default value: True.

<ClearTheFormatting> (optional)

Type: Boolean.
Determines whether to clear format of cells in a spreadsheet document or not. True - clear format, False - do not clear format.
Default value: False.

<ClearBorders> (optional)

Type: Boolean.
Determines whether to delete cell borders of the spreadsheet document area or not. True - delete borders; False - do not delete borders.
Default value: False.

Description:

Clears area contents.

Availability:

Thin client, web-client, server, thick client, external connection, Mobile application (client), Mobile application (server).

Example:

Area.Clear(); // clears text in the Area area

    

1C:Enterprise Developer's Community