Improve the description of the array of changes

[sequba]

Context

• improve the description of the array of changes in the basic-operations guide
• link this description to the related guides and API reference
• add unit tests to make sure the description is accurate

How did you test your changes?

• [x] unit tests pass
• [x] new unit tests to make sure the description is accurate
• [x] local docs build

Types of changes

• [ ] Breaking change (a fix or a feature because of which an existing functionality doesn't work as expected anymore)
• [ ] New feature or improvement (a non-breaking change that adds functionality)
• [ ] Bug fix (a non-breaking change that fixes an issue)
• [ ] Additional language file, or a change to an existing language file (translations)
• [x] Change to the documentation

Related issues:

Fixes #1062

Checklist:

• [x] I have reviewed the guidelines about Contributing to HyperFormula and I confirm that my code follows the code style of this project.
• [ ] I have signed the Contributor License Agreement.
• [x] My change is compliant with the OpenDocument standard.
• [x] My change is compatible with Microsoft Excel.
• [x] My change is compatible with Google Sheets.
• [ ] I described my changes in the CHANGELOG.md file.
• [ ] My changes require a documentation update.
• [ ] My changes require a migration guide.

[github-actions[bot]]

Performance comparison of head (461c5c5addf33d603524bec8345bc619b66e6dd2) vs base (642506bb8dc2b17da224b7e4e59d87223867de48)

                                     testName |   base |   head |  change
-------------------------------------------------------------------------
                                      Sheet A | 540.89 | 544.18 |  +0.61%
                                      Sheet B | 180.41 | 180.49 |  +0.04%
                                      Sheet T | 156.41 | 159.51 |  +1.98%
                                Column ranges | 557.09 | 565.28 |  +1.47%
Sheet A:  change value, add/remove row/column |     35 |     39 | +11.43%
 Sheet B: change value, add/remove row/column |    264 |    281 |  +6.44%
                   Column ranges - add column |    156 |    308 | +97.44%
                Column ranges - without batch |    410 |    460 | +12.20%
                        Column ranges - batch |    221 |    103 | -53.39%

[codecov[bot]]

Codecov Report

Merging #1343 (5a27440) into develop (c74bb21) will decrease coverage by 0.09%. Report is 1 commits behind head on develop. The diff coverage is n/a.

:exclamation: Current head 5a27440 differs from pull request most recent head 461c5c5. Consider uploading reports for the commit 461c5c5 to get more accurate results

Additional details and impacted files

[](https://app.codecov.io/gh/handsontable/hyperformula/pull/1343?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=handsontable) ```diff @@ Coverage Diff @@ ## develop #1343 +/- ## =========================================== - Coverage 97.35% 97.27% -0.09% =========================================== Files 169 169 Lines 14416 14422 +6 Branches 3016 3018 +2 =========================================== - Hits 14035 14029 -6 - Misses 381 393 +12 ``` | [Files](https://app.codecov.io/gh/handsontable/hyperformula/pull/1343?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=handsontable) | Coverage Δ | | |---|---|---| | [src/HyperFormula.ts](https://app.codecov.io/gh/handsontable/hyperformula/pull/1343?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=handsontable#diff-c3JjL0h5cGVyRm9ybXVsYS50cw==) | `99.59% <ø> (ø)` | | ... and [2 files with indirect coverage changes](https://app.codecov.io/gh/handsontable/hyperformula/pull/1343/indirect-changes?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=handsontable)