How can we improve Spreadsheets?

when fill large amount of fumula in sheet, the add/remove row will cost large amount of time

var spread = new GcSpread.Sheets.Spread(document.getElementById('ss'), { sheetCount: 1 });
var sheet = spread.getActiveSheet();

sheet.setRowCount(2005);

sheet.isPaintSuspended(true);
sheet.suspendEvent();
sheet.suspendCalcService();

for (var i = 1; i < 2000; i++) {
for (var j = 1; j < 21;j++) {
sheet.setFormula(i, j, 'A1+A'+ (i + 1) + '+' + String.fromCharCode(j + 65) + '1');
}
}

sheet.resumeCalcService();
sheet.resumeEvent();
sheet.isPaintSuspended(false);

then:

var spread = new GcSpread.Sheets.Spread(document.getElementById('ss'), { sheetCount: 1 });
var sheet = spread.getActiveSheet();

sheet.setRowCount(2005);

sheet.isPaintSuspended(true);
sheet.suspendEvent();
sheet.suspendCalcService();

for (var i = 1; i < 2000; i++) {
for (var j = 1; j < 21;j++) {
sheet.setFormula(i, j, 'A1+A'+ (i + 1) + '+' + String.fromCharCode(j + 65) + '1');
}
}

sheet.resumeCalcService();
sheet.resumeEvent();
sheet.isPaintSuspended(false);

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    balbo shared this idea  ·   ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base