Package | Description |
---|---|
org.zkoss.zss.model |
ZK Spreadsheet Internal Book Model classes.
|
org.zkoss.zss.model.impl |
ZK Spreadsheet Internal Book Model Implementation classes.
|
org.zkoss.zss.model.impl.html |
The exporter that convert ZK Spreadsheet to HTML.
|
org.zkoss.zss.range |
ZK Spreadsheet Internal Range API classes.
|
org.zkoss.zss.range.impl |
ZK Spreadsheet Internal Range API Implementation classes.
|
org.zkoss.zss.range.impl.autofill |
ZK Spreadsheet Internal Range API Implementation classes.
|
org.zkoss.zss.ui.impl.undo |
Classes that doing system undoable action control on ZK Spreadsheet UI Components.
|
Modifier and Type | Method and Description |
---|---|
CellRegion |
SSheet.getMergedRegion(int idx) |
CellRegion |
SSheet.getMergedRegion(int row,
int column) |
CellRegion |
SSheet.getMergedRegion(java.lang.String cellRefString) |
CellRegion |
CellRegion.getOverlap(CellRegion target) |
CellRegion |
SName.getRefersToCellRegion() |
CellRegion |
SheetRegion.getRegion() |
CellRegion |
SAutoFilter.getRegion()
Returns the filtered Region.
|
CellRegion |
ModelEvent.getRegion() |
CellRegion |
SPrintSetup.getRepeatingColumnsTitle() |
CellRegion |
SPrintSetup.getRepeatingRowsTitle() |
CellRegion |
SSheet.pasteCell(SheetRegion src,
CellRegion dest,
PasteOption option)
paste cell from src sheet to this sheet, the sheets must in same book
|
Modifier and Type | Method and Description |
---|---|
java.util.List<CellRegion> |
CellRegion.diff(CellRegion target) |
java.util.List<CellRegion> |
SSheet.getContainsMergedRegions(CellRegion region)
Get the merged region that are contained by region.
|
java.util.List<CellRegion> |
SSheet.getMergedRegions() |
java.util.List<CellRegion> |
SSheet.getOverlapsMergedRegions(CellRegion region,
boolean excludeContains)
Get the merged region that overlapped the region
|
java.util.Set<CellRegion> |
SDataValidation.getRegions() |
Modifier and Type | Method and Description |
---|---|
SDataValidation |
SSheet.addDataValidation(CellRegion region) |
SDataValidation |
SSheet.addDataValidation(CellRegion region,
SDataValidation src) |
void |
SSheet.addMergedRegion(CellRegion region)
Add a merged area, you can't assign a area that overlaps existed merged area.
|
void |
SDataValidation.addRegion(CellRegion region) |
void |
SSheet.clearCell(CellRegion region)
Clear cells in specified region
|
boolean |
CellRegion.contains(CellRegion region) |
SAutoFilter |
SSheet.createAutoFilter(CellRegion region)
Creates a new auto filter, the old one will be drop directly.
|
static ModelEvent |
ModelEvents.createModelEvent(java.lang.String name,
SSheet sheet,
CellRegion region) |
static ModelEvent |
ModelEvents.createModelEvent(java.lang.String name,
SSheet sheet,
CellRegion region,
java.util.Map data) |
void |
SSheet.deleteCell(CellRegion region,
boolean horizontal)
Delete a region of cells and shift existing cells.
|
java.util.List<SDataValidation> |
SSheet.deleteDataValidationRegion(CellRegion region)
Delete data validations that are covered by the specified region.
|
java.util.List<CellRegion> |
CellRegion.diff(CellRegion target) |
java.util.List<CellRegion> |
SSheet.getContainsMergedRegions(CellRegion region)
Get the merged region that are contained by region.
|
CellRegion |
CellRegion.getOverlap(CellRegion target) |
java.util.List<CellRegion> |
SSheet.getOverlapsMergedRegions(CellRegion region,
boolean excludeContains)
Get the merged region that overlapped the region
|
void |
SSheet.insertCell(CellRegion region,
boolean horizontal)
Insert a region of cells and shift existing cells.
|
void |
SSheet.moveCell(CellRegion region,
int rowOffset,
int columnOffset)
Move one or more cells.
|
boolean |
CellRegion.overlaps(CellRegion region) |
CellRegion |
SSheet.pasteCell(SheetRegion src,
CellRegion dest,
PasteOption option)
paste cell from src sheet to this sheet, the sheets must in same book
|
void |
SSheet.removeDataValidationRegion(CellRegion region)
Deprecated.
|
void |
SSheet.removeMergedRegion(CellRegion region,
boolean removeOverlaps)
Remove the merged area that are contained by region
|
void |
SDataValidation.removeRegion(CellRegion region) |
Modifier and Type | Method and Description |
---|---|
void |
SDataValidation.setRegions(java.util.Set<CellRegion> regions) |
Constructor and Description |
---|
SheetRegion(SSheet sheet,
CellRegion region) |
Modifier and Type | Method and Description |
---|---|
CellRegion |
SheetImpl.getMergedRegion(int idx) |
CellRegion |
SheetImpl.getMergedRegion(int row,
int column) |
CellRegion |
SheetImpl.getMergedRegion(java.lang.String cellRef) |
CellRegion |
NameImpl.getRefersToCellRegion() |
CellRegion |
AutoFilterImpl.getRegion() |
CellRegion |
PrintSetupImpl.getRepeatingColumnsTitle() |
CellRegion |
PrintSetupImpl.getRepeatingRowsTitle() |
CellRegion |
SheetImpl.pasteCell(SheetRegion src,
CellRegion dest,
PasteOption option) |
CellRegion |
PasteCellHelper.pasteCell(SheetRegion src,
CellRegion dest,
PasteOption option) |
Modifier and Type | Method and Description |
---|---|
java.util.List<CellRegion> |
SheetImpl.getContainsMergedRegions(CellRegion region) |
java.util.List<CellRegion> |
SheetImpl.getMergedRegions() |
java.util.List<CellRegion> |
SheetImpl.getOverlapsMergedRegions(CellRegion region,
boolean excludeContains) |
java.util.Set<CellRegion> |
DataValidationImpl.getRegions() |
Modifier and Type | Method and Description |
---|---|
SDataValidation |
SheetImpl.addDataValidation(CellRegion region) |
SDataValidation |
SheetImpl.addDataValidation(CellRegion region,
SDataValidation src) |
void |
SheetImpl.addMergedRegion(CellRegion region) |
void |
DataValidationImpl.addRegion(CellRegion region) |
void |
SheetImpl.clearCell(CellRegion region) |
SAutoFilter |
SheetImpl.createAutoFilter(CellRegion region) |
void |
SheetImpl.deleteCell(CellRegion region,
boolean horizontal) |
java.util.List<SDataValidation> |
SheetImpl.deleteDataValidationRegion(CellRegion region) |
java.util.List<CellRegion> |
SheetImpl.getContainsMergedRegions(CellRegion region) |
java.util.List<CellRegion> |
SheetImpl.getOverlapsMergedRegions(CellRegion region,
boolean excludeContains) |
void |
SheetImpl.insertCell(CellRegion region,
boolean horizontal) |
void |
SheetImpl.moveCell(CellRegion region,
int rowOffset,
int columnOffset) |
CellRegion |
SheetImpl.pasteCell(SheetRegion src,
CellRegion dest,
PasteOption option) |
CellRegion |
PasteCellHelper.pasteCell(SheetRegion src,
CellRegion dest,
PasteOption option) |
void |
SheetImpl.removeDataValidationRegion(CellRegion region) |
void |
SheetImpl.removeMergedRegion(CellRegion region,
boolean removeOverlaps) |
void |
DataValidationImpl.removeRegion(CellRegion region) |
Modifier and Type | Method and Description |
---|---|
void |
DataValidationImpl.setRegions(java.util.Set<CellRegion> regions) |
Constructor and Description |
---|
AutoFilterImpl(CellRegion region) |
Modifier and Type | Method and Description |
---|---|
static void |
ToHtml.export(SSheet ws,
CellRegion area,
java.io.OutputStream outputStream) |
static void |
ToHtml.export(SSheet ws,
CellRegion area,
java.io.OutputStream outputStream,
boolean noHeader) |
Modifier and Type | Method and Description |
---|---|
static SRange |
SRanges.range(SSheet sheet,
CellRegion region)
|
Modifier and Type | Method and Description |
---|---|
CellRegion |
MergeUpdate.getMerge() |
CellRegion |
MergeUpdate.getOrigMerge() |
Modifier and Type | Method and Description |
---|---|
void |
ModelUpdateCollector.addMergeChange(SSheet sheet,
CellRegion original,
CellRegion changeTo) |
Constructor and Description |
---|
MergeUpdate(SSheet sheet,
CellRegion origMerge,
CellRegion merge) |
RangeImpl(SSheet sheet,
CellRegion region) |
Modifier and Type | Method and Description |
---|---|
void |
AutoFillHelper.fill(SSheet sheet,
CellRegion srcRegion,
CellRegion dstRegion,
SRange.FillType fillType)
fill the sheet, from srcRef to dstRef
|
void |
AutoFillHelper.fillDown(SSheet sheet,
CellRegion srcRef,
CellRegion dstRef,
SRange.FillType fillType) |
void |
AutoFillHelper.fillLeft(SSheet sheet,
CellRegion srcRef,
CellRegion dstRef,
SRange.FillType fillType) |
void |
AutoFillHelper.fillRight(SSheet sheet,
CellRegion srcRef,
CellRegion dstRef,
SRange.FillType fillType) |
void |
AutoFillHelper.fillUp(SSheet sheet,
CellRegion srcRef,
CellRegion dstRef,
SRange.FillType fillType) |
Modifier and Type | Method and Description |
---|---|
CellRegion[] |
ReserveUtil.ReservedResult.getMergeInfo() |
static CellRegion[] |
ReserveUtil.reserveMergeInfo(SSheet sheet,
int row,
int column,
int lastRow,
int lastColumn)
reserve the merge information that in the given range.
|
Modifier and Type | Method and Description |
---|---|
void |
ReserveUtil.ReservedResult.setMergeInfo(CellRegion[] mergeInfo) |
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.