In Development
Last Updated: 24 Jul 2024 14:25 by ADMIN
Fritz
Created on: 21 Feb 2024 14:19
Category: SpreadProcessing
Type: Bug Report
2
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