How to find out programmatically that a render and/or recalculation completed

How to find out programmatically that a render and/or recalculation completed

Posted by: jk on 17 October 2020, 8:49 am EST

• 

  jk

  • Post Options:
  • Link
    Copy

  Posted 17 October 2020, 8:49 am EST

  How to find out programmatically that render and/or recalculation processes completed successfully?

  And the other way around, how to find out that rendering and/or recalculation process is happening now?

  I need it in order to apply events that shouldn’t be applied while recalc or render is taking place due to performance issues.

  I’ll appreciate any help.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 19 October 2020, 1:02 am EST

  Hi,

  We are sorry but currently we do not any public event to track and to notify for this. could you please. Could you please explain more about the use that you trying to implement? so that we could have a better understanding of the issue and assist you accordingly.

  Regards
  
  Avinash

• 

  jk

  • Post Options:
  • Link
    Copy

  Posted 19 October 2020, 6:54 pm EST

  Sure. I have events I’d like to apply after the initial recalculation of a workbook. I don’t want them to be applied too early as they are radically slowing down the initial full recalculation of the workbook. let me know if you understand my situation. Thanks!

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 20 October 2020, 10:17 pm EST

  Hi,

  Thank you for the information. Could you please provide further information about the nature of the events and what purpose do they serve?

  Regards
  
  Avinash

• 

  jk

  • Post Options:
  • Link
    Copy

  Posted 21 October 2020, 3:25 am EST

  They are general-purpose events, mostly for logging, debugging, and data operations/modifications.

  But I feel like we are drifting away from my original issue.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 21 October 2020, 8:12 pm EST

  Hi,

  We are not able to achieve the required functionality using the current public API hence we have escalated this issue to devs. We will update you regarding this as soon as we get any information. The internal tracking ID for this issue will be SJS-6196.

  Regards
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 27 October 2020, 4:58 pm EST

  Hi,

  The Dev team informed that this is already in our backlog, but we don’t have an ETA currently, We will update you whenever the issue will be fixed.

  Regards
  
  Avinash