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 )
The used cell range is expanded when styles to all columns are applied and one copies an entire row.
Workaround:
private void RadSpreadsheet_WorkbookChanged(object sender, EventArgs e)
Exception when exporting document that contains links with an empty address.
Workaround:
private void Button_Click_1(object sender, RoutedEventArgs e)
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);
}
}
}