At the moment the print settings set to the WorksheetPageSetup class are not passed to the Print dialog which leads to bad user experience. If you set the print settings of the RadSpreadsheet like so:

WorksheetPageSetup pageSetup = this.radSpreadsheet.Workbook.ActiveWorksheet.WorksheetPageSetup;
pageSetup.PageOrientation = PageOrientation.Landscape;

and then select Print, the Spreadsheet print menu will show the print preview as landscape. However, when after that you click on Print for the default print dialog to appear and then click Preferences, you will notice that the preference is set to Portrait. The print job will be Landscape, but the incorrect information in the default dialog creates confusion.

This is an example of how to set the preference of the default dialog:

PrintDialog printDialog = new PrintDialog();
var printTicket = printDialog.PrintTicket;
printTicket.PageOrientation = System.Printing.PageOrientation.Landscape;

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

Workaround:

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:

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);
        }
    }
}