OpenXmlDocumentImporterOptions.SuppressSolidFillWithEmptyColor Property

Gets or sets whether to correct the transparent background color rendering in documents created in SpreadsheetControl prior to version 16.1.5.

Namespace: DevExpress.XtraSpreadsheet.Import

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

[Browsable(false)]
public bool SuppressSolidFillWithEmptyColor { get; set; }

VB.NET

<Browsable(False)>
Public Property SuppressSolidFillWithEmptyColor As Boolean

Property Value

Type	Description
Boolean	true, to correct the document; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to SuppressSolidFillWithEmptyColor
WorkbookImportOptions	.OpenXml .SuppressSolidFillWithEmptyColor
WorkbookImportOptions	.Xlsx .SuppressSolidFillWithEmptyColor

Remarks

In the XLSX documents produced by the SpreadsheetControl prior to version 16.1.5, the cells background is rendered incorrectly in MS Excel if the Fill.BackgroundColor is set to Color.Transparent.

Set the SuppressSolidFillWithEmptyColor property before loading a document to correct the document and display it as expected in SpreadsheetControl and MS Excel.