Lines Matching refs:scDocument
50 XSpreadsheetDocument scDocument = null; field in SheetBasicTest
82 scDocument = SCUtil.getSCDocument(scComponent); in insertRenameDeleteSheet()
83 XSpreadsheets spreadsheets = scDocument.getSheets(); 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()
102 scDocument, "TestSpreadsheet.ods"); in insertRenameDeleteSheet()
104 scDocument = scDocumentTemp; in insertRenameDeleteSheet()
105 String sheetnameaftermove = SCUtil.getSCSheetNameByIndex(scDocument, in insertRenameDeleteSheet()
112 scDocument.getSheets().removeByName(changedname); 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()
137 XSpreadsheets spreadsheets = scDocument.getSheets(); in copypastesheet()
143 scDocument, "TestCopysheet.xls"); in copypastesheet()
144 scDocument = scDocumentTemp; in copypastesheet()
147 .getSCSheetByIndex(scDocument, (short) 2); in copypastesheet()
162 scDocument = SCUtil.getSCDocument(scComponent); in movesheet()
163 XSpreadsheets spreadsheets = scDocument.getSheets(); in movesheet()
167 SCUtil.setSCSheetNameByIndex(scDocument, (short) 0, sheetname); in movesheet()
172 .getSCSheetByIndex(scDocument, (short) 0); in movesheet()
177 scDocument, (short) 1); in movesheet()
185 scDocument, "Testmovesheet.xls"); in movesheet()
186 scDocument = scDocumentTemp; in movesheet()
191 scDocument, (short) 0); in movesheet()
196 String sheetnameAfterMove = SCUtil.getSCSheetNameByIndex(scDocument, in movesheet()
202 XSpreadsheet sheetaftermove = SCUtil.getSCSheetByIndex(scDocument, in movesheet()
218 scDocument = SCUtil.getSCDocument(scComponent); in hideShowSheet()
219 XSpreadsheets spreadsheets = scDocument.getSheets(); 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()
239 scDocument, "Testhideshowsheet.xls"); in hideShowSheet()
240 scDocument = scDocumentTemp; 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()
273 XSpreadsheets spreadsheets = scDocument.getSheets(); in sheetColor()
274 XSpreadsheet firstSpreadSheet = SCUtil.getSCSheetByIndex(scDocument, in sheetColor()
284 SCUtil.getSCSheetNameByIndex(scDocument, (short) 0), in sheetColor()
290 scDocument, "Testcolorsheet.ods"); in sheetColor()
291 scDocument = scDocumentTemp; 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()
323 XSpreadsheets spreadsheets = scDocument.getSheets(); 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()
336 SCUtil.closeFile(scDocument); in insertSheetFromfile()
344 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromfile()
345 spreadsheets = scDocument.getSheets(); 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()
397 scDocument, "linked.ods"); in insertSheetFromfile()
398 scDocument = tempscDocument; 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()
422 SCUtil.save(scDocument); in insertSheetFromfile()
423 SCUtil.closeFile(scDocument); in insertSheetFromfile()
427 scDocument, "source.xls"); in insertSheetFromfile()
438 tempscDocument = SCUtil.reloadFile(unoApp, scDocument, "linked.ods"); in insertSheetFromfile()
439 scDocument = tempscDocument; in insertSheetFromfile()
440 spreadsheets = scDocument.getSheets(); 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()
448 .queryInterface(XPropertySet.class, scDocument); in insertSheetFromfile()
481 SCUtil.save(scDocument); in insertSheetFromfile()