Selected merged cells jump to the bottom of the selection when it goes outside the visible area.

Exporting merged columns to PDF creates unnecessary pages. The created file contains more than 8 MB in size and empty pages. It should create only one page as done in MS Excel.

When Bulgarian culture is set and a document with a chart is imported, NullReferenceException is thrown.

The EqualToRule does not work the same way in Excel and RadSpreasheet. 

When using string values with this rule, Excel requires using quotes while in RadSpreadsheet the quotes are interpreted as part of the value.  

When the selection contains a certain combination of text and numbers, the charts dialog throws an exception upon opening.

Selecting multiple columns that are not necessarily next to each other leads to incorrect chart series categories. Having the same columns next to each other and selecting all of them with single selection results in a correct chart. Make it possible for the user to make multiple selections and create charts based on them.

When certain files are imported, an exception with message" is invalid column name" is thrown.

PrintPreviewControl throws NullReferenceException when it is in the GridView Print example. 

Currently, Custom IconSets are not supported when having Conditional Formatting scenarios.

In Excel, when you copy a range and then paste it into a larger one, the values are repeated to fill the larger range. This can be included in RadSpreadsheet as well.

If the Spreadsheet ribbon has a custom template which hides the Style Gallery, when the Styles collection is edited, a NullReferenceException is thrown. This is because the change causes changes in the Style Gallery while the template of the Style Gallery is not yet applied.

DataValidation of a list with defined names is not taking the source into account. As a result, values are not displayed as options in the cell drop-down list.

Defined names do not appear in the Name Box.

A filter cannot be applied to the RadSpreadsheet when a sheet is protected even though the Filter option in the protection dialog is checked. 

Slow performance with documents that contain many custom styles. 

We have a problem creating an Excel file with Telerik.Windows.Documents.Spreadsheet. 
In our last release for our customers we used Telerik WPF version 22.2.613.40 (Spreadsheet DLL)

When calling the following line of code

m_Worksheet.Cells[m_CurrentRowIndex, m_CurrentColumnIndex].SetValue("111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111");

the CellValueType is set to text and the Value is correct.

We have now switched our project to .NET 7 and Telerik WPF to version 2023.2.519.70.

We discovered that this line of code no longer works.

The CellValueType is now Number and the Value Infinity

Have you changed anything internally? How can we solve the problem now?

Memory leak when opening a new window that contains a spreadsheet several times.

Copy/Paste a shape and then an image leads to a wrong result. 

Steps to reproduce: 

1. Copy plain text from a plain text editor onto the clipboard -> Paste in Spreadsheet and the text is pasted OK.
2. Copy the image from another app onto the clipboard -> Paste in Spreadsheet and the "This information cannot be pasted" dialog is displayed.
3. Insert picture from file into spreadsheet -> image displayed in a shape.
4. Select and copy the shape.
5. Repeat step 1 => Copy plain text from a plain text editor onto the clipboard -> Paste in Spreadsheet and the text is pasted OK.
6. Repeat step 2 => Copy image from another app onto clipboard -> Paste in Spreadsheet and shape selected and copied in step 4 is pasted. => Not expected result.