handsontable / hyperformula

HyperFormula is an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting.
https://hyperformula.handsontable.com/
Other
1.9k stars 108 forks source link

Add entry about PV function to the list of runtime differences #1319

Closed sequba closed 9 months ago

sequba commented 9 months ago

Context

PV function with periods = 0 is an edge case in which Excel and Sheets give different results. I added information about this inconsistency to our list of runtime differences in the docs. HyperFormula behaves in the same way as Excel for this edge case.

How did you test your changes?

local docs buid

Types of changes

Related issues:

Fixes #1249

Checklist:

github-actions[bot] commented 9 months ago

Performance comparison of head (02b401fe5de2461406d6cf155b6206815501eb72) vs base (cc5a59f994755c1d28d6facfb2fd0980b6398185)

                                     testName |   base |   head |  change
-------------------------------------------------------------------------
                                      Sheet A | 776.91 | 771.34 |  -0.72%
                                      Sheet B |  265.1 | 263.94 |  -0.44%
                                      Sheet T |  226.3 | 227.34 |  +0.46%
                                Column ranges | 855.91 |  852.9 |  -0.35%
Sheet A:  change value, add/remove row/column |     58 |     59 |  +1.72%
 Sheet B: change value, add/remove row/column |    416 |    433 |  +4.09%
                   Column ranges - add column |    242 |    239 |  -1.24%
                Column ranges - without batch |    800 |    930 | +16.25%
                        Column ranges - batch |    159 |    156 |  -1.89%
codecov[bot] commented 9 months ago

Codecov Report

Merging #1319 (02b401f) into develop (cc5a59f) will not change coverage. The diff coverage is n/a.

Impacted file tree graph

@@           Coverage Diff            @@
##           develop    #1319   +/-   ##
========================================
  Coverage    97.27%   97.27%           
========================================
  Files          169      169           
  Lines        14422    14422           
  Branches      3018     3018           
========================================
  Hits         14029    14029           
  Misses         393      393