poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From a...@apache.org
Subject cvs commit: jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel TestBugs.java
Date Wed, 08 Oct 2003 18:07:32 GMT
avik        2003/10/08 11:07:32

  Modified:    src/testcases/org/apache/poi/hssf/usermodel Tag:
                        REL_2_BRANCH TestBugs.java
  Added:       src/testcases/org/apache/poi/hssf/data Tag: REL_2_BRANCH
                        15375.xls
  Log:
  Testcases for bug 15375
  
  Revision  Changes    Path
  No                   revision
  No                   revision
  1.1.2.1   +18 -0     jakarta-poi/src/testcases/org/apache/poi/hssf/data/Attic/15375.xls
  
  	<<Binary file>>
  
  
  No                   revision
  No                   revision
  1.1.2.8   +123 -1    jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java
  
  Index: TestBugs.java
  ===================================================================
  RCS file: /home/cvs/jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java,v
  retrieving revision 1.1.2.7
  retrieving revision 1.1.2.8
  diff -u -r1.1.2.7 -r1.1.2.8
  --- TestBugs.java	6 Oct 2003 17:40:08 -0000	1.1.2.7
  +++ TestBugs.java	8 Oct 2003 18:07:32 -0000	1.1.2.8
  @@ -74,6 +74,8 @@
           super(s);
       }
       
  +    /** Test reading AND writing a complicated workbook
  +     *Test opening resulting sheet in excel*/
             public void test15228()
           throws java.io.IOException
       {
  @@ -109,7 +111,8 @@
             assertTrue("File Should Exist", file.exists());
               
       }
  -                 
  +     /**Test writing a hyperlink
  +      * Open resulting sheet in Excel and check that A1 contains a hyperlink*/        
   
        public void test23094() throws Exception {
            File file = File.createTempFile("test23094",".xls");
            FileOutputStream out    = new FileOutputStream(file);
  @@ -165,6 +168,125 @@
              assertTrue("No exception throws", true);
          }
       
  +       /** test rewriting a file with large number of unique strings
  +        *open resulting file in Excel to check results!*/
  +       public void test15375() {
  +           
  +           try {
  +               String filename = System.getProperty("HSSF.testdata.path");
  +               filename=filename+"/15375.xls";
  +               FileInputStream in = new FileInputStream(filename);
  +               HSSFWorkbook wb = new HSSFWorkbook(in);
  +               HSSFSheet sheet = wb.getSheetAt(0);
  +               
  +               HSSFRow row = sheet.getRow(5);
  +               HSSFCell cell = row.getCell((short)3);
  +               if (cell == null)
  +                   cell = row.createCell((short)3);
  +               
  +               // Write test
  +               cell.setCellType(HSSFCell.CELL_TYPE_STRING);
  +               cell.setCellValue("a test");
  +               
  +               // change existing numeric cell value
  +               
  +               HSSFRow oRow = sheet.getRow(14);
  +               HSSFCell oCell = oRow.getCell((short)4);
  +               oCell.setCellValue(75);
  +               oCell = oRow.getCell((short)5);
  +               oCell.setCellValue("0.3");
  +               
  +               // Write the output to a file
  +               File f = File.createTempFile("test15375",".xls");
  +               FileOutputStream fileOut = new FileOutputStream(f);
  +               wb.write(fileOut);
  +               fileOut.close();
  +           }
  +           catch (java.io.FileNotFoundException ex) {
  +               ex.printStackTrace();
  +           }
  +           catch (java.io.IOException ex) {
  +               ex.printStackTrace();
  +           }
  +           
  +       }
  +       
  +       /** test writing a file with large number of unique strings
  +        *open resulting file in Excel to check results!*/
  +       
  +       public void test15375_2() throws Exception{
  +           
  +           
  +           HSSFWorkbook wb = new HSSFWorkbook();
  +           HSSFSheet sheet = wb.createSheet();
  +           
  +           String tmp1 = null;
  +           String tmp2 = null;
  +           String tmp3 = null;
  +           
  +           for (int i = 0; i < 6000; i++) {
  +               tmp1 = "Test1" + i;
  +               tmp2 = "Test2" + i;
  +               tmp3 = "Test3" + i;
  +               
  +               HSSFRow row = sheet.createRow((short)i);
  +               
  +               HSSFCell cell = row.createCell((short)0);
  +               cell.setCellValue(tmp1);
  +               cell = row.createCell((short)1);
  +               cell.setCellValue(tmp2);
  +               cell = row.createCell((short)2);
  +               cell.setCellValue(tmp3);
  +           }
  +           File f = File.createTempFile("test15375-2",".xls");
  +           FileOutputStream fileOut = new FileOutputStream(f);
  +           wb.write(fileOut);
  +           fileOut.close();
  +       }
  +       /** another test for the number of unique strings issue
  +        *test opening the resulting file in Excel*/
  +       public void test22568() {
  +           int r=2000;int c=3;
  +           
  +           HSSFWorkbook wb = new HSSFWorkbook() ;
  +           HSSFSheet sheet = wb.createSheet("ExcelTest") ;
  +           
  +           int col_cnt=0, rw_cnt=0 ;
  +           
  +           col_cnt = c;
  +           rw_cnt = r;
  +           
  +           HSSFRow rw = null ;
  +           HSSFCell cell =null;
  +           rw = sheet.createRow((short)0) ;
  +           //Header row
  +           for(short j=0; j<col_cnt; j++){
  +               cell = rw.createCell((short)j) ;
  +               cell.setCellValue("Col " + (j+1)) ;
  +           }
  +           
  +           for(int i=1; i<rw_cnt; i++){
  +               rw = sheet.createRow((short)i) ;
  +               for(short j=0; j<col_cnt; j++){
  +                   cell = rw.createCell((short)j) ;
  +                   cell.setCellValue("Row:" + (i+1) + ",Column:" +
  +                   (j+1)) ;
  +               }
  +           }
  +           
  +           sheet.setDefaultColumnWidth((short) 18) ;
  +           
  +           try {
  +               File f = File.createTempFile("test22568",".xls");
  +               FileOutputStream out = new FileOutputStream(f) ;
  +               wb.write(out) ;
  +               
  +               out.close() ;
  +           }
  +           catch(java.io.IOException io_Excp) {
  +               System.out.println(io_Excp.getMessage()) ;
  +           }
  +       }
   }
       
   
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org


Mime
View raw message