Modifier and Type | Method and Description |
---|---|
CompletableFuture<IRangeAddress> |
IUiSelectionManager.getSelection()
Gets the current cell or range selection
|
Modifier and Type | Method and Description |
---|---|
CompletableFuture<Boolean> |
IUiSelectionManager.setSelection(int worksheetId,
IRangeAddress target)
Changes the current selection to the target cell(s) in specified worksheet
|
CompletableFuture<Boolean> |
IUiSelectionManager.setSelection(IRangeAddress target)
Changes the current selection to the target cell(s) in the active worksheet
|
Modifier and Type | Method and Description |
---|---|
IRangeAddress |
BeforeShowMainContextMenuEvent.getActiveCell() |
IRangeAddress |
BeforeShowCellEditModeContextMenu.getActiveCell() |
IRangeAddress |
BeforeShowMainContextMenuEvent.getSelectedRange() |
IRangeAddress |
BeforeShowCellEditModeContextMenu.getSelectedRange() |
Constructor and Description |
---|
BeforeShowCellEditModeContextMenu(IRangeAddress selectedRange,
IRangeAddress activeCell,
IComment selectedCellComment) |
BeforeShowMainContextMenuEvent(IRangeAddress selectedRange,
IRangeAddress activeCell,
IComment selectedCellComment) |
Constructor and Description |
---|
ActiveCellChangedEvent(IRangeAddress newValue) |
ActiveSelectionChangedEvent(IRangeAddress iRangeAddress) |
Modifier and Type | Method and Description |
---|---|
Stream<IEntry<IRangeAddress,TItem>> |
IMapStorage.allEntries() |
Stream<IEntry<IRangeAddress,TItem>> |
IMapStorage.findContainingEntries(IRangeAddress range)
Returns all item entries contained in the given
IRangeAddress |
Stream<IEntry<IRangeAddress,TItem>> |
IMapStorage.findIntersectingEntries(IRangeAddress range)
Returns the entries of all items within the given
IRangeAddress |
IMapStorage<IRangeAddress> |
IWorksheetStorage.getMergedCellsStorage() |
Modifier and Type | Method and Description |
---|---|
Stream<TItem> |
IMapStorage.findContaining(IRangeAddress range)
Returns all items contained in the given
IRangeAddress |
Stream<IEntry<IRangeAddress,TItem>> |
IMapStorage.findContainingEntries(IRangeAddress range)
Returns all item entries contained in the given
IRangeAddress |
Stream<TItem> |
IMapStorage.findIntersecting(IRangeAddress range)
Returns all items within the given
IRangeAddress |
Stream<IEntry<IRangeAddress,TItem>> |
IMapStorage.findIntersectingEntries(IRangeAddress range)
Returns the entries of all items within the given
IRangeAddress |
IFont |
IWorksheetStorage.getCommonFont(IRangeAddress range)
Gets the aggregated font styles for the given range
|
IStyle |
IWorksheetStorage.getCommonStyle(IRangeAddress range)
Aggregate styles to some structure
|
Modifier and Type | Method and Description |
---|---|
Stream<IEntry<IRangeAddress,String>> |
IWorksheet.streamExistingFormattedValues(IRangeAddress range)
Deprecated.
current method will be completely removed in future releases,
but for the time being it's the only way to get formatted values
|
Modifier and Type | Method and Description |
---|---|
void |
IWorksheet.clear(IRangeAddress range)
Removes all content (values, comments, hyperlinks, styles) from the given range
|
String |
IWorksheet.getFormat(IRangeAddress range)
Gets the common RAW string format code of the given range of cells
|
void |
IWorksheet.inputContent(IRangeAddress range,
IRichString input)
Deprecated.
|
void |
IWorksheet.inputContent(IRangeAddress range,
String input)
Deprecated.
|
void |
IWorksheet.setContent(IRangeAddress range,
boolean cellContent)
Deprecated.
|
void |
IWorksheet.setContent(IRangeAddress range,
Number cellContent)
Deprecated.
|
void |
IWorksheet.setFormat(IRangeAddress range,
String format)
Sets the RAW string format code to the cells of the given range
|
Stream<IEntry<IRangeAddress,String>> |
IWorksheet.streamExistingFormattedValues(IRangeAddress range)
Deprecated.
current method will be completely removed in future releases,
but for the time being it's the only way to get formatted values
|
Modifier and Type | Method and Description |
---|---|
IRangeAddress |
ISelection.getActiveArea() |
IRangeAddress |
ISelection.getActiveCell() |
Modifier and Type | Method and Description |
---|---|
List<IRangeAddress> |
ISelection.getAreas() |
Modifier and Type | Method and Description |
---|---|
IRangeAddress |
IDrawingPoint.toAddress() |
Modifier and Type | Method and Description |
---|---|
void |
IValueService.clear(IRangeAddress range)
Clears the value in the range
|
void |
IStyleService.clear(IRangeAddress range)
Clears the style in the range of cells
|
void |
ICommentService.clear(IRangeAddress range)
Removes all comments in given range
|
IValue |
IValueService.get(IRangeAddress range)
Get value of a cell (of given single cell address) or top left cell (of given cells range)
|
void |
IValueService.parseContent(IRangeAddress range,
String content)
Sets a value in the range of cells.
|
void |
IHyperlinkService.remove(IRangeAddress range)
Removes hyperlinks in the given range
|
void |
IBorderService.set(IRangeAddress range,
Consumer<IBorderStyleBuilder> builderConsumer,
BordersSides sides)
Sets the borders in the given range address.
|
void |
ICommentService.set(IRangeAddress range,
Consumer<ICommentBuilder> builderConsumer)
Sets the comments in the given range address.
|
void |
IFontService.set(IRangeAddress range,
Consumer<IFontBuilder> builderConsumer)
Sets the font in the range of cells.For convenience, the user consumes a new instance of the
IFontBuilder
into which the desired values will be filled in. |
void |
IStyleService.set(IRangeAddress range,
Consumer<IStyleBuilder> builderConsumer)
Sets the font in the range of cells.
|
void |
IValueService.set(IRangeAddress range,
Function<IValueFactory,IValue> valueFunction)
Sets a value in the range of cells.
|
void |
IBorderService.set(IRangeAddress range,
IBorderStyle style,
BordersSides sides)
Sets the borders in the given range address
|
void |
ICommentService.set(IRangeAddress range,
IComment comment)
Sets comments to all cells in the given range
|
void |
IFontService.set(IRangeAddress range,
IFont style)
Sets the font in the range of cells
|
void |
IStyleService.set(IRangeAddress range,
IStyle style)
Sets the style in the range of cells
|
void |
IValueService.set(IRangeAddress range,
IValue value)
Sets the value in the range of cells
|
void |
IHyperlinkService.set(IRangeAddress range,
String content,
HyperlinkType type)
Sets a hyperlink
|
void |
IFontService.updateCommon(IRangeAddress range,
Consumer<IFontBuilder> builderConsumer)
Edits a common font in the range.
|
void |
IStyleService.updateCommon(IRangeAddress range,
Consumer<IStyleBuilder> builderConsumer)
Edits a common style in the range.
|
void |
IFontService.updateCommon(IRangeAddress range,
UnaryOperator<IFont> editor)
Edits a common font in the range.
|
void |
IStyleService.updateCommon(IRangeAddress range,
UnaryOperator<IStyle> editor)
Edit a common style in the range.
|
void |
IStyleService.updateEach(IRangeAddress range,
Consumer<IStyleBuilder> builderConsumer)
Edits the style of each cell in the given range.
|
void |
IStyleService.updateEach(IRangeAddress range,
UnaryOperator<IStyle> editor)
Edits the style of each cell in the given range.
|
void |
IBorderService.updateExisting(IRangeAddress range,
AddressItemEditor<ICellBorders> editor)
Applies the settings of the borders obtained from the
editor to each cell of the given range |
void |
ICommentService.updateExisting(IRangeAddress range,
AddressItemEditor<IComment> editor)
Edits comments in the given range.
|
void |
IHyperlinkService.updateExisting(IRangeAddress range,
UnaryOperator<IHyperlink> editor)
Edits the hyperlinks in the given range.
|
void |
IValueService.updateExisting(IRangeAddress range,
UnaryOperator<IValue> editor)
Edits the value in the range of cells
|
Modifier and Type | Method and Description |
---|---|
IRangeAddress |
IRangeAddressBuilder.buildCell()
Builds the address of a single cell
|
IRangeAddress |
IRangeAddressBuilder.buildRange()
Builds the address of a single cell or a range of cells according to the given settings
|
Modifier and Type | Method and Description |
---|---|
IRangeAddressBuilder |
IRangeAddressBuilder.from(IRangeAddress source)
Copies the existing address
|
Modifier and Type | Method and Description |
---|---|
IRangeAddress |
ISearchResultItem.getAddress() |
Modifier and Type | Method and Description |
---|---|
ISearchIterator |
ISearchService.createSearchInWorkbookIterator(ISearchParams searchParams,
int startWorksheetId,
IRangeAddress startAddress)
Searches all occurrences of a pattern in the workbook and returns the iterator.
|
ISearchIterator |
ISearchService.createSearchInWorksheetIterator(ISearchParams searchParams,
int worksheetId,
IRangeAddress startAddress)
Searches all occurrences of a pattern in the selected worksheet and returns the iterator.
|
Modifier and Type | Method and Description |
---|---|
Stream<IEntry<IRangeAddress,TItem>> |
ICellsLineManager.findContainingEntries(int from,
int to)
Deprecated.
|
Stream<IEntry<IRangeAddress,TItem>> |
ICellsLineManager.findIntersectingEntries(int from,
int to)
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
void |
IWorksheetStructure.deleteCellsWithShiftLeft(IRangeAddress range)
Deletes the range of cells shifting the formulas, formula dependencies, values, styles, comments, hyperlinks to the left
|
void |
IWorksheetStructure.deleteCellsWithShiftUp(IRangeAddress range)
Deletes the range of cells shifting the formulas, formula dependencies, values, styles, comments, hyperlinks up
|
void |
IWorksheetStructure.insertCellsWithShiftDown(IRangeAddress range)
Inserts the range of cells shifting the formulas, formula dependencies, values, styles, comments, hyperlinks down
|
void |
IWorksheetStructure.insertCellsWithShiftRight(IRangeAddress range)
Inserts the range of cells shifting the formulas, formula dependencies, values, styles, comments, hyperlinks to the right
|
void |
IWorksheetStructure.merge(IRangeAddress range)
Merges the range of cells
|
void |
IWorksheetStructure.sorting(IRangeAddress range,
boolean ascending)
Sorts the values in the given range
|
void |
IWorksheetStructure.unmerge(IRangeAddress range)
Unmerges the range of cells
|
Copyright © 2024. All rights reserved.