Posted 23 October 2020, 4:20 am ESTGood morning/afternoon
I'm currently trying to implement the following feature: https://corporatefinanceinstitute.com/resources/excel/study/trace-dependents/
which permits to audit a formula within a spreadsheet.
I found the documentation of SpreadJS right here:
https://www.grapecity.com/spreadjs/docs/v13/online/formula-auditing.html?highlight=trace%2C but I have a 3 issues:
1) There's seems no way to add the arrows between cells which is quite fundamental to understand the flow of the formula.
2) The code snippet provided is using setTimeout which unfortunately after a bunch of selections (navigating the sheet via keyboard) does bloat the DOM and the whole experience become laggy. I tweaked removing these setTimeout (clearTimeout) but the output seems to be quite the same.
3) When the user enters in edit mode of a cell the dependencies show with a pre-existing style (the blue/purple/green outline) which somehow gets mixed up with the style given by the tracing function... ideally, I would expect those tracing styles to be overridden by the edit mode rather than mixing them up.
Could you please have a look?
Thank you in advance for your support