Package | Description |
---|---|
io.keikai.api |
Keikai Spreadsheet API classes.
|
io.keikai.api.impl |
Keikai Spreadsheet API implementation classes, internal use only
|
io.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.
|
Modifier and Type | Method and Description |
---|---|
SRange |
Range.getInternalRange()
Get internal range implementation
|
Modifier and Type | Method and Description |
---|---|
SRange |
RangeImpl.getInternalRange() |
SRange |
RangeImpl.getNative() |
Constructor and Description |
---|
RangeImpl(SRange range,
Book book) |
RangeImpl(SRange range,
Sheet sheet) |
Modifier and Type | Method and Description |
---|---|
SRichText |
RichTextHelper.parse(SRange range,
String content) |
Modifier and Type | Method and 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 a
SRange that represent columns of the 1st selected area of this Range. |
SRange |
SRange.getOffset(int rowOffset,
int colOffset)
Returns a
SRange that represents a range that offset from this Range. |
SRange |
SRange.getRows()
Returns a
SRange 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,
CellRegion region)
|
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 associated
XRange of the specified XNSheet and area. |
static SRange |
SRanges.range(SSheet sheet,
String areaReference)
|
static SRange |
SRanges.rangeByName(SSheet sheet,
String name)
Returns the associated
SRange of the specified name of a NamedRange (e.g. |
Modifier and Type | Method and 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
|
Modifier and Type | Class and 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.
|
Modifier and Type | Field and Description |
---|---|
protected SRange |
RangeHelperBase.range |
Modifier and Type | Method and 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) |
Modifier and Type | Method and 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.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 |
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 region
|
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) |
Constructor and Description |
---|
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) |
Modifier and Type | Method and Description |
---|---|
void |
ReserveUtil.ReservedCellContent.apply(SRange range) |
Copyright © 2020. All rights reserved.