Docs: add information that `getCellPrecedents` and `getCellDependents` return named expressions

sequba commented 7 months ago

Context

update API reference for getCellDependents
update API reference for getCellPrecedents
improve related examples in the dependency-graph guide
add unit tests

How did you test your changes?

local docs buid

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 #1078

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] commented 7 months ago

Performance comparison of head (9033ffe57ce4a53f09f659f05b6d8890b37bfb68) vs base (313939eda78010bf3331b40c82d63199a29e1461)

                                     testName |   base |   head |   change
--------------------------------------------------------------------------
                                      Sheet A |  535.8 | 536.58 |   +0.15%
                                      Sheet B | 177.55 | 179.84 |   +1.29%
                                      Sheet T | 154.32 | 153.93 |   -0.25%
                                Column ranges | 554.73 | 562.16 |   +1.34%
Sheet A:  change value, add/remove row/column |     37 |     36 |   -2.70%
 Sheet B: change value, add/remove row/column |    290 |    295 |   +1.72%
                   Column ranges - add column |    166 |    165 |   -0.60%
                Column ranges - without batch |    511 |    424 |  -17.03%
                        Column ranges - batch |     95 |    193 | +103.16%

codecov[bot] commented 7 months ago

Codecov Report

Merging #1350 (9033ffe) into develop (313939e) will increase coverage by 0.00%. The diff coverage is n/a.

Additional details and impacted files

[![Impacted file tree graph](https://app.codecov.io/gh/handsontable/hyperformula/pull/1350/graphs/tree.svg?width=650&height=150&src=pr&token=5k9ZQv8azO&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=handsontable)](https://app.codecov.io/gh/handsontable/hyperformula/pull/1350?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=handsontable) ```diff @@ Coverage Diff @@ ## develop #1350 +/- ## ======================================== Coverage 97.27% 97.28% ======================================== Files 169 169 Lines 14422 14422 Branches 3081 3081 ======================================== + Hits 14029 14030 +1 + Misses 388 387 -1 Partials 5 5 ``` | [Files](https://app.codecov.io/gh/handsontable/hyperformula/pull/1350?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/1350?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 [1 file with indirect coverage changes](https://app.codecov.io/gh/handsontable/hyperformula/pull/1350/indirect-changes?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=handsontable)

handsontable / hyperformula