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)
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:
Import the attached document:
Expected result: the cell B1 should be rendered with bold text as in MS Excel:
When the HorizontalAxisStroke is not specified, an error occurs during the document's loading.
Filter buttons are not hidden when a column is hidden
Workaround in the attached project.
1.Make the sheet protected
2. Paste using Ctrl+V
The first message shows:
Then:
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)
I have a RadSpreadsheet control on a form. It has a good number of cells protected though this behavior is independent of the protection status.
If I click on a cell, move to the cell using the keyboard (up arrow, etc), and then push the delete key the cell formatting is cleared. When the spreadsheet is protected and I hit delete in the same circumstance on an unlocked cell the formatting is cleared and the cell is then locked.
Is there something I am missing or have not set?