Natural step by step computation
- Cells can hold the result and is stepwise by nature.
- The intermediate result can be referenced by row and column numbers. This is much simpler than the traditional scripts.
- Stepwise computation is not supported in SQL, and thus the computation complexity is increased.
A | ||
1 | =db.query(“select * from Employee”) | |
2 |
![]() =A1.select(Gender==”Male”)
|
Male employees |
3 |
=A1.select(Birthday>=date(“1970-01-01”))
|
Employees born in and after 1970 |
4 |
![]() =A2^A3
|
Male employees born in and after 1970 |
In the expression A1.select(Gender==”Male”) of cell A2, you can use A1 to directly reference the result of previous step. In the expression A2^A3 of cell A4, the A2 and A3 is directly referenced with the cell name.