Completed
Last Updated: 21 Sep 2022 12:57 by ADMIN
Release R3 2022 SP1
ArgumentNullException is thrown when writing in a cell and focus another cell.
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: 31 Jan 2024 11:39 by ADMIN
Release 2024 Q1 (2024.1.130)
NullReferenceException is raised when loading document with charts.
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: 25 Jan 2024 08:06 by ADMIN
This exception will be thrown when the control zoom setting is changed and we drag a selection rectangle outside of the worksheet.
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: 12 Jun 2024 08:17 by Ken
If you type =sum( and leave it at that, then go into the column and start pressing Shift+click to start selecting a range, it throws an error. 
Unplanned
Last Updated: 17 May 2024 12:30 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: 25 Jan 2024 08:45 by ADMIN
Setting the worksheet to protected does not prevent the user from changing the name of the worksheet. 
Unplanned
Last Updated: 07 Mar 2024 14:09 by Walter
Created by: Walter
Comments: 0
Category: Spreadsheet
Type: Feature Request
0
Editable chart in RadSpreadsheet
Unplanned
Last Updated: 07 Mar 2024 14:27 by Walter
Created by: Walter
Comments: 0
Category: Spreadsheet
Type: Feature Request
0
Add axis titles to the charts
Completed
Last Updated: 03 Aug 2021 16:38 by ADMIN
Release R3 2021
For example, going at a slow pace when clicking the right zoom arrow, a user can switch from 50% to 55% to 60% to 65% to 70% to 75% to 80%, and so-forth. The user properly progresses through (let's say) 10 increments, eventually arriving at 100%.    However, if the user clicks the arrow the same 10 times, but at a faster pace, many of the increments are skipped over.  In one test, 10 rapid clicks brought me from 50% up to 250%.  
Completed
Last Updated: 02 Aug 2021 08:33 by ADMIN
Release R3 2021 (LIB 2021_2_802)

Right-click an empty cell and select Copy. 

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ArgumentNullException: Value cannot be null.
Parameter name: text
   at System.Windows.Forms.Clipboard.SetText(String text, TextDataFormat format)
   at System.Windows.Forms.Clipboard.SetText(String text)
   at Telerik.WinForms.Controls.Spreadsheet.Clipboards.ClipboardEx.MSClipboardSetText(String text)
   at Telerik.WinForms.Controls.Spreadsheet.Clipboards.ClipboardEx.SetTextInternal(String text)
   at Telerik.WinForms.Controls.Spreadsheet.Clipboards.ClipboardEx.SetDataInternal(String text, WorksheetFragment fragment)
   at Telerik.WinForms.Controls.Spreadsheet.Worksheets.RadWorksheetEditor.Copy()
   at Telerik.WinForms.Controls.Spreadsheet.Worksheets.RadWorksheetEditorCommands.<>c.<InitializeCommands>b__575_94(RadWorksheetEditor editor, Object parameter)
   at Telerik.WinForms.Controls.Spreadsheet.Commands.RadSheetEditorDelegateCommand`1.ExecuteOverride(Object parameter)
   at Telerik.WinForms.Controls.Spreadsheet.Commands.RadSheetEditorCommandBase`1.Execute(Object parameter)
   at Telerik.WinControls.UI.RadSpreadsheetElement.<CreateDefaultWorkbookContextMenu>b__184_1(Object <p0>, EventArgs <p1>)
   at Telerik.WinControls.RadElement.OnClick(EventArgs e)
   at Telerik.WinControls.UI.RadButtonItem.OnClick(EventArgs e)
   at Telerik.WinControls.UI.RadMenuItem.OnClick(EventArgs e)
   at Telerik.WinControls.RadElement.DoClick(EventArgs e)
   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.DoMouseUp(MouseEventArgs e)
   at Telerik.WinControls.ComponentInputBehavior.OnMouseUp(MouseEventArgs e)
   at Telerik.WinControls.RadControl.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(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 Telerik.WinControls.UI.RadPopupControlBase.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: 06 Jun 2023 07:28 by ADMIN

Please refer to the attached gif file.

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: 27 Jul 2022 12:41 by Tomas
The protection set in the column style has higher priority than the one set in the cell format. This causes invalid behavior and some cells can be edited despite the protection. 
Unplanned
Last Updated: 09 Feb 2022 07:57 by Ken
The row/column headers font is too large when the scaling is 200% or more. 
Duplicated
Last Updated: 04 Feb 2022 13:25 by ADMIN
Created by: Tomas
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
Text wrap does not work 
Completed
Last Updated: 04 Jan 2022 16:55 by ADMIN
Release R1 2022
Created by: Christopher
Comments: 1
Category: Spreadsheet
Type: Bug Report
0
If I type a lowercase letter, the cell accepts the text and is placed in edit mode. If I type an upper case letter (holding Shift), nothing happens (no edit mode, no text displays in the cell).