Kuba Sekowski

Results 148 comments of Kuba Sekowski

@jfstephe, `ADDRESS` function will most likely be included in the upcoming release of HyperFormula. It seems to me that it is impossible to implement `INDIRECT` unless we change the way...

Hi @impauloalves, thanks for your feedback. The default way of converting strings to range objects is by using the [simpleCellRangeFromString](https://hyperformula.handsontable.com/api/classes/hyperformula.html#simplecellrangefromstring) method. However - as you noticed - currently, it works...

Hi @brianjenkins94, thank you for the workaround. Since more people are interested in such a feature, I'm increasing the priority of this task. Related issue: https://github.com/handsontable/hyperformula/issues/1375

This file was renamed to `api-ref-readme.html` but is still present in the search results.

It is caused by the (im)precision of the JavaScript floating-point arithmetics. In most programming languages, calculations that involve fractional numbers are never 100% accurate, e.g. [the famous case with 0.1...

After discussing it with @evanSe we decided to apply the documentation changes (points 2 and 3) in the scope of this task. Changing the default value of the config parameter...

Instead of changing the default value, we will expand the reference to describe the js arithmetic issues better and recommend `precisionRounding: 10` for most day-to-day use cases.

My guess is that our implementation of `INDEX` returns a simple value from the referenced cell (without metadata etc). We should fix it or describe this limitation in https://hyperformula.handsontable.com/guide/list-of-differences.html

@IMSupperkaka A formula cell recomputes only on updates to its dependencies. In your example, the cell `A2` recomputes only when `A1` or `B1` changes. Unfortunately, `#SPILL` errors have no custom...

@IMSupperkaka > this seems to be a bug, is there any plan to fix it? Yes, I agree it is a bug. I'm adding it to our backlog. > Another...