Lines Matching refs:SCUtil
30 import testlib.uno.SCUtil;
80 scDocument = SCUtil.getSCDocument(scComponent); in insertRenameDeleteSheet()
85 XSpreadsheet newSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, in insertRenameDeleteSheet()
87 SCUtil.setCurrentSheet(scDocument, newSpreadSheet); in insertRenameDeleteSheet()
91 SCUtil.getSCSheetNameByIndex(scDocument, (short) 1)); in insertRenameDeleteSheet()
95 SCUtil.setSCSheetNameByIndex(scDocument, (short) 1, changedname); in insertRenameDeleteSheet()
98 SCUtil.saveFileAs(scComponent, "TestSpreadsheet", "ods"); in insertRenameDeleteSheet()
99 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in insertRenameDeleteSheet()
103 String sheetnameaftermove = SCUtil.getSCSheetNameByIndex(scDocument, in insertRenameDeleteSheet()
114 SCUtil.save(scDocumentTemp); in insertRenameDeleteSheet()
123 scDocument = SCUtil.getSCDocument(scComponent); in copypastesheet()
125 SCUtil.setSCSheetNameByIndex(scDocument, (short) 0, souceSheetName); in copypastesheet()
129 XSpreadsheet sourceSpreadSheet = SCUtil.getSCSheetByName(scDocument, in copypastesheet()
132 SCUtil.setTextToCellRange(sourceSpreadSheet, 0, 0, stringValues); in copypastesheet()
139 SCUtil.saveFileAs(scComponent, "TestCopysheet", "xls"); in copypastesheet()
140 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in copypastesheet()
144 XSpreadsheet copysheet = SCUtil in copypastesheet()
146 String[][] CopystringValues = SCUtil.getTextFromCellRange(copysheet, 0, in copypastesheet()
160 scDocument = SCUtil.getSCDocument(scComponent); in movesheet()
165 SCUtil.setSCSheetNameByIndex(scDocument, (short) 0, sheetname); in movesheet()
169 XSpreadsheet movesheet = SCUtil in movesheet()
171 SCUtil.setTextToCellRange(movesheet, 0, 0,stringValues); in movesheet()
174 String secondSheetNameBeforeMove = SCUtil.getSCSheetNameByIndex( in movesheet()
181 SCUtil.saveFileAs(scComponent, "Testmovesheet", "xls"); in movesheet()
182 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in movesheet()
188 String firstsheetnameAfterMove = SCUtil.getSCSheetNameByIndex( in movesheet()
194 String sheetnameAfterMove = SCUtil.getSCSheetNameByIndex(scDocument, in movesheet()
200 XSpreadsheet sheetaftermove = SCUtil.getSCSheetByIndex(scDocument, in movesheet()
202 String[][] stringValuesaftermove = SCUtil.getTextFromCellRange( in movesheet()
216 scDocument = SCUtil.getSCDocument(scComponent); in hideShowSheet()
221 XSpreadsheet secondSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, in hideShowSheet()
223 SCUtil.setCurrentSheet(scDocument, secondSpreadSheet); in hideShowSheet()
226 SCUtil.getSCSheetNameByIndex(scDocument, (short) 1)); in hideShowSheet()
235 SCUtil.saveFileAs(scComponent, "Testhideshowsheet", "xls"); in hideShowSheet()
236 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in hideShowSheet()
241 String sheet2Name = SCUtil.getSCSheetNameByIndex(scDocument, (short) 2); in hideShowSheet()
242 String activesheetname = SCUtil.getSCActiveSheetName(scDocument); in hideShowSheet()
249 SCUtil.getSCSheetByIndex(scDocument, (short) 1)); in hideShowSheet()
254 secondSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, (short) 1); in hideShowSheet()
255 SCUtil.setCurrentSheet(scDocument, secondSpreadSheet); in hideShowSheet()
258 String currentactivesheetname = SCUtil.getSCActiveSheetName(scDocument); in hideShowSheet()
261 SCUtil.save(scDocument); in hideShowSheet()
270 scDocument = SCUtil.getSCDocument(scComponent); in sheetColor()
272 XSpreadsheet firstSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, in sheetColor()
282 SCUtil.getSCSheetNameByIndex(scDocument, (short) 0), in sheetColor()
286 SCUtil.saveFileAs(scComponent, "Testcolorsheet", "ods"); in sheetColor()
287 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in sheetColor()
294 SCUtil.getSCSheetByIndex(scDocument, (short) 0)); in sheetColor()
301 SCUtil.getSCSheetByIndex(scDocument, (short) 3)); in sheetColor()
319 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromfile()
321 XSpreadsheet firstSheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
323 XSpreadsheet secondSheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
325 XSpreadsheet thirdSheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
327 SCUtil.setFormulaToCell(firstSheet, 1, 2, "=2*2"); in insertSheetFromfile()
328 SCUtil.setFormulaToCell(secondSheet, 1, 2, "=2*2"); in insertSheetFromfile()
329 SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=2*2"); in insertSheetFromfile()
332 SCUtil.saveFileAs(scComponent, "source", "xls"); in insertSheetFromfile()
333 SCUtil.closeFile(scDocument); in insertSheetFromfile()
341 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromfile()
346 XSpreadsheet firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
356 XSpreadsheet secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
366 XSpreadsheet thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
375 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
377 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
381 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
383 SCUtil.getTextFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
387 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
389 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
392 SCUtil.saveFileAs(scComponent, "linked", "ods"); in insertSheetFromfile()
393 XSpreadsheetDocument tempscDocument = SCUtil.reloadFile(unoApp, in insertSheetFromfile()
396 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromfile()
397 secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 4); in insertSheetFromfile()
398 thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 5); in insertSheetFromfile()
402 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
404 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
408 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
410 SCUtil.getTextFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
414 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
416 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
419 SCUtil.save(scDocument); in insertSheetFromfile()
420 SCUtil.closeFile(scDocument); in insertSheetFromfile()
423 XSpreadsheetDocument sourcescDocument = SCUtil.reloadFile(unoApp, in insertSheetFromfile()
425 firstSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 0); in insertSheetFromfile()
426 secondSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 1); in insertSheetFromfile()
427 thirdSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 2); in insertSheetFromfile()
428 SCUtil.setFormulaToCell(firstSheet, 1, 2, "=3*3"); in insertSheetFromfile()
429 SCUtil.setFormulaToCell(secondSheet, 1, 2, "=3*3"); in insertSheetFromfile()
430 SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=3*3"); in insertSheetFromfile()
431 SCUtil.save(sourcescDocument); in insertSheetFromfile()
432 SCUtil.closeFile(sourcescDocument); in insertSheetFromfile()
435 tempscDocument = SCUtil.reloadFile(unoApp, scDocument, "linked.ods"); in insertSheetFromfile()
439 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromfile()
440 secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 4); in insertSheetFromfile()
441 thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 5); in insertSheetFromfile()
461 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
463 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
467 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
469 SCUtil.getTextFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
473 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
475 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
478 SCUtil.save(scDocument); in insertSheetFromfile()