Uses of Class
io.keikai.axyra.sheets.content.FormControl.Builder
Packages that use FormControl.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 FormControl.Builder in io.keikai.axyra.sheets.content
Methods in io.keikai.axyra.sheets.content that return FormControl.BuilderModifier and TypeMethodDescriptionFormControl.Builder.anchor(int fromRow, int fromColumn, int toRow, int toColumn) Sets the two-cell anchor (0-based).FormControl.Builder.anchorOffsets(long fromRowOffset, long fromColumnOffset, long toRowOffset, long toColumnOffset) Sets the offsets of the anchor's corners inside their cells, in EMU (914400 EMU = 1 inch).static FormControl.BuilderA push button; the caption comes from.text(...)or the name.static FormControl.BuilderA check box; set state with.checked(true).FormControl.Builder.checked(boolean checked) Sets the state of a check box or option button.static FormControl.BuilderA drop-down combo box; feed it with.listFillRange("F1:F5").FormControl.Builder.dropLines(int lines) Sets how many rows a combo box's drop-down shows; Excel uses 8 when not set.static FormControl.BuilderAn edit box (legacy dialog-sheet control).static FormControl.BuilderA group box frame (visually groups option buttons).FormControl.Builder.increment(int increment) Sets the step of one arrow click on a scroll bar or spin button.static FormControl.BuilderA static text label.FormControl.Builder.linkedCell(String a1Ref) Sets the cell that mirrors the control's state, in A1 form ("A1","Sheet2!B3");nullor an empty string sets none.static FormControl.BuilderA list box; feed it with.listFillRange("F1:F5").FormControl.Builder.listFillRange(String a1Range) Sets the range that supplies a combo box's or list box's items, in A1 form;nullor an empty string sets none.static FormControl.BuilderFormControl.of(FormControlType type, String name) A control of anyFormControlType.static FormControl.BuilderFormControl.optionButton(String name) An option (radio) button; set state with.checked(true).FormControl.Builder.page(int page) Sets the step of one click on a scroll bar's track.FormControl.Builder.range(int min, int max) Sets the minimum and maximum value of a scroll bar or spin button.static FormControl.BuilderA scroll bar; configure.range(min, max)/.value(v).FormControl.Builder.selectedIndex(int index) Sets the 1-based selected item of a combo box or list box; 0 means no selection.static FormControl.BuilderFormControl.spinButton(String name) A spin button; configure.range(min, max)/.value(v).Sets the caption of a button, check box, option button, label or group box;nullor an empty string shows the control name.FormControl.Builder.threeD(boolean threeD) Sets the 3-D shading flag of Excel's Format Control dialog.FormControl.toBuilder()A builder pre-loaded with this control, for read–modify–write round trips.FormControl.Builder.value(int value) Sets the current value of a scroll bar or spin button.