33 import testlib.uno.SCUtil;
83         scDocument = SCUtil.getSCDocument(scComponent);  in insertRenameDeleteSheet()
88         XSpreadsheet newSpreadSheet = SCUtil.getSCSheetByIndex(scDocument,  in insertRenameDeleteSheet()
90         SCUtil.setCurrentSheet(scDocument, newSpreadSheet);  in insertRenameDeleteSheet()
94                 SCUtil.getSCSheetNameByIndex(scDocument, (short) 1));  in insertRenameDeleteSheet()
98         SCUtil.setSCSheetNameByIndex(scDocument, (short) 1, changedname);  in insertRenameDeleteSheet()
101         SCUtil.saveFileAs(scComponent, "TestSpreadsheet", "ods");  in insertRenameDeleteSheet()
102         XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp,  in insertRenameDeleteSheet()
106         String sheetnameaftermove = SCUtil.getSCSheetNameByIndex(scDocument,  in insertRenameDeleteSheet()
117         SCUtil.save(scDocumentTemp);  in insertRenameDeleteSheet()
126         scDocument = SCUtil.getSCDocument(scComponent);  in copypastesheet()
128         SCUtil.setSCSheetNameByIndex(scDocument, (short) 0, souceSheetName);  in copypastesheet()
132         XSpreadsheet sourceSpreadSheet = SCUtil.getSCSheetByName(scDocument,  in copypastesheet()
135         SCUtil.setTextToCellRange(sourceSpreadSheet, 0, 0, stringValues);  in copypastesheet()
142         SCUtil.saveFileAs(scComponent, "TestCopysheet", "xls");  in copypastesheet()
143         XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp,  in copypastesheet()
147         XSpreadsheet copysheet = SCUtil  in copypastesheet()
149         String[][] CopystringValues = SCUtil.getTextFromCellRange(copysheet, 0,  in copypastesheet()
163         scDocument = SCUtil.getSCDocument(scComponent);  in movesheet()
168         SCUtil.setSCSheetNameByIndex(scDocument, (short) 0, sheetname);  in movesheet()
172         XSpreadsheet movesheet = SCUtil  in movesheet()
174         SCUtil.setTextToCellRange(movesheet, 0, 0,stringValues);  in movesheet()
177         String secondSheetNameBeforeMove = SCUtil.getSCSheetNameByIndex(  in movesheet()
184         SCUtil.saveFileAs(scComponent, "Testmovesheet", "xls");  in movesheet()
185         XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp,  in movesheet()
191         String firstsheetnameAfterMove = SCUtil.getSCSheetNameByIndex(  in movesheet()
197         String sheetnameAfterMove = SCUtil.getSCSheetNameByIndex(scDocument,  in movesheet()
203         XSpreadsheet sheetaftermove = SCUtil.getSCSheetByIndex(scDocument,  in movesheet()
205         String[][] stringValuesaftermove = SCUtil.getTextFromCellRange(  in movesheet()
219         scDocument = SCUtil.getSCDocument(scComponent);  in hideShowSheet()
224         XSpreadsheet secondSpreadSheet = SCUtil.getSCSheetByIndex(scDocument,  in hideShowSheet()
226         SCUtil.setCurrentSheet(scDocument, secondSpreadSheet);  in hideShowSheet()
229                 SCUtil.getSCSheetNameByIndex(scDocument, (short) 1));  in hideShowSheet()
238         SCUtil.saveFileAs(scComponent, "Testhideshowsheet", "xls");  in hideShowSheet()
239         XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp,  in hideShowSheet()
244         String sheet2Name = SCUtil.getSCSheetNameByIndex(scDocument, (short) 2);  in hideShowSheet()
245         String activesheetname = SCUtil.getSCActiveSheetName(scDocument);  in hideShowSheet()
252                 SCUtil.getSCSheetByIndex(scDocument, (short) 1));  in hideShowSheet()
257         secondSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, (short) 1);  in hideShowSheet()
258         SCUtil.setCurrentSheet(scDocument, secondSpreadSheet);  in hideShowSheet()
261         String currentactivesheetname = SCUtil.getSCActiveSheetName(scDocument);  in hideShowSheet()
264         SCUtil.save(scDocument);  in hideShowSheet()
273         scDocument = SCUtil.getSCDocument(scComponent);  in sheetColor()
275         XSpreadsheet firstSpreadSheet = SCUtil.getSCSheetByIndex(scDocument,  in sheetColor()
285                 SCUtil.getSCSheetNameByIndex(scDocument, (short) 0),  in sheetColor()
289         SCUtil.saveFileAs(scComponent, "Testcolorsheet", "ods");  in sheetColor()
290         XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp,  in sheetColor()
297                 SCUtil.getSCSheetByIndex(scDocument, (short) 0));  in sheetColor()
304                         SCUtil.getSCSheetByIndex(scDocument, (short) 3));  in sheetColor()
323         scDocument = SCUtil.getSCDocument(scComponent);  in insertSheetFromfile()
325         XSpreadsheet firstSheet = SCUtil.getSCSheetByIndex(scDocument,  in insertSheetFromfile()
327         XSpreadsheet secondSheet = SCUtil.getSCSheetByIndex(scDocument,  in insertSheetFromfile()
329         XSpreadsheet thirdSheet = SCUtil.getSCSheetByIndex(scDocument,  in insertSheetFromfile()
331         SCUtil.setFormulaToCell(firstSheet, 1, 2, "=2*2");  in insertSheetFromfile()
332         SCUtil.setFormulaToCell(secondSheet, 1, 2, "=2*2");  in insertSheetFromfile()
333         SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=2*2");  in insertSheetFromfile()
336         SCUtil.saveFileAs(scComponent, "source", "xls");  in insertSheetFromfile()
337         SCUtil.closeFile(scDocument);  in insertSheetFromfile()
345         scDocument = SCUtil.getSCDocument(scComponent);  in insertSheetFromfile()
350         XSpreadsheet firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument,  in insertSheetFromfile()
360         XSpreadsheet secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument,  in insertSheetFromfile()
370         XSpreadsheet thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument,  in insertSheetFromfile()
379                 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2));  in insertSheetFromfile()
381                 SCUtil.getTextFromCell(firstexternalsheet, 1, 2));  in insertSheetFromfile()
385                 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2));  in insertSheetFromfile()
387                 SCUtil.getTextFromCell(secondexternalsheet, 1, 2));  in insertSheetFromfile()
391                 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2));  in insertSheetFromfile()
393                 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2));  in insertSheetFromfile()
396         SCUtil.saveFileAs(scComponent, "linked", "ods");  in insertSheetFromfile()
397         XSpreadsheetDocument tempscDocument = SCUtil.reloadFile(unoApp,  in insertSheetFromfile()
400         firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3);  in insertSheetFromfile()
401         secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 4);  in insertSheetFromfile()
402         thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 5);  in insertSheetFromfile()
406                 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2));  in insertSheetFromfile()
408                 SCUtil.getTextFromCell(firstexternalsheet, 1, 2));  in insertSheetFromfile()
412                 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2));  in insertSheetFromfile()
414                 SCUtil.getTextFromCell(secondexternalsheet, 1, 2));  in insertSheetFromfile()
418                 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2));  in insertSheetFromfile()
420                 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2));  in insertSheetFromfile()
423         SCUtil.save(scDocument);  in insertSheetFromfile()
424         SCUtil.closeFile(scDocument);  in insertSheetFromfile()
427         XSpreadsheetDocument sourcescDocument = SCUtil.reloadFile(unoApp,  in insertSheetFromfile()
429         firstSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 0);  in insertSheetFromfile()
430         secondSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 1);  in insertSheetFromfile()
431         thirdSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 2);  in insertSheetFromfile()
432         SCUtil.setFormulaToCell(firstSheet, 1, 2, "=3*3");  in insertSheetFromfile()
433         SCUtil.setFormulaToCell(secondSheet, 1, 2, "=3*3");  in insertSheetFromfile()
434         SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=3*3");  in insertSheetFromfile()
435         SCUtil.save(sourcescDocument);  in insertSheetFromfile()
436         SCUtil.closeFile(sourcescDocument);  in insertSheetFromfile()
439         tempscDocument = SCUtil.reloadFile(unoApp, scDocument, "linked.ods");  in insertSheetFromfile()
443         firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3);  in insertSheetFromfile()
444         secondexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 4);  in insertSheetFromfile()
445         thirdexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 5);  in insertSheetFromfile()
465                 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2));  in insertSheetFromfile()
467                 SCUtil.getTextFromCell(firstexternalsheet, 1, 2));  in insertSheetFromfile()
471                 SCUtil.getFormulaFromCell(secondexternalsheet, 1, 2));  in insertSheetFromfile()
473                 SCUtil.getTextFromCell(secondexternalsheet, 1, 2));  in insertSheetFromfile()
477                 SCUtil.getFormulaFromCell(thirdexternalsheet, 1, 2));  in insertSheetFromfile()
479                 SCUtil.getTextFromCell(thirdexternalsheet, 1, 2));  in insertSheetFromfile()
482         SCUtil.save(scDocument);  in insertSheetFromfile()