public interface IWorksheetStructure
Modifier and Type | Method and Description |
---|---|
void |
deleteCellsWithShiftLeft(IRangeAddress range)
Deletes the range of cells shifting the formulas, formula dependencies, values, styles, comments, hyperlinks to the left
|
void |
deleteCellsWithShiftUp(IRangeAddress range)
Deletes the range of cells shifting the formulas, formula dependencies, values, styles, comments, hyperlinks up
|
ICellsLineManager<IColumn> |
getColumnsManager() |
ICellsLineManager<IRow> |
getRowsManager() |
void |
insertCellsWithShiftDown(IRangeAddress range)
Inserts the range of cells shifting the formulas, formula dependencies, values, styles, comments, hyperlinks down
|
void |
insertCellsWithShiftRight(IRangeAddress range)
Inserts the range of cells shifting the formulas, formula dependencies, values, styles, comments, hyperlinks to the right
|
void |
merge(IRangeAddress range)
Merges the range of cells
|
void |
sorting(IRangeAddress range,
boolean ascending)
Sorts the values in the given range
|
void |
unmerge(IRangeAddress range)
Unmerges the range of cells
|
ICellsLineManager<IRow> getRowsManager()
ICellsLineManager
for IRow
to manage rowsICellsLineManager<IColumn> getColumnsManager()
ICellsLineManager
for IColumn
to manage columnsvoid merge(IRangeAddress range)
range
- the range of cells to be mergedIRangeAddress
void unmerge(IRangeAddress range)
range
- the range of cells to be unmergedIRangeAddress
void deleteCellsWithShiftLeft(IRangeAddress range)
range
- the cells to be deletedIRangeAddress
void deleteCellsWithShiftUp(IRangeAddress range)
range
- the cells to be deletedIRangeAddress
void insertCellsWithShiftDown(IRangeAddress range)
range
- the cells to be insertedIRangeAddress
void insertCellsWithShiftRight(IRangeAddress range)
range
- the cells to be insertedIRangeAddress
void sorting(IRangeAddress range, boolean ascending)
range
- the target cells IRangeAddress
ascending
- the true
value is set to sort the selected cells in the ascending orderCopyright © 2024. All rights reserved.