Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

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

#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.

See Also