Home
last modified time | relevance | path

Searched refs:oSheet (Results 1 – 25 of 87) sorted by relevance

1234

/trunk/main/qadevOOo/java/OOoRunner/src/main/java/mod/_sc/
H A DScChartsObj.java125 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 DScIndexEnumeration_TableChartsEnumeration.java85 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 DScChartObj.java117 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 DScTableSheetObj.java199 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 DScDataPilotFieldGroupsObj.java127 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 DScDataPilotFieldGroupItemObj.java128 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 DScDataPilotFieldGroupObj.java127 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 DScDataPilotTableObj.java147 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 DScCellRangesObj.java162 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 DScCellCursorObj.java156 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 DScIndexEnumeration_SheetCellRangesEnumeration.java101 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 DScModelObj.java177 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 DScScenariosObj.java117 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 DScDataPilotTablesObj.java129 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 DScIndexEnumeration_ScenariosEnumeration.java84 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 DScDataPilotFieldObj.java149 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()
/trunk/main/qadevOOo/java/OOoRunner/src/main/java/mod/_sch/
H A DChXDiagram.java219 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 …]
/trunk/main/qadevOOo/java/OOoRunner/src/main/java/ifc/sheet/
H A D_XCellRangeMovement.java66 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.java38 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.java39 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.java45 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.java41 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.java42 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.java57 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.java68 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()

Completed in 86 milliseconds

1234