Package org.zkoss.poi.ss.usermodel

Examples of org.zkoss.poi.ss.usermodel.CellStyle

72
73
74
75
76
77
78
79
80
81
82
83
84
85
      return "#000000";
    return  color;
  }
 
  public static String getBackgroundHTMLColor(Cell cell) {
    CellStyle cellStyle = cell.getCellStyle();
    Book book = (Book)cell.getSheet().getWorkbook();
    //bug#ZSS-34: cell background color does not show in excel
    String color = cellStyle.getFillPattern() != CellStyle.NO_FILL ?
        BookHelper.colorToHTML(book, cellStyle.getFillForegroundColorColor()) : null;
    if (color == null || BookHelper.AUTO_COLOR.equals(color))
      return "#FFFFFF";
    return color;
  }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
  @Test
  public void testSetBgColor() {
    Worksheet sheet1 = _workbook.getWorksheet("Sheet1");
    Row row1 = sheet1.getRow(0);
    Cell A1 = BookHelper.getOrCreateCell(sheet1, 0, 0);
    CellStyle newCellStyle = _workbook.createCellStyle();
    newCellStyle.cloneStyleFrom(A1.getCellStyle());
    final Color bsColor = BookHelper.HTMLToColor(_workbook, "#00FF00");
    BookHelper.setFillForegroundColor(newCellStyle, bsColor);
    BookHelper.setCellStyle(sheet1, 0, 0, 0, 0, newCellStyle);
    assertEquals("FF00FF00", ((XSSFColor)row1.getCell(0).getCellStyle().getFillForegroundColorColor()).getARGBHex()); //A1: Green
  }
View Full Code Here
617
618
619
620
621
622
623
624
625
626
627
628
          @Override
          public void handle(CellVisitorContext context) {
            final short srcAlign = context.getVerticalAlignment();

            if (srcAlign != alignment) {
              CellStyle newStyle = context.cloneCellStyle();
              newStyle.setVerticalAlignment(alignment);
              context.getRange().setStyle(newStyle);
            }
          }}); 
      } else {
        showProtectMessage();
View Full Code Here
638
639
640
641
642
643
644
645
646
647
648
649
          @Override
          public void handle(CellVisitorContext context) {
            final short srcAlign = context.getAlignment();

            if (srcAlign != alignment) {
              CellStyle newStyle = context.cloneCellStyle();
              newStyle.setAlignment(alignment);
              context.getRange().setStyle(newStyle);
            }
          }}); 
      } else {
        showProtectMessage();
View Full Code Here
1729
1730
1731
1732
1733
1734
1735
1736
1737
1738
      }
    }
  }

  protected void clearStyleImp(Rect selection, Worksheet worksheet) {
    final CellStyle defaultStyle = worksheet.getBook().createCellStyle();
    Ranges
    .range(worksheet, selection.getTop(), selection.getLeft(),selection.getBottom(), selection.getRight())
    .setStyle(defaultStyle);
  }
View Full Code Here
TOP

Related Classes of org.zkoss.poi.ss.usermodel.CellStyle

  • org.zkoss.zss.app.cell.CellHelper
  • org.zkoss.zss.app.FormatProtectionHelper
  • org.zkoss.zss.app.PasteSpecialWindowCtrl
  • org.zkoss.zss.app.zul.ctrl.SSRectCellStyle
  • org.zkoss.zss.model.impl.bgcolorXlsGetBgcolorTest
  • org.zkoss.zss.model.impl.BookHelper
  • org.zkoss.zss.model.impl.HSSFSheetImpl
  • org.zkoss.zss.model.impl.RangeImpl
  • org.zkoss.zss.model.impl.XSSFSheetImpl
  • org.zkoss.zss.ui.impl.CellFormatHelper
    • Copyright © 2018 www.massapicom. 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.