Package org.openxmlformats.schemas.spreadsheetml.x2006.main

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols.sizeOfColArray()

306
307
308
309
310
311
312
313
314
315
316
        //three level
        sheet.groupColumn((short) 6, (short) 8);
        sheet.groupColumn((short) 2, (short) 3);
        cols = sheet.getCTWorksheet().getColsArray(0);
        assertEquals(7, cols.sizeOfColArray());
        colArray = cols.getColArray();
        assertEquals(3, colArray[1].getOutlineLevel());
        assertEquals(3, sheet.getCTWorksheet().getSheetFormatPr().getOutlineLevelCol());

        sheet.ungroupColumn((short) 8, (short) 10);
View Full Code Here
387
388
389
390
391
392
393
394
395
396
397
    public void testSetColumnGroupCollapsed(){
      Workbook wb = new XSSFWorkbook();
      XSSFSheet sheet1 =(XSSFSheet) wb.createSheet();

      CTCols cols=sheet1.getCTWorksheet().getColsArray(0);
      assertEquals(0,cols.sizeOfColArray());

      sheet1.groupColumn( (short)4, (short)7 );
      sheet1.groupColumn( (short)9, (short)12 );

      assertEquals(2,cols.sizeOfColArray());
View Full Code Here
392
393
394
395
396
397
398
399
400
401
402
      assertEquals(0,cols.sizeOfColArray());

      sheet1.groupColumn( (short)4, (short)7 );
      sheet1.groupColumn( (short)9, (short)12 );

      assertEquals(2,cols.sizeOfColArray());

      assertEquals(false,cols.getColArray(0).isSetHidden());
      assertEquals(true, cols.getColArray(0).isSetCollapsed());
      assertEquals(5, cols.getColArray(0).getMin()); // 1 based
      assertEquals(8, cols.getColArray(0).getMax()); // 1 based
View Full Code Here
404
405
406
407
408
409
410
411
412
413
414
      assertEquals(true, cols.getColArray(1).isSetCollapsed());
      assertEquals(10, cols.getColArray(1).getMin()); // 1 based
      assertEquals(13, cols.getColArray(1).getMax()); // 1 based

      sheet1.groupColumn( (short)10, (short)11 );
      assertEquals(4,cols.sizeOfColArray());

      assertEquals(false,cols.getColArray(0).isSetHidden());
      assertEquals(true, cols.getColArray(0).isSetCollapsed());
      assertEquals(5, cols.getColArray(0).getMin()); // 1 based
      assertEquals(8, cols.getColArray(0).getMax()); // 1 based
View Full Code Here
425
426
427
428
429
430
431
432
433
434
435
      assertEquals(13, cols.getColArray(3).getMin()); // 1 based
      assertEquals(13, cols.getColArray(3).getMax()); // 1 based

      // collapse columns - 1
      sheet1.setColumnGroupCollapsed( (short)5, true );
      assertEquals(5,cols.sizeOfColArray());

      assertEquals(true, cols.getColArray(0).isSetHidden());
      assertEquals(true, cols.getColArray(0).isSetCollapsed());
      assertEquals(5, cols.getColArray(0).getMin()); // 1 based
      assertEquals(8, cols.getColArray(0).getMax()); // 1 based
View Full Code Here
476
477
478
479
480
481
482
483
484
485
486
      assertEquals(13, cols.getColArray(4).getMax()); // 1 based


      //collapse - 2
      sheet1.setColumnGroupCollapsed( (short)9, true );
      assertEquals(6,cols.sizeOfColArray());
      assertEquals(false,cols.getColArray(0).isSetHidden());
      assertEquals(true, cols.getColArray(0).isSetCollapsed());
      assertEquals(5, cols.getColArray(0).getMin()); // 1 based
      assertEquals(8, cols.getColArray(0).getMax()); // 1 based
      assertEquals(false,cols.getColArray(1).isSetHidden());
View Full Code Here
505
506
507
508
509
510
511
512
513
514
515
      assertEquals(14, cols.getColArray(5).getMax()); // 1 based


      //expand - 2
      sheet1.setColumnGroupCollapsed( (short)9, false );
      assertEquals(6,cols.sizeOfColArray());
      assertEquals(14,cols.getColArray(5).getMin());

      //outline level 2: the line under ==> collapsed==True
      assertEquals(2,cols.getColArray(3).getOutlineLevel());
      assertEquals(true,cols.getColArray(4).isSetCollapsed());
View Full Code Here
540
541
542
543
544
545
546
547
548
549
550
      assertEquals(14, cols.getColArray(5).getMax()); // 1 based

      //DOCUMENTARE MEGLIO IL DISCORSO DEL LIVELLO
      //collapse - 3
      sheet1.setColumnGroupCollapsed( (short)10, true );
      assertEquals(6,cols.sizeOfColArray());
      assertEquals(false,cols.getColArray(0).isSetHidden());
      assertEquals(true, cols.getColArray(0).isSetCollapsed());
      assertEquals(5, cols.getColArray(0).getMin()); // 1 based
      assertEquals(8, cols.getColArray(0).getMax()); // 1 based
      assertEquals(false,cols.getColArray(1).isSetHidden());
View Full Code Here
569
570
571
572
573
574
575
576
577
578
579
      assertEquals(14, cols.getColArray(5).getMax()); // 1 based


      //expand - 3
      sheet1.setColumnGroupCollapsed( (short)10, false );
      assertEquals(6,cols.sizeOfColArray());
      assertEquals(false,cols.getColArray(0).getHidden());
      assertEquals(false,cols.getColArray(5).getHidden());
      assertEquals(false,cols.getColArray(4).isSetCollapsed());

//    write out and give back
View Full Code Here
578
579
580
581
582
583
584
585
586
587
588
//    write out and give back
      // Save and re-load
      wb = XSSFTestDataSamples.writeOutAndReadBack(wb);
      sheet1 = (XSSFSheet)wb.getSheetAt(0);
      assertEquals(6,cols.sizeOfColArray());

      assertEquals(false,cols.getColArray(0).isSetHidden());
      assertEquals(true, cols.getColArray(0).isSetCollapsed());
      assertEquals(5, cols.getColArray(0).getMin()); // 1 based
      assertEquals(8, cols.getColArray(0).getMax()); // 1 based
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.