Edit this page
Available for: UI for ASP.NET AJAX | UI for ASP.NET MVC | UI for WPF | UI for WinForms | UI for Silverlight

Features

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

Feature Supported Comment
Text Formatting
Font Family Yes
Font Size Yes
Font Color Yes
Bold Yes
Italic Yes
Underline Yes
Text Horizontal Alignment Yes
Text Vertical Alignment Yes
Text Wrapping Yes
Indent Yes
Cells
Merge Cells Yes
Number Format Yes
Borders Yes
Pattern Fills Yes
Gradient Fills Yes
Cell Locked State Yes
Cell Styles
Style Name Yes
Include Number Format Option Yes
Include Alignment Option Yes
Include Font Properties Option Yes
Include Borders Option Yes
Include Fills Option Yes
Include Protection Option Yes
Themes
Document Theme Yes
Color Scheme Yes
Font Scheme Yes
Hyperlinks
Web page Yes
Place in document Yes
E-mail address Yes
Workbook protection
Structure protection option Yes
Windows protection option Yes
Worksheet protection
Allow Changes In Cells/Rows/Columns Format Option Yes
Allow Inserting Rows/Columns Option Yes
Allow Deleting Rows/Columns Option Yes
Allow Sort Option Yes
Allow Filter Option Yes
Formulas
Formula Values Yes
Names
Defined Names Yes
Shapes
Floating Images Yes
Position Yes
Size Yes
Rotation Yes
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 Yes
Show/Hide Row and Column Headings Yes
Show/Hide Gridlines Yes
Center Horizontally/Vertically Yes
View State
Scale Factor Yes
Selection State Yes
Scroll Position Yes
Freeze Panes Yes
Sorting
Values Sort Condition Yes
Cell Color Sort Condition Yes
Font Color Sort Condition Yes
Custom Sort Condition Yes
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