#.##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).

A password is asked although Adobe opens the document without one when the document is encrypted with "Encryption of data using the RC4 or AES algorithms with a file encryption key length of 40 bits." - Version 1 (V 1) Revision 2 (R 2).

Similar cases (V1 R3 and V2 R3) are handled in the following item: PdfViewer: A password is asked although Adobe opens the document without one.

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

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.

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()

The PDF document with images shows black canvas:

NOTE:

For the Spanish culture, some of the localization strings are for the German culture.

The following resource keys are the ones containing wrong values:

• PivotInlineFieldList_ValuesEmptyText
  
• PivotInlineFieldList_RowsEmptyText
  
• PivotInlineFieldList_ColumnsEmptyText
  
• PivotInlineFieldList_FiltersEmptyText
  
• Pivot_AggregateSum
  
• PivotFieldList_SetSumAggregate
  
• PivotFieldList_Top10Sum
  
• PivotFieldList_StringFormatDescription

To work around this, you could introduce a custom LocalizationManager and override the GetStringOverride method.

More information about this suggestion can be found here.

The busy animation keeps running on the background when the busy indicator control gets unloaded (removed from the visual tree).

To work this around, set the IsBusy property of RadBusyIndicator to False in its Unloaded event handler.

The bug happens when we have two or more rows merged in the first column and programmatically, we make the rowDetails for the first row visible, the merged cells of the first column stay merged and are over of the rowDetails, hiding a part of the Row Details:

Steps to reproduce:

When a DropDownList SDT form is saved in a XAML document and then imported with the XamlFormatProvider, an extra ListItem entry is added in the items collection of the DropDownList. The extra entry is the default "Choose an item".

To work this around, iterate all ComboBoxProperties and manually remove duplicates of the "Choose an item" entry.

var dropDownLists = radRichTextBox.Document.EnumerateChildrenOfType<SdtRangeStart>()
     .Where(x => x.SdtProperties is ComboBoxProperties)
     .Select(x => x.SdtProperties).OfType<ComboBoxProperties>();
 var defaultItemString = LocalizationManager.GetString("Documents_ContentControlsGenerator_ListItem");
 foreach (var item in dropDownLists)
 {
     if (item.Items.Count > 0 && item.Items.Any(x => x.Value != defaultItemString) && item.Items.Any(x => x.Value == defaultItemString))
     {
         var occurrence = item.Items.FirstOrDefault(x => x.Value == defaultItemString);
         while (occurrence != null)
         {
             item.Items.Remove(occurrence);
             occurrence = item.Items.FirstOrDefault(x => x.Value == defaultItemString);
         }
     }
 }

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 };
    }
}

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.