What can make UsedCellRange to give bad values?

Hello Ian,

I have tried replicating your case with a basic approach and from my understanding, it seems like the formatting could be the reason UsedCellRange is not updated correctly.

The UsedCallRange takes into account all the formatting and value set in the cell. By setting a value and formatting a cell, then deleting only the cell's value, the formatting still exists. So, in order to be sure that the CellSelection is empty you can use the clear method by passing ClearType.All - selection.Clear(ClearType.All);

Please have a look at the example code:

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add();

CellSelection selection = worksheet.Cells[1, 1];
selection.SetValue("Hello RadSpreadProcessing");
selection.SetIsBold(true);
CellRange usedCellRange = worksheet.UsedCellRange;
selection.Clear(ClearType.All);

// Assert is false
bool isBold = selection.GetIsBold().Value;
// Assert is empty
CellRange newCellRange = worksheet.UsedCellRange;

Regards,
Aleks
Progress Telerik