incubator-ooo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liu...@apache.org
Subject svn commit: r1379298 - /incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/rowcolumn/ResizeHideShowRowColumn.java
Date Fri, 31 Aug 2012 05:48:22 GMT
Author: liuzhe
Date: Fri Aug 31 05:48:22 2012
New Revision: 1379298

URL: http://svn.apache.org/viewvc?rev=1379298&view=rev
Log:
#120701 - [testuno] Resize/hide/show row and column in spreadsheet.
Patch By: Guo Bin <binbjguo@gmail.com>
Review By: Liu Zhe <aliuzhe@gmail.com>

Added:
    incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/rowcolumn/ResizeHideShowRowColumn.java

Added: incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/rowcolumn/ResizeHideShowRowColumn.java
URL: http://svn.apache.org/viewvc/incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/rowcolumn/ResizeHideShowRowColumn.java?rev=1379298&view=auto
==============================================================================
--- incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/rowcolumn/ResizeHideShowRowColumn.java
(added)
+++ incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/rowcolumn/ResizeHideShowRowColumn.java
Fri Aug 31 05:48:22 2012
@@ -0,0 +1,251 @@
+package testcase.uno.sc.rowcolumn;
+
+import static org.junit.Assert.*;
+import static testlib.uno.SCUtil.*;
+
+import org.junit.After;
+import org.junit.Before;
+import org.junit.Test;
+import org.openoffice.test.uno.UnoApp;
+
+import com.sun.star.lang.XComponent;
+import com.sun.star.sheet.XSpreadsheet;
+import com.sun.star.sheet.XSpreadsheetDocument;
+import com.sun.star.sheet.XSpreadsheets;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.table.XTableColumns;
+import com.sun.star.table.XTableRows;
+import com.sun.star.table.XColumnRowRange;
+import com.sun.star.beans.XPropertySet;
+import com.sun.star.table.XCellRange;
+import com.sun.star.frame.XModel;
+import com.sun.star.frame.XController;
+import com.sun.star.frame.XStorable;
+import com.sun.star.sheet.XSpreadsheetView;
+
+
+public class ResizeHideShowRowColumn {
+
+	UnoApp unoApp = new UnoApp();
+	XSpreadsheetDocument scDocument = null;
+	XComponent scComponent = null;
+	
+	@Before
+	public void setUp() throws Exception {
+		unoApp.start();
+	}
+
+	@After
+	public void tearDown() throws Exception {
+		unoApp.closeDocument(scComponent);
+		unoApp.close();
+		}
+
+@Test
+public void testResizeColumn() throws Exception {
+	String sheetname = "AddTest";
+  	XPropertySet PropSet = null;
+	
+	//Create Spreadsheet file.
+	scComponent = unoApp.newDocument("scalc");
+	scDocument = (XSpreadsheetDocument) UnoRuntime.queryInterface(XSpreadsheetDocument.class,
scComponent);
+	
+	//Create a sheet at the first place.
+	XSpreadsheets spreadsheets = scDocument.getSheets();
+	spreadsheets.insertNewByName(sheetname, (short) 0);
+	Object sheetObj = spreadsheets.getByName(sheetname);
+
+	XSpreadsheet sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
+	
+	//Active the new sheet.
+	XModel scModel = (XModel) UnoRuntime.queryInterface(XModel.class, scDocument); 
+    XController scController = scModel.getCurrentController();
+    XSpreadsheetView sheetview = (XSpreadsheetView) UnoRuntime.queryInterface(XSpreadsheetView.class,
scController);
+    sheetview.setActiveSheet(sheet);
+    
+    //Set cell range to A1:B1
+    XCellRange CellRange = sheet.getCellRangeByPosition(0, 0, 1, 0);
+    
+    //Get column A1 by index
+    XColumnRowRange ColRowRange = (XColumnRowRange)UnoRuntime.queryInterface( XColumnRowRange.class,
CellRange );
+    XTableColumns Columns = ColRowRange.getColumns();
+    Object aColumnObj = Columns.getByIndex( 0 );
+ 
+    PropSet = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, aColumnObj);
+    
+    //Verify the default values of specified column A1
+    int expectedDefaultWidth = 2267;
+    
+    assertEquals("Verify default width value is 2267.", expectedDefaultWidth, PropSet.getPropertyValue("Width"));
+    assertTrue("Verify column is visible as default.",  (Boolean) PropSet.getPropertyValue("IsVisible"));
+    
+    //Resize width of column A1 to "6001"
+    PropSet.setPropertyValue( "Width", new Integer( 6001 ));
+
+    //Save and reload document
+    saveFileAs(scComponent, "TestColumn", "ods");
+    XSpreadsheetDocument TempSCDocument = reloadFile(unoApp, scDocument, "TestColumn.ods");
+    scDocument = TempSCDocument;
+    
+    spreadsheets = scDocument.getSheets();
+   	sheetObj = spreadsheets.getByName(sheetname);
+	sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
+	
+    //Set cell range to A1:B1
+    CellRange = sheet.getCellRangeByPosition(0, 0, 1, 0);
+    ColRowRange = (XColumnRowRange)UnoRuntime.queryInterface( XColumnRowRange.class, CellRange
);
+    Columns = ColRowRange.getColumns();
+    
+    //Get column A1 by index
+    aColumnObj = Columns.getByIndex( 0 );
+ 
+    PropSet = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, aColumnObj);
+
+    //Verify the  values of specified column A1 after resize
+       int expectedWidth = 6001;
+
+    assertEquals("Verify current width value is 6001.", expectedWidth, PropSet.getPropertyValue("Width"));
+    assertTrue("Verify column is visible as default.",  (Boolean) PropSet.getPropertyValue("IsVisible"));
+
+    //Set column is invisible
+    PropSet.setPropertyValue("IsVisible", new Boolean(false));
+   
+    //Save and reload document
+    //Save the modified spreadsheet first
+    save(TempSCDocument);
+    //close it and reload it
+    TempSCDocument = reloadFile(unoApp, scDocument, "TestColumn.ods");
+    scDocument = TempSCDocument;
+   
+    spreadsheets = scDocument.getSheets();
+	sheetObj = spreadsheets.getByName(sheetname);
+	sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
+    
+    //Set cell range to A1:B1
+    CellRange = sheet.getCellRangeByPosition(0, 0, 1, 0);
+    ColRowRange = (XColumnRowRange)UnoRuntime.queryInterface( XColumnRowRange.class, CellRange
);
+    Columns = ColRowRange.getColumns();
+    
+    //Get column A1 by index
+    aColumnObj = Columns.getByIndex( 0 );
+ 
+    PropSet = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, aColumnObj);
+    
+    //Verify the values of specified column A1 after save
+    assertFalse("Verify column A1 is invisible", (Boolean) PropSet.getPropertyValue("IsVisible"));
+    assertEquals("Verify current width value is 6001 after hide it.", expectedWidth, PropSet.getPropertyValue("Width"));
+    }
+
+@Test
+public void testResizeRow() throws Exception {
+	String sheetname = "AddTest";
+	XPropertySet PropSet = null;
+	
+	//Create Spreadsheet file.
+	scComponent = unoApp.newDocument("scalc");
+	scDocument = (XSpreadsheetDocument) UnoRuntime.queryInterface(XSpreadsheetDocument.class,
scComponent);
+	
+	//Create a sheet at the first place.
+	XSpreadsheets spreadsheets = scDocument.getSheets();
+	spreadsheets.insertNewByName(sheetname, (short) 0);
+	Object sheetObj = spreadsheets.getByName(sheetname);
+	XSpreadsheet sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
+	
+	//Active the new sheet.
+	XModel scModel = (XModel) UnoRuntime.queryInterface(XModel.class, scDocument); 
+    XController scController = scModel.getCurrentController();
+    XSpreadsheetView sheetview = (XSpreadsheetView) UnoRuntime.queryInterface(XSpreadsheetView.class,
scController);
+    sheetview.setActiveSheet(sheet);
+    
+    //Set cell range to A1:A2
+    XCellRange CellRange = sheet.getCellRangeByPosition(0, 0, 0, 1);
+    //XCell cell = sheet.getCellByPosition(1, 0);
+    XColumnRowRange ColRowRange = (XColumnRowRange)UnoRuntime.queryInterface( XColumnRowRange.class,
CellRange );
+    XTableRows Rows = ColRowRange.getRows();
+    
+    //Get Row 1 by index
+    Object aRowObj = Rows.getByIndex( 0 );
+
+    PropSet = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, aRowObj );
+    
+    //Verify the default values of specified Row 1
+    int expectedDefaultHeight = 453;
+    
+    assertEquals("Verify default width value is 453.", expectedDefaultHeight, PropSet.getPropertyValue("Height"));
+    assertTrue("Verify column is visible as default.",  (Boolean) PropSet.getPropertyValue("IsVisible"));
+
+    //Resize Height of Row 1 to "5001"
+    PropSet.setPropertyValue( "Height", new Integer( 5001 ) );
+
+    // Save and reload document
+    saveFileAs(scComponent, "TestRow", "xls");
+    XSpreadsheetDocument TempSCDocument = reloadFile(unoApp, scDocument, "TestRow.xls");
+    scDocument = TempSCDocument;
+    
+    spreadsheets = scDocument.getSheets();
+	sheetObj = spreadsheets.getByName(sheetname);
+	sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
+	
+    //Set cell range to A1:A2
+    CellRange = sheet.getCellRangeByPosition(0, 0, 0, 1);
+    ColRowRange = (XColumnRowRange)UnoRuntime.queryInterface( XColumnRowRange.class, CellRange
);
+    Rows = ColRowRange.getRows();
+ 
+    //Get Row 1 by index
+    aRowObj = Rows.getByIndex( 0 );
+
+    PropSet = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, aRowObj);
+
+    //Verify the  values of specified Row 1 after resize
+    int expectedHeight = 5001;
+
+    assertEquals("Verify current width value is 5001.", expectedHeight, PropSet.getPropertyValue("Height"));
+    assertTrue("Verify column is visible as default.", (Boolean) PropSet.getPropertyValue("IsVisible"));
+
+    //Set Row is invisible
+    PropSet.setPropertyValue("IsVisible", new Boolean(false));
+
+    //Save and reload document
+    //Save the modified spreadsheet first
+    save(TempSCDocument);
+    //Close and reload it
+    TempSCDocument = reloadFile(unoApp, scDocument, "TestRow.xls");
+    scDocument = TempSCDocument;
+    
+    spreadsheets = scDocument.getSheets();
+ 	sheetObj = spreadsheets.getByName(sheetname);
+ 	sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
+ 	
+    //Set cell range to A1:A2
+    CellRange = sheet.getCellRangeByPosition(0, 0, 0, 1);
+    ColRowRange = (XColumnRowRange)UnoRuntime.queryInterface( XColumnRowRange.class, CellRange
);
+    Rows = ColRowRange.getRows();
+  
+    //Get Row 1 by index
+    aRowObj = Rows.getByIndex( 0 );
+
+    PropSet = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, aRowObj);
+
+    //Verify the values of specified Row 1 after resize
+    assertEquals("Verify current width value is 5001 after hide it.", expectedHeight, PropSet.getPropertyValue("Height"));
+    assertFalse("Verify column is invisible.",  (Boolean) PropSet.getPropertyValue("IsVisible"));
+
+    }
+
+/* Save file after open file.
+* 
+* @param xSpreadsheetDocument
+* @throws Exception
+*/
+public static void save(XSpreadsheetDocument xSpreadsheetDocument)
+		throws Exception {
+
+	XStorable scStorable = (XStorable) UnoRuntime.queryInterface(
+			XStorable.class, xSpreadsheetDocument);
+	scStorable.store();
+
+    }
+
+}
+
+



Mime
View raw message