[HyperFormula] Testing API - stage 1

[aninde]

Description

We need to check conformance with requirements of API

Due to the limited time, the tests will consist of verification of ready tests, or adding test cases.

More complicated tests e2e will be written in the next stage after developing test scenarios based on ready-made Excel sheets.

Test cases:

• CRUD AddSheet should return generated name hyperformula#26 AddSheet helpers have different sytnax hyperformula#28 Set cell value methods hyperformula#31 There is no API to replace sheet content hyperformula#33 Move operations on Columns, Rows hyperformula#29 Move operations on Columns, Rows hyperformula#29 some test are already written, we can add more edge cases
• events Add events to notify about value and formula updates hyperformula#135 WIP
• named expresion Named Expressions and Structured References hyperformula#126 some test were already written, we can add more edge cases
• copy, cut, paste
• batch Worksheet helpers and name to id translation hyperformula#32 Batch operations hyperformula#18 - WIP, some tests were already written, we coud add more edge cases
• helpers Worksheet helpers and name to id translation hyperformula#32 Cell helpers: hasValue, hasFormula, getType hyperformula#30 Formula helpers hyperformula#24 - Formula helpers WIP
  • Is this sheet name optional?
  • What would happen if everything is absolute?
  • What about mixed adressing?
  • Whether which formula depends on the specific Cell or sheets
  • Each function via calculate formula
  • Check with SUM
  • Add up if the given value is greater than A1 - SUMIF
  • What if there are new references?
• language support Address translation helpers hyperformula#22
• custom function supported
• addColumns
• addNamedExpression
• addRows
• addSheet
• batch
• calculateFormula
• changeNamedExpression
• clearClipboard
• clearSheet
• copy
• countSheets
• cut
• destroy
• disableNumericMatrices
• doesCellHaveFormula
• doesCellHaveSimpleValue
• doesSheetExist
• forceApplyPostponedTransformations
• getAllSheetsDimensions
• getAllSheetsFormulas
• getAllSheetsSerialized
• getAllSheetsValues
• getCellFormula
• getCellSerialized
• getCellType
• getCellValue
• getCellValueType
• getNamedExpressionValue
• getRangeFormulas
• getRangeSerialized
• getRangeValues
• getSheetDimensions
• getSheetFormulas
• getSheetId
• getSheetName
• getSheetSerialized
• getSheetValues
• getStats
• isCellEmpty
• isCellPartOfMatrix
• isItPossibleToAddColumns
• isItPossibleToAddRows
• isItPossibleToAddSheet
• isItPossibleToClearSheet
• isItPossibleToMoveCells
• isItPossibleToMoveColumns
• isItPossibleToMoveRows
• isItPossibleToRemoveColumns
• isItPossibleToRemoveRows
• isItPossibleToRemoveSheet
• isItPossibleToReplaceSheetContent
• isItPossibleToSetCellContents
• isThereSomethingToUndo
• listNamedExpressions
• moveCells
• moveColumns
• moveRows
• normalizeFormula
• onNamedExpressionAdded
• onNamedExpressionRemoved
• onSheetAdded
• onSheetRemoved
• onSheetRenamed
• onValuesUpdated
• paste
• removeColumns
• removeNamedExpression
• removeRows
• removeSheet
• renameSheet
• setCellContents
• setSheetContent
• simpleCellAddressFromString
• simpleCellAddressToString
• undo
• validateFormula
• buildEmpty
• buildFromArray
• buildFromSheets

Requirements

Compatibility with http://127.0.0.1:5005/classes/_index_.hyperformulans.html

Documentation

Internal HyperFormula documentation generated on develop branch

Flow to create docs with Makefile.
Should be changed after removing Makefile.

$ npm i
$ make setup
$ make doc
$ make servedoc

[aninde]

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