[Bug]: set formula content includes row range will throw error!

[IMSupperkaka]

Description

See demo for details

Video or screenshots

No response

Demo

https://codesandbox.io/s/jolly-bell-l7693t?file=/src/index.js

HyperFormula version

2.4.0

Your framework

No response

Your environment

chrome 113

[adrianszymanski89]

Hi @IMSupperkaka

It seems that the reason for this issue was the order of the operations. When I changed to the following order - row 0, row 0, row 1, row 2 it worked correctly. Can you please confirm if that's your expected output?

Here's the changed example: https://codesandbox.io/s/heuristic-wiles-h3dx42

[IMSupperkaka]

Hi @IMSupperkaka

It seems that the reason for this issue was the order of the operations. When I changed to the following order - row 0, row 0, row 1, row 2 it worked correctly. Can you please confirm if that's your expected output?

Here's the changed example: https://codesandbox.io/s/heuristic-wiles-h3dx42

It seems a dependencyGragh bug, i fixed in my local version.
I know it works when i change the order of operation but In some reason i canot control the order of operation.

[IMSupperkaka]

In fact, I found dozens of bugs in the process of development, can I submit some Pr later?

[adrianszymanski89]

Hi @IMSupperkaka

I understand. Of course, we really appreciate our users' input, so feel free to create PR.