Uses of Interface
io.keikai.range.SRange
-
Packages that use SRange Package Description io.keikai.api Keikai Spreadsheet API classes.io.keikai.api.impl Keikai Spreadsheet API implementation classes, internal use onlyio.keikai.model.util Keikai Spreadsheet Internal Book Model Utilities classes.io.keikai.range Keikai Spreadsheet Internal Range API classes.io.keikai.range.impl Keikai Spreadsheet Internal Range API Implementation classes.io.keikai.ui.impl.undo Classes that doing system undoable action control on Keikai Spreadsheet UI Components. -
-
Uses of SRange in io.keikai.api
Methods in io.keikai.api that return SRange Modifier and Type Method Description SRange
Range. getInternalRange()
Get internal range implementation -
Uses of SRange in io.keikai.api.impl
Methods in io.keikai.api.impl that return SRange Modifier and Type Method Description SRange
RangeImpl. getInternalRange()
SRange
RangeImpl. getNative()
Constructors in io.keikai.api.impl with parameters of type SRange Constructor Description RangeImpl(SRange range, Book book)
RangeImpl(SRange range, Sheet sheet)
-
Uses of SRange in io.keikai.model.util
Methods in io.keikai.model.util with parameters of type SRange Modifier and Type Method Description SRichText
RichTextHelper. parse(SRange range, String content)
-
Uses of SRange in io.keikai.range
Methods in io.keikai.range that return SRange Modifier and Type Method Description SRange
SRange. copy(SRange dstRange)
Copy data from this range to the specified destination range.SRange
SRange. copy(SRange dstRange, boolean cut)
cut the selected range and paste to destination range.SRange
SRange. findAutoFilterRange()
To find a range of cells for applying auto filter according to this range.SRange
SRange. getColumns()
Returns aSRange
that represent columns of the 1st selected area of this Range.SRange
SRange. getOffset(int rowOffset, int colOffset)
Returns aSRange
that represents a range that offset from this Range.SRange
SRange. getRows()
Returns aSRange
that represent rows of the 1st selected area of this Range.SRange
SRange. pasteSpecial(SRange dstRange, SRange.PasteType pasteType, SRange.PasteOperation pasteOp, boolean skipBlanks, boolean transpose)
Pastes to a destination Range from this range.static SRange
SRanges. range(SBook book)
static SRange
SRanges. range(SSheet sheet)
static SRange
SRanges. range(SSheet sheet, int row, int col)
static SRange
SRanges. range(SSheet sheet, int tRow, int lCol, int bRow, int rCol)
Returns the associatedXRange
of the specifiedXNSheet
and area.static SRange
SRanges. range(SSheet sheet, CellRegion region)
static SRange
SRanges. range(SSheet sheet, String areaReference)
static SRange
SRanges. rangeByName(SSheet sheet, String name)
Returns the associatedSRange
of the specified name of a NamedRange (e.g.Methods in io.keikai.range that return types with arguments of type SRange Modifier and Type Method Description List<SRange>
SRange. getColumnGroups()
Returns all group ranges for columns, which intersect with this range.List<SRange>
SRange. getColumnGroups(int outlineLevel)
Returns all group ranges matched the given outline level for columns, which intersect with this range.List<SRange>
SRange. getColumnGroups(int fromOutlineLevel, int toOutlineLevel)
Returns all group ranges matched between fromOutlineLevel and toOutlineLevel for columns, which intersect with this range.Set<SRange>
SRange. getDependents()
Returns all Range(s) that are the direct or indirect dependents of this cell Range.Set<SRange>
SRange. getDirectDependents()
Returns Range(s) that are the direct dependents of this cell Range.Set<SRange>
SRange. getDirectPrecedents()
Returns Range(s) that are the direct precedents of this cell Range.Set<SRange>
SRange. getPrecedents()
Returns all Range(s) that are the direct or indirect precedents of this cell Range.List<SRange>
SRange. getRowGroups()
Returns all group ranges for rows, which intersect with this range.List<SRange>
SRange. getRowGroups(int outlineLevel)
Returns all group ranges matched the given outline level for rows, which intersect with this range.List<SRange>
SRange. getRowGroups(int fromOutlineLevel, int toOutlineLevel)
Returns all group ranges matched between fromOutlineLevel and toOutlineLevel for rows, which intersect with this range.Methods in io.keikai.range with parameters of type SRange Modifier and Type Method Description SRange
SRange. copy(SRange dstRange)
Copy data from this range to the specified destination range.SRange
SRange. copy(SRange dstRange, boolean cut)
cut the selected range and paste to destination range.void
SRange. fill(SRange dstRange, SRange.FillType fillType)
Perform an auto fill on the specified destination Range.SRange
SRange. pasteSpecial(SRange dstRange, SRange.PasteType pasteType, SRange.PasteOperation pasteOp, boolean skipBlanks, boolean transpose)
Pastes to a destination Range from this range.void
SRange. sort(SRange key1, boolean descending1, SRange.SortDataOption dataOption1, SRange key2, boolean descending2, SRange.SortDataOption dataOption2, SRange key3, boolean descending3, SRange.SortDataOption dataOption3, int hasHeader, boolean matchCase, boolean sortByRows)
Sort this Range according the specified parameters -
Uses of SRange in io.keikai.range.impl
Classes in io.keikai.range.impl that implement SRange Modifier and Type Class Description class
PasteRangeImpl
To avoid paste too many rows; ZSS copy column only copy to sheetMaxVisibleRows.class
RangeImpl
Only those methods that set cell data, cell style, row (column) style, width, height, and hidden consider 3-D references.Fields in io.keikai.range.impl declared as SRange Modifier and Type Field Description protected SRange
RangeHelperBase. range
Methods in io.keikai.range.impl that return SRange Modifier and Type Method Description SRange
RangeImpl. copy(SRange dstRange)
SRange
RangeImpl. copy(SRange dstRange, boolean cut)
SRange
RangeImpl. findAutoFilterRange()
SRange
RangeImpl. getColumns()
SRange
RangeImpl. getOffset(int rowOffset, int colOffset)
SRange
RangeImpl. getRows()
SRange
RangeImpl. pasteSpecial(SRange dstRange, SRange.PasteType pasteType, SRange.PasteOperation pasteOp, boolean skipBlanks, boolean transpose)
SRange
RangeImpl. pasteSpecial0(SRange dstRange, PasteOption option)
Methods in io.keikai.range.impl that return types with arguments of type SRange Modifier and Type Method Description List<SRange>
RangeImpl. getColumnGroups()
List<SRange>
RangeImpl. getColumnGroups(int outlineLevel)
List<SRange>
RangeImpl. getColumnGroups(int fromOutlineLevel, int toOutlineLevel)
Set<SRange>
RangeImpl. getDependents()
Set<SRange>
RangeImpl. getDirectDependents()
Set<SRange>
RangeImpl. getDirectPrecedents()
Set<SRange>
RangeImpl. getPrecedents()
List<SRange>
RangeImpl. getRowGroups()
List<SRange>
RangeImpl. getRowGroups(int outlineLevel)
List<SRange>
RangeImpl. getRowGroups(int fromOutlineLevel, int toOutlineLevel)
Methods in io.keikai.range.impl with parameters of type SRange Modifier and Type Method Description SRange
RangeImpl. copy(SRange dstRange)
SRange
RangeImpl. copy(SRange dstRange, boolean cut)
void
RangeImpl. fill(SRange dstRange, SRange.FillType fillType)
SRange
RangeImpl. pasteSpecial(SRange dstRange, SRange.PasteType pasteType, SRange.PasteOperation pasteOp, boolean skipBlanks, boolean transpose)
SRange
RangeImpl. pasteSpecial0(SRange dstRange, PasteOption option)
static void
WholeStyleUtil. setBackColor(SRange wholeRange, String htmlColor)
static void
WholeStyleUtil. setDataFormat(SRange wholeRange, String format)
static void
WholeStyleUtil. setFillColor(SRange wholeRange, String htmlColor)
static void
WholeStyleUtil. setFillOptions(SRange wholeRange, String backColor, String fillColor, SFill.FillPattern pattern)
static void
WholeStyleUtil. setFontBoldWeight(SRange wholeRange, SFont.Boldweight fontBoldweight)
static void
WholeStyleUtil. setFontColor(SRange wholeRange, String htmlColor)
static void
WholeStyleUtil. setFontHeightPoints(SRange wholeRange, int fontHeightPoints)
static void
WholeStyleUtil. setFontItalic(SRange wholeRange, boolean italic)
static void
WholeStyleUtil. setFontName(SRange wholeRange, String fontName)
static void
WholeStyleUtil. setFontStrikethrough(SRange wholeRange, boolean strikeout)
static void
WholeStyleUtil. setFontTypeOffset(SRange wholeRange, SFont.TypeOffset fontTypeOffset)
static void
WholeStyleUtil. setFontUnderline(SRange wholeRange, SFont.Underline fontUnderline)
static void
WholeStyleUtil. setLocked(SRange wholeRange, boolean locked)
static void
WholeStyleUtil. setTextHAlign(SRange wholeRange, SCellStyle.Alignment hAlignment)
static void
WholeStyleUtil. setTextIndention(SRange wholeRange, int indention)
static void
WholeStyleUtil. setTextIndentionOffset(SRange wholeRange, int offset)
static void
WholeStyleUtil. setTextRotation(SRange wholeRange, int rotation)
static void
WholeStyleUtil. setTextVAlign(SRange wholeRange, SCellStyle.VerticalAlignment vAlignment)
static void
WholeStyleUtil. setTextWrap(SRange wholeRange, boolean wraptext)
static void
WholeStyleUtil. setWholeColumnCellStyle(SRange range, WholeStyleUtil.StyleApplyer applyer)
static void
WholeStyleUtil. setWholeRowCellStyle(SRange range, WholeStyleUtil.StyleApplyer applyer)
static void
WholeStyleUtil. setWholeStyle(SRange range, WholeStyleUtil.StyleApplyer applyer)
void
RangeImpl. sort(SRange key1, boolean descending1, SRange.SortDataOption dataOption1, SRange key2, boolean descending2, SRange.SortDataOption dataOption2, SRange key3, boolean descending3, SRange.SortDataOption dataOption3, int hasHeader, boolean matchCase, boolean sortByRows)
void
SortHelper. sort(SRange key1, boolean descending1, SRange.SortDataOption dataOption1, SRange key2, boolean descending2, SRange.SortDataOption dataOption2, SRange key3, boolean descending3, SRange.SortDataOption dataOption3, int header, boolean matchCase, boolean sortByRows)
Major procedure for sorting a selected range: record merged region, sort, unmerge merged regions, restore merged regionConstructors in io.keikai.range.impl with parameters of type SRange Constructor Description AutoFilterHelper(SRange range)
BorderHelper(SRange range)
ChartDataHelper(SRange range)
ClearCellHelper(SRange range)
DataRegionHelper(SRange range)
InsertDeleteHelper(SRange range)
MergeHelper(SRange range)
RangeHelperBase(SRange range)
SetCellStyleHelper(SRange range)
SortHelper(SRange range)
-
Uses of SRange in io.keikai.ui.impl.undo
Methods in io.keikai.ui.impl.undo with parameters of type SRange Modifier and Type Method Description void
ReserveUtil.ReservedCellContent. apply(SRange range)
-