At this point, the ribbon and the context menu are not localized out of the box and the users need to change the strings manually.
Implement functionality to rotate the text in a cell.
The sheet selector should hide sheets when their visibility is set to hidden or very hidden. The context menu of the sheet selector should contain Hide and Unhide options that allow to hide a sheet or unhide one of the hidden sheets.
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 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)
Provide the ability to work with images in headers/footers of a worksheet. Note that large images put in headers are visualized as watermarks on printing/exporting to PDF.
- 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).