Setting a cell value seems to be very slow when the sheet contains several formulars.
I this the optimal code to set a cell value :
var rr = range._sheet.range(row, column);
Is there any setting that disable automatic calculation "manual calculation" ? Could offer a better performance by
1. disable automatic calculation
2. set all cell values
3. activate automatic calculation.