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. 

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

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

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)

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: 19 Jul 2021 12:21 by ADMIN

Hi,

 

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()
        {
            InitializeComponent();

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

Regards,

Markus

Unplanned
Last Updated: 14 Jul 2021 06:08 by ADMIN
Created by: Desislava
Comments: 2
Category: Spreadsheet
Type: Feature Request
3
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.
Unplanned
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.
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.
Unplanned
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

Completed
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.
Unplanned
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) 
Unplanned
Last Updated: 23 Feb 2021 07:08 by ADMIN
Created by: Dennis
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
MS Excel supports dragging cells and thus moving the value to a new cell. 
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