RadSpreadsheetFormulaBar has a drop down list that shows the named ranges in the document. If a named range contains an underscore character (ex: Income_Amount), the associated item in the drop down won't display the underscore (ex: IncomeAmount).

To workaround this, you can use a global Loaded event handler of RadMenuItem and override the Header content with a TextBlock.

static MainWindow()
{
    EventManager.RegisterClassHandler(typeof(RadMenuItem), RadMenuItem.LoadedEvent, new RoutedEventHandler(OnMenuItemLoaded));
}

private static void OnMenuItemLoaded(object sender, RoutedEventArgs e)
{
    var menuItem = (RadMenuItem)sender;
    if (menuItem.DataContext is DefinedName context)
    {
        menuItem.Header = new TextBlock() { Text = context.Name };
    }
}

Since the last update, we receive often the following exception from our users log. I don't know exactly how to reproduce, but I know that when it happens, the user tries to click anywhere in the document and each time the exception is thrown. The users need to close and reopen the document to make it work again.

System.NullReferenceException: Object reference not set to an instance of an object. at Telerik.Windows.Documents.UI.DocumentPresenterBase.CaretPosition_PositionChanged(Object sender, EventArgs e) at Telerik.Windows.Documents.DocumentPosition.MoveToPosition(DocumentPosition newPosition) at Telerik.Windows.Documents.Selection.MouseSelectionHandler.UpdateSelectionAndCaretPosition() at Telerik.Windows.Documents.Selection.MouseSelectionHandler.RegisterDocumentMouseMove(Point position, SourceType source) at Telerik.Windows.Documents.UI.DocumentPresenterBase.HandleMouseMoveOnPosition(Point position, SourceType source) at Telerik.Windows.Documents.UI.DocumentPresenterBase.Owner_MouseMove(Object sender, MouseEventArgs e) at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args) at System.Windows.Input.InputManager.ProcessStagingArea() at System.Windows.Input.MouseDevice.Synchronize() at System.Windows.Input.MouseDevice.PostProcessInput(Object sender, ProcessInputEventArgs e) at System.Windows.Input.InputManager.ProcessStagingArea() at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel) at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)

We also had this case when we try programatically to move the caret (seems to be the same end result exception):

System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.Windows.Documents.UI.DocumentPresenterBase.CaretPosition_PositionChanged(Object sender, EventArgs e)
   at Telerik.Windows.Documents.DocumentPosition.MoveToDocumentStart()
   at Telerik.Windows.Documents.DocumentPosition.MoveToFirstPositionInDocument()

We want to have the option to replace texts only in a selected part of the document. 

Use Notepad++ as a reference to check this feature.

Steps to reproduce:
- Open RadSpreadsheet
 -Put 1 in B2 and B6
 -Put 0 in B3, B4, B5
 -Add filtering on columns A and B
 -Filter on column B to have only rows with 1. The rows 3 to 5 will be hidden.
 -Paste "1234" as cell selection in the Range A2:A6 
 Note: It is important to enter 1234 in another cell, make a cell selection and then paste it
 -Remove the filter

Expected: "1234" in pasted in cells A2 and A6 only.
Actual: "1234" in pasted in cells A2, A3, A4, A5, A6.

Steps to reproduce: 

1. Enter in a cell =Today()
2. Show Format Cells dialog and set Custom format "d"

Expected: The value is the day of the month.
Actual: The date is formatted as short date but has to be day of the month.

Selecting a column with two or more merged cells, selects not only the selected column but the rest of columns that the merged cells are from. The behavior when working with rows is analogical.

When setting the following strings as cell value, they are recognized as dates. In industry standard applications like MS Excel and OpenOffice, they are recognized as strings:
- "12 3456" in bg-BG, fr-FR, ru-RU, sv-FI, en-US
- "12.3456" in de-DE
- "1 23" in en-US
- "2013/5" in en-US
- "3000-03" in en-US

The document will be imported with a loss of content. The reason is that ASCII85Decoder will throw an ArgumentException when the stream doesn't end with '~>'. 

Although this is invalid case according to PDF specification, other applications are handling it and the document is successfully visualized in them. We may also consider implementing workaround that handles such invalid streams.

#.##0,00;-#.##0,00;;@ does not work in RadSpreadsheet. It should suppress visualizing of ) values.

Workaround: #.##0,00;-#.##0,00; ;@ works fine (there is ' ' [space] set for the zero values).