51     XSpreadsheetDocument scDocument = null;  field in SheetBasicTest
83         scDocument = SCUtil.getSCDocument(scComponent);  in insertRenameDeleteSheet()
84         XSpreadsheets spreadsheets = scDocument.getSheets();  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()
103                 scDocument, "TestSpreadsheet.ods");  in insertRenameDeleteSheet()
105         scDocument = scDocumentTemp;  in insertRenameDeleteSheet()
106         String sheetnameaftermove = SCUtil.getSCSheetNameByIndex(scDocument,  in insertRenameDeleteSheet()
113         scDocument.getSheets().removeByName(changedname);  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()
138         XSpreadsheets spreadsheets = scDocument.getSheets();  in copypastesheet()
144                 scDocument, "TestCopysheet.xls");  in copypastesheet()
145         scDocument = scDocumentTemp;  in copypastesheet()
148                 .getSCSheetByIndex(scDocument, (short) 2);  in copypastesheet()
163         scDocument = SCUtil.getSCDocument(scComponent);  in movesheet()
164         XSpreadsheets spreadsheets = scDocument.getSheets();  in movesheet()
168         SCUtil.setSCSheetNameByIndex(scDocument, (short) 0, sheetname);  in movesheet()
173                 .getSCSheetByIndex(scDocument, (short) 0);  in movesheet()
178                 scDocument, (short) 1);  in movesheet()
186                 scDocument, "Testmovesheet.xls");  in movesheet()
187         scDocument = scDocumentTemp;  in movesheet()
192                 scDocument, (short) 0);  in movesheet()
197         String sheetnameAfterMove = SCUtil.getSCSheetNameByIndex(scDocument,  in movesheet()
203         XSpreadsheet sheetaftermove = SCUtil.getSCSheetByIndex(scDocument,  in movesheet()
219         scDocument = SCUtil.getSCDocument(scComponent);  in hideShowSheet()
220         XSpreadsheets spreadsheets = scDocument.getSheets();  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()
240                 scDocument, "Testhideshowsheet.xls");  in hideShowSheet()
241         scDocument = scDocumentTemp;  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()
274         XSpreadsheets spreadsheets = scDocument.getSheets();  in sheetColor()
275         XSpreadsheet firstSpreadSheet = SCUtil.getSCSheetByIndex(scDocument,  in sheetColor()
285                 SCUtil.getSCSheetNameByIndex(scDocument, (short) 0),  in sheetColor()
291                 scDocument, "Testcolorsheet.ods");  in sheetColor()
292         scDocument = scDocumentTemp;  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()
324         XSpreadsheets spreadsheets = scDocument.getSheets();  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()
337         SCUtil.closeFile(scDocument);  in insertSheetFromfile()
345         scDocument = SCUtil.getSCDocument(scComponent);  in insertSheetFromfile()
346         spreadsheets = scDocument.getSheets();  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()
398                 scDocument, "linked.ods");  in insertSheetFromfile()
399         scDocument = tempscDocument;  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()
423         SCUtil.save(scDocument);  in insertSheetFromfile()
424         SCUtil.closeFile(scDocument);  in insertSheetFromfile()
428                 scDocument, "source.xls");  in insertSheetFromfile()
439         tempscDocument = SCUtil.reloadFile(unoApp, scDocument, "linked.ods");  in insertSheetFromfile()
440         scDocument = tempscDocument;  in insertSheetFromfile()
441         spreadsheets = scDocument.getSheets();  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()
449                 .queryInterface(XPropertySet.class, scDocument);  in insertSheetFromfile()
482         SCUtil.save(scDocument);  in insertSheetFromfile()