ScreenUpdating Office-js任务窗格 [英] ScreenUpdating Office-js taskpane

问题描述

在开发一个新的taskpane插件的时候，我们推出了一个大的两个痴呆对象，例如excel工作簿，并根据另一个对象格式化一些行。

While developing a new taskpane addin we push a large two dementional object ot the excel workbook and format some rows based on another object.

在执行此操作时，用户可以看到他的excel工作簿闪烁。

While doing this the user can see his excel workbook flickering.

对于旧的com api，通过关闭屏幕更新属性，得到了一个讽刺。
ScreenUpdating MSDN

With the old com api there was a salution by turning off the screen updateing property. ScreenUpdating MSDN

在office-js中是否有这样的excel？

is there something like this in office-js for excel?

推荐答案

Office-js没有关闭屏幕更新的API。你提到的闪烁可能是数据更新和控制返回到UI之间的控制。在此更新时间范围内，API允许用户与Excel UI进行交互，例如按钮/鼠标点击，选择等。我明白这可能很麻烦。

Office-js doesn't have an API to turning off screen updating. The flickering you mentioned is probably the control going back-n-forth between the data update and control returning to the UI. During this update timeframe, the API allows user to interact with Excel UI such as button/mouse clicks, selection, etc. I do understand this can be bothersome.

我们正在添加一些功能来帮助加快更新本身，例如延迟计算。这将减少用户看到更新模式打开和关闭的持续时间。

We are adding some features to help speed-up the update itself such as by delaying the calculation. This will reduce the duration for which users see the update mode on and off.

这篇关于ScreenUpdating Office-js任务窗格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！