CellDataBar

Defined in: src/core/document-model/types.ts:869

A conditional-format data bar: a horizontal bar of width fraction (0..1 of the cell), painted over the shading and under the text (E-SHEET SC1c). It starts at startFraction from the cell’s left (default 0); a mixed-sign range puts the axis inside the cell so negative bars run left of it (tail TC4).

Properties

colorHex

readonly colorHex: string

Defined in: src/core/document-model/types.ts:871

---

fraction

readonly fraction: number

Defined in: src/core/document-model/types.ts:870

---

negative?

readonly optional negative?: boolean

Defined in: src/core/document-model/types.ts:878

The bar runs LEFT from the axis (a negative value in a mixed-sign range), so its solid end is its right one. Excel fades a data bar away from the axis, and which way that is depends on the sign.

---

solid?

readonly optional solid?: boolean

Defined in: src/core/document-model/types.ts:880

The bar is one solid colour, not faded from the axis (<x14:dataBar gradient="0">).

---

startFraction?

readonly optional startFraction?: number

Defined in: src/core/document-model/types.ts:872