OFFSET function in HyperFormula

Getting help Questions
1

Function id OFFSET is protected in HyperFormula but don’t have implementation.
Therefore I can’t create my own variant of function and can’t use it at all.
Why OFFSET don’t have implementation and it’s protected?

2

Hi @midaV

a custom function can have a name that is not yet registered. OFFSET is already taken.

Here https://codesandbox.io/s/zen-heisenberg-vgfli is an example of a custom HYPER formula that does some simple calculations.

Here is a list of formulas (ENG language) https://github.com/handsontable/hyperformula/blob/6ec629b16035174d3f63e418d05cd0e98e682eb3/src/i18n/languages/enGB.ts#L156

3

Hi @aleksandra_budnik

a custom function can have a name that is not yet registered.

I understand it. But OFFSET function doesn’t work at all, it’s the reason I write here.

I change a little your example to try get information about OFFSET. And there is no such function in registered, look at my screen, please, Screenshot by Lightshot

4

This issue seems to be related to the instant parse of the formula to its reference. I have reported this behavior as a bug at https://github.com/handsontable/hyperformula/issues/714 and I will update you as soon as we get this issue fixed.

5

Will wait for updates.
Thank you.

6

Hi @midaV

I just got an update on the topic https://github.com/handsontable/hyperformula/issues/714#issuecomment-861815044. The developer who answered the topic is one of the creators.

7

Unobvious behavior, but I managed to use OFFSET normally in my project, thanks.

8

Thank you for the update. I’m glad that you were able to get things going.