Unplanned
Last Updated: 12 Jun 2024 08:17 by Ken
If you type =sum( and leave it at that, then go into the column and start pressing Shift+click to start selecting a range, it throws an error. 
Unplanned
Last Updated: 17 May 2024 12:30 by ADMIN
Unplanned
Last Updated: 07 Mar 2024 14:27 by Walter
Created by: Walter
Comments: 0
Category: Spreadsheet
Type: Feature Request
0
Add axis titles to the charts
Unplanned
Last Updated: 07 Mar 2024 14:09 by Walter
Created by: Walter
Comments: 0
Category: Spreadsheet
Type: Feature Request
0
Editable chart in RadSpreadsheet
Unplanned
Last Updated: 01 Feb 2024 08:09 by ADMIN

When the text is set using the following code, the text in a wrapped cell is overlapping.

radSpreadSheet1.ActiveWorksheet.Cells[0, 0].SetValue(@"Blocked flow; potential increase in level in  (BLANK); potential to overfill equipment; potential spill or overflow to (BLANK) 
Blocked flow; potential increase in level in  (BLANK); 
potential to overfill equipment; potential spill or overflow to(BLANK)");
radSpreadSheet1.ActiveWorksheet.Columns[0].SetWidth(new ColumnWidth(300, true));
Worksheet worksheet = radSpreadSheet1.ActiveWorksheet as Worksheet;
CellStyle cellStyle = worksheet.Workbook.Styles.Add("Wrap Style", CellStyleCategory.Custom);
cellStyle.IsWrapped = true;
CellRange cr = new CellRange(0, 0, 10, 10);
worksheet.Cells[cr].SetStyleName("Wrap Style");

 

Unplanned
Last Updated: 25 Jan 2024 08:06 by ADMIN
This exception will be thrown when the control zoom setting is changed and we drag a selection rectangle outside of the worksheet.
Unplanned
Last Updated: 25 Jan 2024 08:45 by ADMIN
Setting the worksheet to protected does not prevent the user from changing the name of the worksheet. 
Unplanned
Last Updated: 15 May 2024 13:26 by ADMIN
Created by: TestTeam
Comments: 7
Category: Spreadsheet
Type: Bug Report
1
The behavior can be reproduced when the zoom of the control is changed and we try to enter a value in a cell.
Unplanned
Last Updated: 09 Oct 2023 11:11 by ADMIN
Users want to save the workbook via the Save ribbon button, but they want a default filename in the save dialog (not "book1.xlsx"). 
Unplanned
Last Updated: 27 Sep 2023 12:54 by ADMIN
Created by: Louis
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Currently, the WinForms Spreadsheet doesn't have separators between the column headers:

It would be better to have separators for the headers like the WPF Spreadsheet:

Unplanned
Last Updated: 29 Aug 2023 11:51 by ADMIN
Unplanned
Last Updated: 27 Jun 2023 05:01 by ADMIN
Unplanned
Last Updated: 06 Jun 2023 07:28 by ADMIN

Please refer to the attached gif file.

Unplanned
Last Updated: 01 Sep 2023 09:25 by ADMIN
Unplanned
Last Updated: 02 May 2023 06:05 by ADMIN

This is the sample code snippet:

        public RadForm1()
        {
            InitializeComponent();
            this.radSpreadsheet1.SpreadsheetElement.ActiveWorksheetEditor.MouseClick += ActiveWorksheetEditor_MouseClick;
        }

        private void ActiveWorksheetEditor_MouseClick(object sender, Telerik.WinControls.Spreadsheet.UI.MouseButtonEventArgs e)
        {
            Console.WriteLine(DateTime.Now.ToLongTimeString());
            var selection = this.radSpreadsheet1.SpreadsheetElement.ActiveWorksheetEditor.Selection.ActiveRange;
            if (!selection.IsColumnRange)
            {
            }
        }

Unplanned
Last Updated: 28 Apr 2023 10:05 by Ian

At the moment when any of the properties are changed, e.g. the frozen panes, the UI is not notified and you have to export and import the file in order for the UI to pick them up. 


Workaround: There are several workarounds:

1. Change the active worksheet and return to the old one

2. Export and import the document

3. Change the workbook of the RadSpreadsheet to a new one, and return the old one after that

4. Freeze the active worksheet using the ActiveWorksheetEditor.FreezePanes() method and freeze all others using the ViewState:

this.radSpreadsheet1.ActiveWorksheetEditor.FreezePanes(new CellIndex(10, 3));
foreach (var worksheet in this.radSpreadsheet1.Workbook.Worksheets)
{
      worksheet.ViewState.FreezePanes(5, 5);
}
Unplanned
Last Updated: 05 Apr 2023 07:33 by ADMIN

In Material(Pink,Teal,BlueGrey) themes, the row heading numbers are truncated.

Unplanned
Last Updated: 07 Mar 2023 12:14 by ADMIN

Clicking on a calculated cell leads to the following error and crashes the demo:

Unplanned
Last Updated: 01 Dec 2022 13:46 by ADMIN

Please follow the steps in the VS Designer:

1. Add a RadSpreadsheet and Office2019Dark theme:

2. Set the ThemeName for RadSpreadsheet to Office2019Dark:

3. Run the project. You will see that the row/column headers are not readable:

4. Stop the project and reopen the designer:

 

1 2 3