Home
last modified time | relevance | path

Searched refs:cell (Results 1 – 25 of 363) sorted by relevance

12345678910>>...15

/trunk/main/offapi/com/sun/star/sheet/
H A DXCellRangesQuery.idl49 /** provides methods to query for cell ranges with specific contents.
51 <p>All methods return a collection of cell ranges.</p>
63 the visible (not hidden) cells of the current cell range(s).
72 the empty cells of the current cell range(s).
88 all cells of the current cell range(s) with the specified
102 all formula cells of the current cell range(s) with the
112 <p>This method takes each column of the current cell range(s) and
113 compares all cells with the cell in the specified row. All cells
114 which are different to this comparison cell will be returned.</p>
117 contains a cell address with the row index used for comparison.
[all …]
H A DXSheetAuditing.idl48 /** removes arrows for one level of dependents of a formula cell.
50 <p>If the method is executed again for the same cell, the previous
54 the address of the formula cell.
60 /** removes arrows for one level of precedents of a formula cell.
62 <p>If the method is executed again for the same cell, the previous
66 the address of the formula cell.
72 /** draws arrows between a formula cell and its dependents.
74 <p>If the method is executed again for the same cell, the next
78 the address of the formula cell.
84 /** draws arrows between a formula cell and its precedents.
[all …]
H A DXDataPilotTable2.idl68 /** When the address of a cell within the result area is given,
71 that cell.
73 @param aAddr cell address within the result area of a DataPilot table.
81 /** Given a cell address, it returns the information about that cell. The
82 type of information returned depends upon whether the cell is within
85 @param aAddr address of the cell whose information is to be returned.
88 position type and the information for that cell position.
97 specified result cell. A drill-down data for a result cell consists
99 the value displayed in that cell.</p>
105 @param aAddr address of a result cell
H A DTableAutoFormatField.idl69 /** represents a field in an AutoFormat. A field contains all cell
225 /** contains the cell background color.
231 /** is <TRUE/> if the cell background is transparent.
246 /** specifies the horizontal alignment of the cell contents.
252 /** specifies the vertical alignment of the cell contents.
258 /** is <TRUE/> if text breaks automatically at cell borders.
264 /** contains the orientation of the cell contents
271 /** contains the rotation angle of the cell contents.
277 /** contains the reference egde of the cell rotation.
283 /** contains the margin between cell contents and top border
[all …]
H A DSheetCellRange.idl173 /** provides basic handling of cell ranges and contributes common cell
221 /** provides merging and unmerging the cells of this cell range.
227 /** provides modifying the cell indentation.
239 /** provides applying an AutoFormat to the cell range.
245 /** provides access to the spreadsheet that contains this cell range.
265 /** provides access to the cell range address of this range.
278 /** provides filling out the cell range automatically with values based
324 /** provide access to a collection of equal-formatted cell ranges.
330 /** provide access to a collection of equal-formatted cell ranges.
337 it possible to learn about changes in the cell values.
[all …]
H A DSheetCell.idl124 /** represents a single addressable cell in a spreadsheet document.
130 /** provides basic cell handling and contributes common cell
204 /** provides modifying the cell indentation.
216 /** provides access to the cell address of this cell.
222 /** provides access to the annotation attached to this cell.
228 /** provides access to the text fields used in this cell.
250 /** contains the position of this cell in the sheet (in 1/100 mm).
259 /** contains the size of this cell (in 1/100 mm).
281 /** contains the conditional formatting settings for this cell.
293 /** contains the conditional formatting settings for this cell,
[all …]
H A DXCellRangesAccess.idl61 /** Returns a single cell within the range.
64 is the column index of the cell inside the sheet.
67 is the row index of the cell inside the sheet.
73 the specified cell.
91 is the column index of the first cell inside the range.
94 is the row index of the first cell inside the range.
97 is the column index of the last cell inside the range.
100 is the row index of the last cell inside the range.
106 the specified cell range.
127 names may be "Sheet1.A1:C5" or "$Sheet1.$B$2" or even defined names for cell ranges
[all …]
H A DXCellRangeMovement.idl64 the cell range in which empty cells will be inserted.
78 the cell range to remove.
89 /** moves a cell range to another position in the document.
91 <p>After copying the contents of the cell range, all cells
95 the address of the top left cell of the destination range.
98 the cell range which will be copied.
106 /** copies a cell range to another position in the document.
108 <p>The source cell range keeps unchanged.</p>
111 the address of the top left cell of the destination range.
114 the cell range which will be copied.
H A DXConsolidationDescriptor.idl71 /** returns the cell ranges which are consolidated.
77 /** sets the cell ranges which are consolidated.
84 /** returns the position of the top left cell of the cell range where
91 /** sets the position of the top left cell of the cell range
99 /** returns, whether column headers from the cell ranges are used to
106 /** specifies if column headers from the cell ranges are used to find
113 /** returns, whether row headers from the cell ranges are used to
120 /** specifies if row headers from the cell ranges are used to find
H A DSheetCellRanges.idl96 /** represents a collection of cell ranges in a spreadsheet document.
104 /** contributes common cell formatting properties.
151 /** provides modifying the cell indentation.
165 it possible to learn about changes in the cell values.
171 /** provides methods to access cell ranges via index and to add and
172 remove cell ranges.
178 /** creates an enumeration of all cell ranges.
186 /** provides access of the cell ranges via an user-defined name.
195 /** contains the conditional formatting settings for this cell.
207 /** contains the conditional formatting settings for this cell,
[all …]
H A DAccessibleCell.idl56 /** This interface gives access to the whole content of the cell.
68 <li>There are relations between the cell and the shapes with an anchor
69 on this cell.</li>
76 >AccessibleStateType::EDITABLE</const> is false if the cell
86 >AccessibleStateType::OPAQUE</const> is false if the cell
97 cell is selected.</li>
106 column/row with this cell is filtered or hidden.
114 /** This interface gives access to the visibility of the cell.
118 /** This interface gives access to the value of the cell.
122 /** This interface gives access to the text representation of the cell content.
H A DXNamedRanges.idl68 <p>A cell range address is one possible content of a named
72 specifies the base address for relative cell references.
88 /** creates named cell ranges from titles in a cell range.
99 name of the first is equal to the content of cell A1 and contains the
100 range $Sheet.$A$2:$A$3 (excluding the title cell). The latter named
101 range is named using cell B1 and contains the cell range address
105 the cell range used to create the named ranges.
128 specifies the top left cell of the output range.
H A DXExternalSheetCache.idl39 /** It sets a cached value for a specified cell position. The value is expected
45 @param aValue cell value to be cached
50 /** It retrieves a cached value from a specified cell position. The cached
53 @return any cached cell value
58 /** It returns a list of all row numbers where a cached cell or cells exist.
61 @return sequence<long> list of all row numbers with cached cell(s)
66 that store cached cell values in that row. The column numbers are
69 @return sequence<long> list of all columns numbers with cached cell values
/trunk/main/offapi/com/sun/star/table/
H A DXCell.idl41 /** provides methods to access the contents of a cell in a table.
49 /** returns the formula string of a cell.
51 <p>Even if the cell does not contain a formula, an assignment of
52 this attribute's value to another cell's formula attribute would
53 create the same cell content. This is because this attribute contains
54 the original text value of a string cell. The value of a
55 <em>value cell</em> will be formatted using the number format's
57 cell.</p>
63 /** sets a formula into the cell.
66 or formula cell is created, depending on the text and the number
[all …]
H A DCellProperties.idl73 /** contains the properties of a table cell.
89 /** contains the name of the style of the cell.
95 /** contains the cell background color.
101 /** is <TRUE/>, if the cell background is transparent.
110 /** contains the horizontal alignment of the cell contents.
116 /** contains the vertical alignment of the cell contents.
129 /** defines the indentation of the cell contents (in 1/100 mm).
135 /** contains the orientation of the cell contents.
169 /** contains a description of the cell or cell range border.
171 <p>If used with a cell range, the top, left, right, and bottom
[all …]
H A DAccessibleCellView.idl57 /** The accessible view of a cell in a text document or in the page preview
65 /** This interface gives access to the visible content of a cell in a
81 fragment that is contained in the cell and
89 <li>For spreadsheets, there are relations between the cell and the
90 shapes with an anchor on this cell.</li>
95 cell is showed, otherwise it is true.</li>
97 >AccessibleStateType::EDITABLE</const> is false if the cell
98 is showed in a page preview or the cell or the table is
106 >AccessibleStateType::OPAQUE</const> is false if the cell
110 cell is not showed in a page preview, otherwise is it
[all …]
H A DXCellRange.idl45 /** provides access to the cells or to sub-ranges of a cell range.
53 /** Returns a single cell within the range.
56 is the column index of the cell inside the range.
59 is the row index of the cell inside the range.
62 the specified cell.
79 is the column index of the first cell inside the range.
82 is the row index of the first cell inside the range.
85 is the column index of the last cell inside the range.
88 is the row index of the last cell inside the range.
91 the specified cell range.
[all …]
/trunk/main/xmerge/java/pexcel/src/main/java/org/openoffice/xmerge/converter/xml/sxc/pexcel/
H A DPocketExcelDecoder.java51 private CellValue cell; field in PocketExcelDecoder
184 maxRows = Math.max(maxRows, cell.getRow()); in setWorksheet()
185 maxCols = Math.max(maxCols, cell.getCol()); in setWorksheet()
221 cell = (CellValue) cellValue.nextElement(); in goToNextCell()
222 Debug.log(Debug.TRACE,"Current Cell : " + cell.getString()); in goToNextCell()
243 if (cell != null) { in getRowNumber()
244 row = cell.getRow(); in getRowNumber()
279 if (cell != null) { in getColNumber()
280 col = cell.getCol(); in getColNumber()
296 if (cell != null) { in getCellContents()
[all …]
/trunk/main/xmerge/java/pexcel/src/main/java/org/openoffice/xmerge/converter/xml/sxc/pexcel/records/formula/
H A DFormulaParser.java366 String cell = getTokenString(); in ident() local
368 Debug.log(Debug.TRACE,"Found Function : " + cell); in ident()
376 tokenVector.insertElementAt(tokenFactory.getFunctionToken(cell, numArgs), index); in ident()
379 if(cell.indexOf('.')!=-1) { in ident()
380 String cellRef = cell.substring(cell.indexOf('.') + 1, cell.length()); in ident()
382 tokenVector.add(tokenFactory.getOperandToken(cell, "3D_CELL_AREA_REFERENCE")); in ident()
384 tokenVector.add(tokenFactory.getOperandToken(cell, "3D_CELL_REFERENCE")); in ident()
386 } else if(cell.indexOf(':')!=-1) { in ident()
387 tokenVector.add(tokenFactory.getOperandToken(cell, "CELL_AREA_REFERENCE")); in ident()
388 } else if(isCellRef(cell)) { in ident()
[all …]
/trunk/main/offapi/com/sun/star/text/
H A DXTextTableCursor.idl49 the name of the cell range that is selected by this cursor.
50 <p>The name is the cell name of the top left table cell of the range
51 … contatenated by ':' with the table cell name of the bottom left table cell of the cell range.
52 … If the range consists of one table cell only then the name of that table cell is returned.
60 /** moves the cursor to the cell with the specified name.
63 specifies the name of the cell to go to.
114 /** moves the cursor to the bottom neighbor cell.
127 /** moves the cursor to the top left cell of the table.
136 /** moves the cursor to the bottom right cell of the table.
157 for each cell contained in the range.
/trunk/main/xmerge/source/minicalc/java/org/openoffice/xmerge/converter/xml/sxc/minicalc/
H A DMinicalcDecoder.java66 private CellDescriptor cell = null; field in MinicalcDecoder
223 maxRows = Math.max(maxRows, cell.getRowNumber()); in setWorksheet()
224 maxCols = Math.max(maxCols, cell.getColNumber()); in setWorksheet()
271 cell = ws.getNextCell(); in goToNextCell()
273 if (cell != null) { in goToNextCell()
303 if (cell != null) { in getRowNumber()
305 row = cell.getRowNumber(); in getRowNumber()
341 if (cell != null) { in getColNumber()
343 col = cell.getColNumber(); in getColNumber()
360 if (cell != null) { in getCellContents()
[all …]
/trunk/main/qadevOOo/java/OOoRunner/src/main/java/ifc/sheet/
H A D_XMultipleOperation.java65 XCell cell = null; in _setTableOperation() local
69 cell = oSheet.getCellByPosition(0, 16); in _setTableOperation()
70 cell.setFormula("=a15+a16"); in _setTableOperation()
71 cell = oSheet.getCellByPosition(0, 14); in _setTableOperation()
78 XCellAddressable.class, cell); in _setTableOperation()
128 XCell cell = null; in fillCells() local
132 cell = oSheet.getCellByPosition(0, k); in fillCells()
133 cell.setValue(k * 12); in fillCells()
134 cell = oSheet.getCellByPosition(k, 0); in fillCells()
135 cell.setValue(k * 5); in fillCells()
H A D_XNamedRanges.java135 XCell cell = null; in _addNewFromTitles() local
139 cell = oSheet.getCellByPosition(0, i); in _addNewFromTitles()
141 queryInterface(XTextRange.class, cell); in _addNewFromTitles()
144 cell = oSheet.getCellByPosition(i, 0); in _addNewFromTitles()
146 queryInterface(XTextRange.class, cell); in _addNewFromTitles()
152 cell = oSheet.getCellByPosition(i, j); in _addNewFromTitles()
154 queryInterface(XTextRange.class, cell); in _addNewFromTitles()
238 XCell cell = oSheet.getCellByPosition(0, i); in _outputList() local
240 UnoRuntime.queryInterface(XTextRange.class, cell); in _outputList()
/trunk/main/forms/qa/integration/forms/
H A DCellBinding.java407 XCellRangeData cell = (XCellRangeData)UnoRuntime.queryInterface( XCellRangeData.class, in verifyVoidCell() local
410 Object cellContent = cell.getDataArray()[0][0]; in verifyVoidCell()
424 XCell cell = (XCell)UnoRuntime.queryInterface( XCell.class, in verifyNumericCellContent() local
427 if ( cell.getValue() != value ) in verifyNumericCellContent()
440 XTextRange cell = (XTextRange)UnoRuntime.queryInterface( XTextRange.class, in verifyStringCellContent() local
443 if ( !cell.getString().equals( text ) ) in verifyStringCellContent()
456 XTextRange cell = (XTextRange)UnoRuntime.queryInterface( XTextRange.class, in setCellText() local
459 cell.setString( text ); in setCellText()
467 XCell cell = (XCell)UnoRuntime.queryInterface( XCell.class, in setCellValue() local
470 cell.setValue( value ); in setCellValue()
[all …]
/trunk/main/offapi/com/sun/star/accessibility/
H A DXAccessibleTable.idl45 cell-clusters of a table have to be at the same time children of the
127 <p>The result differs from 1 if the specified cell spans multiple
139 Returns the row extent of the specified cell.
152 <p>The result differs from 1 if the specified cell spans multiple
266 The row index for which to retrieve the cell.
269 The column index for which to retrieve the cell.
274 requested cell regardless of whether the cell is currently
306 Row index of the cell for which to determine if the accessible
307 object that spans that cell is selected.
310 Column index of the cell for which to determine if the
[all …]

12345678910>>...15