Home
last modified time | relevance | path

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

12345678

/trunk/main/qadevOOo/java/OOoRunner/src/main/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()
92 loc_result = (oSheet.getCellByPosition(1, 10).getValue() == 100); in _copyRange()
93 loc_result &= (oSheet.getCellByPosition(1, 11).getValue() == 200); in _copyRange()
94 loc_result &= (oSheet.getCellByPosition(2, 10).getValue() == 300); in _copyRange()
95 loc_result &= (oSheet.getCellByPosition(2, 11).getValue() == 400); in _copyRange()
121 oSheet.getCellByPosition(0,20).setValue(100); in _insertCells()
122 oSheet.getCellByPosition(1,20).setValue(100); in _insertCells()
[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()
90 double getting = oSheet.getCellByPosition(0, 4).getValue(); 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()
146 double getting = oSheet.getCellByPosition(0, 4).getValue(); in _fillSeries()
168 oSheet.getCellByPosition(0, 4).setFormula("=sum(A1:D1)"); in _fillSeries()
169 getting = oSheet.getCellByPosition(0, 4).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()
/trunk/test/testuno/source/fvt/uno/sc/cell/
H A DInsertDeleteCells.java98 xSheet.getCellByPosition( nCol, nRow ).setValue( nValue ); in testInsertCells()
121 XCell cellA2 = xSheet.getCellByPosition(0, 1); in testInsertCells()
122 XCell cellB2 = xSheet.getCellByPosition(1, 1); in testInsertCells()
123 XCell cellC2 = xSheet.getCellByPosition(2, 1); in testInsertCells()
140 cellC2 = xSheet.getCellByPosition(2, 1); in testInsertCells()
141 XCell cellD2 = xSheet.getCellByPosition(3, 1); in testInsertCells()
142 XCell cellE2 = xSheet.getCellByPosition(4, 1); in testInsertCells()
143 XCell cellC3 = xSheet.getCellByPosition(2, 2); in testInsertCells()
163 cellE2 = xSheet.getCellByPosition(4, 1); in testInsertCells()
164 XCell cellE3 = xSheet.getCellByPosition(4, 2); in testInsertCells()
[all …]
/trunk/main/qadevOOo/java/OOoRunner/src/main/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()
224 oSheet.getCellByPosition(8, 8).setFormula("= B5 + C1"); in createTestEnvironment()
226 oSheet.getCellByPosition(6, 6).setValue(3); in createTestEnvironment()
227 oSheet.getCellByPosition(7, 6).setValue(3); in createTestEnvironment()
228 oSheet.getCellByPosition(8, 6).setFormula("= SUM(G7:H7)"); in createTestEnvironment()
229 oSheet.getCellByPosition(9, 6).setFormula("= G7*I7"); in createTestEnvironment()
305 oSheet.getCellByPosition(15, 15)); in createTestEnvironment()
320 oSheet.getCellByPosition(15, 15), 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()
173 oSheet.getCellByPosition (i, j).setValue (i * (j + 1)); in createTestEnvironment()
174 oSheet2.getCellByPosition (i, j).setValue (i * (j + 2)); 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()
[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()
173 oSheet.getCellByPosition (i, j).setValue (i * (j + 1)); in createTestEnvironment()
174 oSheet2.getCellByPosition (i, j).setValue (i * (j + 2)); 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()
[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()
174 oSheet.getCellByPosition (i, j).setValue (i * (j + 1)); in createTestEnvironment()
175 oSheet2.getCellByPosition (i, j).setValue (i * (j + 2)); 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()
[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 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 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 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()
/trunk/main/svx/source/table/
H A Dcellcursor.cxx67 Reference< XCell > SAL_CALL CellCursor::getCellByPosition( sal_Int32 nColumn, sal_Int32 nRow ) thro… in getCellByPosition() function in sdr::table::CellCursor
69 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()
227 … xCell.set( dynamic_cast< Cell* >( mxTable->getCellByPosition( nOriginCol, nOriginRow ).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()
[all …]
/trunk/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()
/trunk/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()
/trunk/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()
/trunk/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()
286 XCell xCell = xSpreadsheet.getCellByPosition(column, row); in getFormulaFromCell()
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()
[all …]
/trunk/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 …]
/trunk/main/qadevOOo/java/OOoRunner/src/main/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()

12345678