Unplanned
Last Updated: 06 Mar 2024 12:45 by ADMIN
Created by: TestTeam
Comments: 5
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: 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:45 by ADMIN
Setting the worksheet to protected does not prevent the user from changing the name of the worksheet. 
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: 01 Sep 2023 09:25 by ADMIN
Unplanned
Last Updated: 06 Jun 2023 07:28 by ADMIN

Please refer to the attached gif file.

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: 19 Jan 2023 11:39 by ADMIN
Created by: Matthias
Comments: 2
Category: Spreadsheet
Type: Bug Report
3

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.

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:

 

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

Import the attached document in RadSpreadsheet:

Expected result: centered text like in MS Excel:

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:

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. 
Unplanned
Last Updated: 01 Apr 2022 09:50 by Fratessa
Exception when copying sheet with conditional formatting and opening it in RadSpreadsheet
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. 
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 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: 02 Dec 2019 06:38 by ADMIN
Created by: n/a
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

The UI behaivor of drag selection shows inconsistent behavior between WinForm vs WPF/Excel.

When you drag some cells for selection and keep dragging to the right (getting the out scope), the control scrolls to the right.

This behavior is common in Winform/WPF/Excel.

When you drag backward (to the left), WPF controls scroll back and so is Excel, while Winform controls does not scroll

Same thing for top and bottom scroll. Winform Spreadsheet control does not scroll. It may scrolls only to the right.

Another Caveat I see meanwhile is that when you scroll backwards until the row area, the pointer become row-resize pointer, or so

If you keep mouse moving around, it sometimes makes a horizontal line (possibly a guide for row resize?)

The issue in this case is that, it does not remove itself. the horizontal line stays there. It is not very annoying (as it is thin horizontal line) but is still a bug.

 

To reproduce,

create a empty Winform app, with the RadSpreadsheet Control, and Run

Drag from row C3 and to the right (around the scrollbar) the control scrolls to the right (this is not quite smooth though..)

Scroll right to AZ3 say, and drag backward back to C3, this now does not scroll back.

Same for top and bottom.

Do the same for WPF, it now works as expected

Do the same for MS Excel, it now works as expected.

1 2