Home
last modified time | relevance | path

Searched refs:getCellByPosition (Results 1 – 25 of 189) sorted by relevance

12345678

/aoo41x/main/qadevOOo/tests/java/ifc/sheet/
H A D_XCellRangeMovement.java69 oSheet.getCellByPosition(1,1).setValue(100); in _copyRange()
70 oSheet.getCellByPosition(1,2).setValue(200); in _copyRange()
71 oSheet.getCellByPosition(2,1).setValue(300); in _copyRange()
72 oSheet.getCellByPosition(2,2).setValue(400); in _copyRange()
121 oSheet.getCellByPosition(0,20).setValue(100); in _insertCells()
177 oSheet.getCellByPosition(4,0).setValue(111); in _moveRange()
178 oSheet.getCellByPosition(4,1).setValue(222); in _moveRange()
190 oSheet.getCellByPosition(4,4).setValue(0); in _moveRange()
191 oSheet.getCellByPosition(4,5).setValue(0); in _moveRange()
231 oSheet.getCellByPosition(5, 0).setValue(0); in _removeRange()
[all …]
H A D_XCellSeries.java83 oSheet.getCellByPosition(0, 0).setValue(2); in _fillAuto()
88 oSheet.getCellByPosition(0, 4).setFormula("=sum(A1:D1)"); in _fillAuto()
104 oSheet.getCellByPosition(4, 0).setFormula("=sum(A1:A4)"); in _fillAuto()
105 getting = oSheet.getCellByPosition(4, 0).getValue(); in _fillAuto()
134 oSheet.getCellByPosition(0, 0).setValue(2); in _fillSeries()
144 oSheet.getCellByPosition(0, 4).setFormula("=sum(A1:D1)"); in _fillSeries()
168 oSheet.getCellByPosition(0, 4).setFormula("=sum(A1:D1)"); in _fillSeries()
169 getting = oSheet.getCellByPosition(0, 4).getValue(); in _fillSeries()
190 oSheet.getCellByPosition(4, 0).setFormula("=sum(A1:A4)"); in _fillSeries()
191 getting = oSheet.getCellByPosition(4, 0).getValue(); in _fillSeries()
[all …]
H A D_XFormulaQuery.java72 mxCell = oSheet.getCellByPosition(15, 15); in before()
116 oSheet.getCellByPosition(0, 0).setValue(1); in _queryDependents()
117 oSheet.getCellByPosition(1, 0).setValue(1); in _queryDependents()
118 oSheet.getCellByPosition(2, 0).setValue(1); in _queryDependents()
119 oSheet.getCellByPosition(3, 0).setValue(1); in _queryDependents()
155 oSheet.getCellByPosition(0, 0).setValue(1); in _queryPrecedents()
156 oSheet.getCellByPosition(1, 0).setValue(1); in _queryPrecedents()
157 oSheet.getCellByPosition(2, 0).setValue(1); in _queryPrecedents()
158 oSheet.getCellByPosition(3, 0).setValue(1); in _queryPrecedents()
159 oSheet.getCellByPosition(1, 2).setFormula("=A16*2"); in _queryPrecedents()
H A D_XSubTotalCalculatable.java63 oSheet.getCellByPosition(0, 0).setFormula("first"); in _applySubTotals()
64 oSheet.getCellByPosition(1, 0).setFormula("second"); in _applySubTotals()
65 oSheet.getCellByPosition(0, 3).setFormula(""); in _applySubTotals()
66 oSheet.getCellByPosition(0, 1).setValue(5); in _applySubTotals()
67 oSheet.getCellByPosition(0, 2).setValue(5); in _applySubTotals()
68 oSheet.getCellByPosition(1, 1).setValue(17); in _applySubTotals()
69 oSheet.getCellByPosition(1, 2).setValue(25); in _applySubTotals()
72 String formula = oSheet.getCellByPosition(0, 3).getFormula(); in _applySubTotals()
107 String formula = oSheet.getCellByPosition(0, 3).getFormula(); in _removeSubTotals()
H A D_XMultipleOperation.java69 cell = oSheet.getCellByPosition(0, 16); in _setTableOperation()
71 cell = oSheet.getCellByPosition(0, 14); in _setTableOperation()
72 cell2 = oSheet.getCellByPosition(0, 15); in _setTableOperation()
132 cell = oSheet.getCellByPosition(0, k); in fillCells()
134 cell = oSheet.getCellByPosition(k, 0); in fillCells()
147 boolean locres = oSheet.getCellByPosition(cellCoords[i].X, in checkValues()
158 oSheet.getCellByPosition(cellCoords[i].X, in checkValues()
H A D_XSheetFilterable.java82 oSheet.getCellByPosition(0, 0).setValue(1); in _filter()
83 oSheet.getCellByPosition(0, 1).setValue(2); in _filter()
84 oSheet.getCellByPosition(0, 2).setValue(3); in _filter()
85 oSheet.getCellByPosition(1, 0).setFormula("A"); in _filter()
86 oSheet.getCellByPosition(1, 1).setFormula("D"); in _filter()
87 oSheet.getCellByPosition(1, 2).setFormula("B"); in _filter()
/aoo41x/test/testuno/source/fvt/uno/sc/cell/
H A DInsertDeleteCells.java140 cellC2 = xSheet.getCellByPosition(2, 1); in testInsertCells()
163 cellE2 = xSheet.getCellByPosition(4, 1); in testInsertCells()
165 cellC3 = xSheet.getCellByPosition(2, 2); in testInsertCells()
270 cellA2 = xSheet.getCellByPosition(0, 1); in testDeleteCells()
271 cellB2 = xSheet.getCellByPosition(1, 1); in testDeleteCells()
272 cellC2 = xSheet.getCellByPosition(2, 1); in testDeleteCells()
289 cellA2 = xSheet.getCellByPosition(0, 1); in testDeleteCells()
290 cellB2 = xSheet.getCellByPosition(1, 1); in testDeleteCells()
291 cellC2 = xSheet.getCellByPosition(2, 1); in testDeleteCells()
308 cellA2 = xSheet.getCellByPosition(0, 1); in testDeleteCells()
[all …]
/aoo41x/main/qadevOOo/tests/java/mod/_sc/
H A DScTableSheetObj.java221 oSheet.getCellByPosition(5, 5).setValue(15); in createTestEnvironment()
222 oSheet.getCellByPosition(1, 4).setValue(10); in createTestEnvironment()
223 oSheet.getCellByPosition(2, 0).setValue(-5.15); in createTestEnvironment()
226 oSheet.getCellByPosition(6, 6).setValue(3); in createTestEnvironment()
227 oSheet.getCellByPosition(7, 6).setValue(3); in createTestEnvironment()
229 oSheet.getCellByPosition(9, 6).setFormula("= G7*I7"); in createTestEnvironment()
320 oSheet.getCellByPosition(15, 15), in createTestEnvironment()
321 oSheet.getCellByPosition(15, 16) in createTestEnvironment()
342 oTable.getCellByPosition(0, 0).setValue(4); in createTestEnvironment()
344 oTable.getCellByPosition(0, 2).setValue(3); in createTestEnvironment()
[all …]
H A DScDataPilotFieldGroupsObj.java163 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
164 oSheet.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
165 oSheet2.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
166 oSheet2.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
178 oSheet.getCellByPosition (1, 1).setFormula ("aName"); in createTestEnvironment()
179 oSheet.getCellByPosition (1, 2).setFormula ("otherName"); in createTestEnvironment()
180 oSheet.getCellByPosition (1, 3).setFormula ("una"); in createTestEnvironment()
181 oSheet.getCellByPosition (1, 4).setFormula ("otherName"); in createTestEnvironment()
182 oSheet.getCellByPosition (1, 5).setFormula ("somethingelse"); in createTestEnvironment()
200 oChangeCell = oSheet.getCellByPosition (1, 5); in createTestEnvironment()
[all …]
H A DScDataPilotFieldGroupItemObj.java164 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
165 oSheet.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
166 oSheet2.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
167 oSheet2.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
179 oSheet.getCellByPosition (1, 1).setFormula ("aName"); in createTestEnvironment()
180 oSheet.getCellByPosition (1, 2).setFormula ("otherName"); in createTestEnvironment()
181 oSheet.getCellByPosition (1, 3).setFormula ("una"); in createTestEnvironment()
182 oSheet.getCellByPosition (1, 4).setFormula ("otherName"); in createTestEnvironment()
183 oSheet.getCellByPosition (1, 5).setFormula ("somethingelse"); in createTestEnvironment()
201 oChangeCell = oSheet.getCellByPosition (1, 5); in createTestEnvironment()
[all …]
H A DScDataPilotFieldGroupObj.java163 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
164 oSheet.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
165 oSheet2.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment()
166 oSheet2.getCellByPosition (0, i).setFormula ("Row" + i); in createTestEnvironment()
178 oSheet.getCellByPosition (1, 1).setFormula ("aName"); in createTestEnvironment()
179 oSheet.getCellByPosition (1, 2).setFormula ("otherName"); in createTestEnvironment()
180 oSheet.getCellByPosition (1, 3).setFormula ("una"); in createTestEnvironment()
181 oSheet.getCellByPosition (1, 4).setFormula ("otherName"); in createTestEnvironment()
182 oSheet.getCellByPosition (1, 5).setFormula ("somethingelse"); in createTestEnvironment()
200 oChangeCell = oSheet.getCellByPosition (1, 5); in createTestEnvironment()
[all …]
H A DScCellCursorObj.java180 oSheet.getCellByPosition(1, 1).setValue(1); in createTestEnvironment()
181 oSheet.getCellByPosition(4, 5).setValue(1); in createTestEnvironment()
182 oSheet.getCellByPosition(3, 2).setFormula("xTextDoc"); in createTestEnvironment()
183 oSheet.getCellByPosition(3, 3).setFormula("xTextDoc"); in createTestEnvironment()
247 oTable.getCellByPosition(0, 0).setValue(4); in createTestEnvironment()
248 oTable.getCellByPosition(0, 1).setFormula("b"); in createTestEnvironment()
249 oTable.getCellByPosition(0, 2).setValue(3); in createTestEnvironment()
250 oTable.getCellByPosition(0, 3).setValue(23); in createTestEnvironment()
265 XCell cell = oTable.getCellByPosition(0, i); in createTestEnvironment()
H A DScModelObj.java182 toSel = oSheet.getCellByPosition(2, 3); in createTestEnvironment()
184 oSheet.getCellByPosition(4, 5).setValue(15); in createTestEnvironment()
185 oSheet.getCellByPosition(5, 5).setValue(10); in createTestEnvironment()
186 oSheet.getCellByPosition(6, 5).setFormula("= E6 * F6"); in createTestEnvironment()
188 oSheet.getCellByPosition(4, 5), in createTestEnvironment()
189 oSheet.getCellByPosition(5, 5), in createTestEnvironment()
190 oSheet.getCellByPosition(6, 5) in createTestEnvironment()
H A DScDataPilotFieldObj.java176 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
177 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
178 oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
179 oSheet2.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
184 oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); in createTestEnvironment()
185 oSheet2.getCellByPosition(i, j).setValue(i * (j + 2)); in createTestEnvironment()
200 oChangeCell = oSheet.getCellByPosition(1, 5); in createTestEnvironment()
207 oCheckCell = oSheet.getCellByPosition(x, y); in createTestEnvironment()
H A DScCellRangeObj.java204 testRange.getCellByPosition(0,0), testRange.getCellByPosition(0,1)}); in createTestEnvironment()
233 oTable.getCellByPosition(0, 0).setValue(4); in createTestEnvironment()
234 oTable.getCellByPosition(0, 1).setFormula("b"); in createTestEnvironment()
235 oTable.getCellByPosition(0, 2).setValue(3); in createTestEnvironment()
236 oTable.getCellByPosition(0, 3).setValue(23); in createTestEnvironment()
251 XCell cell = oTable.getCellByPosition(0, i); in createTestEnvironment()
H A DScDataPilotItemObj.java177 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
178 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
179 oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
180 oSheet2.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
185 oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); in createTestEnvironment()
186 oSheet2.getCellByPosition(i, j).setValue(i * (j + 2)); in createTestEnvironment()
201 oChangeCell = oSheet.getCellByPosition(1, 5); in createTestEnvironment()
208 oCheckCell = oSheet.getCellByPosition(x, y); in createTestEnvironment()
H A DScDataPilotItemsObj.java177 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
178 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
179 oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
180 oSheet2.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
185 oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); in createTestEnvironment()
186 oSheet2.getCellByPosition(i, j).setValue(i * (j + 2)); in createTestEnvironment()
201 oChangeCell = oSheet.getCellByPosition(1, 5); in createTestEnvironment()
208 oCheckCell = oSheet.getCellByPosition(x, y); in createTestEnvironment()
H A DScIndexEnumeration_DataPilotItemsEnumeration.java179 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
180 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
181 oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment()
182 oSheet2.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment()
187 oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); in createTestEnvironment()
188 oSheet2.getCellByPosition(i, j).setValue(i * (j + 2)); in createTestEnvironment()
203 oChangeCell = oSheet.getCellByPosition(1, 5); in createTestEnvironment()
210 oCheckCell = oSheet.getCellByPosition(x, y); in createTestEnvironment()
/aoo41x/main/svx/source/table/
H A Dcellcursor.cxx69 return CellRange::getCellByPosition( nColumn, nRow ); in getCellByPosition()
184 CellRef xCell( dynamic_cast< Cell* >( mxTable->getCellByPosition( mnLeft, mnTop ).get() ) ); in GetMergedSelection()
191 xCell.set( dynamic_cast< Cell* >( mxTable->getCellByPosition( mnRight, mnBottom ).get() ) ); in GetMergedSelection()
200 … xCell.set( dynamic_cast< Cell* >( mxTable->getCellByPosition( rEnd.mnCol, rEnd.mnRow ).get() ) ); in GetMergedSelection()
215 xCell.set( dynamic_cast< Cell* >( mxTable->getCellByPosition( nCol, nRow ).get() ) ); in GetMergedSelection()
299 CellRef xCell( dynamic_cast< Cell* >( mxTable->getCellByPosition( nCol, nRow ).get() ) ); in split_column()
329 CellRef xCell( dynamic_cast< Cell* >( mxTable->getCellByPosition( nCol, nRow ).get() ) ); in split_column()
335 … xCell.set( dynamic_cast< Cell* >(mxTable->getCellByPosition( nCol+1, nRow ).get() ) ); in split_column()
415 CellRef xCell( dynamic_cast< Cell* >( mxTable->getCellByPosition( nCol, nRow ).get() ) ); in split_row()
445 CellRef xCell( dynamic_cast< Cell* >( mxTable->getCellByPosition( nCol, nRow ).get() ) ); in split_row()
[all …]
/aoo41x/main/odk/examples/CLI/CSharp/Spreadsheet/
H A DGeneralTableSample.cs70 xCell = xSheet.getCellByPosition( 0, 0 ); in doSampleFunction()
76 xSheet.getCellByPosition( 0, 1 ).setValue( nDblValue ); in doSampleFunction()
79 xCell = xSheet.getCellByPosition( 0, 2 ); in doSampleFunction()
90 xCell = xSheet.getCellByPosition( 0, 3 ); in doSampleFunction()
142 xCursor.getCellByPosition( 0, 0 ).setFormula( in doSampleFunction()
165 xSheet.getCellByPosition( 2, 2 ).setFormula( aText ); in doSampleFunction()
181 xSheet.getCellByPosition( 2, 6 ).setFormula( "What a big cell." ); in doSampleFunction()
185 xSheet.getCellByPosition( 0, nRow ).setValue( nRow - 7 ); in doSampleFunction()
221 xSheet.getCellByPosition( 2, 8 ).setFormula( aText ); in doSampleFunction()
224 xSheet.getCellByPosition( 2, 9 ).setFormula( aText ); in doSampleFunction()
/aoo41x/main/odk/examples/DevelopersGuide/Spreadsheet/
H A DGeneralTableSample.java70 xCell = xSheet.getCellByPosition( 0, 0 ); in doSampleFunction()
76 xSheet.getCellByPosition( 0, 1 ).setValue( nDblValue ); in doSampleFunction()
79 xCell = xSheet.getCellByPosition( 0, 2 ); in doSampleFunction()
90 xCell = xSheet.getCellByPosition( 0, 3 ); in doSampleFunction()
140 xCursor.getCellByPosition( 0, 0 ).setFormula( "Beyond of the last filled cell." ); in doSampleFunction()
161 xSheet.getCellByPosition( 2, 2 ).setFormula( aText ); in doSampleFunction()
178 xSheet.getCellByPosition( 2, 6 ).setFormula( "What a big cell." ); in doSampleFunction()
182 xSheet.getCellByPosition( 0, nRow ).setValue( nRow - 7 ); in doSampleFunction()
216 xSheet.getCellByPosition( 2, 8 ).setFormula( aText ); in doSampleFunction()
219 xSheet.getCellByPosition( 2, 9 ).setFormula( aText ); in doSampleFunction()
/aoo41x/test/testuno/source/fvt/uno/sc/rowcolumn/
H A DInsertDeleteRowAndColumn.java83 sheet.getCellByPosition( 0, nRow ).setValue( nRow ); in testInsertDeleteRows()
91 XCell cell = sheet.getCellByPosition(0, 2); in testInsertDeleteRows()
101 XCell cellA3 = sheet.getCellByPosition(0, 2); in testInsertDeleteRows()
102 XCell cellA4 = sheet.getCellByPosition(0, 3); in testInsertDeleteRows()
129 sheet.getCellByPosition( 1, nRow ).setValue( nRow ); in testInsertDeleteColumns()
137 XCell cell = sheet.getCellByPosition(2, 1); in testInsertDeleteColumns()
147 XCell cellA3 = sheet.getCellByPosition(1, 2); in testInsertDeleteColumns()
148 XCell cellA4 = sheet.getCellByPosition(1, 3); in testInsertDeleteColumns()
/aoo41x/test/testuno/source/testlib/uno/
H A DSCUtil.java204 XCell xCell = xSpreadsheet.getCellByPosition(column, row); in setValueToCell()
217 XCell xCell = xSpreadsheet.getCellByPosition(column, row); in setTextToCell()
242 XCell xCell = xSpreadsheet.getCellByPosition(column, row); in setFormulaToCell()
255 XCell xCell = xSpreadsheet.getCellByPosition(column, row); in getValueFromCell()
271 XCell xCell = xSpreadsheet.getCellByPosition(column, row); in getTextFromCell()
308 xCell = xCellRange.getCellByPosition(j, i); in setValueToCellRange()
319 xCell = xCellRange.getCellByPosition(j, i); in setValueToCellRange()
342 xCell = xCellRange.getCellByPosition(j, i); in setTextToCellRange()
355 xCell = xCellRange.getCellByPosition(j, i); in setTextToCellRange()
379 xCell = xCellRange.getCellByPosition(j, i); in getValueFromCellRange()
[all …]
/aoo41x/main/qadevOOo/tests/java/ifc/table/
H A D_XTableColumns.java334 setCellText(xRange.getCellByPosition(i, 0), "" + i + "a"); in fillRange()
335 setCellText(xRange.getCellByPosition(i, 1), "" + i + "b"); in fillRange()
339 setCellText(xRange.getCellByPosition(i, 0), ""); in fillRange()
340 setCellText(xRange.getCellByPosition(i, 1), ""); in fillRange()
359 String c1 = getCellText(xCellRange.getCellByPosition(col, 0)); in checkColumn()
360 String c2 = getCellText(xCellRange.getCellByPosition(col, 1)); in checkColumn()
384 String c1 = getCellText(xCellRange.getCellByPosition(col, 0)); in checkColumnEmpty()
385 String c2 = getCellText(xCellRange.getCellByPosition(col, 1)); in checkColumnEmpty()
/aoo41x/main/odk/examples/java/ToDo/
H A DToDo.java270 xcellrange.getCellByPosition( in recalc()
279 XCell xcell = xcellrange.getCellByPosition( in recalc()
345 XCell xcell = xcellrange.getCellByPosition( in recalc()
473 xcellrange.getCellByPosition( in recalc()
507 xcellrange.getCellByPosition( in recalc()
645 XCell xcellStartDate = xcellrange.getCellByPosition(intColumn, in getStringFromCell()
669 XCell xcellStartDate = xcellrange.getCellByPosition(intColumn, in setStringToCell()
859 double dHolidayStart = xcellrange.getCellByPosition( in getPrivateHolidays()
862 double dHolidayEnd = xcellrange.getCellByPosition( in getPrivateHolidays()
881 dHolidayStart = xcellrange.getCellByPosition( in getPrivateHolidays()
[all …]

Completed in 159 milliseconds

12345678