The label of the field that allows you to set the ScreenTip in the Hyperlink dialog is not vertically centered to the associated textbox visual. This reproduces in the Windows11 theme.

To work this around, get the TextBlock element in the Hyperlink dialog and set its VerticalAlignment property to Center.

private void RadSpreadsheet_Loaded(object sender, RoutedEventArgs e)
{
    var hyperlinkDialog = this.spreadsheet.ActiveWorksheetEditor.Dialogs.HyperlinkDialog as HyperlinkDialogContent;
    hyperlinkDialog.Loaded += HyperlinkDialog_Loaded;
}

private void HyperlinkDialog_Loaded(object sender, RoutedEventArgs e)
{
    var dialog = (HyperlinkDialogContent)sender;
    var screenTipLocalizedText = LocalizationManager.Manager.GetStringOverride("Spreadsheet_InsertHyperlinkDialog_ScreenTip");
    var screenTipTb = dialog.ChildrenOfType<TextBlock>().FirstOrDefault(x => x.Text == screenTipLocalizedText);
    if (screenTipTb != null)
    {
        screenTipTb.VerticalAlignment = VerticalAlignment.Center;
    }            
}

We have a document in XLS format produced by GemBox. The yellow cells get black once the document is imported and then exported (back to XLS or XLSX) with RadSpreadProcessing.

Hi Team,

   I have backported the Xlsx file to Xls format. When I am trying to import the backported file using the Radspreadsheet UI control, I find that it has lost the color formatting which was existing in the original Xlsx file. Where as when we open the back ported file with Excel application we find that all the data and formatting is maintained.

So the request is that after backporting  and while importing the file, it should not loose the minimal xls supported features which Excel is able to support.





Attached is the InitialFile.xlsx and BackPorted.xls file

Note that Xlsx file if imported it maintains the data and formatting information of the workbbok when loaded via UI control.
Let us know in case of any more details or queries.

Exepct this to work

Regards,

Manish.

The fill selection stops working, after a filtering is applied and the currently selected cell is filtered out (it gets hidden). This prevents from displaying the fill selection cross displayed when you hover the bottom right corner of a selected cell. Any further changes in the selection doesn't re-enable the selection fill feature.

To work this around, you can set the IsEnabled property of the FillSelection on selection changed.

private RadWorksheetEditor activeWorksheetEditor;

public MainWindow()
{
  InitializeComponent();

  this.spreadsheet.ActiveSheetEditorChanged += (s, e) =>
  {
 if (activeWorksheetEditor != null)
 {
 activeWorksheetEditor.Selection.SelectionChanged -= Selection_SelectionChanged;
 }

 activeWorksheetEditor = this.spreadsheet.ActiveWorksheetEditor;
 activeWorksheetEditor.Selection.SelectionChanged += Selection_SelectionChanged;
  };
}

private void Selection_SelectionChanged(object? sender, EventArgs e)
{
  this.spreadsheet.ActiveWorksheetEditor.Selection.FillSelection.IsEnabled = true;
}

When filter is added to merged cells, there should be a single filter icon displayed in the combined cell. Instead, multiple filters appear - one for each column in the range of the merged cells.

Handle the case when the cell is too small and the value contains a decimal separator. 

For example, see attached images. 

 Missing localization strings in PageSetup dialog. 

Go to the headers and footers section. The localization is missing.

When applying a ListDataValidation, the created RadDropDownButton, which has a RadPathButton in it, looks broken when using the Windows11, Office2013, Office2019, and VisualStudio2019 themes.

The CustomFilterDialogContent element's OK and Cancel buttons are different in size for the Windows 11 theme.

To work this around, you can subscribe to the Loaded event of the CustomFilterDialogContent element and retrieve the RadButton with x:Name="PART_ButtonCancel" via the ChildrenOfType extension method. On the retrieved button, set the VerticalAlignment property to Center.

The following code snippet showcases this suggestion's implementation:

static MainWindow()
{
    EventManager.RegisterClassHandler(typeof(CustomFilterDialogContent), LoadedEvent, new RoutedEventHandler(OnCustomFilterDialogContentLoaded));
}

private static void OnCustomFilterDialogContentLoaded(object sender, RoutedEventArgs e)
{
    RadButton cancelButton = ((CustomFilterDialogContent)sender).ChildrenOfType<RadButton>().FirstOrDefault(x => x.Name == "PART_ButtonCancel");

    if (cancelButton != null)
    {
        cancelButton.VerticalAlignment = VerticalAlignment.Center;
    }
}

The horizontal ScrollBar of RadSpreadsheet is missing the bottom border of its track. Additional to that there is a slight offset between the right end of the viewport and the right button of the ScrollBar.

To work this around, set the Margin of the horizontal ScrollBar to 0, and modify its ControlTemplate so that it adds a bottom border for the track's RepeatButton elements.

private void RadSpreadsheet_Loaded(object sender, RoutedEventArgs e)
{
    var spreadsheet = (RadSpreadsheet)sender;
    var scrollBar = spreadsheet.ChildrenOfType<ScrollBar>().FirstOrDefault(x => x.Name == "HorizontalScrollBar");
    scrollBar.Margin = new Thickness(0);
    scrollBar.Template = (ControlTemplate)this.Resources["MyCustomScrollBarTemplate"];
}

For the German language translations, the following resource keys are translated into Dutch instead:

• Spreadsheet_PrintPreview_FitSheetOnOnePage
• Spreadsheet_PrintPreview_FitSheetOnOnePage_Description
• Spreadsheet_PrintPreview_FitColumnsOnOnePage
• Spreadsheet_PrintPreview_FitColumnsOnOnePage_Description
• Spreadsheet_PrintPreview_FitRowsOnOnePage
• Spreadsheet_PrintPreview_FitRowsOnOnePage_Description