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.

Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. If we want to be consistent with MS Excel we should implement this property. It is useful for many operations of a region such as filtering(selecting one cell and executing the Filter command should apply it to the current region), sorting, selecting all and etc. This document will be useful: https://docs.microsoft.com/en-us/office/vba/api/excel.range.currentregion.

Check how the performance can be improved in this scenario. The StyleGallery is taking much time to load, the GetUsedCellRange method is called multiple times.