Home
last modified time | relevance | path

Searched refs:cells (Results 1 – 25 of 222) sorted by relevance

123456789

/aoo42x/main/offapi/com/sun/star/sheet/
H A DXCellRangesQuery.idl60 /** queries all visible cells.
63 the visible (not hidden) cells of the current cell range(s).
69 /** queries all empty cells.
72 the empty cells of the current cell range(s).
78 /** queries all cells with the specified content type(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
113 compares all cells with the cell in the specified row. All cells
121 all cells of the current cell range(s) which are different
132 compares all cells with the cell in the specified column. All cells
[all …]
H A DXFormulaQuery.idl41 /** provides methods to query cells for dependencies
53 /** queries all dependent formula cells.
55 <p>Dependent cells are cells containing formulas with references to
59 <FALSE/> = queries cells dependent from the original range(s),
60 <TRUE/> = repeates query with all found cells
64 all dependent cells of any formula cell of the current
72 /** queries all precedent cells.
74 <p>Precedent cells are cells which are referenced from a formula
78 <FALSE/> = queries precedent cells of the original range(s),
79 <TRUE/> = repeates query with all found cells
[all …]
H A DCellDeleteMode.idl33 /** is used to specify how remaining cells are moved when cells are deleted.
39 /** no cells are moved.
45 /** the cells below the deleted cells are moved up.
51 /** the cells to the right of the deleted cells are moved left.
57 /** entire rows below the deleted cells are moved up.
63 /** entire columns to the right of the deleted cells are moved left.
H A DCellInsertMode.idl33 /** is used to specify how cells are moved when new cells are inserted.
39 /** no cells are moved.
45 /** the cells below the inserted cells are moved down.
51 /** the cells to the right of the inserted cells are moved right.
57 /** entire rows below the inserted cells are moved down.
63 /** entire columns to the right of the inserted cells are moved right.
H A DXCellRangeMovement.idl53 /** provides methods for moving ranges of cells in a sheet.
59 /** inserts cells, moving other cells down or right.
61 <p>Non-empty cells cannot be moved off the sheet.</p>
64 the cell range in which empty cells will be inserted.
67 describes how to move existing cells.
75 /** deletes cells, moving other cells up or left.
81 describes how to move following cells.
91 <p>After copying the contents of the cell range, all cells
H A DFillMode.idl33 /** used to specify the series type used to fill cells.
41 <p>All cells are filled with the same value.</p>
49 <p>Cell by cell, the value used to fill the cells is increased
58 <p>Cell by cell, the value used to fill the cells is multiplied
67 <p>Cell by cell, the value used to fill the cells is increased
78 <p>The cells are filled using a user-defined series.</p>
H A DXSheetAuditing.idl51 level of dependent cells is removed.</p>
63 level of dependent cells is removed.</p>
75 level of dependent cells is marked.</p>
87 level of dependent cells is marked.</p>
97 and the cells causing the error.
103 /** marks all cells containing invalid values.
H A DSheetCellRange.idl164 /** represents a rectangular range of cells in a spreadsheet document.
204 /** provides interfaces to find cells with specific properties.
215 spreadsheet searches for cells containing the serch text only.</p>
221 /** provides merging and unmerging the cells of this cell range.
251 /** provides simultaneous access to the contents of all cells.
257 /** provides simultaneous access to the formula contents of all cells.
272 cells of this range and to clear specific cells.
336 /** provides modifying the source data cells of a chart and makes
H A DXSheetCellCursor.idl46 /** expands the cursor into the region containing the cells to which
49 <p>A region is a cell range bounded by empty cells.</p>
70 If the cursor does not point to any range with merged cells, it
77 /** expands the cursor to include the entire columns of the cells
84 /** expands the cursor to include the entire rows of the cells to
H A DCellFlags.idl99 /** selects cells with formatting within the cells or cells with more than
100 one paragraph within the cells.
/aoo42x/main/vcl/aqua/source/a11y/
H A Daqua11ytablewrapper.mm43 NSMutableArray * cells = [ [ NSMutableArray alloc ] init ];
60 [ cells addObject: cell_wrapper ];
86 // create an array containing the visible cells
95 [ cells addObject: cell_wrapper ];
102 pResult = NSAccessibilityUnignoredChildren( cells );
107 [cells autorelease];
152 [ cells addObject: cell_wrapper ];
156 pResult = NSAccessibilityUnignoredChildren( cells );
162 [ cells autorelease ];
191 [ cells addObject: cell_wrapper ];
[all …]
/aoo42x/test/testuno/source/fvt/uno/sc/cell/
H A DCellEffectOverline.java166 XCell[] cells = new XCell[cellNum]; in testCharOverline() local
175 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCharOverline()
178 cells[0].setValue(inputColor); in testCharOverline()
179 SCUtil.setTextToCell(cells[1], inputType[0]); in testCharOverline()
180 cells[2].setFormula("=10/0"); in testCharOverline()
181 cells[3].setValue(-0.0000001); in testCharOverline()
184 SCUtil.setCellProperties(cells[i], inputType[0], inputStyle); in testCharOverline()
186 SCUtil.setCellProperties(cells[i], inputType[1], true); in testCharOverline()
187 SCUtil.setCellProperties(cells[i], inputType[2], inputColor); in testCharOverline()
196 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCharOverline()
[all …]
H A DCellEffectUnderline.java165 XCell[] cells = new XCell[cellNum]; in testCharUnderline() local
174 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCharUnderline()
177 cells[0].setValue(inputColor); in testCharUnderline()
178 SCUtil.setTextToCell(cells[1], inputType[0]); in testCharUnderline()
179 cells[2].setFormula("=\"ABC\""); in testCharUnderline()
180 cells[3].setValue(-0.90000001); in testCharUnderline()
183 SCUtil.setCellProperties(cells[i], inputType[0], inputStyle); in testCharUnderline()
185 SCUtil.setCellProperties(cells[i], inputType[1], true); in testCharUnderline()
186 SCUtil.setCellProperties(cells[i], inputType[2], inputColor); in testCharUnderline()
195 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCharUnderline()
[all …]
H A DCellFontSize.java129 XCell[] cells = new XCell[cellNum]; in testCellFontSize() local
136 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCellFontSize()
139 cells[0].setValue(inputData[0]); in testCellFontSize()
140 SCUtil. setTextToCell(cells[1], inputType); in testCellFontSize()
141 cells[2].setFormula("=TRUE()"); in testCellFontSize()
142 cells[3].setValue(-0.000999999); in testCellFontSize()
145 SCUtil.setCellProperties(cells[i], inputType, inputData[i]); in testCellFontSize()
153 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCellFontSize()
154 results[i] = ((Float) SCUtil.getCellProperties(cells[i], inputType)).floatValue(); in testCellFontSize()
H A DCellColor.java135 XCell[] cells = new XCell[cellNum]; in testCellColor() local
142 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCellColor()
145 cells[0].setValue(inputData[0]); in testCellColor()
146 SCUtil. setTextToCell(cells[1], inputType); in testCellColor()
147 cells[2].setFormula("=100*23/5"); in testCellColor()
148 cells[3].setValue(-0.0003424); in testCellColor()
151 SCUtil.setCellProperties(cells[i], inputType, inputData[i]); in testCellColor()
159 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCellColor()
160 results[i] = ((Integer) SCUtil.getCellProperties(cells[i], inputType)).intValue(); in testCellColor()
H A DCellProtected.java140 XCell[] cells = new XCell[cellNum]; in testCellProtected() local
147 cells[i] = sheet.getCellByPosition(cInfo.getCol() + i, cInfo.getRow()); in testCellProtected()
150 cells[0].setValue(2134359.343223); in testCellProtected()
151 SCUtil. setTextToCell(cells[1], inputType); in testCellProtected()
152 cells[2].setFormula("=Average(A1:A10)"); in testCellProtected()
153 cells[3].setValue(-0.0003424); in testCellProtected()
156 SCUtil.setCellProperties(cells[i], inputType, inputProtectProps); in testCellProtected()
164 cells[i] = sheet.getCellByPosition(cInfo.getCol() + i, cInfo.getRow()); in testCellProtected()
165 results[i] = (CellProtection) SCUtil.getCellProperties(cells[i], inputType); in testCellProtected()
H A DCellAlignment.java142 XCell[] cells = new XCell[cellNum]; in testCellAlignment() local
152 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCellAlignment()
155 cells[0].setValue(13.42); in testCellAlignment()
156 SCUtil. setTextToCell(cells[1], "alignment"); in testCellAlignment()
157 cells[2].setFormula("=SUM(A100:B100)"); in testCellAlignment()
158 cells[3].setValue(-0.2343123); in testCellAlignment()
161 SCUtil.setCellProperties(cells[i], inputType, inputValue); in testCellAlignment()
169 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCellAlignment()
170 results[i] = (Enum) SCUtil.getCellProperties(cells[i], inputType); in testCellAlignment()
H A DCellBorder.java180 XCell[] cells = new XCell[cellNum]; in testCellBorder() local
187 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCellBorder()
190 cells[0].setValue(borderLine.Color); in testCellBorder()
191 SCUtil. setTextToCell(cells[1], "all border"); in testCellBorder()
192 cells[2].setFormula("=2^6"); in testCellBorder()
193 cells[3].setValue(-0.1); in testCellBorder()
197 SCUtil.setCellProperties(cells[i], borderType[j], borderLine); in testCellBorder()
206 cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i); in testCellBorder()
208 results[i][j] = (BorderLine) SCUtil.getCellProperties(cells[i], borderType[j]); in testCellBorder()
/aoo42x/main/xmerge/java/pexcel/src/main/java/org/openoffice/xmerge/converter/xml/sxc/pexcel/records/
H A DWorksheet.java50 private Vector cells = new Vector(); field in Worksheet
88 for(Enumeration e = cells.elements();e.hasMoreElements();) { in write()
118 cells.add(bc); in read()
124 cells.add(fn); in read()
130 cells.add(lc); in read()
141 cells.add(f); in read()
218 return (cells.elements()); in getCellEnumerator()
228 cells.add(br); in addCell()
/aoo42x/main/offapi/com/sun/star/text/
H A DXTextTableCursor.idl37 … TextTableCursor provide methods to navigate throught the table structure, to merge and split cells
78 the number of cells to move.
91 the number of cells to move.
104 the number of cells to move.
117 the number of cells to move.
145 /** merges the selected range of cells.
153 /** splits the range of cells.
156 specifies the number of new cells that will be created
H A DTextTableCursor.idl60 <li>travel through text table cells</li>
61 <li>select text table cells</li>
62 <li>get property values from the selected cells</li>
63 <li>set property values in the selected cells</li>
/aoo42x/main/offapi/com/sun/star/accessibility/
H A DAccessibleTableModelChange.idl38 type. The range of the affected rows, columns, and/or cells can be
49 and/or columns or modified the content of a number of cells. See
58 modified cells.</p>
65 cells.</p>
72 cells.</p>
79 cells.</p>
/aoo42x/main/qadevOOo/tests/java/ifc/util/
H A D_XReplaceable.java70 XCell[] cells = new XCell[0]; in before() local
72 cells = new XCell[]{(XCell)o}; in before()
75 cells = (XCell[])o; in before()
81 for (int i=0; i<cells.length; i++) { in before()
82 cells[i].setFormula(mSearchString); in before()
H A D_XSearchable.java72 XCell[] cells = new XCell[0]; in before() local
74 cells = new XCell[]{(XCell)o}; in before()
77 cells = (XCell[])o; in before()
83 for (int i=0; i<cells.length; i++) { in before()
84 cells[i].setFormula(mSearchString); in before()
/aoo42x/main/offapi/com/sun/star/table/
H A DXTableChart.idl50 /** returns, whether the cells of the topmost row of the source data
57 /** specifies whether the cells of the topmost row of the source data
64 /** returns, whether the cells of the leftmost column of the source
71 /** specifies whether the cells of the leftmost column of the source

Completed in 61 milliseconds

123456789