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.
Cell Values disappearing when RadWindow is dragged to a second Monitor.
Workaround:
private void MainWindow_Loaded(object sender, RoutedEventArgs e)
{
this.viewModel.OpenSampleCommand.Execute(null);
radDocking1.ToolWindowCreated += RadDocking1_ToolWindowCreated;
}
private void RadDocking1_ToolWindowCreated(object sender, Telerik.Windows.Controls.Docking.ElementCreatedEventArgs e)
{
var window = e.CreatedElement as ToolWindow;
if (window != null)
{
window.WindowStateChanged += Window_WindowStateChanged;
}
}
private void Window_WindowStateChanged(object sender, EventArgs e)
{
var window = sender as ToolWindow;
var spreadsheet = window.ChildrenOfType<RadSpreadsheet>().FirstOrDefault();
if (spreadsheet != null)
{
spreadsheet.InvalidateVisual();
}
}
Value of a cell is visualized outside of the cell boundaries, or the value is clipped and partially visible, when the cell is updated (from code-behind), while being in an inactive worksheet, and is referenced by another cell from the active sheet. Workaround: get a value of some cell in the active sheet and set it again to the same cell. The issue is reproducible after the official release of Q1 2015.