We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

Event on change cell format


Hi team,
    I am fetching a trouble to save my report.
    I want to trigger an event when something change in cell format, but there is no way I found to settle down.
  suppose I have below json Data

[{ "name": "Nandan", "sales": 345.00, "month": "July,2019" },
{ "name": "Sandipan" "sales: 1200.34, "month": "July, 2019}]

Now I format on the coloumn "sales" to 0 decimal place. That fine.
Now whenever I applied this format, I want to trigger reportchange
event or any custom javascript function.

please help me to do this...

3 answers

WebDataRocks Team WebDataRocks July 4, 2019

Hello, Nandan,

Thank you for writing to us.

reportchange event is triggered when a report is changed in the component. This includes cell formatting. You can always get your current report via getReport() API call, get it after report change and see the changes.

Hope it helps.

WebDataRocks Team

Sergey November 22, 2020

reportchange is not triggered if we do any changes in “Format cells” dialog.
See your demo https://codepen.io/webdatarocks/pen/bQvwzz
Looks like there is no any everts for format cells changes?

WebDataRocks Team WebDataRocks November 30, 2020

Hello, Sergey,
Thank you for writing to us.
We have checked and it seems that the reportchange event is not fired when setting the number formatting. Our team has added this issue to our backlog. 
Also, you are welcome to check out Flexmonster Pivot, which is a product developed by the same team. The reportchange event is fired as expected here.
WebDataRocks Team