Conditional Formatting is lost when pagination is turned on

Conditional Formatting is lost when pagination is turned on

Posted by: jonhenning on 21 August 2024, 11:18 pm EST

• 

  jonhenning

  • Post Options:
  • Link
    Copy

  Posted 21 August 2024, 11:18 pm EST

  By turning on Debug Mode (TemplateOptions.Debug = true) and exporting to excel I can see that the Sheet1 correctly applies the conditional formatting, whereas, Sheet1_Page1 and thereafter do not apply conditional formatting. Turning off Pagination (TemplateOptions.PaginationMode = false) correctly applies the conditional formatting to Sheet1_Template and Sheet1.

  version: 7.2.0

  I need pagination and conditional formatting please.

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 22 August 2024, 7:28 am EST

  Hi,

  Apologize for the inconvenience. Conditional Formatting is not supported in the workbook generated using a Paginated template. Please refer here for the same: https://developer.mescius.com/document-solutions/dot-net-excel-api/docs/online/paginated-templates.html#:~:text=DsExcel%20does%20not%20support%20formula%2C%20conditional%20formatting%2C%20data%20validation%2C%20tables%2C%20charts%20in%20the%20workbook%20generated%20using%20paginated%20templates.

  This is a limitation right now. However, this is under investigation. Our development team is working on this requirement. There is no fixed ETA. We will let you know once it is achievable.[Internal Tracking Id - DOCXLS-8830]

  Regards,
  
  Nitin