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.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?
Scatter chart with category range where data has both numbers and strings is incorrectly visualized.
Excel:
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.
Custom style is not applied to empty cells when applying to the entire row.
Workaround:
Dim usedCellRange As CellRange = mobjValidationResultWs.UsedCellRange
For rowIndex As Integer = usedCellRange.FromIndex.RowIndex To usedCellRange.ToIndex.RowIndex
For columnIndex As Integer = usedCellRange.FromIndex.ColumnIndex To usedCellRange.ToIndex.ColumnIndex
Dim cell As CellSelection = mobjValidationResultWs.Cells(rowIndex, columnIndex)
cell.SetStyleName("Common")
Next columnIndex
Next rowIndex
The formula is not evaluated correctly when the fill right function is used.
To reproduce:
1. Enter the word "A1" in cell A1 and "B1" in cell B1.
2. Enter the formula "=A1&B1" in cell C1. C1 now correctly shows "A1B1"
3. Select C1 to H1 and run the Fill Right command.
Observe that D1, E1, and F1 show the correct result, but G1 and H1 show "0".
Workaround:
Save and reopen the document.
Setting up a paper size to A1 and exporting it actually sets the paperSize to 1. Using the same scenario in Excel sets the paperSize to 305.
This leads to inappropriate values when entering the Page Setup options later in Excel.