Scrolling / moving in sheet very slow

Posted by: petri.rasanen on 22 March 2021, 11:46 pm EST

  • Posted 22 March 2021, 11:46 pm EST

    Hi,

    Scrolling / moving in sheet is very slow in certain templates. Attached an excel that is very slow.
    TestFile.zip
  • Replied 23 March 2021, 9:00 pm EST

    Hi,

    Thanks for the sample file. We are able to replicate the issue at our end hence we have escalated this issue to the concerned team for further investigation. We will update you regarding this as soon as we get any information. The internal ID for this issue will be SJS-8108.

    Regards
    Avinash
  • Marked as Answer

    Replied 27 March 2021, 10:24 pm EST

    Hi,

    The Devs informed us that the identical rules in the file are causing this issue. You may use the following logic to combine all the rules.


    Object.keys(json.sheets).forEach(function (key) {
    var sheet = json.sheets[key], ruleMap = {};
    if (sheet.conditionalFormats && sheet.conditionalFormats.rules) {
    var rules = sheet.conditionalFormats.rules;
    rules.forEach(function (rule) {
    var key = rule.formula + "_" + JSON.stringify(rule.style);
    if (ruleMap[key]) {
    ruleMap[key].ranges = ruleMap[key].ranges.concat(rule.ranges);
    } else {
    ruleMap[key] = rule;
    }
    });
    }
    let newRules = [];
    Object.keys(ruleMap).forEach(function(key){
    newRules.push(ruleMap[key]);
    });
    sheet.conditionalFormats.rules = newRules;
    });


    We updated the original excel file, combine all formulas into one, it has the same effect but doesn't have any performance issues. Please refer to the following excel and let us know if you face any issues.

    Regards,
    Avinash
    TestFile 2.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels