Kuba Sekowski
Kuba Sekowski
### 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
### Context TBP ### How did you test your changes? TBP ### Types of changes - [ ] Breaking change (a fix or a feature because of which an existing...
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 - 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...
### Description The dependency graph needs to be rebuilt sometime between adding new sheet and reading the cell that references it (lazily if possible). The mechanism might be analogous to...
### Context Internal discussion: https://handsoncode.slack.com/archives/C04MQ954YPL/p1713780506089739 ### Types of changes - [ ] Breaking change (a fix or a feature because of which an existing functionality doesn't work as expected anymore)...
### Context Unit tests written when analyzing the behavior of function `SUM` and operator `^`. ### How did you test your changes? unit tests pass ### Types of changes -...
### Description - `returnNumberType` -> `returnType` - `arraySizeMethod` -> `shapeOfResultMethod` - `arrayFunction` -> `enableArrayArithmeticForArguments` **Do not remove the existing props. Mark them as deprecated instead.** ### Links https://github.com/handsontable/hyperformula/blob/master/src/interpreter/plugin/FunctionPlugin.ts
Add a working example that demonstrates creating a custom function that calls an external API by implementing `GPT()` function - a [GPT API](https://openai.com/product) wrapper. Docs: https://platform.openai.com/docs/introduction Pricing: https://openai.com/pricing Internal discussion...
### Context TBP ### How did you test your changes? TBP ### Types of changes - [ ] Breaking change (a fix or a feature because of which an existing...