Uses of Class
org.apache.poi.ss.util.CellAddress

Packages that use CellAddress

Package	Description
org.apache.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.ss.usermodel
org.apache.poi.ss.util
org.apache.poi.xssf.binary	The org.apache.poi.xssf.binary package includes necessary underlying components for streaming/read-only processing of xlsb files.
org.apache.poi.xssf.model
org.apache.poi.xssf.streaming
org.apache.poi.xssf.usermodel

Uses of CellAddress in org.apache.poi.hssf.usermodel

Methods in org.apache.poi.hssf.usermodel that return CellAddress

Modifier and Type	Method and Description
CellAddress	HSSFSheet.getActiveCell() Return location of the active cell, e.g.
CellAddress	HSSFCell.getAddress() Gets the address of this cell
CellAddress	HSSFComment.getAddress()

Methods in org.apache.poi.hssf.usermodel that return types with arguments of type CellAddress

Modifier and Type	Method and Description
java.util.Map<CellAddress,HSSFComment>	HSSFSheet.getCellComments() Returns all cell comments on this sheet.

Methods in org.apache.poi.hssf.usermodel with parameters of type CellAddress

Modifier and Type	Method and Description
HSSFComment	HSSFSheet.getCellComment(CellAddress ref) Returns cell comment for the specified row and column
HSSFHyperlink	HSSFSheet.getHyperlink(CellAddress addr) Get a Hyperlink in this sheet located in a cell specified by {code addr}
void	HSSFSheet.setActiveCell(CellAddress address) Sets location of the active cell
void	HSSFComment.setAddress(CellAddress address)

Uses of CellAddress in org.apache.poi.ss.usermodel

Methods in org.apache.poi.ss.usermodel that return CellAddress

Modifier and Type	Method and Description
CellAddress	Sheet.getActiveCell() Return location of the active cell, e.g.
CellAddress	Comment.getAddress() Get the address of the cell that this comment is attached to
CellAddress	Cell.getAddress() Gets the address of this cell

Methods in org.apache.poi.ss.usermodel that return types with arguments of type CellAddress

Modifier and Type	Method and Description
java.util.Map<CellAddress,? extends Comment>	Sheet.getCellComments() Returns all cell comments on this sheet.

Methods in org.apache.poi.ss.usermodel with parameters of type CellAddress

Modifier and Type	Method and Description
Comment	Sheet.getCellComment(CellAddress ref) Returns cell comment for the specified location
Hyperlink	Sheet.getHyperlink(CellAddress addr) Get a Hyperlink in this sheet located in a cell specified by {code addr}
void	Sheet.setActiveCell(CellAddress address) Sets location of the active cell
void	Comment.setAddress(CellAddress addr) Set the address of the cell that this comment is attached to

Uses of CellAddress in org.apache.poi.ss.util

Fields in org.apache.poi.ss.util declared as CellAddress

Modifier and Type	Field and Description
static CellAddress	CellAddress.A1 A constant for references to the first cell in a sheet.

Methods in org.apache.poi.ss.util that return types with arguments of type CellAddress

Modifier and Type	Method and Description
java.util.Iterator<CellAddress>	CellRangeAddressBase.iterator() Returns an iterator over the CellAddresses in this cell range in row-major order.

Methods in org.apache.poi.ss.util with parameters of type CellAddress

Modifier and Type	Method and Description
int	CellAddress.compareTo(CellAddress other) Compare this CellAddress using the "natural" row-major, column-minor ordering.
BorderStyle	PropertyTemplate.getBorderStyle(CellAddress cell, java.lang.String property) Retrieves the border style for a given cell
int	PropertyTemplate.getNumBorderColors(CellAddress cell) Retrieves the number of border colors assigned to a cell
int	PropertyTemplate.getNumBorders(CellAddress cell) Retrieves the number of borders assigned to a cell
short	PropertyTemplate.getTemplateProperty(CellAddress cell, java.lang.String property) Retrieves the border style for a given cell
boolean	CellRangeAddressBase.isInRange(CellAddress ref) Determines if the given CellAddress lies within the bounds of this range.

Constructors in org.apache.poi.ss.util with parameters of type CellAddress

Constructor and Description
CellAddress(CellAddress address) Create a new CellAddress object

Uses of CellAddress in org.apache.poi.xssf.binary

Methods in org.apache.poi.xssf.binary that return types with arguments of type CellAddress

Modifier and Type	Method and Description
java.util.Queue<CellAddress>	XSSFBCommentsTable.getAddresses()
java.util.Map<CellAddress,java.util.List<XSSFHyperlinkRecord>>	XSSFBHyperlinksTable.getHyperLinks()

Methods in org.apache.poi.xssf.binary with parameters of type CellAddress

Modifier and Type	Method and Description
java.util.List<XSSFHyperlinkRecord>	XSSFBHyperlinksTable.findHyperlinkRecord(CellAddress cellAddress)
org.apache.poi.xssf.binary.XSSFBComment	XSSFBCommentsTable.get(CellAddress cellAddress)

Uses of CellAddress in org.apache.poi.xssf.model

Methods in org.apache.poi.xssf.model that return types with arguments of type CellAddress

Modifier and Type	Method and Description
java.util.Iterator<CellAddress>	Comments.getCellAddresses() Returns all cell addresses that have comments.
java.util.Iterator<CellAddress>	CommentsTable.getCellAddresses() Returns all cell addresses that have comments.
java.util.Map<CellAddress,XSSFComment>	CommentsTable.getCellComments() Deprecated. use getCellAddresses instead

Methods in org.apache.poi.xssf.model with parameters of type CellAddress

Modifier and Type	Method and Description
XSSFComment	Comments.findCellComment(CellAddress cellAddress) Finds the cell comment at cellAddress, if one exists
XSSFComment	CommentsTable.findCellComment(CellAddress cellAddress) Finds the cell comment at cellAddress, if one exists
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTComment	CommentsTable.getCTComment(CellAddress cellRef) Get the underlying CTComment xmlbean for a comment located at cellRef, if it exists
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTComment	CommentsTable.newComment(CellAddress ref) Create a new comment located` at cell address
void	CommentsTable.referenceUpdated(CellAddress oldReference, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTComment comment) Called after the reference is updated, so that we can reflect that in our cache
boolean	Comments.removeComment(CellAddress cellRef) Remove the comment at cellRef location, if one exists
boolean	CommentsTable.removeComment(CellAddress cellRef) Remove the comment at cellRef location, if one exists

Uses of CellAddress in org.apache.poi.xssf.streaming

Methods in org.apache.poi.xssf.streaming that return CellAddress

Modifier and Type	Method and Description
CellAddress	SXSSFSheet.getActiveCell() Return location of the active cell, e.g.
CellAddress	SXSSFCell.getAddress() Gets the address of this cell

Methods in org.apache.poi.xssf.streaming that return types with arguments of type CellAddress

Modifier and Type	Method and Description
java.util.Map<CellAddress,XSSFComment>	SXSSFSheet.getCellComments() Returns all cell comments on this sheet.

Methods in org.apache.poi.xssf.streaming with parameters of type CellAddress

Modifier and Type	Method and Description
XSSFComment	SXSSFSheet.getCellComment(CellAddress ref) Returns cell comment for the specified row and column
XSSFHyperlink	SXSSFSheet.getHyperlink(CellAddress addr) Get a Hyperlink in this sheet located in a cell specified by {code addr}
void	SXSSFSheet.setActiveCell(CellAddress address) Sets location of the active cell

Uses of CellAddress in org.apache.poi.xssf.usermodel

Methods in org.apache.poi.xssf.usermodel that return CellAddress

Modifier and Type	Method and Description
CellAddress	XSSFSheet.getActiveCell() Return location of the active cell, e.g.
CellAddress	XSSFComment.getAddress()
CellAddress	XSSFCell.getAddress() Gets the address of this cell

Methods in org.apache.poi.xssf.usermodel that return types with arguments of type CellAddress

Modifier and Type	Method and Description
java.util.Map<CellAddress,XSSFComment>	XSSFSheet.getCellComments() Returns all cell comments on this sheet.

Methods in org.apache.poi.xssf.usermodel with parameters of type CellAddress

Modifier and Type	Method and Description
XSSFComment	XSSFSheet.getCellComment(CellAddress address) Return cell comment at row, column, if one exists.
XSSFHyperlink	XSSFSheet.getHyperlink(CellAddress addr) Get a Hyperlink in this sheet located in a cell specified by {code addr}
void	XSSFSheet.setActiveCell(CellAddress address) Sets location of the active cell
void	XSSFComment.setAddress(CellAddress address)