First Release about hyperformula HOT 2 CLOSED

All the tasks required for initial release were done and successfully published 🎉

from hyperformula.

Based on the above list and the current status and capabilities of the application, @wojciechczerniak and I have developed a list of acceptance tests with the order of testing stages. WDYT @krzysztofspilka

Acceptance testing before release

1. Syntax - based on ODFF

• Small evaluator group - basic limit #61, tests
• arithmetic operations - more details in quality/#33
• comparision operations - some tests were already written: booleans, operators, we can add more edge cases
• text operations
• whitespace - #68 some tests were already written, we can add more edge cases
• errors, errors propagation- some tests were already written, we can add more edge cases
• type coercion to scalar, to number, to Logical, to txt, some tests were already written
• separators #15, some tests were already written, but we can add more edge cases
• optional params in functions - after #76
• cell references #198
• sheet references #198
• range references
• date - some tests were already written date, leap year and max and min date, date arithmetic
• time - after #229
• duration - after #229
• empty Values - ready tests
• boolean - some were done as comparison operators tests and zero, null, empty, we can add more edge cases
• number,
• infinity,
• negative zero
• string - some were done as comparison operators tests, we can add more edge cases
• case sensitive #66 ready tests
• percantage - some were done as comparison operators tests, we can add more edge cases
• precision - ready tests
• Check changelog. All features and formulas should be up to date.

2. API #7

• CRUD #26 #28 #31 #33 #29 #29 some test are already written, we can add more edge cases
• events #135 WIP
• named expresion #126 some test were already written, we can add more edge cases
• copy, cut, paste
• batch #32 #18 - WIP, some tests were already written, we coud add more edge cases
• helpers #32 #30 #24 - Formula helpers WIP
• language support #22
• custom function supported
• config

3. Environment

• Operation system: Windows, IE 9? IE 10, IE 11, Edge, Chrome, Firefox #1
• Operation system: macOS
• Browsers: Firefox, Chrome, Safari, Edge, Opera?
• Minified build
• Node
• Mobile: Android, iOs
• Mobile: Ipad, iOs 13?
• UMD, ES, CommonJS (TypeScript, WebPAck, Babel)

3a. Performance

• Performance testing (required by the spec?)
• Compare performance with 7.2.2 formula-plugin

4. Functions - test cases will be based on ODFF

• * wildcards -> *? regx? after #220 handsontable/quality#31
• ready interpreter tests
• functions from #221
• Does all parameters are supported
• Does it work without optional parameters
• Can parameters be a reference to another cell
• Are the correct errors returned when something went wrong
• How does it behave when parameters are out of bounds (eg. -1 when it should be >0)
• It is possible to implement remaining functions

5. Buisness examples

• Acceptance tests based on real spreadsheet data
• Smoke test based on real spreadsheet data

from hyperformula.