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.

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

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.

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.

The SUMIFS function adds all of its arguments that meet multiple criteria.

A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions

This function can be implemented as a custom function. Check the following resources for more details on how to achieve that:

- http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions
- https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/WPF/CustomFunctions

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.