Description:
Clear the cell value.
Syntax:
clear a:b,c,d:e
Note:
The function clears values and #@ in certain cells. With only a: specified, it clears the cell values in a code block where a is the master cell.
Parameter:
|
a:b,c,d:e |
The cells whose values need to be cleared |
Example:
|
|
A |
|
|
1 |
=demo.query("select * from EMPLOYEE") |
|
|
2 |
clear A1 |
Clear value of cell A1. |
|
|
A |
B |
|
|
1 |
=demo.query("select * from EMPLOYEE") |
=[] |
|
|
2 |
>B1=A1.select(EID>6) |
|
|
|
3 |
=[] |
|
|
|
4 |
if A1.len()>10 |
|
|
|
5 |
|
>A3=A1.len()+10 |
|
|
6 |
clear A1:B2 |
|
Clear values of cells from A1to B2. |
|
7 |
clear A4: |
|
Clear cell values in a code block whereA4 is the master cell. |