Contact Us

API support for conditional formatting - Community / GemBox.Spreadsheet Feature Request - GemBox Support Center

12

API support for conditional formatting Completed

Mario - GemBox

Request for adding an API support for Conditional Formatting.

GemBox.Spreadsheet supports Conditional Formatting only through the preservation in XLSX files.
Which means that any previous formatting we made on our XLSX file will be preserved when we load this file with GemBox.Spreadsheet and save it back to an XLSX format, but they are not directly supported by GemBox.Spreadsheet API.

More informations about GemBox.Spreadsheet's preservation can be found on the following link:

https://www.gemboxsoftware.com/spreadsheet/help/html/Preservation.htm

Comments (2)

Rob Sherratt

6 years ago

It would be great if we could create conditional formats and ranges instead of having to import a template and preserve conditional formats from it. The problem with using a preserved template is that often the number of columns and rows we are writing is different to the number of columns and rows in the template. Simply adding or deleting columns and rows from the template file gives strange and unpredictable formatting results.

Mario - GemBox

2 years ago

Hi,

This feature request has been implemented and is available in latest versions of GemBox.Spreadsheet.

Regards,

Mario
GemBox d.o.o.

Created By: Mario - GemBox
Published: Mar 20, 2014
Unpublished date: Apr 27, 2018 closed