The horizontal ScrollBar of RadSpreadsheet is missing the bottom border of its track. Additional to that there is a slight offset between the right end of the viewport and the right button of the ScrollBar.
To work this around, set the Margin of the horizontal ScrollBar to 0, and modify its ControlTemplate so that it adds a bottom border for the track's RepeatButton elements.
private void RadSpreadsheet_Loaded(object sender, RoutedEventArgs e)
{
var spreadsheet = (RadSpreadsheet)sender;
var scrollBar = spreadsheet.ChildrenOfType<ScrollBar>().FirstOrDefault(x => x.Name == "HorizontalScrollBar");
scrollBar.Margin = new Thickness(0);
scrollBar.Template = (ControlTemplate)this.Resources["MyCustomScrollBarTemplate"];
}
For the German language translations, the following resource keys are translated into Dutch instead:
- Spreadsheet_PrintPreview_FitSheetOnOnePage
- Spreadsheet_PrintPreview_FitSheetOnOnePage_Description
- Spreadsheet_PrintPreview_FitColumnsOnOnePage
- Spreadsheet_PrintPreview_FitColumnsOnOnePage_Description
- Spreadsheet_PrintPreview_FitRowsOnOnePage
- Spreadsheet_PrintPreview_FitRowsOnOnePage_Description
Add a "Create New Document" option that allows you to create a document from the selected cell range, like in the Excel version of the Insert Hyperlink dialog.
Add information about the selection in the SelectionChanged event arguments.
- We need to differentiate from mouse event to keyboard event. But since the EventArgs is empty we are not able to differentiate.
When RadSpreadsheet is placed inside a data template and the Workbook property is bound, the binding fails. In the Convert() method of the debug converter, the proper value is set. However, an empty workbook is displayed in the view.
Spreadsheet: Add the ability to build formulas using keyboard navigation:
1. Press '=' in a cell. The cell goes into Edit Mode.2. Use the Keyboard arrow keys to move in any direction. The Cell reference of the focused cell is automatically entered after the '=' into the cell which is in edit mode.
3. The user can press the Control+Arrow Key to add a reference to an entire row or column of data.
Copy/Paste a shape and then an image leads to a wrong result.
Steps to reproduce:
1. Copy plain text from a plain text editor onto the clipboard -> Paste in Spreadsheet and the text is pasted OK.2. Copy the image from another app onto the clipboard -> Paste in Spreadsheet and the "This information cannot be pasted" dialog is displayed.
3. Insert picture from file into spreadsheet -> image displayed in a shape.
4. Select and copy the shape.
5. Repeat step 1 => Copy plain text from a plain text editor onto the clipboard -> Paste in Spreadsheet and the text is pasted OK.
6. Repeat step 2 => Copy image from another app onto clipboard -> Paste in Spreadsheet and shape selected and copied in step 4 is pasted. => Not expected result.
We have a problem creating an Excel file with Telerik.Windows.Documents.Spreadsheet.
In our last release for our customers we used Telerik WPF version 22.2.613.40 (Spreadsheet DLL) When calling the following line of code
m_Worksheet.Cells[m_CurrentRowIndex, m_CurrentColumnIndex].SetValue("111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111"); the CellValueType is set to text and the Value is correct. We have now switched our project to .NET 7 and Telerik WPF to version 2023.2.519.70. We discovered that this line of code no longer works. The CellValueType is now Number and the Value Infinity Have you changed anything internally? How can we solve the problem now?