hyperformula
hyperformula copied to clipboard
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.
### Description Currently `sheetId` needs to be passed twice to `simpleCellAddressToString`: ```js const cellAddress = { sheet: sheetId, row: 0, col: 3}; const cellAddressAsString = hfInstance.simpleCellAddressToString(cellAddress, sheetId); ``` ~~The second...
### Description Pointed out by @kirszenbaum in https://github.com/handsontable/hyperformula/pull/1099#issuecomment-1317499945 ### Links #1099 ### Type of issue - [x] Missing documentation - [ ] Error in the documentation - [ ] Request...
### Description In particular, the description of `setColumnOrder` method is not useful for a developer and it is not linked to the API reference that explains that method really good....
### Description It would be nice to be able to write: ```js const result = hfInstance.getCellValue('A1'); ``` The old way should still work for backwards compatibility ### Links
### Description * After working through https://github.com/handsontable/hyperformula/issues/1166 * I encountered the following error when attempting to `npm run bundle:development` ``` node:internal/crypto/hash:71 this[kHandle] = new _Hash(algorithm, xofLen); ^ Error: error:0308010C:digital envelope...
### Context TBP ### How did you test your changes? TBP ### Types of changes - [ ] Breaking change (a fix or a feature because of which an existing...
### Description Search results are not limited in quantity and cannot be scrolled vertically.  ### Steps to reproduce 1. Type 'a' into the searchbar...
Referencing external state inside a custom function - add support or describe workaround in the docs
### Description We received 3 questions about it from our clients. There is a workaround described here: https://github.com/handsontable/hyperformula/discussions/808#discussioncomment-4862487 ### Links - https://github.com/handsontable/hyperformula/issues/1119#issuecomment-1428845543 - https://github.com/handsontable/hyperformula/discussions/808
### Description The inactive license warning is missing. Validation should run without any delay. Tested on the artificially generated licenses. ### Your environment Not related * HyperFormula version: * Browser...
### Description - reorganize the information in the date-and-time-handling guide to distinguish better the date/time formats that are supported out of the box and the formats that need custom implementations...