hyperformula

hyperformula copied to clipboard

HyperFormula.languages returns only `enGB`.

2

### Description [Reference about HyperFormula.languages property](https://handsontable.github.io/hyperformula/api/classes/hyperformula.html#languages) says: > Contains all available languages to use in registerLanguage. Also, [Localizing functions guide](https://handsontable.github.io/hyperformula/guide/localizing-functions.html) mentions this property as a way to get all the...

sequba

### Description Some clients might want to limit the scope of the functions available in their applications. The documentation should include a section describing how HF could be configured to...

sequba

Slow graph building with 500k of rows without formulas

3

hi， we use handsonetable + hyperformula to develop sheet like excel. But we find when setSheetContent or buildfromsheets with huge datas may has bad performance. demo: setSheetContent 50w rows data...

crystalstone

35 seconds to build graph for non-trivial workbook

6

### Description For non-trivial workbook (10+ worksheets, multiple rows and formulas referencing cross worksheets + named expressions) it takes hyperformula about 30-35 seconds to build dependency graph. ### Steps to...

rackuka

Reduce bundle size of HyperFormula

2

### Description [hot-formula-parser](https://www.npmjs.com/package/hot-formula-parser) has a significantly smaller bundle size than HyperFormula. We should investigate possibilities of reducing it, e.g.: - remove some dependencies (like `regenerator-runtime`) - add tree-shaking support for...

sequba

Run performance benchmark automatically for each PR

1

### Description Run performance benchmark automatically for each PR. Something similar is done in Spreadsheet Viewer repo. It might be helpful ### Links - https://github.com/handsontable/hyperformula/pull/938#issuecomment-1090052862 - https://handsoncode.slack.com/archives/D02T462B3GS/p1648823588399299 (internal discussion -...

sequba

Document how to optimize formulas

1

### Discussed in https://github.com/handsontable/hyperformula/discussions/871 Originally posted by **rackuka** December 8, 2021 I have excel workbook which I parse and provide to HyperFormula as dictionary (Record) of array of arrays. It...

warpech

Vertex for address missing in AddressMapping when adding a row/col & then clearing the sheet

2

Browser: Chrome OS: Ubuntu 12.x HF version: 1.3.0 Example with the error: https://codesandbox.io/s/gallant-jepsen-ix935?file=/src/index.js Apologies for the large data set. I tried to figure out what is wrong but was unable...

MartinDawson

More links from the API reference to the guides

1

Some options have a very short explanation in the API reference and it is not clear what they apply to. On the other hand, they are nicely explained in the...

warpech

### Description `TODAY()` return number that represents the date. Describe the way this number maps to a date. ### Links - https://handsoncode.slack.com/archives/C031GBX62SE/p1655791054784039 (internal discussion) ### Type of issue - [x]...

sequba