[HyperFormula] Kitchensink testing

[aninde]

When https://github.com/handsontable/hyperformula/issues/17 will be ready.

Testing checklist:

• Compliance with requirements
• Manual tests comparing working to Excel, Google Spreadsheet and Libra Ofice
• Testing current API & hooks
  • setDataAtCell
  • loadData
  • populateFromArray
  • setDataAtRowProp
  • updateSettings> data
  • setCellMeta
  • alter
  • setCellMetaObject
  • getCopyableData
  • getCopyableText
  • setCommentAtCell
  • setComment
  • removeCommentAtCell
  • removeComment
• Integration with Handsontable
• Formula plugin
  • Any numbers,
  • negative and
  • positive
  • as float
  • or integer;
  • Arithmetic operations such as:
  • +,
  • -,
  • /,
  • *,
  • %,
  • ^;
  • Logical operations such as: AND(),
  • OR(),
  • NOT(),
  • XOR();
  • Comparison operations such as: =, >, >=, <, <=, <>;
  • All JavaScript Math constants such as: PI(), E(), LN10(), LN2(), LOG10E(), LOG2E(), SQRT1_2(), SQRT2();
  • Error handling: #DIV/0!, #ERROR!, #VALUE!, #REF!, #NAME?, #N/A, #NUM!;
  • String operations such as: & (concatenation eq. =-(2&5) will return -25);
  • All excel formulas defined in formula.js;
  • Relative and absolute cell references such as: A1, $A1, A$1, $A$1;
  • Build-in variables such as: TRUE, FALSE, NULL;
  • Custom variables;
  • Nested functions;
  • Dynamic updates.
• Working of Handsontable should be compliance with requirements
• CRUD operations
• Sorting
• Filtering
• contextMenu
• Formulas
• Formulas update
• Value calculation
• Integration of formulas in many Handsontable
• Editors with a value other than text

Related issues:

https://github.com/handsontable/handsontable/labels/Formulas

• #3908 perhaps an issue on formula
• #3975 Dropdown and Autocomplete should work without loading extra plugins
• #4066 Formula does not get initially evaluated with column mapping
• #4154 formulas not init with nestedRows
• #4353 When the cell type is numeric, the formula does not work properly.
• #4357 Circular reference error in the formula handsontable#4357
• #4430 Formulas does not apply for some cells
• #4654 After inserting a row, an auto-updated formula displays incorrect value
• #4668
  Formulas do not recalculate when we move columns
• #4675 AVERAGE formula updates incorrectly
• #4678 Formulas recalculates when we block a change via beforeChange
• #4693 Handsontable should work without formula parser enabled
• #5279 Bug in formula parsing when using nested data structures.
• #5455 Column with formulas doesn't filter properly
• #5550 after remove columns get wrong sourceData with formulas enabled
• #5613 continus removeRow cause error in formula situation
• #5635 Formulas don't update after row is removed
• #5689 beforeChange event i cahnge a value, but the relate formula calculate wrong
• #5852 Add case sensitive options for filters formulas
• #5870 Calculation issue when IF is used on FALSE data
• #5872 AVERAGE doesn't allow to define numbers as strings
• #6248 Using clear() method breaks down formulas
• #6336 Formulas are incorrectly calculated / auto updated on sort
• #/6359 Formula is converted to a value if merged areas are included
• #6480 It seems that the Formulas plugin doesn't work well with sorting

Requirements

handsontable/handsontable#6466

[aninde]

Work on HyperFormula has been postponed, for now, so I am closing #2 for later reopening.