Package org.apache.poi.hssf.util

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

55
56
57
58
59
60
61
62
63
64
65
    /**
     * Takes in a String represnetation of a cell reference and fills out the
     * numeric fields.
     */
    public ReferencePtg(String cellref) {
        CellReference c= new CellReference(cellref);
        setRow(c.getRow());
        setColumn(c.getCol());
        setColRelative(!c.isColAbsolute());
        setRowRelative(!c.isRowAbsolute());
    }
View Full Code Here
177
178
179
180
181
182
183
    }

    public String toFormulaString(HSSFWorkbook book)
    {
        //TODO -- should we store a cellreference instance in this ptg?? but .. memory is an issue, i believe!
        return (new CellReference(getRowAsInt(),getColumn(),!isRowRelative(),!isColRelative())).formatAsString();
    }
View Full Code Here
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
   */
  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
47
48
49
50
51
52
53
54
55
56
57
    /**
     * Takes in a String represnetation of a cell reference and fills out the
     * numeric fields.
     */
    public 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
137
138
139
140
141
142
143
    }

    public String toFormulaString(Workbook book)
    {
        //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
54
55
56
57
58
59
60
61
62
63
64
65
        field_2_row          = in.readShort();
        field_3_column        = in.readShort();
    }
   
    public Ref3DPtg(String cellref, short externIdx ) {
        CellReference c= new CellReference(cellref);
        setRow((short) c.getRow());
        setColumn((short) c.getCol());
        setColRelative(!c.isColAbsolute());
        setRowRelative(!c.isRowAbsolute());  
        setExternSheetIndex(externIdx);
    }
View Full Code Here
161
162
163
164
165
166
167
168
        SheetReferences refs = book == null ? null : book.getSheetReferences();
        if (refs != null) {
            retval.append(refs.getSheetName((int)this.field_1_index_extern_sheet));
            retval.append('!');
        }
        retval.append((new CellReference(getRow(),getColumn(),!isRowRelative(),!isColRelative())).toString());
        return retval.toString();
    }
View Full Code Here
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
   */
  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
59
60
61
62
63
64
65
66
67
68
69
70
        field_2_row          = in.readShort();
        field_3_column        = in.readShort();
    }
   
    public Ref3DPtg(String cellref, short externIdx ) {
        CellReference c= new CellReference(cellref);
        setRow(c.getRow());
        setColumn(c.getCol());
        setColRelative(!c.isColAbsolute());
        setRowRelative(!c.isRowAbsolute());  
        setExternSheetIndex(externIdx);
    }
View Full Code Here
185
186
187
188
189
190
191
192
        String sheetName = getSheetName(book, field_1_index_extern_sheet);
        if(sheetName != null) {
            SheetNameFormatter.appendFormat(retval, sheetName);
            retval.append( '!' );
        }
        retval.append((new CellReference(getRow(),getColumn(),!isRowRelative(),!isColRelative())).formatAsString());
        return retval.toString();
    }
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.