-
New Feature
-
Resolution: Done
-
Normal
-
3.5.0
-
None
-
None
When calling Range#setXxx(), zk spreadsheet will automatically check cell dependencies, update the dependent cells and refresh the spreadsheet UI of the range. However, in some cases, developers might not want such "automation" and like to control the evaluation and update(see ZSS-751) by themselves. Thus we provide this method.
Range.java
/** * Turn on(true)/off(false) of auto refresh of this range and return previous on/off status. */ public boolean setAutoRefresh(boolean auto);
MyApp.java
... boolean old = range.setAutoRefresh(false); // turn off auto update of this range try { range.setEditText(...); // do whatever setXxx() operation; will not evaluate and update automatically ... } finally { range.setAutoRefresh(old); // set to previous value }