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.