We are currently using the Infragistics4.WebUI.Documents.Excel.v17.1.dll version. What we would like to accomplish is to copy the conditional formating rules of the cells of a row to the cells of another row.
The initial template can have only a few rows predefined (due to download size limitations). But the export can contain up to thousand records.
Until now we managed to copy all formatting and styles of a cell, apart from the conditional formatting rules.
All the posts I found on this topic are old, so I am wondering if this feature is implement in this version already? And how can we accomplish the desired task?
Starting from version 18.1 Infragistics Excel Engine allows you to add conditional formatting in the worksheets. For more information, please check the following article in our online documentation “Conditional Formatting in igSpreadsheet”, as well as this sample “Spreadsheet - Conditional Formatting”.
Please let me know if any additional questions on this matter arise.