New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Bug]: No change event is emitted when the formula changes #1408
Comments
Hi @CodeChaosConjurer Thank you for contacting us. I tried to recreate this behavior in this example, but there seems to be something wrong: https://stackblitz.com/edit/vitejs-vite-pjjrzz?file=index.html,main.js&terminal=dev. Can you please modify it so it matches your scenario? |
https://stackblitz.com/edit/stackblitz-starters-2wmbyf?file=index.js i'm create a new stack. without vite, just simple with nodejs. I want to listener formulas change event. |
Hi @CodeChaosConjurer Unfortunately, this example still doesn't work for me. However, if you need a listener, did you try this method? https://hyperformula.handsontable.com/api/interfaces/listeners.html#values |
Hi, i'm fork your stackblitz, https://stackblitz.com/edit/vitejs-vite-yhajtz?file=index.html,main.js&terminal=dev will it work? For example, the formula in cell |
Hi @CodeChaosConjurer I'm not sure if this example was updated. It throws an error that |
sorry,try it again, i don't know how to run this program |
i 'm already fix it, plz try it again |
Hi @CodeChaosConjurer Thank you. Now it works. We'll take a closer look at this, and I'll get back to you when I have more information. |
Thank you~ |
Hi @CodeChaosConjurer We determined that, according to the documentation, this behavior is correct: https://hyperformula.handsontable.com/api/interfaces/listeners.html#valuesupdated This hook is only fired on value change, not the formula, so it's the correct behavior in your case. Here's an updated example showing that it works as expected: https://stackblitz.com/edit/vitejs-vite-ex3waj?file=index.html,main.js&terminal=dev |
ok,thanks,Is there any way for me to listen for formula change events? |
Currently, there's no such method available, but this is valuable feedback and that might be a good idea to add such method in the future. |
ok,thanks,I think this can be closed, what do you think? |
Hi @nomind2think we can keep it open as a |
Description
when i insert/remove row, formula's relative address is change, but no valueUpdateEvent emit, how to listening this event?
Video or screenshots
No response
Demo
none
HyperFormula version
2.7.0
Your framework
vue
Your environment
nodejs v18.17.1
The text was updated successfully, but these errors were encountered: