Uses of Class
io.keikai.axyra.sheets.content.ConditionalFormat.Builder
Packages that use ConditionalFormat.Builder
Package
Description
The objects a workbook or sheet holds besides cell values: charts, tables,
data validations, conditional formats, comments, hyperlinks, sparklines,
form controls, slicers, timelines, external links, embedded objects and
more.
-
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).Sets the data-bar axis color.ConditionalFormat.Builder.axisPosition(String position) Data-bar axis position:"automatic","middle", or"none".ConditionalFormat.Builder.barBorderColor(Color color) Draws 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.AcellIsrule that matches values fromlowtohigh, both included.ConditionalFormat.Builder.bold()Makes matching cells 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()A builder.AcellIsrule, for examplecellIs("greaterThan", "100").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).Fills matching cells with a solidcolor.Sets the font color of matching cells.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) Sets the border color of negative-value data bars.ConditionalFormat.Builder.negativeFillColor(Color color) Sets 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) Sets the evaluation priority: 1 is evaluated first.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.