@sheetwrite/coreinterface
Ordered condition and style applied to a cell range.
- Package
@sheetwrite/core- Source
packages/core/src/types/cell.ts#L58
Members 3
range
range: Rangeinterface Range {
sheet: SheetId;
start: { row: number; col: number };
end: { row: number; col: number };
}interface Range {
sheet: SheetId;
start: { row: number; col: number };
end: { row: number; col: number };
}interface Range {
sheet: SheetId;
start: {
row: number;
col: number;
};
end: {
row: number;
col: number;
};
}Inclusive rectangular cell range on a stable sheet ID.API reference →;when
when: ConditionalFormatPredicatetype ConditionalFormatPredicate =
| { kind: "greaterThan"; value: number }
| { kind: "lessThan"; value: number }
| { kind: "equal"; value: CellScalar }
| { kind: "contains"; text: string; matchCase?: boolean };type ConditionalFormatPredicate =
| { kind: "greaterThan"; value: number }
| { kind: "lessThan"; value: number }
| { kind: "equal"; value: CellScalar }
| { kind: "contains"; text: string; matchCase?: boolean };type ConditionalFormatPredicate =
| {
kind: "greaterThan";
value: number;
}
| {
kind: "lessThan";
value: number;
}
| {
kind: "equal";
value: CellScalar;
}
| {
kind: "contains";
text: string;
matchCase?: boolean;
};Predicate used to decide whether a conditional format applies.API reference →;style
style: CellStyleinterface CellStyle {
bold?: boolean;
italic?: boolean;
underline?: boolean;
strikethrough?: boolean;
fontSize?: number;
color?: string;
backgroundColor?: string;
align?: CellAlign;
wrap?: boolean;
border?: CellBorders;
}interface CellStyle {
bold?: boolean;
italic?: boolean;
underline?: boolean;
strikethrough?: boolean;
fontSize?: number;
color?: string;
backgroundColor?: string;
align?: CellAlign;
wrap?: boolean;
border?: CellBorders;
}interface CellStyle {
bold?: boolean;
italic?: boolean;
underline?: boolean;
strikethrough?: boolean;
fontSize?: number;
color?: string;
backgroundColor?: string;
align?: CellAlign;
wrap?: boolean;
border?: CellBorders;
}Serializable formatting applied to a cell or used as a column default.API reference →;Declaration
View full TypeScript declaration
export interface ConditionalFormatRule { range: Rangeinterface Range {
sheet: SheetId;
start: { row: number; col: number };
end: { row: number; col: number };
}interface Range {
sheet: SheetId;
start: { row: number; col: number };
end: { row: number; col: number };
}interface Range {
sheet: SheetId;
start: {
row: number;
col: number;
};
end: {
row: number;
col: number;
};
}Inclusive rectangular cell range on a stable sheet ID.API reference →; when: ConditionalFormatPredicatetype ConditionalFormatPredicate =
| { kind: "greaterThan"; value: number }
| { kind: "lessThan"; value: number }
| { kind: "equal"; value: CellScalar }
| { kind: "contains"; text: string; matchCase?: boolean };type ConditionalFormatPredicate =
| { kind: "greaterThan"; value: number }
| { kind: "lessThan"; value: number }
| { kind: "equal"; value: CellScalar }
| { kind: "contains"; text: string; matchCase?: boolean };type ConditionalFormatPredicate =
| {
kind: "greaterThan";
value: number;
}
| {
kind: "lessThan";
value: number;
}
| {
kind: "equal";
value: CellScalar;
}
| {
kind: "contains";
text: string;
matchCase?: boolean;
};Predicate used to decide whether a conditional format applies.API reference →; style: CellStyleinterface CellStyle {
bold?: boolean;
italic?: boolean;
underline?: boolean;
strikethrough?: boolean;
fontSize?: number;
color?: string;
backgroundColor?: string;
align?: CellAlign;
wrap?: boolean;
border?: CellBorders;
}interface CellStyle {
bold?: boolean;
italic?: boolean;
underline?: boolean;
strikethrough?: boolean;
fontSize?: number;
color?: string;
backgroundColor?: string;
align?: CellAlign;
wrap?: boolean;
border?: CellBorders;
}interface CellStyle {
bold?: boolean;
italic?: boolean;
underline?: boolean;
strikethrough?: boolean;
fontSize?: number;
color?: string;
backgroundColor?: string;
align?: CellAlign;
wrap?: boolean;
border?: CellBorders;
}Serializable formatting applied to a cell or used as a column default.API reference →;}