Home
last modified time | relevance | path

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

12345678910>>...15

/trunk/main/offapi/com/sun/star/sheet/
H A DXCellRangesQuery.idl51 <p>All methods return a collection of cell ranges.</p>
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
121 all cells of the current cell range(s) which are different
122 to the comparison cell of each column.
136 contains a cell address with the column index used for
141 to the comparison cell of each row.
148 /** intersects the current cell range(s) with the specified cell range.
151 contains the cell range for intersection.
[all …]
H A DXSheetAuditing.idl48 /** removes arrows for one level of dependents of a formula cell.
54 the address of the formula cell.
60 /** removes arrows for one level of precedents of a formula cell.
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.
86 <p>If the method is executed again for the same cell, the next
90 the address of the formula cell.
[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.
265 /** provides access to the cell range address of this range.
337 it possible to learn about changes in the cell values.
356 /** contains the position of the top left cell of this range in
372 /** contains the conditional formatting settings for this cell.
384 /** contains the conditional formatting settings for this cell,
397 /** contains the data validation settings for this cell.
[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.
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,
306 /** contains the data validation 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.
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,
220 /** contains the data validation settings for this cell.
[all …]
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 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 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.idl49 /** returns the formula string of a cell.
54 the original text value of a string cell. The value of a
57 cell.</p>
63 /** sets a formula into the cell.
73 /** returns the floating point value of the cell.
75 <p>For a <em>value cell</em> the value is returned, for a
76 <em>string cell</em> zero is returned and for a <em>formula cell</em>
83 /** sets a floating point value into the cell.
85 <p>After a call to this method the type of the cell is
92 /** returns the type of the cell.
[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.
135 /** contains the orientation of the cell contents.
169 /** contains a description of the cell or cell range border.
173 the individual cell.</p>
219 /** contains a description of the cell protection.
[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>
98 is showed in a page preview or the cell or the table is
110 cell is not showed in a page preview, otherwise is it
131 /** This interface gives access to the visibility of the cell.
135 /** This interface gives access to the value of the cell.
[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
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()
298 contents = cell.getString(); in getCellContents()
356 if (cell != null) { in getCellValue()
358 contents = ((Formula)cell).getValue(); in getCellValue()
380 if(cell instanceof FloatNumber) in getCellDataType()
[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()
379 if(cell.indexOf('.')!=-1) { in ident()
380 String cellRef = cell.substring(cell.indexOf('.') + 1, cell.length()); in ident()
386 } else if(cell.indexOf(':')!=-1) { in ident()
388 } else if(isCellRef(cell)) { in ident()
389 tokenVector.add(tokenFactory.getOperandToken(cell, "CELL_REFERENCE")); in ident()
391 tokenVector.add(tokenFactory.getOperandToken(cell, "NAME")); in ident()
425 String cell = new String(); in getTokenString() local
428 cell += look; in getTokenString()
[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
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()
361 contents = cell.getCellContents(); in getCellContents()
576 if (cell != null) { in getCellFormatType()
[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
307 object that spans that cell is selected.
310 Column index of the cell for which to determine if the
311 accessible object that spans that cell is selected.
[all …]

Completed in 133 milliseconds

12345678910>>...15