MVP

[wojciechczerniak]

Issue #1 is reserved for our first release 🎉

Description

WIP

Tasks

• MVP #1 Use Github to organize tasks
• Move the code to Handsontable organization #20 Move Hyperformula code to handsontable/hyperformula
• Public API proposal #7 Finish public API
  • Languages support #36 Add support for custom languages
  • Languages support #36 Add support for cultures
  • Add support for custom functions #37 Add support for custom formulas
  • Function meta data format #2 Define formula and meta data format
  • Formula helpers #24 Function helpers: normalize, validate
  • Formula helpers #24 Evaluate function from string
  • Address translation helpers #22 Address translation helpers a1ToCoords, coordsToA1
  • Export version and build date as static properties #19 Export static version and buildDate from package.json
  • Batch operations #18 Refactor CRUD operations to remove auto recalculate
  • Batch operations #18 Add manual recalculate method
  • Batch operations #18 Add batch operations support
• Built-in functions required for the initial release #13 Implement all required functions
• External functions for the initial release #14 Implement all external function
• Sort and filter support #38 Figure out how do we handle filtering and sorting
• Spreadsheet data types #16 Full support for data types
  • NUMBER type precision is not precise enough #4 Number precision
  • DATE type is not supported by arithmetic and comparison operators #3 Date/Time support
  • FALSE() and TRUE() functions aliases are missing #5 True/False aliases
  • Spreadsheet data types #16 Array constant support
• Full support for references
  • Worksheet reference #12 Worksheet references
  • Support 3D references #11 3D references
• Support all operators
  • Arithmetic operators
  • Logical/Comparison operators
  • Text Concatenation operator
  • Does not support reference operators  #15 Reference operators
• Clean up the development tools
  • Cleanup R&D tools before we release the lib #23 Remove CsvImporter i CsvExporter and their dependancies
  • Cleanup R&D tools before we release the lib #23 Hide or remove from the runtime this.stats.measure, this.dependencyGraph.stats.start i this.dependencyGraph.stats.end
• Write documentation for the engine
  • Better descriptions for generated TSDoc
  • How to guide for quick start and usage instructions
  • Better README.md #8 Readme that is NPM ready
• Create new plugin for Handsontable New formula plugin handsontable#6466
• #17 Create a kitchen sink demo to prove that integration works well
• Verify dependancy licensing #25 Check Hyperformula dependencies with FOSSA (https://fossa.com)

Yet to be addressed

• Undo and redo
• Copy, cut, paste
• Merged cells
• Cell validation
• Error reporting
• Moving rows / columns
• Syntax highlight

Browser support

Browser Name	Version
Firefox	58
Safari	11
Chrome	64
iOS Safari	11.2
Chrome for Android	64
IE	11
Edge	16
Android browser	62
Firefox Android	57

Appendix 9

[aninde]

I noticed that support for browsers was probably described as at the beginning of 2018.
e.g.

Browser Name	Version	Release date	Currently used version (as of Dec 2018)
Firefox	58	Jan 2018	71
Safari	11	Sept 2017	13
Chrome	64	Jan 2018	79
Chrome for Android	64	Jan 2018	78/79

It is my responsibility before the first release to check how HyperFormula works in most popular web browsers. IMHO I should test HyperFormula on the latest stable versions of browsers, as our clients will be.

Thus, should we upgrade the versions of the browser in the above description? @wojciechczerniak WDYT?

[wojciechczerniak]

We should test on the latest browsers. The list is more a guide which browsers we should check at some point. As a formal requirement, it was already validated by @krzysztofspilka at stage 1, 2 and 3.

[wojciechczerniak]

MVP was for 2019 and is now outdated. See #54 for progress