Package org.apache.poi.hssf.util

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

903
904
905
906
907
908
909
910
911
912
913
914
915
   */
  public void setPrintArea(int sheetIndex, int startColumn, int endColumn,
                int startRow, int endRow) {

    //using absolute references because they dont get copied and pasted anyway
    CellReference cell = new CellReference(startRow, startColumn, true, true);
    String reference = cell.toString();

    cell = new CellReference(endRow, endColumn, true, true);
    reference = reference+":"+cell.toString();

    setPrintArea(sheetIndex, reference);
  }
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
243
      }
      return cce.getValue();
    }
    if (isDebugLogEnabled()) {
      String sheetName = getSheetName(sheetIndex);
      CellReference cr = new CellReference(rowIndex, columnIndex);
      logDebug("Evaluated " + sheetName + "!" + cr.formatAsString() + " to " + result.toString());
    }
    // Usually (result === cce.getValue()) 
    // But sometimes: (result==ErrorEval.CIRCULAR_REF_ERROR, cce.getValue()==null)
    // When circular references are detected, the cache entry is only updated for
    // the top evaluation frame
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
262
   */
  private NotImplementedException addExceptionInfo(NotImplementedException inner, int sheetIndex, int rowIndex, int columnIndex) {
   
    try {
      String sheetName = _workbook.getSheetName(sheetIndex);
      CellReference cr = new CellReference(sheetName, rowIndex, columnIndex, false, false);
      String msg =  "Error evaluating cell " + cr.formatAsString();
      return new NotImplementedException(msg, inner);
    } catch (Exception e) {
      // avoid bombing out during exception handling
      e.printStackTrace();
      return inner; // preserve original exception
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
65
66
67
    return new LazyAreaEval(area, _evaluator);
  }

  public String toString() {
    CellReference cr = new CellReference(getRow(), getColumn());
    StringBuffer sb = new StringBuffer();
    sb.append(getClass().getName()).append("[");
    sb.append(_evaluator.getSheetName());
    sb.append('!');
    sb.append(cr.formatAsString());
    sb.append("]");
    return sb.toString();
  }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
    /**
     * Takes in a String represnetation of a cell reference and fills out the
     * numeric fields.
     */
    protected ReferencePtg(String cellref) {
        CellReference c= new CellReference(cellref);
        setRow((short) c.getRow());
        setColumn((short) c.getCol());
        setColRelative(!c.isColAbsolute());
        setRowRelative(!c.isRowAbsolute());
    }
View Full Code Here
176
177
178
179
180
181
182
    }

    public String toFormulaString()
    {
        //TODO -- should we store a cellreference instance in this ptg?? but .. memory is an issue, i believe!
        return (new CellReference(getRow(),getColumn(),!isRowRelative(),!isColRelative())).toString();
    }
View Full Code Here
303
304
305
306
307
308
309
310
        field_4_last_column = column;
    }

    public String toFormulaString()
    {
         return (new CellReference(getFirstRow(),getFirstColumn(),!isFirstRowRelative(),!isFirstColRelative())).toString() + ":" +
                (new CellReference(getLastRow(),getLastColumn(),!isLastRowRelative(),!isLastColRelative())).toString();
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
      // ignores it (see bug 46213).
      _stringRecord = null;
    }

    if (formulaRec.isSharedFormula()) {
      CellReference firstCell = formulaRec.getFormula().getExpReference();
      if (firstCell == null) {
        handleMissingSharedFormulaRecord(formulaRec);
      } else {
        _sharedFormulaRecord = svm.linkSharedFormulaRecord(firstCell, this);
      }
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
    return _formulaRecord.toString();
  }

  public void visitContainedRecords(RecordVisitor rv) {
     rv.visitRecord(_formulaRecord);
     CellReference sharedFirstCell = _formulaRecord.getFormula().getExpReference();
     // perhaps this could be optimised by consulting the (somewhat unreliable) isShared flag
     // and/or distinguishing between tExp and tTbl.
     if (sharedFirstCell != null) {
       Record sharedFormulaRecord = _sharedValueManager.getRecordForFirstCell(sharedFirstCell, this);
       if (sharedFormulaRecord != null) {
View Full Code Here
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
     */
    public void setPrintArea(int sheetIndex, int startColumn, int endColumn,
                              int startRow, int endRow) {

        //using absolute references because they don't get copied and pasted anyway
        CellReference cell = new CellReference(startRow, startColumn, true, true);
        String reference = cell.formatAsString();

        cell = new CellReference(endRow, endColumn, true, true);
        reference = reference+":"+cell.formatAsString();

        setPrintArea(sheetIndex, reference);
    }
View Full Code Here
TOP

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

  • com.canoo.webtest.plugins.exceltest.AbstractExcelCellStep
  • com.canoo.webtest.plugins.exceltest.ExcelCellUtils
  • com.canoo.webtest.plugins.exceltest.ExcelFindRow
  • com.canoo.webtest.plugins.exceltest.ExcelVerifyCellStyle
  • com.canoo.webtest.plugins.exceltest.ExcelVerifyCellSum
  • org.apache.poi.hssf.model.FormulaParser
  • org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
  • org.apache.poi.hssf.record.formula.Area3DPtg
  • org.apache.poi.hssf.record.formula.AreaPtg
  • org.apache.poi.hssf.record.formula.AreaPtgBase
    • 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.