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