Fix the bug when Desktop Excel hangs when the JavaScript getSelectedRanges method is called when a big range is selected
I am developing an Excel JS add-in that processes all selected ranges.
When selecting a large range with data, such as A1:O1000000, desktop Excel hangs when I call the ctx.sync method after getting the ctx.workbook.getSelectedRanges() object.
In Excel Online, this code works normally.
(Excel version is 16.0.12430.20172 64-bit)
0
votes