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 ){
radSpreadsheet.IsEnabled = false;
Workbook spreadsheetWorkbook =
new XlsxFormatProvider( ).Import( File.ReadAllBytes( @"..\..\Book2.xlsx" ) );
radSpreadsheet.Workbook = new Workbook( );
Dispatcher.InvokeAsync( ( ) => radSpreadsheet.Workbook = spreadsheetWorkbook );
radSpreadsheet.IsEnabled = true;
}
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){
var range = this.radSpreadsheet.Workbook.ActiveWorksheet.UsedCellRange;
this.radSpreadsheet.ActiveWorksheet.Columns[range.ColumnCount + 1, SpreadsheetDefaultValues.ColumnCount - 1].Clear(ClearType.All);
}
Exception when exporting document that contains links with an empty address.
Workaround:
private void Button_Click_1(object sender, RoutedEventArgs e){
foreach (SpreadsheetHyperlink item in this.radSpreadsheet.Workbook.ActiveWorksheet.Hyperlinks.ToList())
{
if (string.IsNullOrEmpty(item.HyperlinkInfo.Address))
{
this.radSpreadsheet.Workbook.ActiveWorksheet.Hyperlinks.Remove(item);
}
}
}
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);
}
}
}
Hello,
In the spreadsheet control you cannot link/use in a function cells from one work sheet to cell(s) in another work sheet. Would like to have the same behavior and functionality of Excel, which allows you to use data from one sheet in any other sheet in the work book. Need the ability to create a sum of (or any other function available) cells from another worksheet in my current worksheet, within the same workbook.
