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);
}
}
}
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.
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).
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.
Exception when exporting document that contains links with an empty address.
Workaround:
private void Button_Click_1(object sender, RoutedEventArgs e)
The current worksheet is not updated if the workbook is set while the control is disabled.
Workaround:
private void RadButton_Click( object sender, RoutedEventArgs e )
this.radSpreadsheet.ActiveWorksheet.ViewState.TabColor = new ThemableColor(Colors.Red);
The scroll exceeds the visible area when using the auto-fill.
Steps to reproduce:
- Set the VisibleSize to (10 ,10)
- Drag the autofill icon down