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()
320 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromfile()
322 XSpreadsheet firstSheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
324 XSpreadsheet secondSheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
326 XSpreadsheet thirdSheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
328 SCUtil.setFormulaToCell(firstSheet, 1, 2, "=2*2"); in insertSheetFromfile()
329 SCUtil.setFormulaToCell(secondSheet, 1, 2, "=2*2"); in insertSheetFromfile()
330 SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=2*2"); in insertSheetFromfile()
333 SCUtil.saveFileAs(scComponent, "source", "xls"); in insertSheetFromfile()
334 SCUtil.closeFile(scDocument); in insertSheetFromfile()
342 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromfile()
347 XSpreadsheet firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
357 XSpreadsheet secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
367 XSpreadsheet thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromfile()
376 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
378 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
382 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
384 SCUtil.getTextFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
388 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
390 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
393 SCUtil.saveFileAs(scComponent, "linked", "ods"); in insertSheetFromfile()
394 XSpreadsheetDocument tempscDocument = SCUtil.reloadFile(unoApp, in insertSheetFromfile()
397 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromfile()
398 secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 4); in insertSheetFromfile()
399 thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 5); in insertSheetFromfile()
403 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
405 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
409 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
411 SCUtil.getTextFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
415 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
417 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
420 SCUtil.save(scDocument); in insertSheetFromfile()
421 SCUtil.closeFile(scDocument); in insertSheetFromfile()
424 XSpreadsheetDocument sourcescDocument = SCUtil.reloadFile(unoApp, in insertSheetFromfile()
426 firstSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 0); in insertSheetFromfile()
427 secondSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 1); in insertSheetFromfile()
428 thirdSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 2); in insertSheetFromfile()
429 SCUtil.setFormulaToCell(firstSheet, 1, 2, "=3*3"); in insertSheetFromfile()
430 SCUtil.setFormulaToCell(secondSheet, 1, 2, "=3*3"); in insertSheetFromfile()
431 SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=3*3"); in insertSheetFromfile()
432 SCUtil.save(sourcescDocument); in insertSheetFromfile()
433 SCUtil.closeFile(sourcescDocument); in insertSheetFromfile()
436 tempscDocument = SCUtil.reloadFile(unoApp, scDocument, "linked.ods"); in insertSheetFromfile()
440 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromfile()
441 secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 4); in insertSheetFromfile()
442 thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 5); in insertSheetFromfile()
462 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
464 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromfile()
468 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
470 SCUtil.getTextFromCell(secondexternalsheet, 1, 2)); in insertSheetFromfile()
474 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
476 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2)); in insertSheetFromfile()
479 SCUtil.save(scDocument); in insertSheetFromfile()