Kuba Sekowski

Docs: Exclude file `api-ref-readme.html` from search results (previously: `api-template.html`)

1

### Description This file shouldn't be in the search results. It is, in fact, duplicated, because it is displayed as `HyperFormula API reference` in the `API reference` section of the...

### Description Method `moveColumns` does not change the number of columns in a sheet. But when `maxColumns` limit is set tightly, this operation produces error: ``` Error: Sheet size limit...

Calling `setRowsOrder` twice crashes the application

2

### Description A call to `setRowsOrder` might modify sheet dimensions. It is counterintuitive and unexpected.  ### Demo https://codesandbox.io/s/funny-https-h9go7f?file=/src/hyperformulaConfig.js ### Links https://github.com/handsontable/dev-handsontable/issues/440#issuecomment-1455673440 https://handsoncode.slack.com/archives/C04MC750UJW/p1678191576051399 (internal, private channel)

### Description As @kirszenbaum pointed out in https://github.com/handsontable/hyperformula/pull/1099#issuecomment-1317499945: > We could use an example that shows integration with a CSV parser library (analogically to the ExcelJS example) ### Links #1099...

### Description There are 2 ways of defining named expressions: - addNamedExpression() function - the last argument of functions `buildEmpty()`, `buildFromArray()` & `buildFromSheets()` ```js const engine = HyperFormula.buildFromArray( [['=FOO']], {},...

### Description - TEXT() has a description in built-in-functions guida - TEXT() limitations are mentioned in the runtime-differences guide Both of the above are not accurate enough about the formats...

`TEXT()` function should support popular currency formats

4

### Description Our implementation of `TEXT()` supports less formats than Excel. We should expand it. Particularly, format `$#,##0.00` should be supported. Alternatively, we can add a config option `stringifyCurrency` similar...

Make signatures of `simpleCellAddressToString` and `simpleCellRangeToString` more logical

3

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