public interface IRangeAddressBuilder
IRangeAddress
instances according to the given settings
The address consists of 4 values: top row, left column, bottom row and right column numbers
Note, that in the address of a single cell the numbers of the top and bottom row as well as the numbers of the left and right column coincide (are identical)
By the default all values (column and row numbers) are set to "1"
Modifier and Type | Method and Description |
---|---|
IRangeAddress |
buildCell()
Builds the address of a single cell
|
IRangeAddress |
buildRange()
Builds the address of a single cell or a range of cells according to the given settings
|
IRangeAddressBuilder |
from(IRangeAddress source)
Copies the existing address
|
IRangeAddressBuilder |
fromA1String(String source)
Parses the A1-like address and sets the result
|
IRangeAddressBuilder |
incBottomRight(int delta)
Adds a delta value to the bottom row and to the right column values
|
IRangeAddressBuilder |
incBottomRight(int deltaRow,
int deltaColumn)
Adds a deltaRow value to the bottom row value and a deltaColumn value to the right column value
|
IRangeAddressBuilder |
incBottomRow(int delta)
Adds a delta value to the bottom row value
|
IRangeAddressBuilder |
incLeftColumn(int delta)
Adds a delta value to the left column value
|
IRangeAddressBuilder |
incRightColumn(int delta)
Adds a delta value to the right column value
|
IRangeAddressBuilder |
incTopLeft(int delta)
Adds a delta value to the top row and to the left column values
|
IRangeAddressBuilder |
incTopLeft(int deltaRow,
int deltaColumn)
Adds a deltaRow value to the top row value and a deltaColumn value to the left column value
|
IRangeAddressBuilder |
incTopRow(int delta)
Adds a delta value to the top row value
|
static IRangeAddressBuilder |
resolve(IScellApiResolver resolver)
Resolves a new instance of
IRangeAddressBuilder with the given resolver |
IRangeAddressBuilder |
setBottomRight(int rowNumber,
int columnNumber)
Sets the bottom right cell for a range address
|
IRangeAddressBuilder |
setBottomRow(int rowNumber)
Sets the bottom row for a range address
|
IRangeAddressBuilder |
setLeftColumn(int columnNumber)
Sets the left column for a single sell address or a range address
|
IRangeAddressBuilder |
setRightColumn(int columnNumber)
Sets the right column for a range address
|
IRangeAddressBuilder |
setTopLeft(int rowNumber,
int columnNumber)
Sets a single cell address or the top left cell for a range address
|
IRangeAddressBuilder |
setTopRow(int rowNumber)
Sets the top row for a single cell address or a range address
|
IRangeAddressBuilder |
setWholeColumns(int from,
int to)
Sets the range address of the selected number of columns taken as a whole,
i.e.
|
IRangeAddressBuilder |
setWholeRows(int from,
int to)
Sets the range address of the selected number of rows taken as a whole,
i.e.
|
static IRangeAddressBuilder resolve(IScellApiResolver resolver)
IRangeAddressBuilder
with the given resolverresolver
- the given resolverIRangeAddressBuilder
IRangeAddress buildCell()
IRangeAddress
IRangeAddress buildRange()
IRangeAddress
IRangeAddressBuilder from(IRangeAddress source)
source
- the address to be copiedIRangeAddress
IRangeAddressBuilder fromA1String(String source)
source
- the string to be parsedIRangeAddressBuilder
if the process of parsing was successful,
otherwise returns the Optional.empty()
IRangeAddressBuilder setTopLeft(int rowNumber, int columnNumber)
rowNumber
- the row number of the top left cell (starts from 1)columnNumber
- the column number of the top left cell (starts from 1)IRangeAddressBuilder setBottomRight(int rowNumber, int columnNumber)
rowNumber
- the row number of the bottom right cell (starts from 1)columnNumber
- the column number of bottom right cell (starts from 1)IRangeAddressBuilder setTopRow(int rowNumber)
rowNumber
- the number of the row (starts from 1)IRangeAddressBuilder setWholeRows(int from, int to)
Sets the range address from topRow to bottomRow
The left column value is set to the minimal column number (the left boundary of the spreadsheet)
The right column value is set to the maximal column number (the right boundary of the spreadsheet)
from
- the top row index, inclusiveto
- the bottom row index, inclusiveIRangeAddressBuilder setWholeColumns(int from, int to)
Sets the range address from leftColumn to rightColumn
The top row value is set to the minimal row number (the top of the spreadsheet)
The bottom row value is set to the maximal row number (the bottom of the spreadsheet)
from
- the left column index, inclusiveto
- the right column index, inclusiveIRangeAddressBuilder setLeftColumn(int columnNumber)
columnNumber
- the number of the column (starts from 1)IRangeAddressBuilder setBottomRow(int rowNumber)
rowNumber
- the row number (starts from 1)IRangeAddressBuilder setRightColumn(int columnNumber)
columnNumber
- the column number (starts from 1)IRangeAddressBuilder incTopRow(int delta)
delta
- the value to be addedIRangeAddressBuilder incLeftColumn(int delta)
delta
- the value to be addedIRangeAddressBuilder incBottomRow(int delta)
delta
- the value to be addedIRangeAddressBuilder incRightColumn(int delta)
delta
- the value to be addedIRangeAddressBuilder incTopLeft(int delta)
delta
- the value to be addedIRangeAddressBuilder incTopLeft(int deltaRow, int deltaColumn)
deltaRow
- the value to be added to the top row valuedeltaColumn
- the value to be added to the left column valueIRangeAddressBuilder incBottomRight(int delta)
delta
- the value to be addedIRangeAddressBuilder incBottomRight(int deltaRow, int deltaColumn)
deltaRow
- the value to be added to the row valuedeltaColumn
- the value to be added to the column valueCopyright © 2024. All rights reserved.