Package org.zkoss.poi.ss.usermodel

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

75
76
77
78
79
80
81
82
83
84
85
86
87
88
    BookHelper.setFillForegroundColor(style, newColor);
    cell.setCellStyle(style);
  }
 
  public static void setTextWrap(Worksheet sheet,int row,int col,boolean wrap){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final boolean textWrap = cell.getCellStyle().getWrapText();
    if (wrap == textWrap) { //no change, skip
      return;
    }
    final CellStyle style = cloneCellStyle(cell);
    style.setWrapText(wrap);
    cell.setCellStyle(style);
  }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
    style.setWrapText(wrap);
    cell.setCellStyle(style);
  }
 
  public static void setFontSize(Worksheet sheet,int row,int col,int fontHeight){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final short fontIdx = cell.getCellStyle().getFontIndex();
    final Font font = book.getFontAt(fontIdx);
    final short orgSize = font.getFontHeight();
    if (orgSize == fontHeight) { //no change, skip
      return;
    }
    final short boldWeight = font.getBoldweight();
    final Color color = BookHelper.getFontColor(book, font);
    final String name = font.getFontName();
    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, color, (short)fontHeight, name, italic, strikeout, typeOffset, underline);
    final CellStyle style = cloneCellStyle(cell);
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
 
  public static void setFontStrikethrough(Worksheet sheet,int row,int col, boolean strikeout){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final short fontIdx = cell.getCellStyle().getFontIndex();
    final Font font = book.getFontAt(fontIdx);
    final boolean orgStrikeout = font.getStrikeout();
    if (orgStrikeout == strikeout) { //no change, skip
      return;
    }
    final short boldWeight = font.getBoldweight();
    final Color color = BookHelper.getFontColor(book, font);
    final short fontHeight = font.getFontHeight();
    final String name = font.getFontName();
    final boolean italic = font.getItalic();
    final short typeOffset = font.getTypeOffset();
    final byte underline = font.getUnderline();
    final Font newFont = BookHelper.getOrCreateFont(book, boldWeight, color, fontHeight, name, italic, strikeout, typeOffset, underline);
    final CellStyle style = cloneCellStyle(cell);
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
 
  public static void setFontType(Worksheet sheet,int row,int col,String name){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final short fontIdx = cell.getCellStyle().getFontIndex();
    final Font font = book.getFontAt(fontIdx);
    final String orgName = font.getFontName();
    if (orgName.equals(name)) { //no change, skip
      return;
    }
    final short boldWeight = font.getBoldweight();
    final Color color = BookHelper.getFontColor(book, font);
    final short fontHeight = font.getFontHeight();
    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, color, fontHeight, name, italic, strikeout, typeOffset, underline);
    final CellStyle style = cloneCellStyle(cell);
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
View Full Code Here
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
  }
  public static void setBorderRight(Worksheet sheet,int row,int col,String color, short linestyle){
    setBorder(sheet,row,col, BookHelper.HTMLToColor(sheet.getWorkbook(), color), linestyle, 0x2);
  }
  public static void setBorder(Worksheet sheet,int row,int col, short color, short lineStyle, int at){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final CellStyle style = cloneCellStyle(cell);
    if((at & BookHelper.BORDER_EDGE_LEFT)!=0) {
      style.setBorderLeft(lineStyle);
    }
    if((at & BookHelper.BORDER_EDGE_TOP)!=0){
      style.setTopBorderColor(color);
      style.setBorderTop(lineStyle);
    }
    if((at & BookHelper.BORDER_EDGE_RIGHT)!=0){
      style.setRightBorderColor(color);
      style.setBorderRight(lineStyle);
    }
    if((at & BookHelper.BORDER_EDGE_BOTTOM)!=0){
      style.setBottomBorderColor(color);
      style.setBorderBottom(lineStyle);
    }
    cell.setCellStyle(style);
  }
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
    }
    cell.setCellStyle(style);
  }
 
  public static void setBorder(Worksheet sheet,int row,int col, Color color, short lineStyle, int at){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final CellStyle style = cloneCellStyle(cell);
    if((at & BookHelper.BORDER_EDGE_LEFT)!=0) {
      BookHelper.setLeftBorderColor(style, color);
      style.setBorderLeft(lineStyle);
    }
    if((at & BookHelper.BORDER_EDGE_TOP)!=0){
      BookHelper.setTopBorderColor(style, color);
      style.setBorderTop(lineStyle);
    }
    if((at & BookHelper.BORDER_EDGE_RIGHT)!=0){
      BookHelper.setRightBorderColor(style, color);
      style.setBorderRight(lineStyle);
    }
    if((at & BookHelper.BORDER_EDGE_BOTTOM)!=0){
      BookHelper.setBottomBorderColor(style, color);
      style.setBorderBottom(lineStyle);
    }
    cell.setCellStyle(style);
  }
View Full Code Here
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
    }
    cell.setCellStyle(style);
  }
 
  public static void setFontBoldWeight(Worksheet sheet,int row,int col,short boldWeight){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final short fontIdx = cell.getCellStyle().getFontIndex();
    final Font font = book.getFontAt(fontIdx);
    final short orgBoldWeight = font.getBoldweight();
    if (orgBoldWeight == boldWeight) { //no change, skip
      return;
    }
    final Color color = BookHelper.getFontColor(book, font);
    final short fontHeight = font.getFontHeight();
    final String name = font.getFontName();
    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, color, fontHeight, name, italic, strikeout, typeOffset, underline);
    final CellStyle style = cloneCellStyle(cell);
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
View Full Code Here
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
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
 
  public static void setFontItalic(Worksheet sheet, int row, int col, boolean italic) {
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final short fontIdx = cell.getCellStyle().getFontIndex();
    final Font font = book.getFontAt(fontIdx);
    final boolean orgItalic = font.getItalic();
    if (orgItalic == italic) { //no change, skip
      return;
    }
    final short boldWeight = font.getBoldweight();
    final Color color = BookHelper.getFontColor(book, font);
    final short fontHeight = font.getFontHeight();
    final String name = font.getFontName();
    final boolean strikeout = font.getStrikeout();
    final short typeOffset = font.getTypeOffset();
    final byte underline = font.getUnderline();
    final Font newFont = BookHelper.getOrCreateFont(book, boldWeight, color, fontHeight, name, italic, strikeout, typeOffset, underline);
    final CellStyle style = cloneCellStyle(cell);
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
 
  public static void setFontUnderline(Worksheet sheet,int row,int col, byte underline){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final short fontIdx = cell.getCellStyle().getFontIndex();
    final Font font = book.getFontAt(fontIdx);
    final byte orgUnderline = font.getUnderline();
    if (orgUnderline == underline) { //no change, skip
      return;
    }
    final short boldWeight = font.getBoldweight();
    final Color color = BookHelper.getFontColor(book, font);
    final short fontHeight = font.getFontHeight();
    final String name = font.getFontName();
    final boolean italic = font.getItalic();
    final boolean strikeout = font.getStrikeout();
    final short typeOffset = font.getTypeOffset();
    final Font newFont = BookHelper.getOrCreateFont(book, boldWeight, color, fontHeight, name, italic, strikeout, typeOffset, underline);
    final CellStyle style = cloneCellStyle(cell);
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
287
288
289
    style.setFont(newFont);
    cell.setCellStyle(style);
  }
 
  public static void setTextHAlign(Worksheet sheet,int row,int col, short align){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final short orgAlign = cell.getCellStyle().getAlignment();
    if (align == orgAlign) { //no change, skip
      return;
    }
    final CellStyle style = cloneCellStyle(cell);
    style.setAlignment(align);
    cell.setCellStyle(style);
  }
View Full Code Here
TOP

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

  • org.zkoss.zss.app.cell.CellHelper
  • org.zkoss.zss.app.ctrl.AutoFilterCtrl
  • org.zkoss.zss.app.CustomSortWindowCtrl$SortAlgorithm
  • org.zkoss.zss.app.FormatProtectionHelper
  • org.zkoss.zss.app.MainWindowCtrl
  • org.zkoss.zss.app.MultiSpreadsheetWindow
  • org.zkoss.zss.app.sort.CustomSortWindowCtrl$SortAlgorithm
  • org.zkoss.zss.app.zul.FormulaEditor
  • org.zkoss.zss.demo.MainWindow
  • org.zkoss.zss.demo.ZssGmapWindow
    • 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.