The current worksheet is not updated if the workbook is set while the control is disabled.

Workaround: 

The used cell range is expanded when styles to all columns are applied and one copies an entire row.

Workaround:

 Exception when exporting document that contains links with an empty address.

Workaround:

Hi,

I think it would be really cool to include a search bar in the filter window, as implemented in Excel (Please find attached a screenshot for demonstration). This is a very useful functionality, as there may be too many options to choose from is the filter is added to subject ID, which could result in thousands IDs.

To reproduce; 

- Set the language to Korean

- Type "r" in one of the cells

- Use the AutoFill functionality

At this point, FatalExecutionEngineError occurs (see attached).  

To reproduce: 

- Select some cells within the same column using Ctrl+Click

- Use the context menu to copy the cells

This works in Excel when the cells are within the same column. 

The issue is a regression introduced in R3 2019. When the cells in a hidden column are with IsWrapped=true, an ArgumentOutOfRangeException is thrown during the text measuring. The behavior is related to SpreadProcessing as well.

Workaround: Remove the wrapping from the hidden cells:

var usedCellRange = workbook.ActiveWorksheet.GetUsedCellRange(new IPropertyDefinition[] { CellPropertyDefinitions.IsWrappedProperty});

for (int row = usedCellRange.FromIndex.RowIndex; row <= usedCellRange.ToIndex.RowIndex; row++)
{
    for (int column = usedCellRange.FromIndex.ColumnIndex; column <= usedCellRange.ToIndex.ColumnIndex; column++)
    {
        if (workbook.ActiveWorksheet.Columns[column].GetHidden().Value)
        {
            workbook.ActiveWorksheet.Cells[row, column].SetIsWrapped(false);
        }
    }
}