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 | |
| Text Rotation | 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 | |
| Notes | Yes | Previously called "Comments" |
| Comments | Yes | New version, also called "Threaded Comments" |