Unplanned
Last Updated: 21 Feb 2024 14:19 by Fritz
Fritz
Created on: 21 Feb 2024 14:19
Category: SpreadProcessing
Type: Bug Report
0
SpreadProcessing: Incorrect calculation of UsedCellRange when conditional formatting is applied to a large cell range

Incorrect calculation of UsedCellRange when conditional formatting is applied to a large cell range.

Workaround:

var usedCellRange = workbook.ActiveWorksheet.GetUsedCellRange(
    CellPropertyDefinitions.AllPropertyDefinitions
    .Except(
        CellPropertyDefinitions.AllPropertyDefinitions.Where(p => p.Name == "DataValidationRule" || p.Name == "ConditionalFormatting")));

 

0 comments