Version History
The list below describes past changes and additions to MindFusion.Spreadsheet for WPF:
The Spreadsheet.WPF distribution now includes assemblies for .NET 6. Locally installed assemblies don't show automatically in toolbox at this time, you can add them to projects either manually or through Nuget package manager.
The Spreadsheet.WPF distribution now includes assemblies for .NET 5. Locally installed assemblies don't show automatically in toolbox at this time, you can add them to projects either manually or through Nuget package manager.
Worksheets now support autofiltering. To enable it, call the AutoFilter method of the CellRange class. To specify autofiltering criteria for individual columns, use the AutoFilter overload. These criteria can also be specified interactively, through the drop-down buttons inside the headers of each column in the target range.
The ExcelImporter class now exposes a ReadConditionalFormats property, which can be used to prevent importing of conditional formats.
The standard forms from the MindFusion.Spreadsheet.Wpf.StandardForms.dll assembly can now be localized for German, Spanish, French, Korean, Portuguese, Russian, and Chinese. To do this call the new SetLocalizationInfo method of the Workbook class and provide a XML file containing the localized strings for the respective language. The XML files for the above languages can be found in the Localization folder inside the component installation.
Rows and columns can now be grouped. To group or ungroup a range of rows or columns, use the Group or Ungroup methods of the RowRange and ColumnRange classes. To set the outline level of a row/column or a range of rows/columns directly, use the OutlineLevel property. Groups can be expanded and collapsed interactively, by clicking on the expand/collapse button in the view, or programmatically, by settings the IsCollapsed property of the respective row or column.
Several new events have been added to the WorkbookView class: ColumnGroupCollapsed, ColumnGroupExpanded, ColumnOutlineLevelToggled, RowGroupCollapsed, RowGroupExpanded, and RowOutlineLevelToggled.
The ExcelExporter and ExcelImporter classes are now times faster than before and the results are more accurate. Various problems and inconsistencies were fixed. Both classes now expose a View property. If you set the View property of the ExcelExporter, the exporter will also export view information, such as the active tab and selection. Alternatively, setting this property during import, will cause the view information to be imported.
