handsontable/quality

[9.0.0] Tesing Handsontable with HyperFormula

aninde opened this issue · 4 comments

aninde commented

Description

Testing checklist

Reference

Chores

Integration test

  • add HyperFormula as an engine of formulas and test it with every Handsontable feature
  • build with each wrapper
    • React
    • Vue
    • Angular (blocked for now)

Smoke tests

HF engine test

  • smoke tests with ready data sets
    • Vanilla
    • React
    • Angular
    • Vue

Retests

Documentation tests

  • Header tooltips
  • formulas
    • formulas API
    • formulas demo
  • migration guide?
  • Handsontable API

Breaking changes:

  • formula API
    • batch
  • hooks beforeAutofill: signature change
  • afterAutofill: signature change

Code freeze:

  • performance
  • package size

After release

Environments:
Firefox, Chrome, Internet Explorer, Edge, Safari, Opera
macOS, Windows 10

AMBudnik commented

I've checked all the examples at https://dev.handsontable.com/docs/next/examples/#miscellaneous and they all work as expected (as in the previous version)

  • 👍1
aninde commented

Code freeze 25.05

Official RN:

https://gist.github.com/jansiegel/80ba8aab608e4e73ef006b324cc3c211
suplement
https://github.com/handsontable/handsontable/blob/develop/.changelogs/8095.json

Issues found during the first testing iteration and not fixed yet:

(Current, reported bugs)

    • [9.0.0] Nested rows don't work well while HyperFormula is enabled as formulas engine #8048
    • [9.0.0] column width is not updated when formula result needs more space (number of chars is greater than on the init) #8061 ?
    • [9.0.0] Validation is broken when cell data being changed. #8066
    • [9.0.0] Enabling HF prevents default cell initialization #8069
    • [9.0.0] When the new formula engine is defined undo does not bring back data in the previously removed columns #8076
    • [9.0.0] When we cause the formula to throw a #REF! error with an action undoing it doesn't clear the error #8078

Issues found and fixed:

  • [9.0.0] Sorting doesn't work while HyperFormula is enabled as formulas engine #8046
  • only collapsing and uncollapsing nested Rows handsontable/handsontable#8048 (comment)
  • [9.0.0] Filters don't work while HyperFormula is enabled as new formulas engine #8049 main case fixed, advanced operation with sorting can truncates col header
  • [9.0.0] Data population don't work properly while HyperFormula is enabled #8050
  • [9.0.0] Validation does not work for cells that contain formulas #8053 - fixed, but it's not perfect
  • [9.0.0] Uncaught Error - Table breaks when minSpareRows or minSpareCols are added #8054 - partially fixed
  • The table throws errors when the formulas sheet name contains a dash #8057 -still broken
  • [9.0.0] Moving columns/rows doesn't work #8058 - fixed
  • [9.0.0] ManualColumnFreeze freezes wrong columns when HF is used #8060 - fixed
  • [9.0.0] Autofill truncates column header #8063 -fixed

Testing chores

As supplement:

aninde commented

Results after second test iteration

Reported regressions:

    • [9.0.0] Validation on dropdown cell is broken in specific case when dataset is number passed as strings #8115
    • Moving a column with a formula in a cell changes the formula to its value #8114
    • [9.0.0] Dataset isn't restored after undoing column removal on these column #8113
    • [9.0.0] Enabling formulas change working of autofill: no new rows are added #8112
    • [9.0.0] Spare rows and columns are not visible if formulas as enabled #8110
    • [9.0.0] We are not able to alter the number of rows by pasting data #8109
    • Missing TS for new Formulas plugin #8108
    • [9.0.0] We are not able to block autofill when formulas are defined #8107
    • [9.0.0] One e2e fails on Safari and FF #8106
    • The MIN formula does not support column range notation #8104
aninde commented

Issues found during the first testing iteration and not fixed yet:

(Current, reported bugs)

    • [9.0.0] Nested rows don't work well while HyperFormula is enabled as formulas engine #8048
    • [9.0.0] column width is not updated when formula result needs more space (number of chars is greater than on the init) #8061 ?
    • [9.0.0] Validation is broken when cell data being changed. #8066
    • [9.0.0] Enabling HF prevents default cell initialization #8069
    • [9.0.0] When the new formula engine is defined undo does not bring back data in the previously removed columns #8076
    • [9.0.0] When we cause the formula to throw a #REF! error with an action undoing it doesn't clear the error #8078