Log in to start a topic

Sheet.clear function does not clear formatting added by Conditional format

Posted by: adisa.craig on 20 September 2019, 4:31 pm EST

  • adisa.craig

    • Post Options:
    • Link
      Copy

    Posted 20 September 2019, 4:31 pm EST

    Hi we are using the function ```

    sheet.clear(0, 0, 1,1, GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.style)

  • adisa.craig

    Posted 20 September 2019, 4:44 pm EST

    Sorry I found the solution by using ```

    sheet.conditionalFormats.removeRuleByRange(sel.row, sel.col, sel.rowCount, sel.colCount);

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels

  • © 2023 MESCIUS USA, Inc. All Rights Reserved.  ·  1.800.858.2739

    All product and company names herein may be trademarks of their respective owners.