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);
}
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 background should be stretched along with the item itself. It is currently with specified width. Workaround: Modify the style and change the width of the tab item. A sample is attached.
Implement UI for hiding sheet. The sheets can be visible, hidden, or very hidden (could be made visible only from the API). Note: This is already supported on model level (in RadSpreadProcessing).
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).
Currently it's not possible to disable the fill handle feature. Provide API for disabling it.
Workaround: in the attached project.
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.
If a document contains many and complex formulas (with many functions having other functions as arguments) it may take a long time to show in the control.