Wijmo FlexSheet Conditional Formatting

Wijmo FlexSheet Conditional Formatting

Posted by: guy.g on 25 December 2018, 9:45 am EST

• 

  guy.g

  • Post Options:
  • Link
    Copy

  Posted 25 December 2018, 9:45 am EST

  Hello,

  Is Excel Conditional Formatting supported in Wijmo?
  
  When I set conditional formatting rules for specific cells in xlsx file using excel and I load the file into FlexSheet it does not seem to change the cell color according to the value as I defined in the rules.

  Does Wijmo FlexSheet support conditional formatting?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 26 December 2018, 12:53 am EST

  Hi,

  We are sorry, but conditional formatting is not supported in FlexSheet yet.
  
  However, we may implement it using formatItem event but it won’t work for import/export functionality.
  
  You may refer to the following sample which demonstrates the use of formatItem for conditional formatting:
  
  https://stackblitz.com/edit/js-7v8vet?file=index.js
  
  Further, we have also created an enhancement request(Internal tracking Id: 359273) to add support for this feature. We will let you know regarding any updates on this.

  ~Sharad