/aoo4110/main/qadevOOo/tests/java/mod/_sc/ |
H A D | ScChartsObj.java | 125 XSpreadsheet oSheet=null; in createTestEnvironment() local 150 insertIntoCell(1,0,"JAN",oSheet,""); in createTestEnvironment() 151 insertIntoCell(2,0,"FEB",oSheet,""); in createTestEnvironment() 152 insertIntoCell(3,0,"MAR",oSheet,""); in createTestEnvironment() 153 insertIntoCell(4,0,"APR",oSheet,""); in createTestEnvironment() 154 insertIntoCell(5,0,"MAI",oSheet,""); in createTestEnvironment() 155 insertIntoCell(6,0,"JUN",oSheet,""); in createTestEnvironment() 156 insertIntoCell(7,0,"JUL",oSheet,""); in createTestEnvironment() 157 insertIntoCell(8,0,"AUG",oSheet,""); in createTestEnvironment() 158 insertIntoCell(9,0,"SEP",oSheet,""); in createTestEnvironment() [all …]
|
H A D | ScIndexEnumeration_TableChartsEnumeration.java | 85 XSpreadsheet oSheet=null; in createTestEnvironment() local 110 insertIntoCell(1,0,"JAN",oSheet,""); in createTestEnvironment() 111 insertIntoCell(2,0,"FEB",oSheet,""); in createTestEnvironment() 112 insertIntoCell(3,0,"MAR",oSheet,""); in createTestEnvironment() 113 insertIntoCell(4,0,"APR",oSheet,""); in createTestEnvironment() 114 insertIntoCell(5,0,"MAI",oSheet,""); in createTestEnvironment() 115 insertIntoCell(6,0,"JUN",oSheet,""); in createTestEnvironment() 116 insertIntoCell(7,0,"JUL",oSheet,""); in createTestEnvironment() 117 insertIntoCell(8,0,"AUG",oSheet,""); in createTestEnvironment() 118 insertIntoCell(9,0,"SEP",oSheet,""); in createTestEnvironment() [all …]
|
H A D | ScChartObj.java | 117 XSpreadsheet oSheet=null; in createTestEnvironment() local 142 insertIntoCell(1,0,"JAN",oSheet,""); in createTestEnvironment() 143 insertIntoCell(2,0,"FEB",oSheet,""); in createTestEnvironment() 144 insertIntoCell(3,0,"MAR",oSheet,""); in createTestEnvironment() 145 insertIntoCell(4,0,"APR",oSheet,""); in createTestEnvironment() 146 insertIntoCell(5,0,"MAI",oSheet,""); in createTestEnvironment() 147 insertIntoCell(6,0,"JUN",oSheet,""); in createTestEnvironment() 148 insertIntoCell(7,0,"JUL",oSheet,""); in createTestEnvironment() 149 insertIntoCell(8,0,"AUG",oSheet,""); in createTestEnvironment() 150 insertIntoCell(9,0,"SEP",oSheet,""); in createTestEnvironment() [all …]
|
H A D | ScTableSheetObj.java | 199 XSpreadsheet oSheet = null; in createTestEnvironment() local 204 oSheet = (XSpreadsheet) AnyConverter.toObject( in createTestEnvironment() 221 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() 288 tEnv.addObjRelation("SHEET", oSheet); in createTestEnvironment() 320 oSheet.getCellByPosition(15, 15), in createTestEnvironment() 321 oSheet.getCellByPosition(15, 16) in createTestEnvironment() [all …]
|
H A D | ScDataPilotFieldGroupsObj.java | 127 XSpreadsheet oSheet = null; in createTestEnvironment() local 134 oSheet = (XSpreadsheet) AnyConverter.toObject ( in createTestEnvironment() 163 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment() 164 oSheet.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() 200 oChangeCell = oSheet.getCellByPosition (1, 5); in createTestEnvironment() 207 oCheckCell = oSheet.getCellByPosition (x, y); in createTestEnvironment() [all …]
|
H A D | ScDataPilotFieldGroupItemObj.java | 128 XSpreadsheet oSheet = null; in createTestEnvironment() local 135 oSheet = (XSpreadsheet) AnyConverter.toObject ( in createTestEnvironment() 164 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment() 165 oSheet.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() 201 oChangeCell = oSheet.getCellByPosition (1, 5); in createTestEnvironment() 208 oCheckCell = oSheet.getCellByPosition (x, y); in createTestEnvironment() [all …]
|
H A D | ScDataPilotFieldGroupObj.java | 127 XSpreadsheet oSheet = null; in createTestEnvironment() local 134 oSheet = (XSpreadsheet) AnyConverter.toObject ( in createTestEnvironment() 163 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i); in createTestEnvironment() 164 oSheet.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() 200 oChangeCell = oSheet.getCellByPosition (1, 5); in createTestEnvironment() 207 oCheckCell = oSheet.getCellByPosition (x, y); in createTestEnvironment() [all …]
|
H A D | ScCellRangesObj.java | 162 XSpreadsheet oSheet = null; in createTestEnvironment() local 164 oSheet = (XSpreadsheet) AnyConverter.toObject( in createTestEnvironment() 169 oRange = oSheet.getCellRangeByName("C1:D4"); in createTestEnvironment() 171 oRange = oSheet.getCellRangeByName("E2:F5"); in createTestEnvironment() 173 oRange = oSheet.getCellRangeByName("G2:H3"); in createTestEnvironment() 175 oRange = oSheet.getCellRangeByName("I7:J8"); in createTestEnvironment() 195 oSheet.getCellByPosition(i, j).setFormula("a"); in createTestEnvironment() 200 oSheet.getCellByPosition(i, j).setValue(i + j); in createTestEnvironment() 228 oRange = oSheet.getCellRangeByName("A" + a + ":B" + b); in createTestEnvironment() 238 tEnv.addObjRelation("SHEET", oSheet); in createTestEnvironment()
|
H A D | ScDataPilotTableObj.java | 147 XSpreadsheet oSheet = null; in createTestEnvironment() local 151 oSheet = (XSpreadsheet) AnyConverter.toObject( in createTestEnvironment() 153 oChangeCell = oSheet.getCellByPosition(1, 5); in createTestEnvironment() 154 oCheckCell = oSheet.getCellByPosition( in createTestEnvironment() 166 log.println("Getting sheet - " + (oSheet == null ? "FAILED" : "OK")); in createTestEnvironment() 170 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment() 171 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment() 176 oSheet.getCellByPosition(i, j).setValue(2.5 * j + i); in createTestEnvironment() 205 UnoRuntime.queryInterface(XDataPilotTablesSupplier.class, oSheet); in createTestEnvironment() 276 createTable2(oSheet, sCellRangeAddress, tEnv); in createTestEnvironment() [all …]
|
H A D | ScCellCursorObj.java | 156 XSpreadsheet oSheet = null; in createTestEnvironment() local 169 oSheet = (XSpreadsheet) AnyConverter.toObject( in createTestEnvironment() 174 testRange = oSheet.getCellRangeByName("$A$1:$D$4"); in createTestEnvironment() 179 oObj = oSheet.createCursorByRange(testSheetRange); in createTestEnvironment() 180 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() 209 tEnv.addObjRelation("SHEET", oSheet); in createTestEnvironment()
|
H A D | ScIndexEnumeration_SheetCellRangesEnumeration.java | 101 XSpreadsheet oSheet = null; in createTestEnvironment() local 103 oSheet = (XSpreadsheet) AnyConverter.toObject( in createTestEnvironment() 108 oRange = oSheet.getCellRangeByName("C1:D4"); in createTestEnvironment() 110 oRange = oSheet.getCellRangeByName("E2:F5"); in createTestEnvironment() 112 oRange = oSheet.getCellRangeByName("G2:H3"); in createTestEnvironment() 114 oRange = oSheet.getCellRangeByName("I7:J8"); in createTestEnvironment() 134 oSheet.getCellByPosition(i, j).setFormula("a"); in createTestEnvironment() 139 oSheet.getCellByPosition(i, j).setValue(i + j); in createTestEnvironment()
|
H A D | ScModelObj.java | 177 XSpreadsheet oSheet = (XSpreadsheet) AnyConverter.toObject( in createTestEnvironment() local 182 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 D | ScScenariosObj.java | 117 XSpreadsheet oSheet = null; in createTestEnvironment() local 121 oSheet = (XSpreadsheet)AnyConverter.toObject( in createTestEnvironment() 136 oSheet.getCellByPosition(5, 5).setValue(15); in createTestEnvironment() 137 oSheet.getCellByPosition(1, 4).setValue(10); in createTestEnvironment() 138 oSheet.getCellByPosition(2, 0).setValue(-5.15); in createTestEnvironment() 145 UnoRuntime.queryInterface(XScenariosSupplier.class, oSheet); in createTestEnvironment() 147 UnoRuntime.queryInterface(XCellRange.class, oSheet); in createTestEnvironment()
|
H A D | ScDataPilotTablesObj.java | 129 XSpreadsheet oSheet = null; in createTestEnvironment() local 133 oSheet = (XSpreadsheet) AnyConverter.toObject( in createTestEnvironment() 150 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment() 151 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment() 156 oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); in createTestEnvironment() 164 UnoRuntime.queryInterface(XDataPilotTablesSupplier.class, oSheet); in createTestEnvironment() 184 tEnv.addObjRelation("SHEET", oSheet); in createTestEnvironment()
|
H A D | ScIndexEnumeration_ScenariosEnumeration.java | 84 XSpreadsheet oSheet = null; in createTestEnvironment() local 88 oSheet = (XSpreadsheet) AnyConverter.toObject( in createTestEnvironment() 103 oSheet.getCellByPosition(5, 5).setValue(15); in createTestEnvironment() 104 oSheet.getCellByPosition(1, 4).setValue(10); in createTestEnvironment() 105 oSheet.getCellByPosition(2, 0).setValue(-5.15); in createTestEnvironment() 112 UnoRuntime.queryInterface(XScenariosSupplier.class, oSheet); in createTestEnvironment() 114 UnoRuntime.queryInterface(XCellRange.class, oSheet); in createTestEnvironment()
|
H A D | ScDataPilotFieldObj.java | 149 XSpreadsheet oSheet = null; in createTestEnvironment() local 155 oSheet = (XSpreadsheet) AnyConverter.toObject( in createTestEnvironment() 176 oSheet.getCellByPosition(i, 0).setFormula("Col" + i); in createTestEnvironment() 177 oSheet.getCellByPosition(0, i).setFormula("Row" + i); in createTestEnvironment() 184 oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); in createTestEnvironment() 200 oChangeCell = oSheet.getCellByPosition(1, 5); in createTestEnvironment() 207 oCheckCell = oSheet.getCellByPosition(x, y); in createTestEnvironment() 220 oSheet); in createTestEnvironment()
|
/aoo4110/main/qadevOOo/tests/java/mod/_sch/ |
H A D | ChXDiagram.java | 219 XSpreadsheet oSheet=null; in createTestEnvironment() local 243 insertIntoCell(1,0,"JAN",oSheet,""); in createTestEnvironment() 244 insertIntoCell(2,0,"FEB",oSheet,""); in createTestEnvironment() 245 insertIntoCell(3,0,"MAR",oSheet,""); in createTestEnvironment() 246 insertIntoCell(4,0,"APR",oSheet,""); in createTestEnvironment() 247 insertIntoCell(5,0,"MAI",oSheet,""); in createTestEnvironment() 248 insertIntoCell(6,0,"JUN",oSheet,""); in createTestEnvironment() 249 insertIntoCell(7,0,"JUL",oSheet,""); in createTestEnvironment() 250 insertIntoCell(8,0,"AUG",oSheet,""); in createTestEnvironment() 251 insertIntoCell(9,0,"SEP",oSheet,""); in createTestEnvironment() [all …]
|
/aoo4110/main/qadevOOo/tests/java/ifc/sheet/ |
H A D | _XCellRangeMovement.java | 66 XSpreadsheet oSheet = (XSpreadsheet) in _copyRange() local 69 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() 115 XSpreadsheet oSheet = (XSpreadsheet) in _insertCells() local 168 XSpreadsheet oSheet = (XSpreadsheet) in _moveRange() local 190 oSheet.getCellByPosition(4,4).setValue(0); in _moveRange() 191 oSheet.getCellByPosition(4,5).setValue(0); in _moveRange() 211 XSpreadsheet oSheet = (XSpreadsheet) in _removeRange() local [all …]
|
H A D | _XCellSeries.java | 38 protected XSpreadsheet oSheet = null; field in _XCellSeries 45 oSheet = (XSpreadsheet) tEnv.getObjRelation("SHEET"); in before() 47 if (oSheet == null) { in before() 50 oSheet = (XSpreadsheet) UnoRuntime.queryInterface( in before() 53 if (oSheet == null) { in before() 83 oSheet.getCellByPosition(0, 0).setValue(2); in _fillAuto() 105 getting = oSheet.getCellByPosition(4, 0).getValue(); in _fillAuto() 134 oSheet.getCellByPosition(0, 0).setValue(2); in _fillSeries() 169 getting = oSheet.getCellByPosition(0, 4).getValue(); in _fillSeries() 191 getting = oSheet.getCellByPosition(4, 0).getValue(); in _fillSeries() [all …]
|
H A D | _XSubTotalCalculatable.java | 39 protected XSpreadsheet oSheet; field in _XSubTotalCalculatable 42 oSheet = (XSpreadsheet) tEnv.getObjRelation("SHEET"); in before() 44 if (oSheet == null) { in before() 47 oSheet = (XSpreadsheet) UnoRuntime.queryInterface( in before() 50 if (oSheet == null) { in before() 63 oSheet.getCellByPosition(0, 0).setFormula("first"); 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() [all …]
|
H A D | _XFormulaQuery.java | 45 protected XSpreadsheet oSheet = null; field in _XFormulaQuery 55 if (oSheet == null) { in before() 61 if (oSheet == null) { 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() [all …]
|
H A D | _XSheetFilterable.java | 41 protected XSpreadsheet oSheet; field in _XSheetFilterable 45 oSheet = (XSpreadsheet) tEnv.getObjRelation("SHEET"); in before() 47 if (oSheet == null) { in before() 50 oSheet = (XSpreadsheet) UnoRuntime.queryInterface( in before() 53 if (oSheet == null) { in before() 82 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() [all …]
|
H A D | _XMultipleOperation.java | 42 protected XSpreadsheet oSheet = null; field in _XMultipleOperation 46 oSheet = (XSpreadsheet) tEnv.getObjRelation("SHEET"); in before() 48 if (oSheet == null) { in before() 61 XCellRange cellRange = oSheet.getCellRangeByName("$A$17:$A$17"); in _setTableOperation() 69 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() [all …]
|
H A D | _XCellRangesQuery.java | 57 protected XSpreadsheet oSheet; field in _XCellRangesQuery 74 oSheet = (XSpreadsheet) tEnv.getObjRelation("SHEET"); in before() 76 if (oSheet == null) { in before() 79 oSheet = (XSpreadsheet) UnoRuntime.queryInterface( in before() 82 if (oSheet == null) { in before() 94 oSheet); in before() 110 oSheet.getCellByPosition(1, 1).setValue(5); in before() 111 oSheet.getCellByPosition(1, 2).setValue(15); in before() 112 oSheet.getCellByPosition(2, 1).setFormula("=B2+B3"); in before() 113 oSheet.getCellByPosition(1, 3).setFormula("=B2+B4"); in before() [all …]
|
H A D | _XNamedRanges.java | 68 XSpreadsheet oSheet = null; field in _XNamedRanges 75 oSheet = (XSpreadsheet)tEnv.getObjRelation("SHEET"); in before() 76 if (oSheet == null) throw new StatusException(Status.failed in before() 108 s = oSheet.getCellByPosition(1, 1).getFormula(); in _addNewByName() 109 s1 = oSheet.getCellByPosition(2, 1).getFormula(); in _addNewByName() 139 cell = oSheet.getCellByPosition(0, i); in _addNewFromTitles() 144 cell = oSheet.getCellByPosition(i, 0); in _addNewFromTitles() 152 cell = oSheet.getCellByPosition(i, j); in _addNewFromTitles() 238 XCell cell = oSheet.getCellByPosition(0, i); in _outputList()
|