In Development
Last Updated: 05 Dec 2023 13:19 by ADMIN
Scheduled for Q1 2024
NullReferenceException is raised when loading document with charts.
Unplanned
Last Updated: 09 Oct 2023 11:11 by ADMIN
Users want to save the workbook via the Save ribbon button, but they want a default filename in the save dialog (not "book1.xlsx"). 
Unplanned
Last Updated: 27 Sep 2023 12:54 by ADMIN
Created by: Louis
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Currently, the WinForms Spreadsheet doesn't have separators between the column headers:

It would be better to have separators for the headers like the WPF Spreadsheet:

Duplicated
Last Updated: 27 Sep 2023 08:01 by ADMIN
Created by: Dinko
Comments: 1
Category: Spreadsheet
Type: Feature Request
0
Implement support for Comments functionality in the Spreadsheet.
Unplanned
Last Updated: 01 Sep 2023 09:25 by ADMIN
Unplanned
Last Updated: 29 Aug 2023 11:51 by ADMIN
Duplicated
Last Updated: 14 Jul 2023 09:31 by ADMIN
Created by: n/a
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Please add radSpreadsheet RTL support in windows version of Telerik.

Today we testing last trial version , and we see this option inside the component properties , but its not working.

Thank You.

Unplanned
Last Updated: 27 Jun 2023 05:01 by ADMIN
Unplanned
Last Updated: 06 Jun 2023 07:28 by ADMIN

Please refer to the attached gif file.

Completed
Last Updated: 08 May 2023 14:41 by ADMIN
Release R2 2023
Exception in the ValueContextResolver when importing a document that contains conditional formatting.
Unplanned
Last Updated: 02 May 2023 06:05 by ADMIN

This is the sample code snippet:

        public RadForm1()
        {
            InitializeComponent();
            this.radSpreadsheet1.SpreadsheetElement.ActiveWorksheetEditor.MouseClick += ActiveWorksheetEditor_MouseClick;
        }

        private void ActiveWorksheetEditor_MouseClick(object sender, Telerik.WinControls.Spreadsheet.UI.MouseButtonEventArgs e)
        {
            Console.WriteLine(DateTime.Now.ToLongTimeString());
            var selection = this.radSpreadsheet1.SpreadsheetElement.ActiveWorksheetEditor.Selection.ActiveRange;
            if (!selection.IsColumnRange)
            {
            }
        }

Unplanned
Last Updated: 28 Apr 2023 10:05 by Ian

At the moment when any of the properties are changed, e.g. the frozen panes, the UI is not notified and you have to export and import the file in order for the UI to pick them up. 


Workaround: There are several workarounds:

1. Change the active worksheet and return to the old one

2. Export and import the document

3. Change the workbook of the RadSpreadsheet to a new one, and return the old one after that

4. Freeze the active worksheet using the ActiveWorksheetEditor.FreezePanes() method and freeze all others using the ViewState:

this.radSpreadsheet1.ActiveWorksheetEditor.FreezePanes(new CellIndex(10, 3));
foreach (var worksheet in this.radSpreadsheet1.Workbook.Worksheets)
{
      worksheet.ViewState.FreezePanes(5, 5);
}
Completed
Last Updated: 27 Apr 2023 06:55 by ADMIN
Release R2 2023 (LIB 2023.1.427)

Create an empty project with a RadSpreadsheet. Hide column A and B and try to scroll:

System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at Telerik.Windows.Documents.Spreadsheet.Layout.RadWorksheetLayout.GetColumnWidth(Int32 columnIndex)
   at Telerik.WinForms.Controls.Spreadsheet.Worksheets.RadWorksheetEditorPresenterBase.SetHorizontalOffsetInternal(ScrollEventType scrollType, Double value)
   at Telerik.WinForms.Controls.Spreadsheet.Worksheets.RadWorksheetEditor.SetHorizontalOffsetInternal(ScrollEventType scrollType, Double value)
   at Telerik.WinControls.UI.RadSpreadsheetElement.ScrollBar_Scroll(Object sender, ScrollEventArgs e)
   at System.Windows.Forms.ScrollEventHandler.Invoke(Object sender, ScrollEventArgs e)
   at Telerik.WinControls.UI.RadScrollBarElement.OnScroll(ScrollEventArgs args)
   at Telerik.WinControls.UI.RadScrollBarElement.CallOnScroll(ScrollEventType scrollType, Int32 oldValue, Int32 newValue)
   at Telerik.WinControls.UI.RadScrollBarElement.ScrollWith(Int32 step, ScrollEventType scrollType)
   at Telerik.WinControls.UI.RadScrollBarElement.OnScrollTimer(Object sender, EventArgs e)
   at Telerik.WinControls.UI.RadScrollBarElement.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.RadElement.OnCLREventsRise(RoutedEventArgs args)
   at Telerik.WinControls.RadElement.OnBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadItem.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadItem.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.RaiseRoutedEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.DoMouseDown(MouseEventArgs e)
   at Telerik.WinControls.ComponentInputBehavior.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.Spreadsheet.UI.RadSpreadsheetComponentInputBehavior.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.RadControl.OnMouseDown(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at Telerik.WinControls.RadControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Unplanned
Last Updated: 05 Apr 2023 07:33 by ADMIN

In Material(Pink,Teal,BlueGrey) themes, the row heading numbers are truncated.

Unplanned
Last Updated: 07 Mar 2023 12:14 by ADMIN

Clicking on a calculated cell leads to the following error and crashes the demo:

Completed
Last Updated: 02 Feb 2023 09:35 by ADMIN
Release R1 2023

Import the attached sample file, right-click on the first cell and select Format Cell:

Expected result: correct cell style should be loaded as it is MS Excel:

Completed
Last Updated: 02 Feb 2023 09:35 by ADMIN
Release R1 2023

Import the attached document:

Expected result: the cell B1 should be rendered with bold text as in MS Excel:

Unplanned
Last Updated: 19 Jan 2023 11:41 by ADMIN
Created by: Kim
Comments: 4
Category: Spreadsheet
Type: Feature Request
3
Add support for conditional formatting 
Unplanned
Last Updated: 19 Jan 2023 11:39 by ADMIN
Created by: Matthias
Comments: 2
Category: Spreadsheet
Type: Bug Report
3

Currently, it takes around 5 seconds to load the RadSpreadsheetRibbonBar.

Please run the project and compare the load time when clicking the two buttons in the main form.

Unplanned
Last Updated: 01 Dec 2022 13:46 by ADMIN

Please follow the steps in the VS Designer:

1. Add a RadSpreadsheet and Office2019Dark theme:

2. Set the ThemeName for RadSpreadsheet to Office2019Dark:

3. Run the project. You will see that the row/column headers are not readable:

4. Stop the project and reopen the designer:

 

1 2 3 4 5