Completed
Last Updated: 09 Jun 2022 08:39 by ADMIN
Release R2 2022 SP1
Exception when setting transparent texbox editor background
Completed
Last Updated: 03 Jun 2022 13:06 by ADMIN
Release R2 2022 SP1

Filter buttons are not hidden when a column is hidden

Workaround in the attached project. 

Unplanned
Last Updated: 01 Apr 2022 09:50 by Fratessa
Exception when copying sheet with conditional formatting and opening it in RadSpreadsheet
Completed
Last Updated: 18 Feb 2022 15:16 by ADMIN
Release R1 2022 SP1
The FilteringUILayer contains an internal collection of FilteringPopupControls for the different cells in RadSpreadsheet. It would be good to provide a convenient API for accessing these FilteringPopupControls and allowing any customizations over its menu items.
Completed
Last Updated: 18 Feb 2022 15:14 by ADMIN
Release R1 2022 SP1
The filtering popup layout is not correct when a cell contains a very long text.
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). 
Completed
Last Updated: 04 Jan 2022 10:09 by ADMIN
Release R1 2022
When importing a document containing a hyperlink formula (e.g. "=HYPERLINK(B2,A2)") an exception is thrown: System.Collections.Generic.KeyNotFoundException: 'The given key was not present in the dictionary.'
Unplanned
Last Updated: 17 Dec 2021 06:51 by ADMIN
Expose the most used events on the control so they can be accessed at design time. Currently, most of the events are on the SpreadsheetElement.
Unplanned
Last Updated: 23 Aug 2021 05:57 by ADMIN

Steps to reproduce: 

1. Handle the MessageShowing event like this: 

private void SpreadsheetElement_MessageShowing(object sender, Telerik.WinForms.Controls.Spreadsheet.MessageShowingEventArgs e)
{
    e.IsHandled = true;
}

2. Protect the Workbook 

3. Start the app and paste with the context menu

Actual: A dialog is shown 

Unplanned
Last Updated: 19 Aug 2021 06:24 by ADMIN
Created by: Dennis
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Introduce support for Spell Check
Unplanned
Last Updated: 09 Aug 2021 11:23 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.
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: 03 Aug 2021 13:40 by ADMIN
Release R3 2021
Double-Clicking the fx button in the formula bar allows modifications to protected worksheet
Completed
Last Updated: 02 Aug 2021 08:33 by ADMIN
Release R3 2021 (LIB 2021_2_802)
Created by: Dennis
Comments: 0
Category: Spreadsheet
Type: Bug Report
3
Hi,

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. 
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)

Completed
Last Updated: 02 Aug 2021 08:33 by ADMIN
Release R3 2021 (LIB 2021_2_802)

1.Make the sheet protected

2. Paste using Ctrl+V

The first message shows:

Then:

Completed
Last Updated: 02 Aug 2021 08:33 by ADMIN
Release R3 2021 (LIB 2021_2_802)
Created by: Ioannis
Comments: 3
Category: Spreadsheet
Type: Bug Report
3

Hello,

 

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.

Completed
Last Updated: 30 Jul 2021 12:00 by ADMIN
Release R3 2021
Workaround: Handle the MouseWheel event of the control

private void RadSpreadsheet1_MouseWheel(object sender, MouseEventArgs e)
{
    int offset = this.radSpreadsheet1.SpreadsheetElement.VerticalScrollBar.SmallChange * 3;
    int x = e.Delta < 0 ? offset : -offset;
    this.radSpreadsheet1.SpreadsheetElement.VerticalScrollBar.ClampValue = true;
    this.radSpreadsheet1.SpreadsheetElement.VerticalScrollBar.Value += x;

    RadWorksheetEditor editor = this.radSpreadsheet1.SpreadsheetElement.ActiveSheetEditor as RadWorksheetEditor;
    if (editor != null)
    {
        IRadWorksheetEditorPresenter presenter = (IRadWorksheetEditorPresenter)editor.GetType().GetField("activePresenter", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic).GetValue(editor);
        presenter.SetVerticalOffset(presenter.VerticalOffset + x);
        editor.InvalidateMeasure(true);
    }
}