GroupCriteria2.AddEx Method (Project)
Adds a GroupCriterion2 object to the GroupCriteria2 collection, where CellColor can be a hexadecimal value.
Version Information
Version Added: Project 2010
Syntax
expression .AddEx(FieldName, Ascending, FontName, FontSize, FontBold, FontItalic, FontUnderLine, FontColor, CellColor, Pattern, GroupOn, StartAt, GroupInterval)
expression An expression that returns a GroupCriteria2 object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
FieldName |
Required |
String |
The name of the field being grouped by. |
Ascending |
Optional |
Boolean |
True if the field in a group definition should be grouped in ascending order. False if the field should be grouped in descending order. The default value is True. |
FontName |
Optional |
String |
The name of the font for a group definition. |
FontSize |
Optional |
[INT] |
The size of the font in a group definition, in points. The default value is 8. |
FontBold |
Optional |
Boolean |
True if the font in a group definition is bold. The default value is True. |
FontItalic |
Optional |
Boolean |
True if the font in a group definition is italic. The default value is False. |
FontUnderLine |
Optional |
Boolean |
True if the font in a group definition is underlined. The default value is False. |
FontColor |
Optional |
Long |
The color of the font in a group definition, where color can be a hexadecimal value. See remarks. The default value is &H0. |
CellColor |
Optional |
Long |
The color of the cell background specified by a hexadecimal value. See remarks. The default value is &HFFFFFF. |
Pattern |
Optional |
PjBackgroundPattern |
The pattern for the cells in a group definition. Can be one of the PjBackgroundPattern constants. |
GroupOn |
Optional |
PjGroupOn |
The type of grouping in a group definition. Can be one of the PjGroupOn constants. The default value is pjGroupOnEachValue. |
StartAt |
Optional |
Variant |
The start of the intervals in a group definition. The default value is 0 for all fields except date fields, where it is the string "Project Start Date". |
GroupInterval |
Optional |
Variant |
The interval in a group definition. The default value is 1. |
Return Value
GroupCriterion2
Remarks
RGB colors can be expressed in decimal or hexadecimal values. In Project, red is the last byte of a hexadecimal value. For example, if the value of CellColorEx is 65535, the color is blue (&HFF0000).
The valid range for a normal RGB color is 0 to 16,777,215 (&HFFFFFF&). Each color setting (property or argument) is a 4-byte integer. The high byte of a number in this range equals 0. The lower 3 bytes, from least to most significant byte, determine the amount of red, green, and blue, respectively. The red, green, and blue components are each represented by a number between 0 and 255 (&HFF).