Enumeration: QuarterType

Sheets.ConditionalFormatting.QuarterType

Specifies the quarter type.

example

var style = new GC.Spread.Sheets.Style();
style.backColor = "lightgreen";
// Create a condition for first quarter
var condition = new GC.Spread.Sheets.ConditionalFormatting.Condition(
    GC.Spread.Sheets.ConditionalFormatting.ConditionType.dateExCondition,
    {
        expected: GC.Spread.Sheets.ConditionalFormatting.QuarterType.quarter1
    }
);
condition.expectTypeId(GC.Spread.Sheets.ConditionalFormatting.DateExConditionExpectType.quarterOccurring);
// Create a rule using the condition
var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
rule.condition(condition);
rule.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
rule.style(style);
activeSheet.conditionalFormats.addRule(rule);

Table of contents

Enumeration members

• quarter1
• quarter2
• quarter3
• quarter4

Enumeration members

quarter1

• quarter1 = 0

Indicates the first quarter of a year.

quarter2

• quarter2 = 1

Indicates the second quarter of a year.

quarter3

• quarter3 = 2

Indicates the third quarter of a year.

quarter4

• quarter4 = 3

Indicates the fourth quarter of a year.