Package org.zkoss.poi.ss.usermodel

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

446
447
448
449
450
451
452
453
454
455
456
      @Override
      public void handle(CellVisitorContext context) {
        final boolean srcWrapText = context.isWrapText();

        if (srcWrapText != wrapped) {
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setWrapText(wrapped);
          context.getRange().setStyle(newStyle);
        }
      }});
  }
View Full Code Here
466
467
468
469
470
471
472
473
474
475
476
      @Override
      public void handle(CellVisitorContext context) {
        final boolean srcLocked = context.getLocked();

        if (srcLocked != locked) {
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setLocked(locked);
          context.getRange().setStyle(newStyle);
        }
      }});
  }
View Full Code Here
490
491
492
493
494
495
496
497
498
499
500
501
       
        DataFormat dataFormat = context.getBook().createDataFormat();
        short dstFormat = dataFormat.getFormat(format);
       
        if (srcFormat != dstFormat) {
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setDataFormat(dstFormat);
          context.getRange().setStyle(newStyle);
        }
      }
    });
  }
View Full Code Here
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
    final Book book  = (Book) sheet.getWorkbook();
    final Color bsColor = BookHelper.HTMLToColor(book, color);
    for (int row = rect.getTop(); row <= rect.getBottom(); row++)
      for (int col = rect.getLeft(); col <= rect.getRight(); col++) {
        Cell cell = Utils.getOrCreateCell(sheet, row, col);
        CellStyle cs = cell.getCellStyle();
        final Color srcColor = cs.getFillForegroundColorColor();
        if (Objects.equals(srcColor, bsColor)) {
          continue;
        }
        CellStyle newCellStyle = book.createCellStyle();
        newCellStyle.cloneStyleFrom(cs);
       
        //bug#ZSS-34: cell background color does not show in excel
        //20110819, henrichen@zkoss.org: set color to a cell shall change its fillPattern to "solid" automatically
        final short patternType = cs.getFillPattern();
        if (patternType == CellStyle.NO_FILL) {
          newCellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
        }
        BookHelper.setFillForegroundColor(newCellStyle, bsColor);
        Range rng = Utils.getRange(sheet, row, col);
        rng.setStyle(newCellStyle);
      }
View Full Code Here
914
915
916
917
918
919
920
921
922
923
924
925
    Range range = getRange((Worksheet)cell.getSheet(), cell.getRowIndex(), cell.getColumnIndex());
    return range.getFormatText();
  }
 
  public static String getCellText(Worksheet sheet, Cell cell) {
    CellStyle style = (cell == null) ? null : cell.getCellStyle();
    boolean wrap = style != null && style.getWrapText();
    Hyperlink hlink = cell == null ? null : Utils.getHyperlink(cell);
    final FormatText ft = (cell == null) ? null : Utils.getFormatText(cell);
   
    final RichTextString rstr = ft != null && ft.isRichTextString() ? ft.getRichTextString() : null;
    String text = rstr != null ? Utils.formatRichTextString(sheet, rstr, wrap) : ft != null ? Utils.escapeCellText(ft.getCellFormatResult().text, wrap, true) : "";
View Full Code Here
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
      if(rect!=null){
        hitMerge = true;
        right = Utils.getCell(_sheet, _row, rect.getRight());
      }
      if (right != null) {
        CellStyle style = right.getCellStyle();
        if (style != null){
          int bb = style.getBorderRight();
          //String color = BookHelper.indexToRGB(_book, style.getRightBorderColor());
          String color = BookHelper.colorToHTML(_book, style.getRightBorderColorColor());
          hitRight = appendBorderStyle(sb, "right", bb, color);
        }
      }
    }

    Cell next = null;
    //if no border for target cell,then check is this cell in a merge range
    //if(true) then try to get next cell after this merge range
    //else get next cell of this cell
    if(!hitRight){
      int c = hitMerge?rect.getRight()+1:_col+1;
      next = Utils.getCell(_sheet, _row, c);
      //find the right cell of merge range.
      if(next!=null){
        CellStyle style = next.getCellStyle();
        if (style != null){
          int bb = style.getBorderLeft();//get left here
          //String color = BookHelper.indexToRGB(_book, style.getLeftBorderColor());
          //ZSS-34 cell background color does not show in excel
          String color = style.getFillPattern() != CellStyle.NO_FILL ?
              BookHelper.colorToHTML(_book, style.getLeftBorderColorColor()) : null;
            hitRight = appendBorderStyle(sb, "right", bb, color);
        }
      }
    }

    //border depends on next cell's background color
    if(!hitRight && next !=null){
      CellStyle style = next.getCellStyle();
      if (style != null){
        //String bgColor = BookHelper.indexToRGB(_book, style.getFillForegroundColor());
        //ZSS-34 cell background color does not show in excel
        String bgColor = style.getFillPattern() != CellStyle.NO_FILL ?
            BookHelper.colorToHTML(_book, style.getFillForegroundColorColor()) : null;
        if (BookHelper.AUTO_COLOR.equals(bgColor)) {
          bgColor = null;
        }
       
        if (bgColor != null) {
          hitRight = appendBorderStyle(sb, "right", CellStyle.BORDER_THIN, bgColor);
        }
      }
    }
    //border depends on current cell's background color
    if(!hitRight && _cell !=null){
      CellStyle style = _cell.getCellStyle();
      if (style != null){
        //String bgColor = BookHelper.indexToRGB(_book, style.getFillForegroundColor());
        //ZSS-34 cell background color does not show in excel
        String bgColor = style.getFillPattern() != CellStyle.NO_FILL ?
            BookHelper.colorToHTML(_book, style.getFillForegroundColorColor()) : null;
        if (BookHelper.AUTO_COLOR.equals(bgColor)) {
          bgColor = null;
        }
        if (bgColor != null) {
          hitRight = appendBorderStyle(sb, "right", CellStyle.BORDER_THIN, bgColor);
View Full Code Here
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
    return true;
  }

  public String getInnerHtmlStyle() {
    if (_cell != null) {
      CellStyle style = _cell.getCellStyle();
      if (style == null)
        return "";
     
      final StringBuffer sb = new StringBuffer();
      sb.append(BookHelper.getTextCSSStyle(_book, _cell));
     
      //vertical alignment
      int verticalAlignment = style.getVerticalAlignment();
      sb.append("display: table-cell;");
      switch (verticalAlignment) {
      case CellStyle.VERTICAL_TOP:
        sb.append("vertical-align: top;");
        break;
      case CellStyle.VERTICAL_CENTER:
        sb.append("vertical-align: middle;");
        break;
      case CellStyle.VERTICAL_BOTTOM:
        sb.append("vertical-align: bottom;");
        break;
      }
     
      final Font font = _book.getFontAt(style.getFontIndex());
     
      //sb.append(BookHelper.getFontCSSStyle(_book, font));
      sb.append(BookHelper.getFontCSSStyle(_cell, font));

      //condition color
View Full Code Here
33
34
35
36
37
38
39
40
41
*/
public class Styles {
  private static final Log log = Log.lookup(Styles.class);
 
  public static CellStyle cloneCellStyle(Cell cell) {
    final CellStyle destination = cell.getSheet().getWorkbook().createCellStyle();
    destination.cloneStyleFrom(cell.getCellStyle());
    return destination;
  }
View Full Code Here
56
57
58
59
60
61
62
63
64
    final boolean italic = font.getItalic();
    final boolean strikeout = font.getStrikeout();
    final short typeOffset = font.getTypeOffset();
    final byte underline = font.getUnderline();
    final Font newFont = BookHelper.getOrCreateFont(book, boldWeight, newColor, fontHeight, name, italic, strikeout, typeOffset, underline);
    final CellStyle style = cloneCellStyle(cell);
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
View Full Code Here
69
70
71
72
73
74
75
76
77
    final Color orgColor = cell.getCellStyle().getFillForegroundColorColor();
    final Color newColor = BookHelper.HTMLToColor(book, color);
    if (orgColor == newColor || orgColor != null  && orgColor.equals(newColor)) { //no change, skip
      return;
    }
    final CellStyle style = cloneCellStyle(cell);
    BookHelper.setFillForegroundColor(style, newColor);
    cell.setCellStyle(style);
  }
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.