Uses of Class
io.keikai.axyra.sheets.content.ConditionalFormat.Builder
Packages that use ConditionalFormat.Builder
-
Uses of ConditionalFormat.Builder in io.keikai.axyra.sheets.content
Methods in io.keikai.axyra.sheets.content that return ConditionalFormat.BuilderModifier and TypeMethodDescriptionConditionalFormat.Builder.aboveAverage(boolean below, boolean includeEqual) An above-average (or below-average whenbelow) rule.ConditionalFormat.Builder.aboveAverage(boolean below, boolean includeEqual, int stdDev) An above/below-average rule restricted to a standard-deviation band: select cellsstdDevstandard deviations above (or below, whenbelow) the mean (ECMA-376 §18.3.1.1stdDev, values 1-3).The data-bar axis color.ConditionalFormat.Builder.axisPosition(String position) Data-bar axis position:"automatic","middle", or"none".ConditionalFormat.Builder.barBorderColor(Color color) Draw a data-bar border incolor.ConditionalFormat.Builder.barDirection(String direction) Data-bar direction:"context","leftToRight", or"rightToLeft".ConditionalFormat.Builder.beginsWith(String text) A "cell text begins withtext" rule.Abetweenrule.ConditionalFormat.Builder.bold()ConditionalFormat.Builder.border(BorderStyle style, Color color) Draw the same border style and color on all four edges of matching cells — the differential<border>of the rule style.ConditionalFormat.Builder.borderSide(String side, BorderStyle borderStyle, Color color) Draw a border on one edge ("left","right","top", or"bottom") of matching cells.static ConditionalFormat.BuilderConditionalFormat.builder()AcellIsrule, e.g.ConditionalFormat.Builder.colorScale(Color... colors) A 2- or 3-color scale rule (min → [mid] → max).ConditionalFormat.Builder.containsBlanks()Highlight blank cells (Excel's "contains blanks").ConditionalFormat.Builder.containsErrors()Highlight cells whose value is an error.ConditionalFormat.Builder.containsText(String text) A "cell text containstext" rule.A data-bar rule drawn incolor.ConditionalFormat.Builder.dateOccurring(TimePeriod period) A "date occurring" rule: highlight cells whose date falls in the given window (ECMA-376 §18.18.82 ST_TimePeriod).ConditionalFormat.Builder.duplicateValues()Highlight duplicate values in the range.A "cell text ends withtext" rule.ConditionalFormat.Builder.expression(String formula) Anexpressionrule (a boolean formula).ConditionalFormat.Builder.gradient(boolean gradient) Solid (false) vs gradient (true) data-bar fill.An icon-set rule, e.g.ConditionalFormat.Builder.italic()Italicize matching cells.ConditionalFormat.Builder.negativeBorderColor(Color color) The border color of negative-value data bars.ConditionalFormat.Builder.negativeFillColor(Color color) The fill color of negative-value data bars.ConditionalFormat.Builder.notContainsBlanks()Highlight non-blank cells.ConditionalFormat.Builder.notContainsErrors()Highlight cells whose value is not an error.ConditionalFormat.Builder.notContainsText(String text) A "cell text does not containtext" rule.ConditionalFormat.Builder.numberFormat(String formatCode) Apply a number format code (e.g.ConditionalFormat.Builder.priority(int priority) Evaluation priority (lower wins).ConditionalFormat.Builder.reverse(boolean reversed) Draw the icon set in reversed order.ConditionalFormat.Builder.showValue(boolean show) Show / hide the cell value beside a data bar or icon set.ConditionalFormat.Builder.stopIfTrue()Stop evaluating lower-priority rules once this one matches.ConditionalFormat.Builder.strikethrough()Strike through matching cells.ConditionalFormat.toBuilder()A builder pre-loaded with this rule, for read–modify–write round-trips.ConditionalFormat.Builder.top10(int rank, boolean bottom, boolean percent) A top-N (or bottom-N whenbottom) rule;percentranks by %.ConditionalFormat.Builder.underline()Single-underline matching cells.ConditionalFormat.Builder.uniqueValues()Highlight values that occur exactly once in the range.ConditionalFormat.Builder.valueObject(ConditionalFormat.ValueObject vo) Append a threshold value object (ECMA-376 §18.3.1.11 cfvo) for a color-scale / data-bar / icon-set rule.ConditionalFormat.Builder.valueObject(String type) Append a valueless threshold ("min"/"max").ConditionalFormat.Builder.valueObject(String type, String value) Append a threshold with a number or formula value.