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

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

256
257
258
259
260
261
262
263
264
265
    }

    private float getColumnWidthInPixels(int columnIndex){
        XSSFSheet sheet = (XSSFSheet)getDrawing().getParent();

        CTCol col = sheet.getColumnHelper().getColumn(columnIndex, false);
        double numChars = col == null || !col.isSetWidth() ? DEFAULT_COLUMN_WIDTH : col.getWidth();

        return (float)numChars*XSSFWorkbook.DEFAULT_CHARACTER_WIDTH;
    }
View Full Code Here
3023
3024
3025
3026
3027
3028
3029
3030
3031
3032
    CTDataValidations dataValidations = worksheet.getDataValidations();
    if( dataValidations==null ) {
      dataValidations = worksheet.addNewDataValidations();
    }
    int currentCount = dataValidations.sizeOfDataValidationArray();
        CTDataValidation newval = dataValidations.addNewDataValidation();
    newval.set(xssfDataValidation.getCtDdataValidation());
    dataValidations.setCount(currentCount + 1);

  }
View Full Code Here
3237
3238
3239
3240
3241
3242
3243
3244
3245
3246
    CTDataValidations dataValidations = worksheet.getDataValidations();
    if( dataValidations==null ) {
      dataValidations = worksheet.addNewDataValidations();
    }
    int currentCount = dataValidations.sizeOfDataValidationArray();
        CTDataValidation newval = dataValidations.addNewDataValidation();
    newval.set(xssfDataValidation.getCtDdataValidation());
    dataValidations.setCount(currentCount + 1);

  }
View Full Code Here
3343
3344
3345
3346
3347
3348
3349
3350
3351
3352
        CTDataValidations dataValidations = worksheet.getDataValidations();
        if( dataValidations==null ) {
            dataValidations = worksheet.addNewDataValidations();
        }
        int currentCount = dataValidations.sizeOfDataValidationArray();
        CTDataValidation newval = dataValidations.addNewDataValidation();
        newval.set(xssfDataValidation.getCtDdataValidation());
        dataValidations.setCount(currentCount + 1);

    }
View Full Code Here
3138
3139
3140
3141
3142
3143
3144
3145
3146
3147
    CTDataValidations dataValidations = worksheet.getDataValidations();
    if( dataValidations==null ) {
      dataValidations = worksheet.addNewDataValidations();
    }
    int currentCount = dataValidations.sizeOfDataValidationArray();
        CTDataValidation newval = dataValidations.addNewDataValidation();
    newval.set(xssfDataValidation.getCtDdataValidation());
    dataValidations.setCount(currentCount + 1);

  }
View Full Code Here
2908
2909
2910
2911
2912
2913
2914
2915
2916
2917
    CTDataValidations dataValidations = worksheet.getDataValidations();
    if( dataValidations==null ) {
      dataValidations = worksheet.addNewDataValidations();
    }
    int currentCount = dataValidations.getDataValidationArray().length;
        CTDataValidation newval = dataValidations.addNewDataValidation();
    newval.set(xssfDataValidation.getCtDdataValidation());
    dataValidations.setCount(currentCount + 1);

  }
View Full Code Here
2911
2912
2913
2914
2915
2916
2917
2918
2919
2920
    CTDataValidations dataValidations = worksheet.getDataValidations();
    if( dataValidations==null ) {
      dataValidations = worksheet.addNewDataValidations();
    }
    int currentCount = dataValidations.getDataValidationList().size();
        CTDataValidation newval = dataValidations.addNewDataValidation();
    newval.set(xssfDataValidation.getCtDdataValidation());
    dataValidations.setCount(currentCount + 1);

  }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
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
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
  /* (non-Javadoc)
   * @see org.apache.poi.ss.usermodel.DataValidationHelper#createValidation(org.apache.poi.ss.usermodel.DataValidationConstraint, org.apache.poi.ss.util.CellRangeAddressList)
   */
  public DataValidation createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList) {
    XSSFDataValidationConstraint dataValidationConstraint = (XSSFDataValidationConstraint)constraint;
    CTDataValidation newDataValidation = CTDataValidation.Factory.newInstance();

    int validationType = constraint.getValidationType();
    switch(validationType) {
      case DataValidationConstraint.ValidationType.LIST:
          newDataValidation.setType(STDataValidationType.LIST);
        newDataValidation.setFormula1(constraint.getFormula1());       
          break;
      case DataValidationConstraint.ValidationType.ANY:       
        newDataValidation.setType(STDataValidationType.NONE);       
        break;
      case DataValidationConstraint.ValidationType.TEXT_LENGTH:
        newDataValidation.setType(STDataValidationType.TEXT_LENGTH);
        break;       
      case DataValidationConstraint.ValidationType.DATE:
        newDataValidation.setType(STDataValidationType.DATE);
        break;       
      case DataValidationConstraint.ValidationType.INTEGER:
        newDataValidation.setType(STDataValidationType.WHOLE);
        break;       
      case DataValidationConstraint.ValidationType.DECIMAL:
        newDataValidation.setType(STDataValidationType.DECIMAL);
        break;       
      case DataValidationConstraint.ValidationType.TIME:
        newDataValidation.setType(STDataValidationType.TIME);
        break;
      case DataValidationConstraint.ValidationType.FORMULA:
        newDataValidation.setType(STDataValidationType.CUSTOM);
        break;
      default:
        newDataValidation.setType(STDataValidationType.NONE);       
    }
   
    if (validationType!=ValidationType.ANY && validationType!=ValidationType.LIST) {
            STDataValidationOperator.Enum op = XSSFDataValidation.operatorTypeMappings.get(constraint.getOperator());
      if(op != null) {
                newDataValidation.setOperator(op);
            }
      if (constraint.getFormula1() != null) {
        newDataValidation.setFormula1(constraint.getFormula1());
      }
      if (constraint.getFormula2() != null) {
        newDataValidation.setFormula2(constraint.getFormula2());
      }
    }
   
    CellRangeAddress[] cellRangeAddresses = cellRangeAddressList.getCellRangeAddresses();
    List<String> sqref = new ArrayList<String>();
    for (int i = 0; i < cellRangeAddresses.length; i++) {
      CellRangeAddress cellRangeAddress = cellRangeAddresses[i];
      sqref.add(cellRangeAddress.formatAsString());
    }
    newDataValidation.setSqref(sqref);
   
    return new XSSFDataValidation(dataValidationConstraint,cellRangeAddressList,newDataValidation);
  }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
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
155
156
157
158
159
160
161
162
163
164
165
166
167
  /* (non-Javadoc)
   * @see org.apache.poi.ss.usermodel.DataValidationHelper#createValidation(org.apache.poi.ss.usermodel.DataValidationConstraint, org.apache.poi.ss.util.CellRangeAddressList)
   */
  public DataValidation createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList) {
    XSSFDataValidationConstraint dataValidationConstraint = (XSSFDataValidationConstraint)constraint;
    CTDataValidation newDataValidation = CTDataValidation.Factory.newInstance();

    int validationType = constraint.getValidationType();
    switch(validationType) {
      case DataValidationConstraint.ValidationType.LIST:
          newDataValidation.setType(STDataValidationType.LIST);
        newDataValidation.setFormula1(constraint.getFormula1());       
          break;
      case DataValidationConstraint.ValidationType.ANY:       
        newDataValidation.setType(STDataValidationType.NONE);       
        break;
      case DataValidationConstraint.ValidationType.TEXT_LENGTH:
        newDataValidation.setType(STDataValidationType.TEXT_LENGTH);
        break;       
      case DataValidationConstraint.ValidationType.DATE:
        newDataValidation.setType(STDataValidationType.DATE);
        break;       
      case DataValidationConstraint.ValidationType.INTEGER:
        newDataValidation.setType(STDataValidationType.WHOLE);
        break;       
      case DataValidationConstraint.ValidationType.DECIMAL:
        newDataValidation.setType(STDataValidationType.DECIMAL);
        break;       
      case DataValidationConstraint.ValidationType.TIME:
        newDataValidation.setType(STDataValidationType.TIME);
        break;
      case DataValidationConstraint.ValidationType.FORMULA:
        newDataValidation.setType(STDataValidationType.CUSTOM);
        break;
      default:
        newDataValidation.setType(STDataValidationType.NONE);       
    }
   
    if (validationType!=ValidationType.ANY && validationType!=ValidationType.LIST) {
      newDataValidation.setOperator(XSSFDataValidation.operatorTypeMappings.get(constraint.getOperator()));     
      if (constraint.getFormula1() != null) {
        newDataValidation.setFormula1(constraint.getFormula1());
      }
      if (constraint.getFormula2() != null) {
        newDataValidation.setFormula2(constraint.getFormula2());
      }
    }
   
    CellRangeAddress[] cellRangeAddresses = cellRangeAddressList.getCellRangeAddresses();
    List<String> sqref = new ArrayList<String>();
    for (int i = 0; i < cellRangeAddresses.length; i++) {
      CellRangeAddress cellRangeAddress = cellRangeAddresses[i];
      sqref.add(cellRangeAddress.formatAsString());
    }
    newDataValidation.setSqref(sqref);
   
    return new XSSFDataValidation(dataValidationConstraint,cellRangeAddressList,newDataValidation);
  }
View Full Code Here
3485
3486
3487
3488
3489
3490
3491
3492
3493
3494
        CTDataValidations dataValidations = worksheet.getDataValidations();
        if( dataValidations==null ) {
            dataValidations = worksheet.addNewDataValidations();
        }
        int currentCount = dataValidations.sizeOfDataValidationArray();
        CTDataValidation newval = dataValidations.addNewDataValidation();
        newval.set(xssfDataValidation.getCtDdataValidation());
        dataValidations.setCount(currentCount + 1);

    }
View Full Code Here
TOP

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

  • 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.