Lines Matching refs:SCUtil
32 import testlib.uno.SCUtil;
82 scDocument = SCUtil.getSCDocument(scComponent); in insertRenameDeleteSheet()
87 XSpreadsheet newSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, in insertRenameDeleteSheet()
89 SCUtil.setCurrentSheet(scDocument, newSpreadSheet); in insertRenameDeleteSheet()
93 SCUtil.getSCSheetNameByIndex(scDocument, (short) 1)); in insertRenameDeleteSheet()
97 SCUtil.setSCSheetNameByIndex(scDocument, (short) 1, changedname); in insertRenameDeleteSheet()
100 SCUtil.saveFileAs(scComponent, "TestSpreadsheet", "ods"); in insertRenameDeleteSheet()
101 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in insertRenameDeleteSheet()
105 String sheetnameaftermove = SCUtil.getSCSheetNameByIndex(scDocument, in insertRenameDeleteSheet()
116 SCUtil.save(scDocumentTemp); in insertRenameDeleteSheet()
125 scDocument = SCUtil.getSCDocument(scComponent); in copypastesheet()
127 SCUtil.setSCSheetNameByIndex(scDocument, (short) 0, souceSheetName); in copypastesheet()
131 XSpreadsheet sourceSpreadSheet = SCUtil.getSCSheetByName(scDocument, in copypastesheet()
134 SCUtil.setTextToCellRange(sourceSpreadSheet, 0, 0, stringValues); in copypastesheet()
141 SCUtil.saveFileAs(scComponent, "TestCopysheet", "xls"); in copypastesheet()
142 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in copypastesheet()
146 XSpreadsheet copysheet = SCUtil in copypastesheet()
148 String[][] CopystringValues = SCUtil.getTextFromCellRange(copysheet, 0, in copypastesheet()
162 scDocument = SCUtil.getSCDocument(scComponent); in movesheet()
167 SCUtil.setSCSheetNameByIndex(scDocument, (short) 0, sheetname); in movesheet()
171 XSpreadsheet movesheet = SCUtil in movesheet()
173 SCUtil.setTextToCellRange(movesheet, 0, 0,stringValues); in movesheet()
176 String secondSheetNameBeforeMove = SCUtil.getSCSheetNameByIndex( in movesheet()
183 SCUtil.saveFileAs(scComponent, "Testmovesheet", "xls"); in movesheet()
184 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in movesheet()
190 String firstsheetnameAfterMove = SCUtil.getSCSheetNameByIndex( in movesheet()
196 String sheetnameAfterMove = SCUtil.getSCSheetNameByIndex(scDocument, in movesheet()
202 XSpreadsheet sheetaftermove = SCUtil.getSCSheetByIndex(scDocument, in movesheet()
204 String[][] stringValuesaftermove = SCUtil.getTextFromCellRange( in movesheet()
218 scDocument = SCUtil.getSCDocument(scComponent); in hideShowSheet()
223 XSpreadsheet secondSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, in hideShowSheet()
225 SCUtil.setCurrentSheet(scDocument, secondSpreadSheet); in hideShowSheet()
228 SCUtil.getSCSheetNameByIndex(scDocument, (short) 1)); in hideShowSheet()
237 SCUtil.saveFileAs(scComponent, "Testhideshowsheet", "xls"); in hideShowSheet()
238 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in hideShowSheet()
243 String sheet2Name = SCUtil.getSCSheetNameByIndex(scDocument, (short) 2); in hideShowSheet()
244 String activesheetname = SCUtil.getSCActiveSheetName(scDocument); in hideShowSheet()
251 SCUtil.getSCSheetByIndex(scDocument, (short) 1)); in hideShowSheet()
256 secondSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, (short) 1); in hideShowSheet()
257 SCUtil.setCurrentSheet(scDocument, secondSpreadSheet); in hideShowSheet()
260 String currentactivesheetname = SCUtil.getSCActiveSheetName(scDocument); in hideShowSheet()
263 SCUtil.save(scDocument); in hideShowSheet()
272 scDocument = SCUtil.getSCDocument(scComponent); in sheetColor()
274 XSpreadsheet firstSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, in sheetColor()
284 SCUtil.getSCSheetNameByIndex(scDocument, (short) 0), in sheetColor()
288 SCUtil.saveFileAs(scComponent, "Testcolorsheet", "ods"); in sheetColor()
289 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in sheetColor()
296 SCUtil.getSCSheetByIndex(scDocument, (short) 0)); in sheetColor()
303 SCUtil.getSCSheetByIndex(scDocument, (short) 3)); in sheetColor()
322 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromfile()
324 XSpreadsheet firstSheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
326 XSpreadsheet secondSheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
328 XSpreadsheet thirdSheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
330 SCUtil.setFormulaToCell(firstSheet, 1, 2, "=2*2"); in insertSheetFromfile()
331 SCUtil.setFormulaToCell(secondSheet, 1, 2, "=2*2"); in insertSheetFromfile()
332 SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=2*2"); in insertSheetFromfile()
335 SCUtil.saveFileAs(scComponent, "source", "xls"); in insertSheetFromfile()
336 SCUtil.closeFile(scDocument); in insertSheetFromfile()
344 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromfile()
349 XSpreadsheet firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
359 XSpreadsheet secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
369 XSpreadsheet thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
378 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
380 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
384 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
386 SCUtil.getTextFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
390 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
392 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
395 SCUtil.saveFileAs(scComponent, "linked", "ods"); in insertSheetFromfile()
396 XSpreadsheetDocument tempscDocument = SCUtil.reloadFile(unoApp, in insertSheetFromfile()
399 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromfile()
400 secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 4); in insertSheetFromfile()
401 thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 5); in insertSheetFromfile()
405 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
407 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
411 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
413 SCUtil.getTextFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
417 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
419 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
422 SCUtil.save(scDocument); in insertSheetFromfile()
423 SCUtil.closeFile(scDocument); in insertSheetFromfile()
426 XSpreadsheetDocument sourcescDocument = SCUtil.reloadFile(unoApp, in insertSheetFromfile()
428 firstSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 0); in insertSheetFromfile()
429 secondSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 1); in insertSheetFromfile()
430 thirdSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 2); in insertSheetFromfile()
431 SCUtil.setFormulaToCell(firstSheet, 1, 2, "=3*3"); in insertSheetFromfile()
432 SCUtil.setFormulaToCell(secondSheet, 1, 2, "=3*3"); in insertSheetFromfile()
433 SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=3*3"); in insertSheetFromfile()
434 SCUtil.save(sourcescDocument); in insertSheetFromfile()
435 SCUtil.closeFile(sourcescDocument); in insertSheetFromfile()
438 tempscDocument = SCUtil.reloadFile(unoApp, scDocument, "linked.ods"); in insertSheetFromfile()
442 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromfile()
443 secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 4); in insertSheetFromfile()
444 thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 5); in insertSheetFromfile()
464 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
466 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
470 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
472 SCUtil.getTextFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
476 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
478 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
481 SCUtil.save(scDocument); in insertSheetFromfile()