Kuba Sekowski

Hi @Esmail-Rahmani, thank you for reaching out. I can confirm it is a bug. I'm adding it to our backlog.

I'm closing this issue. @Dhatchanamoorthi8 if you have any further questions feel free to re-open it.

When it's done, check issue https://github.com/handsontable/dev-handsontable/issues/1979

Merged to master with: https://github.com/handsontable/hyperformula/pull/1454

Hi @bacek97, thank you for reporting this issue. The implementation of the `OFFSET` function in HyperFormula has some limitations. The first argument must be a reference to a single cell....

> The first argument must be a reference to a single cell. Ranges are not allowed. This will be done in https://github.com/handsontable/hyperformula/pull/1488 > Please add information about the impossibility of...

Here's a unit test that demonstrates the issue: ```js it('function OFFSET can reference a different sheet', () => { const engine = HyperFormula.buildFromSheets({ Sheet1: [['sheet1']], Sheet2: [['sheet2', '=OFFSET(Sheet1!A1, 0, 0)']],...

Hi @bacek97 I am happy to share the good news. We just launched HyperFormula v3.1.0, which fixes this issue. [Here](https://handsontable.com/blog/hyperformula-3.1.0-improved-cross-sheet-operations-easier-apis-and-clearer-docs), you can read more about the changes in this version.

I think it's worth mentioning on our [Integration with Vue](https://hyperformula.handsontable.com/guide/integration-with-vue.html#demo) site.

In more complex cases, like [using HyperFormula together with Handsontable](https://github.com/handsontable/dev-handsontable/issues/2896), it also may be helpful to prevent Vue from injecting the reactive proxy by marking the HyperFormula instance as [raw](https://vuejs.org/api/reactivity-advanced#markraw):...