Last Updated: 28 Jul 2021 14:01 by ADMIN
Created by: Dennis
Comments: 0
Category: Spreadsheet
Type: Bug Report

I am using the Spreadsheet control and noticed that when I move to the right by clicking on the horizontal scroll arrow, the scroll does not seem to work as expected. I have to click on the scroll arrow 4 times for it to work correctly. 
In Development
Last Updated: 28 Jul 2021 13:14 by ADMIN

1.Make the sheet protected

2. Paste using Ctrl+V

The first message shows:


Last Updated: 28 Jul 2021 10:54 by ADMIN
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%.  
In Development
Last Updated: 28 Jul 2021 06:45 by ADMIN

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)

Last Updated: 20 Jul 2021 11:04 by ADMIN
Release R3 2021
Created by: Ioannis
Comments: 3
Category: Spreadsheet
Type: Bug Report



So here's what happens. I create a workbook and a worksheet in that wb which I assign as the workbook of a RadSpreadSheet by RadSpreadSheet..Workbook = wb

The first time I assign a name to the first (and only sheet) created in the creation of the wb, the name does appear on that sheet.

Then some code takes this workbook ByVal, creates a new Sheet, makes that sheet the wb's ActiveWorksheet and then changes the ws's name.

You can see in the debugging that the worksheet does have the new name i put there ("2018-05"), but visually this 2nd worksheet has the default name "sheet 2".

Then that wb which is returned by the function is assigned as the RadSpreadSheet's workbook

If I run the code again, so a 3rd sheet is created, then the 3rd sheet will visually have the default name "sheet 3", however in the debugger it says "2018-06" as its name; but most importantly, now sheet 2 has magically changed to what I was seeing its name to be in the debugger ("2018-05").


I'm assuming that If I'm changing the sheet names at runtime, I need to call some method on the Workbook element or something like that in order to update the names. I just couldn't find which method to call.


Best regards,

Ioannis Mamalikidis.

Last Updated: 19 Jul 2021 12:21 by ADMIN



if you add a Style to a cell containing a "\n"  (which I am forced to use, since text wrap does not work either) the style won't apply.


To reproduce just add a radspreadsheet to a form

public Form1()

            Workbook workbook = new Workbook();
            radSpreadsheet1.Workbook = workbook;

            Worksheet worksheet = workbook.ActiveWorksheet;

            CellStyle style = workbook.Styles.Add("HeaderStyle");
            style.IsBold = true;

            worksheet.Cells[0, 0].SetValue("first\ncell");
            worksheet.Cells[0, 1].SetValue("second cell");

            worksheet.Cells[0, 0, 0, 1].SetStyleName("HeaderStyle");



Last Updated: 14 Jul 2021 06:08 by ADMIN
Created by: Desislava
Comments: 2
Category: Spreadsheet
Type: Feature Request
At this point, character formatting can be applied only to the whole cell content. Enable applying rich text formatting only to parts of the text inside a cell.
Last Updated: 06 Jul 2021 08:20 by ADMIN
One of the options grouped under alignment is Shrink to Fit. Shrink to fit will automatically reduce the font size until text fits in a cell.
Last Updated: 05 Jul 2021 16:22 by ADMIN
Provide API allowing to import documents on background thread. The API should allow the passing of a CancellationToken in order to cancel the import at any time.
Last Updated: 11 Jun 2021 10:12 by ADMIN
Release R2 2021 SP1
The formula cell value is not updated when another cell value is changed.
Last Updated: 08 Jun 2021 06:09 by ADMIN

One cannot reference another sheet in a formula by using the UI.

To replicate,

1. Open your spreadsheet demonstration app.

2. Create two work pages.

3. Enter some information on the first page.

4 .go to the second page, select any cell, and press =

5. navigate to the first page and select a cell with data in it.

6. Check the second page again, there is no reference link.

Workaround: manually type the sheet name in the formula

Last Updated: 06 May 2021 12:43 by ADMIN
Charts: Add support for data rows or separate axes with values  on the chart (see attached) 
Last Updated: 23 Feb 2021 07:08 by ADMIN
Created by: Dennis
Comments: 0
Category: Spreadsheet
Type: Feature Request
MS Excel supports dragging cells and thus moving the value to a new cell. 
Last Updated: 19 Feb 2021 09:45 by ADMIN
Release R1 2021 SP2

I have implemented the ListDataValidationRule code to add a dropdownlist to the spreadsheet. Based on the code I can find and the searching I have conducted, it seems to be correct, however the dropdown does not appear in the control.

The dropdown list does appear in Excel when I export the file.


Dim Context As ListDataValidationRuleContext = New ListDataValidationRuleContext(CurrentWorksheet, CurrentCellIndex)

Context.InputMessageTitle = "Restricted input"
Context.InputMessageContent = "The input is restricted to the week days."
Context.ErrorStyle = ErrorStyle.Stop
Context.ErrorAlertTitle = "Invalid Bedroom Type"
Context.ErrorAlertContent = "The entered value is not valid."
Context.InCellDropdown = True

Context.Argument1 = String.Join(",", _Data.ArchitectCert_UnitBedrooms.AsEnumerable().Select(Function(x) x.Field(Of Integer)("UnitBedroomNumber").ToString()).ToArray())

Dim Rule As ListDataValidationRule = New ListDataValidationRule(Context)

Last Updated: 15 Jan 2021 12:55 by ADMIN
The wrap text feature does not work as expected when not in edit mode
Last Updated: 06 Nov 2020 09:47 by ADMIN
Created by: Matthias
Comments: 0
Category: Spreadsheet
Type: Bug Report

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.

Last Updated: 07 Oct 2020 11:46 by ADMIN
Release R3 2020 SP1 (LIB 2020.3.1007)

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?

Last Updated: 26 May 2020 07:56 by ADMIN

To reproduce: 

Add the rule from this article and observe the result: Data Validation

Last Updated: 08 Apr 2020 10:23 by ADMIN
Exception when setting transparent texbox editor background
Last Updated: 20 Jan 2020 14:11 by ADMIN
Release R1 2020 SP1 (LIB 2020_1_120)


Using the last release of RadSpreadsheet, I get an exception when the first row is hidden when scrolling with the mousewheel. Attached is a demo.



1 2 3