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
Forums Home / Spread / SpreadJS
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
Posted 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
Posted 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