Examples of org.apache.poi.hssf.util.CellRangeAddressList

org.apache.poi.hssf.util.CellRangeAddressList
Implementation of the cell range address lists,like is described in OpenOffice.org's Excel Documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address List' In BIFF8 there is a common way to store absolute cell range address lists in several records (not formulas). A cell range address list consists of a field with the number of ranges and the list of the range addresses. Each cell range address (called an ADDR structure) contains 4 16-bit-values.
@deprecated use {@link org.apache.poi.ss.util.CellRangeAddressList}

  private CellRangeAddressList field_4_cell_ranges;


  /** Creates new CFHeaderRecord */
  public CFHeaderRecord()
  {
    field_4_cell_ranges = new CellRangeAddressList();
  }

View Full Code Here

  public CFHeaderRecord(RecordInputStream in)
  {
    field_1_numcf = in.readShort();
    field_2_need_recalculation = in.readShort();
    field_3_enclosing_cell_range = new CellRangeAddress(in);
    field_4_cell_ranges = new CellRangeAddressList(in);
  }

View Full Code Here

  {
    if(cellRanges == null)
    {
      throw new IllegalArgumentException("cellRanges must not be null");
    }
    CellRangeAddressList cral = new CellRangeAddressList();
    CellRangeAddress enclosingRange = null;
    for (int i = 0; i < cellRanges.length; i++)
    {
      CellRangeAddress cr = cellRanges[i];
      enclosingRange = CellRangeUtil.createEnclosingCellRange(cr, enclosingRange);
      cral.addCellRangeAddress(cr);
    }
    field_3_enclosing_cell_range = enclosingRange;
    field_4_cell_ranges = cral;
  }

View Full Code Here


     //read sec formula data condition
     _formula2 = Ptg.readTokens(field_size_sec_formula, in);


     //read cell range address list with all affected ranges
     _regions = new CellRangeAddressList(in);
  }

View Full Code Here

    // and then deleting the row that contains the cell.
    HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("dvEmpty.xls");  
    int dvRow = 0;
    HSSFSheet sheet = wb.getSheetAt(0);
    DVConstraint dc = DVConstraint.createNumericConstraint(VT.INTEGER, OP.EQUAL, "42", null);
    HSSFDataValidation dv = new HSSFDataValidation(new CellRangeAddressList(dvRow, dvRow, 0, 0), dc);
    
    dv.setEmptyCellAllowed(false);
    dv.setErrorStyle(ES.STOP);
    dv.setShowPromptBox(true);
    dv.createErrorBox("Xxx", "Yyy");

View Full Code Here

        String[] explicitListValues) {
      int rowNum = _currentRowIndex++;


      DVConstraint dc = createConstraint(operatorType, firstFormula, secondFormula, explicitListValues);


      HSSFDataValidation dv = new HSSFDataValidation(new CellRangeAddressList(rowNum, rowNum, 0, 0), dc);
      
      dv.setEmptyCellAllowed(allowEmpty);
      dv.setErrorStyle(errorStyle);
      dv.createErrorBox("Invalid Input", "Something is wrong - check condition!");
      dv.createPromptBox("Validated Cell", "Allowable values have been restricted");

View Full Code Here

TOP

Related Classes of org.apache.poi.hssf.util.CellRangeAddressList

org.apache.poi.hssf.record.CFHeaderRecord

org.apache.poi.hssf.record.DVRecord

org.apache.poi.hssf.usermodel.TestDataValidation

org.apache.poi.hssf.usermodel.TestDataValidation$ValidationAdder

java.util.ArrayList

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.