category:Structure

esCalc Structure: The Smart Copying of Formulas

If you enter a formula into a cell in an esCalc spreadsheet, it will automatically appear in each of the cell’s homo-cells and intelligently adapt itself to the new settlement. If you set one of the cell’s properties through a formula, all its homo-cells will receive the property setting simultaneously. Here we’ll disc...

2015-08-17 1182 0 0

esCalc Structure: Homologous Relationship

Some data in a spreadsheet contains the same type of topics. Through the structural and hierarchical way, esCalc creates homologous rows and cells – which are called homo-rows and homo-cells – containing data of the same information type. Here’s the explanation of what this homologous relationship is and the advantage ...

2015-08-13 1224 0 0

esCalc Structure: Functions

esCalc stores data in hierarchical, structured spreadsheet, which enables the use of structure-related functions in performing data analysis and aggregation. Here let’s talk about these functions and their basic usages. 1. The sequence of cell values Through esCalc Basics: Sequences, you know that [a:b] can be used in ...

2015-08-11 1258 0 0

esCalc Structure: The Hierarchy of Rows

Different from other spreadsheet applications, esCalc spreadsheet isn’t designed for holding a normal two-dimensional table, but for holding data in a hierarchical way. Here you’ll see in what type of structure the data is stored in esCalc and the hierarchical relationships between rows. 1 .Row number, slave row number...

2015-08-07 1178 0 0