等效于office-js Excel加载项中的Application.ScreenUpdating属性 [英] Equivalent to Application.ScreenUpdating Property in office-js Excel add-in

问题描述

我将大量数据插入到工作表中，这样做时屏幕闪烁.在VBA和com加载项中，有一个属性可以设置为延迟更新，直到更新完成.

I am inserting a lot of data into a sheet and the screen flickers when doing so. In VBA and com add-ins there's a property I can set to delay the updates until they're finished.

excel的office-js加载项中是否有与Application.ScreenUpdating属性等效的内容?

Is there an equivalent to Application.ScreenUpdating Property in office-js add-ins for excel?

推荐答案

Office.js中没有等效的功能-到目前为止还没有.有很多技术问题可以防止这种情况发生(FWIW，如果您很好奇，请在打开任务窗格时尝试在VBA中切换ScreenUpdating；您会明白我的意思).

There is no equivalent for it in Office.js -- not yet, at any rate. There are a number of technical issues that prevent this (FWIW, if you're curious, try toggling ScreenUpdating in VBA while you have a taskpane open; you'll see what I mean).

有一些较长期的想法可能会帮助解决此问题，但要保持透明，我希望它还有几个月和几个月的时间.也就是说，我鼓励您在 https://officespdev.uservoice.com/(或搜索是否已经存在)，并描述您的情况和/或链接到您当前所见问题的视频，以便我们在人们的视野中予以解决.

There are some longer-term ideas that may help with this issue, but to be very transparent, I would expect that it's months and months away. That said, I do encourage you to file a suggestion on https://officespdev.uservoice.com/ (or search if one already exists) and describe your scenario and/or link to a video of the issue you're currently seeing, so we can get it up on folks' radar.

这篇关于等效于office-js Excel加载项中的Application.ScreenUpdating属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！