Package org.zkoss.poi.ss.usermodel

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

828
829
830
831
832
833
834
835
836
837
838
            }
                if (srcCells != null) {
              for(Entry<Integer, Cell> cellEntry : srcCells.entrySet()) {
                final int colnum = cellEntry.getKey().intValue();
                final Cell srcCell = cellEntry.getValue();
                final CellStyle cellStyle = srcCell.getCellStyle();
                Cell dstCell = row.getCell(colnum);
                if (dstCell == null) {
                  dstCell = row.createCell(colnum);
                }
                dstCell.setCellStyle(BookHelper.copyFromStyleExceptBorder(getBook(), cellStyle));
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
      public void handle(CellVisitorContext context) {
        Font srcFont = context.getFont();
        Font font = context.getOrCreateFont(boldWeight, color,
            fontHeight, fontName, italic, strikeout, typeOffset, underline);
        if (!srcFont.equals(font)) {
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setFont(font);
          context.getRange().setStyle(newStyle);
        }
      }});
  }
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
255
          Font srcFont = context.getFont();

          Color fontColor = BookHelper.HTMLToColor(book, color);
          Font newFont = context.getOrCreateFont(srcFont.getBoldweight(), fontColor, srcFont.getFontHeight(), srcFont.getFontName(),
              srcFont.getItalic(), srcFont.getStrikeout(), srcFont.getTypeOffset(), srcFont.getUnderline());
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setFont(newFont);
          newStyle.setFontColorColor(fontColor);
          context.getRange().setStyle(newStyle);
        }
      }});
  }
View Full Code Here
272
273
274
275
276
277
278
279
280
281
282
283
        if (srcFontName != fontName) {
          final Workbook book = sheet.getWorkbook();
          Font srcFont = context.getFont();
          Font newFont = context.getOrCreateFont(srcFont.getBoldweight(), BookHelper.getFontColor(book, srcFont), srcFont.getFontHeight(), fontName,
              srcFont.getItalic(), srcFont.getStrikeout(), srcFont.getTypeOffset(), srcFont.getUnderline());
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setFont(newFont);
          context.getRange().setStyle(newStyle);
        }
      }
    });
  }
View Full Code Here
299
300
301
302
303
304
305
306
307
308
309
        if (srcFontHgh != fontHeight) {
          final Workbook book = sheet.getWorkbook();
          Font srcFont = context.getFont();
          Font newFont = context.getOrCreateFont(srcFont.getBoldweight(), BookHelper.getFontColor(book, srcFont), fontHeight, srcFont.getFontName(),
            srcFont.getItalic(), srcFont.getStrikeout(), srcFont.getTypeOffset(), srcFont.getUnderline());
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setFont(newFont);
          context.getRange().setStyle(newStyle);
        }
      }});
  }
View Full Code Here
325
326
327
328
329
330
331
332
333
334
335
        if (srcBold != isBold) {
          final Workbook book = sheet.getWorkbook();
          Font srcFont = context.getFont();
          Font newFont = context.getOrCreateFont(isBold ? Font.BOLDWEIGHT_BOLD : Font.BOLDWEIGHT_NORMAL, BookHelper.getFontColor(book, srcFont), srcFont.getFontHeight(), srcFont.getFontName(),
              srcFont.getItalic(), srcFont.getStrikeout(), srcFont.getTypeOffset(), srcFont.getUnderline());
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setFont(newFont);
          context.getRange().setStyle(newStyle);
        }
      }});
  }
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
        if (srcItalic != isItalic) {
          final Workbook book = sheet.getWorkbook();
          Font newFont = context.getOrCreateFont(srcFont.getBoldweight(), BookHelper.getFontColor(book, srcFont), srcFont.getFontHeight(), srcFont.getFontName(),
              isItalic, srcFont.getStrikeout(), srcFont.getTypeOffset(), srcFont.getUnderline());
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setFont(newFont);
          context.getRange().setStyle(newStyle);
        }
      }});
  }
View Full Code Here
379
380
381
382
383
384
385
386
387
388
389
390
        if (srcUnderline != underline) {
          final Workbook book = sheet.getWorkbook();
          Font newFont = context.getOrCreateFont(srcFont.getBoldweight(), BookHelper.getFontColor(book, srcFont),
            srcFont.getFontHeight(), srcFont.getFontName(),
            srcFont.getItalic(), srcFont.getStrikeout(), srcFont.getTypeOffset(), underline);
          CellStyle newStyle = context.cloneCellStyle();
          newStyle.setFont(newFont);
          context.getRange().setStyle(newStyle);
        }
      } 
    });
  }
View Full Code Here
406
407
408
409
410
411
412
413
414
415
416
        if (srcStrikeout != isStrikeout) {
          final Workbook book = sheet.getWorkbook();
          Font newFont = context.getOrCreateFont(srcFont.getBoldweight(),
              BookHelper.getFontColor(book, srcFont), srcFont.getFontHeight(), srcFont.getFontName(),
              srcFont.getItalic(), isStrikeout, srcFont.getTypeOffset(), srcFont.getUnderline());
          CellStyle cellStyle = context.cloneCellStyle();
          cellStyle.setFont(newFont);
          context.getRange().setStyle(cellStyle);
        }
      }});
  }
View Full Code Here
426
427
428
429
430
431
432
433
434
435
436
      @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);
        }
      }});
  }
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.