/aoo4110/test/testuno/source/fvt/uno/sc/data/ |
H A D | SubtotalsForGroup.java | 32 import testlib.uno.SCUtil; 80 scDocument = SCUtil.getSCDocument(scComponent); in testForSecondGroup() 119 SCUtil.getFormulaFromCell(currentsheet, 2, 2)); in testForSecondGroup() 128 SCUtil.getFormulaFromCell(currentsheet, 2, 4)); in testForSecondGroup() 137 SCUtil.getFormulaFromCell(currentsheet, 2, 6)); in testForSecondGroup() 146 SCUtil.getFormulaFromCell(currentsheet, 1, 7)); in testForSecondGroup() 155 SCUtil.getFormulaFromCell(currentsheet, 2, 9)); in testForSecondGroup() 226 SCUtil.getFormulaFromCell(currentsheet, 2, 2)); in testForSecondGroup() 235 SCUtil.getFormulaFromCell(currentsheet, 2, 4)); in testForSecondGroup() 244 SCUtil.getFormulaFromCell(currentsheet, 2, 6)); in testForSecondGroup() [all …]
|
H A D | StandardFilterOption.java | 32 import testlib.uno.SCUtil; 117 SCUtil.save(scDocument); in testStandardFilterForString() 118 SCUtil.closeFile(scDocument); in testStandardFilterForString() 190 SCUtil.save(scDocument); in testStandardFilterOptionCaseSensitive() 191 SCUtil.closeFile(scDocument); in testStandardFilterOptionCaseSensitive() 261 SCUtil.save(scDocument); in testStandardFilterOptionContainsHeader() 262 SCUtil.closeFile(scDocument); in testStandardFilterOptionContainsHeader() 346 SCUtil.save(scDocument); in testStandardFilterOptionCopyOutput() 347 SCUtil.closeFile(scDocument); in testStandardFilterOptionCopyOutput() 438 SCUtil.save(scDocument); in testStandardFilterOptionSkipDuplicates() [all …]
|
H A D | SubTotalsFunction.java | 37 import testlib.uno.SCUtil; 129 scDocument = SCUtil.getSCDocument(scComponent); in test() 164 SCUtil.getTextFromCell(currentsheet, 0, 4)); in test() 174 SCUtil.getTextFromCell(currentsheet, 0, 7)); in test() 183 SCUtil.getFormulaFromCell(currentsheet, 2, 10)); in test() 185 SCUtil.getTextFromCell(currentsheet, 0, 10)); in test() 196 SCUtil.getTextFromCell(currentsheet, 0, 11)); in test() 214 SCUtil.getTextFromCell(currentsheet, 0, 4)); in test() 224 SCUtil.getTextFromCell(currentsheet, 0, 7)); in test() 235 SCUtil.getTextFromCell(currentsheet, 0, 10)); in test() [all …]
|
H A D | DataSort.java | 31 import testlib.uno.SCUtil; 79 scDocument = SCUtil.getSCDocument(scComponent); in singleFieldSort() 130 currentsheet = SCUtil.getCurrentSheet(scDocument); in singleFieldSort() 141 scDocument = SCUtil.getSCDocument(scComponent); in sortByTwoFields() 196 currentsheet = SCUtil.getCurrentSheet(scDocument); in sortByTwoFields() 207 scDocument = SCUtil.getSCDocument(scComponent); in sortByThreeField() 268 currentsheet = SCUtil.getCurrentSheet(scDocument); in sortByThreeField() 278 scDocument = SCUtil.getSCDocument(scComponent); in sortOption() 342 SCUtil.saveFileAs(scComponent, "SortOption", "xls"); in sortOption() 346 currentsheet = SCUtil.getCurrentSheet(scDocument); in sortOption() [all …]
|
H A D | AdvanceFilter.java | 32 import testlib.uno.SCUtil; 84 scDocument = SCUtil.openFile(sample, unoApp); in testStandardFilterForString() 86 …XCellRange xdataRange = (XCellRange) UnoRuntime.queryInterface(XCellRange.class, SCUtil.getCurrent… in testStandardFilterForString() 87 XSpreadsheet currentsheet = SCUtil.getCurrentSheet(scDocument); in testStandardFilterForString() 116 SCUtil.save(scDocument); in testStandardFilterForString() 117 SCUtil.closeFile(scDocument); in testStandardFilterForString() 118 scDocument = SCUtil.openFile(sample, unoApp); in testStandardFilterForString() 121 …xdataRange = (XCellRange) UnoRuntime.queryInterface(XCellRange.class, SCUtil.getCurrentSheet(scDoc… in testStandardFilterForString()
|
H A D | StardarFilterTest.java | 37 import testlib.uno.SCUtil; 121 scDocument = SCUtil.openFile(sample, unoApp); in testStandardFilter() 124 …XCellRange xdataRange = (XCellRange) UnoRuntime.queryInterface(XCellRange.class, SCUtil.getCurrent… in testStandardFilter() 150 SCUtil.save(scDocument); in testStandardFilter() 151 SCUtil.closeFile(scDocument); in testStandardFilter() 152 scDocument = SCUtil.openFile(sample, unoApp); in testStandardFilter() 155 …xdataRange = (XCellRange) UnoRuntime.queryInterface(XCellRange.class, SCUtil.getCurrentSheet(scDoc… in testStandardFilter() 163 SCUtil.save(scDocument); in testStandardFilter()
|
H A D | ValidityTypeTest.java | 36 import testlib.uno.SCUtil; 163 scDocument = SCUtil.getSCDocument(scComponent); in test() 164 XSpreadsheet currentsheet = SCUtil.getCurrentSheet(scDocument); in test() 200 SCUtil.saveFileAs(scComponent, "Validationtest", extName); in test() 201 XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp, in test() 204 currentsheet = SCUtil.getCurrentSheet(scDocument); in test()
|
/aoo4110/test/testuno/source/fvt/uno/sc/sheet/ |
H A D | SheetBasicTest.java | 30 import testlib.uno.SCUtil; 114 SCUtil.save(scDocumentTemp); in insertRenameDeleteSheet() 144 XSpreadsheet copysheet = SCUtil in copypastesheet() 169 XSpreadsheet movesheet = SCUtil in movesheet() 261 SCUtil.save(scDocument); in hideShowSheet() 333 SCUtil.closeFile(scDocument); in insertSheetFromfile() 419 SCUtil.save(scDocument); in insertSheetFromfile() 420 SCUtil.closeFile(scDocument); in insertSheetFromfile() 431 SCUtil.save(sourcescDocument); in insertSheetFromfile() 432 SCUtil.closeFile(sourcescDocument); in insertSheetFromfile() [all …]
|
/aoo4110/test/testuno/source/fvt/uno/sc/chart/ |
H A D | ChartTitle.java | 41 import testlib.uno.SCUtil; 103 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 120 SCUtil.clearTempDir(); in tearDownConnection() 157 SCUtil.setChartType(xChartDocument, inputType); in testCreateMainTitle() 168 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateMainTitle() 173 SCUtil.closeFile(scDocument); in testCreateMainTitle() 214 SCUtil.setChartType(xChartDocument, inputType); in testCreateSubTitle() 224 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateSubTitle() 229 SCUtil.closeFile(scDocument); in testCreateSubTitle() 284 sheet = SCUtil.getCurrentSheet(scDocument); in testInputTitles() [all …]
|
H A D | ChartGrid.java | 39 import testlib.uno.SCUtil; 115 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 132 SCUtil.clearTempDir(); in tearDownConnection() 167 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testCreateXYGrid() 174 SCUtil.setChartType(xChartDocument, inputType); in testCreateXYGrid() 190 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCreateXYGrid() 192 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateXYGrid() 201 SCUtil.closeFile(scDocument); in testCreateXYGrid() 246 SCUtil.setChartType(xChartDocument, inputType); in testCreateXYZGrid() 269 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateXYZGrid() [all …]
|
H A D | ChartAxis.java | 39 import testlib.uno.SCUtil; 115 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 132 SCUtil.clearTempDir(); in tearDownConnection() 167 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testCreateXYAxes() 174 SCUtil.setChartType(xChartDocument, inputType); in testCreateXYAxes() 199 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCreateXYAxes() 201 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateXYAxes() 210 SCUtil.closeFile(scDocument); in testCreateXYAxes() 255 SCUtil.setChartType(xChartDocument, inputType); in testCreateXYZAxes() 271 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateXYZAxes() [all …]
|
H A D | ChartLegend.java | 41 import testlib.uno.SCUtil; 104 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 121 SCUtil.clearTempDir(); in tearDownConnection() 154 SCUtil.setChartType(xChartDocument, inputType); in testDisableLegend() 160 SCUtil.saveFileAs(scComponent, fileName, fileType); in testDisableLegend() 162 sheet = SCUtil.getCurrentSheet(scDocument); in testDisableLegend() 167 SCUtil.closeFile(scDocument); in testDisableLegend() 205 SCUtil.setChartType(xChartDocument, inputType); in testLegendPosition() 212 SCUtil.saveFileAs(scComponent, fileName, fileType); in testLegendPosition() 214 sheet = SCUtil.getCurrentSheet(scDocument); in testLegendPosition() [all …]
|
H A D | ChartYErrorBar.java | 39 import testlib.uno.SCUtil; 111 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 128 SCUtil.clearTempDir(); in tearDownConnection() 155 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCreateYErrorBar() 157 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testCreateYErrorBar() 164 SCUtil.setChartType(xChartDocument, inputType); in testCreateYErrorBar() 167 SCUtil.setProperties(xDiagram, "ErrorCategory", inputCategory); in testCreateYErrorBar() 170 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCreateYErrorBar() 172 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateYErrorBar() 174 xChartDocument = SCUtil.getChartByName(sheet, chartName); in testCreateYErrorBar() [all …]
|
H A D | ChartDataLabel.java | 39 import testlib.uno.SCUtil; 112 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 129 SCUtil.clearTempDir(); in tearDownConnection() 155 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCreateDataLabel() 157 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testCreateDataLabel() 160 cellAddress[0] = SCUtil.getChartDataRangeByName(sheet, cellRangeName); in testCreateDataLabel() 164 SCUtil.setChartType(xChartDocument, inputType); in testCreateDataLabel() 168 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCreateDataLabel() 170 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateDataLabel() 172 xChartDocument = SCUtil.getChartByName(sheet, chartName); in testCreateDataLabel() [all …]
|
H A D | ChartMeanValueLine.java | 40 import testlib.uno.SCUtil; 101 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 118 SCUtil.clearTempDir(); in tearDownConnection() 144 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCreateTrendline() 146 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testCreateTrendline() 153 SCUtil.setChartType(xChartDocument, inputType); in testCreateTrendline() 156 SCUtil.setProperties(xDiagram, "MeanValue", meanValueLine); in testCreateTrendline() 158 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCreateTrendline() 160 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateTrendline() 162 xChartDocument = SCUtil.getChartByName(sheet, chartName); in testCreateTrendline() [all …]
|
H A D | ChartTrendline.java | 39 import testlib.uno.SCUtil; 104 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 121 SCUtil.clearTempDir(); in tearDownConnection() 147 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCreateTrendline() 149 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testCreateTrendline() 156 SCUtil.setChartType(xChartDocument, inputType); in testCreateTrendline() 159 SCUtil.setProperties(xDiagram, "RegressionCurves", trendlineType); in testCreateTrendline() 161 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCreateTrendline() 163 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateTrendline() 165 xChartDocument = SCUtil.getChartByName(sheet, chartName); in testCreateTrendline() [all …]
|
H A D | ChartType.java | 39 import testlib.uno.SCUtil; 113 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 130 SCUtil.clearTempDir(); in tearDownConnection() 155 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCreateChart() 157 SCUtil.setValueToCellRange(sheet, 0, 0, numberData); in testCreateChart() 160 cellAddress[0] = SCUtil.getChartDataRangeByName(sheet, cellRangeName); in testCreateChart() 165 SCUtil.setChartType(xChartDocument, inputType); in testCreateChart() 167 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCreateChart() 169 sheet = SCUtil.getCurrentSheet(scDocument); in testCreateChart() 171 xChartDocument = SCUtil.getChartByName(sheet, chartName); in testCreateChart() [all …]
|
/aoo4110/test/testuno/source/fvt/uno/sc/cell/ |
H A D | CellEffectOverline.java | 42 import testlib.uno.SCUtil; 132 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 149 SCUtil.clearTempDir(); in tearDownConnection() 172 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCharOverline() 179 SCUtil.setTextToCell(cells[1], inputType[0]); in testCharOverline() 184 SCUtil.setCellProperties(cells[i], inputType[0], inputStyle); in testCharOverline() 186 SCUtil.setCellProperties(cells[i], inputType[1], true); in testCharOverline() 187 SCUtil.setCellProperties(cells[i], inputType[2], inputColor); in testCharOverline() 191 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCharOverline() 193 sheet = SCUtil.getCurrentSheet(scDocument); in testCharOverline() [all …]
|
H A D | CellEffectUnderline.java | 42 import testlib.uno.SCUtil; 131 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 148 SCUtil.clearTempDir(); in tearDownConnection() 171 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCharUnderline() 178 SCUtil.setTextToCell(cells[1], inputType[0]); in testCharUnderline() 183 SCUtil.setCellProperties(cells[i], inputType[0], inputStyle); in testCharUnderline() 185 SCUtil.setCellProperties(cells[i], inputType[1], true); in testCharUnderline() 186 SCUtil.setCellProperties(cells[i], inputType[2], inputColor); in testCharUnderline() 190 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCharUnderline() 192 sheet = SCUtil.getCurrentSheet(scDocument); in testCharUnderline() [all …]
|
H A D | CellFontSize.java | 40 import testlib.uno.SCUtil; 95 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 112 SCUtil.clearTempDir(); in tearDownConnection() 133 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCellFontSize() 140 SCUtil. setTextToCell(cells[1], inputType); in testCellFontSize() 145 SCUtil.setCellProperties(cells[i], inputType, inputData[i]); in testCellFontSize() 148 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCellFontSize() 149 scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType); in testCellFontSize() 150 sheet = SCUtil.getCurrentSheet(scDocument); in testCellFontSize() 154 results[i] = ((Float) SCUtil.getCellProperties(cells[i], inputType)).floatValue(); in testCellFontSize() [all …]
|
H A D | CellColor.java | 40 import testlib.uno.SCUtil; 100 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 117 SCUtil.clearTempDir(); in tearDownConnection() 139 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCellColor() 146 SCUtil. setTextToCell(cells[1], inputType); in testCellColor() 151 SCUtil.setCellProperties(cells[i], inputType, inputData[i]); in testCellColor() 154 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCellColor() 155 scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType); in testCellColor() 156 sheet = SCUtil.getCurrentSheet(scDocument); in testCellColor() 160 results[i] = ((Integer) SCUtil.getCellProperties(cells[i], inputType)).intValue(); in testCellColor() [all …]
|
H A D | CellProtected.java | 40 import testlib.uno.SCUtil; 106 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 123 SCUtil.clearTempDir(); in tearDownConnection() 144 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCellProtected() 151 SCUtil. setTextToCell(cells[1], inputType); in testCellProtected() 156 SCUtil.setCellProperties(cells[i], inputType, inputProtectProps); in testCellProtected() 159 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCellProtected() 160 scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType); in testCellProtected() 161 sheet = SCUtil.getCurrentSheet(scDocument); in testCellProtected() 165 results[i] = (CellProtection) SCUtil.getCellProperties(cells[i], inputType); in testCellProtected() [all …]
|
H A D | CellAlignment.java | 41 import testlib.uno.SCUtil; 107 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 124 SCUtil.clearTempDir(); in tearDownConnection() 145 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCellAlignment() 156 SCUtil. setTextToCell(cells[1], "alignment"); in testCellAlignment() 161 SCUtil.setCellProperties(cells[i], inputType, inputValue); in testCellAlignment() 164 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCellAlignment() 166 scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName+"." + fileType); in testCellAlignment() 167 sheet = SCUtil.getCurrentSheet(scDocument); in testCellAlignment() 170 results[i] = (Enum) SCUtil.getCellProperties(cells[i], inputType); in testCellAlignment() [all …]
|
H A D | CellBorder.java | 40 import testlib.uno.SCUtil; 145 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 162 SCUtil.clearTempDir(); in tearDownConnection() 184 XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument); in testCellBorder() 191 SCUtil. setTextToCell(cells[1], "all border"); in testCellBorder() 197 SCUtil.setCellProperties(cells[i], borderType[j], borderLine); in testCellBorder() 201 SCUtil.saveFileAs(scComponent, fileName, fileType); in testCellBorder() 202 scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType); in testCellBorder() 203 sheet = SCUtil.getCurrentSheet(scDocument); in testCellBorder() 208 results[i][j] = (BorderLine) SCUtil.getCellProperties(cells[i], borderType[j]); in testCellBorder() [all …]
|
/aoo4110/test/testuno/source/fvt/uno/sc/object/ |
H A D | DrawingObject.java | 39 import testlib.uno.SCUtil; 98 scDocument = SCUtil.getSCDocument(scComponent); in setUp() 115 SCUtil.clearTempDir(); in tearDownConnection() 135 scDocument = SCUtil.getSCDocument(scComponent); in testDrawingObject() 136 XSpreadsheet xSheet = SCUtil.getCurrentSheet(scDocument); in testDrawingObject() 154 SCUtil.saveFileAs(scComponent, fileName, fileType); in testDrawingObject() 155 scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType); in testDrawingObject() 157 xSheet = SCUtil.getCurrentSheet(scDocument); in testDrawingObject() 180 SCUtil.save(scDocument); in testDrawingObject() 183 scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType); in testDrawingObject() [all …]
|