public class OCalcDoc.Sheet.CellRange extends OEnumPropObj
| Modifier and Type | Method and Description |
|---|---|
java.lang.String |
absoluteAddrRange()
Returns the absolute address range of the range, e.g., $F$2:$G$4.
|
void |
applyStyle(ORootDoc doc,
OStyle.Family family,
java.lang.String name)
Applies a style to the cell range.
|
OTable.Cell |
cellByPosition(int col,
int row)
Returns a cell by position.
|
java.lang.Object[][] |
cellContents()
Returns the array [][] of cell contents.
|
OTable.Cell[][] |
cells()
Returns the array [][] of cells from the range.
|
com.sun.star.table.XCellRange |
getXRange()
Gets the XCellRange object.
|
void |
logCellContents()
Lists the contents of the cell range to the log.
|
void |
merge()
Merge all cells in the range into one cell.
|
int |
numCols()
Returns the number of columns.
|
int |
numRows()
Returns the number of rows.
|
void |
putCellNumbers(java.lang.Double[][] values)
Puts an array of Double numbers into the range, one string per cell.
|
void |
putCellText(java.lang.String[][] values)
Puts an array of Strings into the range, one string per cell.
|
void |
putFormat(OTable.CellNumberFormat format)
Formats all cells in the range.
|
void |
putStyle(OStyle style) |
OCalcDoc.Sheet.CellRange |
subRangeByPosition(int left,
int top,
int right,
int bottom)
Returns a sub range of the range.
|
prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, prop, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProp, setProplogProps, xGetPropSetpublic int numCols()
throws com.sun.star.uno.Exception
com.sun.star.uno.Exceptionpublic int numRows()
throws com.sun.star.uno.Exception
com.sun.star.uno.Exceptionpublic java.lang.String absoluteAddrRange()
throws com.sun.star.uno.Exception
com.sun.star.uno.Exceptionpublic OTable.Cell cellByPosition(int col, int row) throws com.sun.star.uno.Exception
col - the columnrow - the rowcom.sun.star.uno.Exceptionpublic OTable.Cell[][] cells() throws com.sun.star.uno.Exception
com.sun.star.uno.Exceptionpublic OCalcDoc.Sheet.CellRange subRangeByPosition(int left, int top, int right, int bottom) throws com.sun.star.uno.Exception
left - the number of the left columntop - the number of the top rowright - the number of the right columnbottom - the number of the bottom rowcom.sun.star.uno.Exceptionpublic java.lang.Object[][] cellContents()
throws com.sun.star.uno.Exception
com.sun.star.uno.Exceptionpublic void logCellContents()
throws com.sun.star.uno.Exception
com.sun.star.uno.Exceptionpublic void putFormat(OTable.CellNumberFormat format) throws com.sun.star.uno.Exception
format - the formatcom.sun.star.uno.Exceptionpublic void merge()
throws com.sun.star.uno.Exception
com.sun.star.uno.Exceptionpublic void putCellText(java.lang.String[][] values)
throws com.sun.star.uno.Exception
values - the stringscom.sun.star.uno.Exceptionpublic void putCellNumbers(java.lang.Double[][] values)
throws com.sun.star.uno.Exception
values - the Double numberscom.sun.star.uno.Exceptionpublic void putStyle(OStyle style) throws com.sun.star.uno.Exception
com.sun.star.uno.Exceptionpublic void applyStyle(ORootDoc doc, OStyle.Family family, java.lang.String name) throws com.sun.star.uno.Exception
doc - the document that has the stylefamily - the style familyname - the style namecom.sun.star.uno.Exceptionpublic com.sun.star.table.XCellRange getXRange()