Completed
Last Updated: 11 Sep 2023 15:00 by ADMIN
Release LIB 2023.2.918 (18 Sep 2023)
DataValidation of a list with defined names is not taking the source into account. As a result, values are not displayed as options in the cell drop-down list.
Completed
Last Updated: 11 Sep 2023 14:59 by ADMIN
Release LIB 2023.2.918 (18 Sep 2023)
ADMIN
Created by: Peshito
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
Defined names do not appear in the Name Box.
Completed
Last Updated: 01 Sep 2023 13:46 by ADMIN
Release LIB 2023.2.904 (4 Sep 2023)
A filter cannot be applied to the RadSpreadsheet when a sheet is protected even though the Filter option in the protection dialog is checked. 
Unplanned
Last Updated: 03 Oct 2023 12:13 by Harald
Slow performance with documents that contain many custom styles. 
Unplanned
Last Updated: 13 Oct 2023 15:29 by ADMIN

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?


Unplanned
Last Updated: 29 Nov 2023 08:54 by Srikanth
Memory leak when opening a new window that contains a spreadsheet several times.
Unplanned
Last Updated: 17 Jan 2024 10:44 by Ugnius
Data validation dialog buttons should respond to the Enter or Esc keys (Retry, Cancel).
Unplanned
Last Updated: 20 Feb 2024 07:36 by Premkumar
Provide a way so one can change the default cell editor with a custom one.
Unplanned
Last Updated: 29 Feb 2024 12:10 by Premkumar
Implement auto complete for ListDataValidationRule like in Excel.
Unplanned
Last Updated: 09 May 2024 07:23 by n/a
Add sheet list that allows activating a sheet similar to Excel.
Unplanned
Last Updated: 20 Jun 2024 08:49 by Robby
Add support for digital signature in the XLSX format.
Completed
Last Updated: 20 Dec 2024 08:46 by ADMIN
Release 2024.4.1219 (Preview)

The numeric box that allows you to select the "to" page in the PrintPreviewControl is clipped when the "Pages:" and "to" strings are translated to a language where these words are longer. For example, this reproduces with Dutch culture which uses the "Pagina's:" and "naar" texts.

To work this around, you can get the Grid panel that hosts the content and increase the Width of one of its ColumnDefinitions.

  private void PrintPreviewControl_Loaded(object sender, RoutedEventArgs e)
  {
      var printPreview = (PrintPreviewControl)sender;
      var rootGrid = printPreview.FindChildByType<Grid>();
      rootGrid.ColumnDefinitions[0].Width = new GridLength(355);
  }

Unplanned
Last Updated: 31 Mar 2025 09:35 by Martin Ivanov

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"];
}