Package org.apache.poi.hssf.util

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

1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
     */
    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
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
     */
    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
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
88
89
90
91
92
93
94
95
96
97
98
    /**
     * 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
179
180
181
182
183
184
185
    }

    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
254
255
256
257
258
259
260
261
262
263
264
265
        StringBuffer sb = new StringBuffer();

        sb.append("In ").append(filename).append(" ");

        CellReference cr = new CellReference(sheetName, rowIndex, c.getColumnIndex(), false, false);
        sb.append(cr.formatAsString());
        sb.append(" {=").append(c.getCellFormula()).append("}");

        if(currentGroupComment != null) {
            sb.append(" '");
            sb.append(currentGroupComment);
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
    /**
     * 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
180
181
182
183
184
185
186
    }

    public String toFormulaString(SheetReferences refs)
    {
        //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
305
306
307
308
309
310
311
312
313
314
        if ( refs != null )
        {
            retval.append( refs.getSheetName( this.field_1_index_extern_sheet ) );
            retval.append( '!' );
        }
        retval.append( ( new CellReference( getFirstRow(), getFirstColumn(), !isFirstRowRelative(), !isFirstColRelative() ) ).toString() );
        retval.append( ':' );
        retval.append( ( new CellReference( getLastRow(), getLastColumn(), !isLastRowRelative(), !isLastColRelative() ) ).toString() );
        return retval.toString();
    }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
        field_2_row          = LittleEndian.getShort(data, 2 + offset);
        field_3_column        = LittleEndian.getShort(data, 4 + offset);
    }
   
    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
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.