Available for: UI for ASP.NET MVC | UI for ASP.NET AJAX | UI for Blazor | UI for WPF | UI for WinForms | UI for Xamarin

Features

Below you can find list with all features that are supported by XlsFormatProvider.

Feature Supported Comment
Text Formatting
Font Family Yes
Font Size Yes
Font Color Yes There might be differences in the colors.
Bold Yes
Italic Yes
Underline Yes
Text Horizontal Alignment Yes
Text Vertical Alignment Yes
Text Wrapping Yes
Indent Yes
Text Rotation Yes
Cells
Merge Cells Yes
Number Format Yes
Borders Yes
Pattern Fills Yes
Gradient Fills Yes
Cell Locked State No
Cell Styles
Style Name No
Include Number Format Option Yes
Include Alignment Option Yes
Include Font Properties Option Yes
Include Borders Option Yes
Include Fills Option Yes Gradient fills are not supported.
Include Protection Option No
Themes
Document Theme Yes
Color Scheme No
Font Scheme Yes
Hyperlinks
Web page Yes
Place in document Yes
E-mail address Yes
Workbook protection
Structure protection option No
Windows protection option No
Worksheet protection
Allow Changes In Cells/Rows/Columns Format Option No
Allow Inserting Rows/Columns Option No
Allow Deleting Rows/Columns Option No
Allow Sort Option No
Allow Filter Option No
Formulas
Formula Values Yes
Names
Defined Names Yes
Shapes
Images No
Floating Images No
Charts No
Page Setup
Page Size Partial No support for custom page size
Page Margins Yes
Page Orientation Yes
Page Breaks Yes
Print Area Yes
Page Order Yes
Scale Factor No
Show/Hide Row and Column Headings Yes
Show/Hide Gridlines Yes
Show/Hide Rows/Columns Partially Only columns can be hidden
Center Horizontally/Vertically Yes
View State
Scale Factor No
Selection State Yes Only single selection is supported
Scroll Position Yes
Freeze Panes Yes
Sorting
Values Sort Condition No
Cell Color Sort Condition No
Font Color Sort Condition No
Custom Sort Condition No
Sort Order and Custom Lists Yes
Filtering
Selected Values Filter Yes
Custom Filter Yes
Dynamic Filter Yes
Top10 Filter Yes
Font Color Filter Yes
Cell Color Filter Yes
Data Validation Partially Data validation formulas to another sheet are not supported
Headers & Footers Partially No Even or Odd header & footer
Other
Themable Colors No
Screen tip of the hyperlink No
Multiple selections No
Columns or Row Styles No
In this article
Not finding the help you need? Improve this article