Column Formatting (Pivot Table)
option.label | option.path | data type |
Title | columnFormatting[i].formatTitle | string |
Group type | columnFormatting[i].formatGroupType | "column" | "row" |
Groups to format | columnFormatting[i].formattedGroups[] | string[] (group labels incl. "Totals") |
Operator | columnFormatting[i].operator | string (from basicOperatorFormatOptions plus "all") |
Comparison type | columnFormatting[i].comparisonType | "number" | "row" | "column" (date/text also supported by code) |
Comparison value | columnFormatting[i].comparisonValue | number | string | date (depends on comparisonType) |
Alignment | columnFormatting[i].styles.alignment | "left" | "center" | "right" |
Cell color | columnFormatting[i].styles.cellColor | color string (e.g., #ffffff) |
Text color | columnFormatting[i].styles.textColor | color string |
Font family | columnFormatting[i].styles.family | string (e.g., "arial, sans-serif") |
Font styles | columnFormatting[i].styles.fontStyles[] | string[] (e.g., "bold", "italic") |
Font size | columnFormatting[i].styles.size | string (e.g., "16px") |
Number format | columnFormatting[i].styles.numberFormat | string (from number-format select) |
Display currency | columnFormatting[i].styles.displayCurrency | boolean |
Currency | columnFormatting[i].styles.currencySelect | string (symbol/code) |
Date format | columnFormatting[i].styles.dateFormatSelect | string | null |