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

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTUnderlineProperty

185
186
187
188
189
190
191
192
193
194
195
196
197
        else
            return Font.SS_NONE;
    }

     public byte getUnderline() {
         CTUnderlineProperty underline=ctFont.sizeOfUArray()==0?null:ctFont.getUArray(0);
        if(underline!=null){
             switch (underline.getVal().intValue()) {
            case STUnderlineValues.INT_DOUBLE:
                return Font.U_DOUBLE;
            case STUnderlineValues.INT_DOUBLE_ACCOUNTING:
                return Font.U_DOUBLE_ACCOUNTING;
View Full Code Here
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
            break;
        }
    }

    public void setUnderline(byte underline) {
         CTUnderlineProperty ctUnderline=ctFont.sizeOfUArray()==0?ctFont.addNewU():ctFont.getUArray(0);
        switch (underline) {
        case Font.U_DOUBLE:
            ctUnderline.setVal(STUnderlineValues.DOUBLE);
            break;
        case Font.U_DOUBLE_ACCOUNTING:
            ctUnderline.setVal(STUnderlineValues.DOUBLE_ACCOUNTING);
            break;
        case Font.U_SINGLE_ACCOUNTING:
            ctUnderline.setVal(STUnderlineValues.SINGLE_ACCOUNTING);
            break;
        case Font.U_NONE:
            ctUnderline.setVal(STUnderlineValues.NONE);
            break;

        case Font.U_SINGLE:
        default:
            ctUnderline.setVal(STUnderlineValues.SINGLE);
        break;
        }
    }
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
150
  }


  public void testUnderline(){
    CTFont ctFont=CTFont.Factory.newInstance();
    CTUnderlineProperty underlinePropr=ctFont.addNewU();
    underlinePropr.setVal(STUnderlineValues.SINGLE);
    ctFont.setUArray(0,underlinePropr);

    XSSFFont xssfFont=new XSSFFont(ctFont);
    assertEquals(Font.U_SINGLE, xssfFont.getUnderline());
View Full Code Here
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
     * Create a new CTWorksheet instance with all values set to defaults
     *
     * @return a new instance
     */
    private static CTWorksheet newSheet(){
        CTWorksheet worksheet = CTWorksheet.Factory.newInstance();
        CTSheetFormatPr ctFormat = worksheet.addNewSheetFormatPr();
        ctFormat.setDefaultRowHeight(15.0);

        CTSheetView ctView = worksheet.addNewSheetViews().addNewSheetView();
        ctView.setWorkbookViewId(0);

        worksheet.addNewDimension().setRef("A1");

        worksheet.addNewSheetData();

        CTPageMargins ctMargins = worksheet.addNewPageMargins();
        ctMargins.setBottom(0.75);
        ctMargins.setFooter(0.3);
        ctMargins.setHeader(0.3);
        ctMargins.setLeft(0.7);
        ctMargins.setRight(0.7);
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
    }

    return new XSSFCellStyle(idx, styleXfId, this, theme);
  }
  public int putStyle(XSSFCellStyle style) {
    CTXf mainXF = style.getCoreXf();

    if(! xfs.contains(mainXF)) {
      xfs.add(mainXF);
    }
    return xfs.indexOf(mainXF);
View Full Code Here
451
452
453
454
455
456
457
458
459
460
461
    fills.add(new XSSFCellFill(ctFill[1]));

    CTBorder ctBorder = createDefaultBorder();
    borders.add(new XSSFCellBorder(ctBorder));

    CTXf styleXf = createDefaultXf();
    styleXfs.add(styleXf);
    CTXf xf = createDefaultXf();
    xf.setXfId(0);
    xfs.add(xf);
  }
View Full Code Here
459
460
461
462
463
464
465
466
467
468
469
470
    xf.setXfId(0);
    xfs.add(xf);
  }

  private static CTXf createDefaultXf() {
    CTXf ctXf = CTXf.Factory.newInstance();
    ctXf.setNumFmtId(0);
    ctXf.setFontId(0);
    ctXf.setFillId(0);
    ctXf.setBorderId(0);
    return ctXf;
  }
View Full Code Here
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
    this.dxfs.add(dxf);
    return this.dxfs.size();
  }

  public XSSFCellStyle createCellStyle() {
    CTXf xf = CTXf.Factory.newInstance();
    xf.setNumFmtId(0);
    xf.setFontId(0);
    xf.setFillId(0);
    xf.setBorderId(0);
    xf.setXfId(0);
    int xfSize = styleXfs.size();
    int indexXf = putCellXf(xf);
    return new XSSFCellStyle(indexXf - 1, xfSize - 1, this, theme);
  }
View Full Code Here
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
1459
     * the references to fills and borders remain.
     *
     * @return a copy of this style
     */
    public Object clone(){
        CTXf xf = (CTXf)_cellXf.copy();

        int xfSize = _stylesSource._getStyleXfsSize();
        int indexXf = _stylesSource.putCellXf(xf);
        return new XSSFCellStyle(indexXf-1, xfSize-1, _stylesSource, _theme);
    }
View Full Code Here
1038
1039
1040
1041
1042
1043
1044
1045
1046
   * 
   * @param password the password string you wish convert to an {@link STUnsignedShortHex}
   * @return {@link STUnsignedShortHex} that contains Excel hashed password in Hex format
   */
  private STUnsignedShortHex stringToExcelPassword(String password) {
    STUnsignedShortHex hexPassword = STUnsignedShortHex.Factory.newInstance();
    hexPassword.setStringValue(String.valueOf(HexDump.shortToHex(PasswordRecord.hashPassword(password))).substring(2));
    return hexPassword;
  }
View Full Code Here
TOP

Related Classes of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTUnderlineProperty

  • com.narirelays.ems.utils.ExcelUtility
  • org.apache.poi.hssf.extractor.HXFExcelExtractor
  • org.apache.poi.hssf.HSSFXML
  • org.apache.poi.hssf.model.SharedStringsTable
  • org.apache.poi.xssf.eventusermodel.TestReadOnlySharedStringsTable
  • org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator
  • org.apache.poi.xssf.model.CommentsTable
  • org.apache.poi.xssf.model.Control
  • org.apache.poi.xssf.model.Drawing
  • org.apache.poi.xssf.model.ExternalLinksTable
    • 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.