OfficeDev / office-js

A repo and NPM package for Office.js, corresponding to a copy of what gets published to the official "evergreen" Office.js CDN, at https://appsforoffice.microsoft.com/lib/1/hosted/office.js.
https://learn.microsoft.com/javascript/api/overview
Other
687 stars 94 forks source link

Chart is sometimes not updated when source is a volatile custom function #885

Closed ddanehl closed 3 years ago

ddanehl commented 4 years ago

when you have a chart which source is a range with volatile custom functions, it can happen that it is sometimes not updated. you then have to move/resize it that it is updated.

Expected Behavior

that the chart updates always correctly

Current Behavior

chart is sometimes not updated and is displayed as empty

Steps to Reproduce, or Live Example

use ScriptLab volatile sample (ROLL6SIDED) and create chart on it as shown in the attached gif. then press F9 a few times and the issue will happen.

Context

show a chart on data that is returned by custom functions

Your Environment

chart_cf_colatile_bug

RuoyingLiang commented 4 years ago

Thanks for reporting. This is a known issue. We are working on fixing. Sorry for the inconvenient.