Unplanned
Last Updated: 27 Oct 2022 12:26 by ADMIN

Import the attached document and zoom in/out:

Expected result: the whole text should be fully visible like in MS Excel:

Completed
Last Updated: 23 Sep 2022 13:07 by ADMIN
Release R3 2022
The wrap text feature does not work as expected when not in edit mode
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: 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. 
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: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: 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 

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);
    }
}