Conditional formats error

Conditional formats error

Posted by: sachot on 11 August 2020, 8:36 am EST

• 

  sachot

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 August 2020, 8:36 am EST - Updated 3 October 2022, 10:12 am EST

  Hi,

  When i add a conditional format based on formula, i get an error when i try to get the rules list.
  
  But no problem with text rule.

  Is it a bug or i do something wrong ?

  Thanks,

  Christophe

  

  1500×330 83 KB

  

  1500×394 99 KB

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 12 August 2020, 9:41 am EST

  Hi Christophe,

  To get a JSON string representation of conditional rules, you need to use the following code:

  var formatsJSON = sheet.conditionalFormats.toJSON();
  var stringifiedRules = JSON.stringify(formatsJSON && formatsJSON.rules);
  console.log(stringifiedRules);
  

  Regards
  
  Sharad

• 

  sachot

  • Post Options:
  • Link
    Copy

  Posted 31 August 2020, 7:09 am EST

  It works.

  Thanks !