Version: Streamsheets 2.5

CLEARCELLS

Removes value, formula or format of cells in specified range.

Syntax

=CLEARCELLS(Range, [Type])

Arguments

Name	Description
Range	Range of cells to clear.
Type (optional)	Number to specify what to clear. Note: a combination of type numbers is supported too. Options (Defaults to 1): 1 : Clear cell value 2 : Clear cell formula

Return

TRUE on success or an error code otherwise.

Examples

Formula	Result	Comment
`${formula}`	TRUE	Clears the value of each cell in range A1:B1.
`${formula}`	TRUE	Same as before.
`${formula}`	TRUE	Clears value and formula of each cell in range A1:B1.
`${formula}`	TRUE	Deletes all cells in range A1:B1.