Lines Matching refs:SCUtil
61 import testlib.uno.SCUtil;
122 scDocument = SCUtil.getSCDocument(scComponent); in setUp()
124 XSpreadsheet firstSheet = SCUtil.getSCSheetByIndex(scDocument, in setUp()
126 XSpreadsheet secondSheet = SCUtil.getSCSheetByIndex(scDocument, in setUp()
128 XSpreadsheet thirdSheet = SCUtil.getSCSheetByIndex(scDocument, in setUp()
130 SCUtil.setFormulaToCell(firstSheet, 1, 2, "=1*2"); // cell B3 in setUp()
131 SCUtil.setFormulaToCell(secondSheet, 1, 2, "=2*2"); in setUp()
132 SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=3*2"); in setUp()
135 SCUtil.saveFileAs(scComponent, "source", "xls"); in setUp()
136 SCUtil.closeFile(scDocument); in setUp()
160 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromFileLinkedNormal()
232 XSpreadsheet firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromFileLinkedNormal()
242 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNormal()
244 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNormal()
250 SCUtil.saveFileAs(scComponent, "linked-normal", "ods"); in insertSheetFromFileLinkedNormal()
273 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromFileLinkedNormal()
277 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNormal()
279 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNormal()
285 SCUtil.save(scDocument); in insertSheetFromFileLinkedNormal()
286 SCUtil.closeFile(scDocument); in insertSheetFromFileLinkedNormal()
290 XSpreadsheetDocument sourcescDocument = SCUtil.reloadFile(unoApp, in insertSheetFromFileLinkedNormal()
292 XSpreadsheet firstSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 0); in insertSheetFromFileLinkedNormal()
293 SCUtil.setFormulaToCell(firstSheet, 1, 2, "=1*3"); in insertSheetFromFileLinkedNormal()
295 SCUtil.save(sourcescDocument); in insertSheetFromFileLinkedNormal()
296 SCUtil.closeFile(sourcescDocument); in insertSheetFromFileLinkedNormal()
324 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromFileLinkedNormal()
353 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNormal()
355 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNormal()
358 SCUtil.save(scDocument); in insertSheetFromFileLinkedNormal()
375 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromFileLinkedValue()
448 XSpreadsheet firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromFileLinkedValue()
461 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedValue()
463 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedValue()
469 SCUtil.saveFileAs(scComponent, "linked-value", "ods"); in insertSheetFromFileLinkedValue()
492 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromFileLinkedValue()
496 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedValue()
498 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedValue()
504 SCUtil.save(scDocument); in insertSheetFromFileLinkedValue()
505 SCUtil.closeFile(scDocument); in insertSheetFromFileLinkedValue()
508 XSpreadsheetDocument sourcescDocument = SCUtil.reloadFile(unoApp, in insertSheetFromFileLinkedValue()
510 XSpreadsheet secondSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 1); in insertSheetFromFileLinkedValue()
511 SCUtil.setFormulaToCell(secondSheet, 1, 2, "=2*3"); in insertSheetFromFileLinkedValue()
512 SCUtil.save(sourcescDocument); in insertSheetFromFileLinkedValue()
513 SCUtil.closeFile(sourcescDocument); in insertSheetFromFileLinkedValue()
541 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromFileLinkedValue()
570 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedValue()
572 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedValue()
575 SCUtil.save(scDocument); in insertSheetFromFileLinkedValue()
593 scDocument = SCUtil.getSCDocument(scComponent); in insertSheetFromFileLinkedNone()
657 XSpreadsheet firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, in insertSheetFromFileLinkedNone()
667 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNone()
669 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNone()
677 SCUtil.saveFileAs(scComponent, "linked-none", "ods"); in insertSheetFromFileLinkedNone()
700 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromFileLinkedNone()
704 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNone()
706 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNone()
712 SCUtil.save(scDocument); in insertSheetFromFileLinkedNone()
713 SCUtil.closeFile(scDocument); in insertSheetFromFileLinkedNone()
716 XSpreadsheetDocument sourcescDocument = SCUtil.reloadFile(unoApp, in insertSheetFromFileLinkedNone()
718 XSpreadsheet thirdSheet = SCUtil.getSCSheetByIndex(sourcescDocument, (short) 2); in insertSheetFromFileLinkedNone()
719 SCUtil.setFormulaToCell(thirdSheet, 1, 2, "=3*3"); in insertSheetFromFileLinkedNone()
720 SCUtil.save(sourcescDocument); in insertSheetFromFileLinkedNone()
721 SCUtil.closeFile(sourcescDocument); in insertSheetFromFileLinkedNone()
741 firstexternalsheet = SCUtil.getSCSheetByIndex(scDocument, (short) 3); in insertSheetFromFileLinkedNone()
756 SCUtil.getFormulaFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNone()
758 SCUtil.getTextFromCell(firstexternalsheet, 1, 2)); in insertSheetFromFileLinkedNone()
761 SCUtil.save(scDocument); in insertSheetFromFileLinkedNone()