<style>
table th:first-of-type {
	width: 23%;
}
table th:nth-of-type(2) {
	width: 7%;
}
table th:nth-of-type(3) {
	width: 17%;
}
table th:nth-of-type(4) {
	width: 53%;
}
</style>

# Device Information Settings for the Excel 2007 (XLSX) rendering format

The following table lists the device information settings for rendering in Excel 2007 (XLSX) format.

## Available Excel 2007 Device Information Settings

> The names of the properties in Device Information Settings are **Case-Sensitive**.

| **Name**                  | **Type** | **Group**     | **Description**                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| ------------------------- | -------- | ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| UseNativePageHeader       | Boolean  | Layout        | Specifies whether to render the report’s page header in the native Excel page header section. When **false** (default value), the page header is rendered as a sequence of frozen rows at the top of the worksheet.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| UseNativePageFooter       | Boolean  | Layout        | Specifies whether to render the report’s page footer in the native Excel page footer section. When **false**, the footer is rendered as a sequence of Excel cells. Default value is **true**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| ShowGridlines             | Boolean  | Appearance    | Specifies whether Excel Gridlines are visible. Default value is **false**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| UseMetafile               | Boolean  | Graphics      | A flag specifying whether to render Graph, Map, and Barcode items as [Metafile (EMF)](https://learn.microsoft.com/en-us/windows/win32/gdiplus/-gdiplus-metafiles-about) or [Bitmap](https://learn.microsoft.com/en-us/windows/win32/gdiplus/-gdiplus-types-of-bitmaps-about) images. The default value is **true**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| UseExtendedFormatting     | Boolean  | Formatting    | Format strings used throughout the report will be hard-coded with "Custom Format" in Excel, which includes the locale information of the server. This way, the formatting from the report definition is preserved and does not depend on the client machine's locale where the document is opened. The custom format information can be omitted by setting **UseExtendedFormatting = false**. Default value is **true**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| SplitWorksheetOnPageBreak | Boolean  | Layout        | Specifies whether rendering should generate a new worksheet on soft page breaks. The supported page breaks are [ReportSection.PageBreak](https://www.telerik.com/products/reporting/documentation/api/telerik.reporting.reportsection#Telerik_Reporting_ReportSection_PageBreak) and [TableGroup.PageBreak](https://www.telerik.com/products/reporting/documentation/api/telerik.reporting.tablegroup#Telerik_Reporting_TableGroup_PageBreak). When *SplitWorksheetOnPageBreak* is enabled, the report property [SkipBlankPages](https://www.telerik.com/products/reporting/documentation/api/telerik.reporting.report#Telerik_Reporting_Report_SkipBlankPages) is respected, and the empty worksheets will not be included in the generated document. The worksheet generation algorithm complies with the rules set in the report definition and might differ from the soft page breaks generated by the rendering extensions that utilize the paging algorithm. The default value is **false**. Introduced in [R2 2022 SP1 (16.1.22.622)](https://www.telerik.com/support/whats-new/reporting/release-history/progress-telerik-reporting-r2-2022-sp1-16-1-22-622) |
| FormulaPrefix             | String   | Compatibility | By default, all of the generated cell values are marked as values rather than formulae. However, if the values are not escaped, there is no guarantee that Excel will not treat values that start with a formula identifier as formulae. The purpose of the **FormulaPrefix** property is to mitigate this by allowing the user to specify a formula prefix that will be used to escape values that start with a formula identifier. The recommended formula prefix is the single quote character `'`. The **default value** is an empty string, which keeps the original cell values intact.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| UseSvgImages              | Boolean  | Graphics      | [**Skia only**](https://www.telerik.com/products/reporting/documentation/doc-output/configure-the-report-engine/processing-element#graphics-engine). Requires [DocumentFormat.OpenXml 3+](https://www.nuget.org/packages/documentformat.openxml). A flag specifying whether the Skia graphics engine embeds SVG images for Graph, Gauge, and Barcode report items using the Office 2019 SVGBlip extension. When enabled, the exported items use resolution-independent vector graphics. When disabled, the Skia engine inserts raster images instead. The default value is **true**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| IncludeRasterFallback     | Boolean  | Graphics      | When `UseSvgImages` is enabled, specifies whether to include a raster fallback image alongside the embedded SVG. The fallback ensures compatibility with Office versions older than 2019 that do not support the SVGBlip extension, however, enabling it will drastically increase the size of the exported documents. The default value is **false**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |

For an example of how to set up the settings for a rendering extension, see [extensions Element](https://www.telerik.com/products/reporting/documentation/doc-output/configure-the-report-engine/extensions-element).

## See Also

* [Device Information Settings](https://www.telerik.com/products/reporting/documentation/doc-output/configure-the-export-formats/overview)
* [Export Formats](https://www.telerik.com/products/reporting/documentation/doc-output/export-formats)