Lines Matching refs:oSheet
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()
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()
115 XSpreadsheet oSheet = (XSpreadsheet) in _insertCells() local
121 oSheet.getCellByPosition(0,20).setValue(100); in _insertCells()
122 oSheet.getCellByPosition(1,20).setValue(100); in _insertCells()
123 oSheet.getCellByPosition(2,20).setValue(100); in _insertCells()
124 oSheet.getCellByPosition(3,20).setValue(100); in _insertCells()
125 oSheet.getCellByPosition(0,21).setValue(200); in _insertCells()
126 oSheet.getCellByPosition(1,21).setValue(200); in _insertCells()
127 oSheet.getCellByPosition(2,21).setValue(200); in _insertCells()
128 oSheet.getCellByPosition(3,21).setValue(200); in _insertCells()
131 if (oSheet.getCellByPosition(1,21).getValue() == 200){ in _insertCells()
138 UnoRuntime.queryInterface(XColumnRowRange.class, oSheet); in _insertCells()
147 double res = oSheet.getCellByPosition(1, 21).getValue(); in _insertCells()
168 XSpreadsheet oSheet = (XSpreadsheet) in _moveRange() local
177 oSheet.getCellByPosition(4,0).setValue(111); in _moveRange()
178 oSheet.getCellByPosition(4,1).setValue(222); in _moveRange()
186 cntA = oSheet.getCellByPosition(4, 4).getValue(); in _moveRange()
187 cntB = oSheet.getCellByPosition(4, 5).getValue(); in _moveRange()
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
218 oSheet.getCellByPosition(5, 0).setValue(333); in _removeRange()
219 oSheet.getCellByPosition(5, 1).setValue(444); in _removeRange()
226 cntA = oSheet.getCellByPosition(5, 0).getValue(); in _removeRange()
227 cntB = oSheet.getCellByPosition(5, 1).getValue(); in _removeRange()
231 oSheet.getCellByPosition(5, 0).setValue(0); in _removeRange()
232 oSheet.getCellByPosition(5, 1).setValue(0); in _removeRange()