When importing a document containing a hyperlink formula (e.g. "=HYPERLINK(B2,A2)") an exception is thrown: System.Collections.Generic.KeyNotFoundException: 'The given key was not present in the dictionary.'
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();
}
}
The WorkbookContentChanged event is invoked right after importing a document.
The outline properties of the chart series are not respected by most charts.
The scale factor is not imported from documents with no information about the selection state.
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.
Can we have the ability to hide the cell selector rectangle in the RadSpreadsheet? If we had this, along with the current existing functionality we would have spreadsheet capabilities inside what looks like an 'empty' page. It would be good for reporting purposes where the developer can make full use of the spreadsheet's functions but completely hide the 'spreadsheet look-and-feel' from the user.
Provide the ability to work with images in headers/footers of a worksheet. Note that large images put in headers are visualized as watermarks on printing/exporting to PDF.
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.