Smarter spreadsheet calculating
esCalc keeps the basic functions and using style of spreadsheet, but is completely beyond traditional spreadsheet on complex tabular data calculation. Traditional spreadsheet lacks the capacity of integral calculation on business data, for example, when pasting a formula, other spreadsheets only permit adjustment of relative position, resulting in a business rule violation, while adjustment with esCalc can be finished automatically and intelligently focusing on the business relevance; When writing a formula, traditional spreadsheet can’t realize automatic copy without recognition of the business relationship among cells, on the contrary, esCalc enables formula or filtering condition expressions copied to the related business cells automatically and realizes intelligent adjustment according to the business relationship.
Traditional spreadsheet‘s positional relationship is disrupted after data grouping, making it difficult for data sorting and filtering, processing of the computed columns or aggregate value, the cross-row computing etc., while the above all will not happen in esCalc. The unique overall table computation model in esCalc can realize advanced features such as join, merge and difference between multi-level groups of data.