ExcelScript.ConditionalRangeFill interface can't manage pattern ?

Abélard Martin 0 Reputation points
2024-06-26T15:10:49.06+00:00

The ConditionalRangeFill interface don't include .setPattern() as a valid fonction : Documentation

In contrary, the RangeFill interface include .setPattern() and even .setPatternColor() as valid fonction : Documentation

By using excel menu, you can set a pattern on a conditional range so this is a feature of excel.

image

Can you add this to Office script API ?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,638 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,673 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2024-06-26T15:10:49.0866667+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    The ConditionalRangeFill interface in ExcelScript does not include a setPattern() function. However, the RangeFill interface does include setPattern() and setPatternColor() functions. While it is possible to set a pattern on a conditional range using the Excel menu, this feature is not currently available in the Office Script API.

    References:

    0 comments