Comments (15)
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?
from hyperformula.
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.
from hyperformula.
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
from hyperformula.
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๏ผ
i try to use listening valuesUpdated event,but no event emit.B1
's raw formulas is =SUM(A1:A2)
,after insert row is =SUM(A1:A3)
, The value is not updated but the formula is. But no event emit.
I try to explain the steps to reproduce.
The first step is to create a sheet with a formula as a relative reference address.
The second step is to insert or delete a row that affects the expression of the formula but does not affect its value. This way there will be no valueUpdate event.
For example, the formula in cell B1
is =SUM(A1:A2)
. If you insert a row after the first row, the formula in B1
becomes =SUM(A1:A3)
, but the value of the inserted row is 0, which will not happen. Modify the value of B1
, but the formula of B1
has changed and I cannot receive any events.
from hyperformula.
Hi @CodeChaosConjurer
I'm not sure if this example was updated. It throws an error that adr
is not defined. Can you please check it again?
from hyperformula.
Hi @CodeChaosConjurer
I'm not sure if this example was updated. It throws an error that
adr
is not defined. Can you please check it again?
sorry,try it again, i don't know how to run this program
from hyperformula.
Hi @CodeChaosConjurer
I'm not sure if this example was updated. It throws an error that
adr
is not defined. Can you please check it again?
i 'm already fix it, plz try it again
from hyperformula.
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.
from hyperformula.
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~
from hyperformula.
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
from hyperformula.
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?
from hyperformula.
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.
from hyperformula.
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?
from hyperformula.
Hi @nomind2think we can keep it open as a feature
. I've just attached the exact label this this issue.
from hyperformula.
Closing. Duplicate of #1156.
from hyperformula.
Related Issues (20)
- Rename the properties of `FunctionMetadata` interface to make them more logical
- [Bug]: In a specific combination of adding rows, content, and column amount alteration we get `Uncaught Error` from the `DenseStrategy` HOT 4
- [Bug]: `COLUMN` doesn't work in the array arithmetic mode HOT 2
- [Bug]: paste after cut gives not changed cells HOT 6
- [Bug]: Docs scrolls automatically to `#demo` on refresh
- Automate the release process
- [Bug]: =1.0667-1.0666 count wrong 0.000099999999999989 HOT 3
- [Bug]: Copying and pasting formulas pastes the value and not the formula HOT 2
- Remove license/copyright comments from `hyperformula.js`, `hyperformula.min.js`, `hyperformula.full.js` and `hyperformula.full.min.js` files HOT 1
- HyperFormula 2.7.1 is here!
- Run all build scripts in Node Active LTS (currently 20)
- Test building the docs on every pull request
- Fix the browser tests `Disconnected (0 times) reconnect failed before timeout of 2000ms (ping timeout)` error
- Refactor demos to make them load faster
- [Bug]: Cannot add rows to an empty sheet HOT 2
- Remove deprecated APIs
- Migrate documentation demos to native HTML+JS
- Make sure react demo is up to date and uses modern react code
- [Bug]: Codecov upload "Rate limit reached" error in GH action
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from hyperformula.