Scrolling / moving in sheet very slow

Scrolling / moving in sheet very slow

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

• 

  petri.rasanen

  • Post Options:
  • Link
    Copy

  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
• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  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

  

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  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