Package org.apache.poi.hssf.util

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

197
198
199
200
201
202
203
204
        StringBuffer retval = new StringBuffer();
        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
343
344
345
346
347
348
349
350
351
352
353
354
355
356
                    refy1=(short)(y-4);
                    refy2=(short)(y-3);
                }
               
                c = r.getCell((short) y);
                CellReference cr= new CellReference(refx1,refy1);
                ref=cr.toString();
                cr=new CellReference(refx2,refy2);
                ref2=cr.toString();

                c = r.createCell((short) y);
                c.setCellFormula("" + ref + operator + ref2);
               
View Full Code Here
420
421
422
423
424
425
426
427
428
429
430
431
432
433
                    refy1=(short)(y-4);
                    refy2=(short)(y-3);
                }

                c = r.getCell((short) y);
                CellReference cr= new CellReference(refx1,refy1);
                ref=cr.toString();
                cr=new CellReference(refx2,refy2);
                ref2=cr.toString();
               
               
                assertTrue("loop Formula is as expected "+ref+operator+ref2+"!="+c.getCellFormula(),(
                (""+ref+operator+ref2).equals(c.getCellFormula())
                                                         )
View Full Code Here
305
306
307
308
309
310
311
312
        field_4_last_column = column;
    }

    public String toFormulaString(SheetReferences refs)
    {
         return (new CellReference(getFirstRow(),getFirstColumn(),!isFirstRowRelative(),!isFirstColRelative())).toString() + ":" +
                (new CellReference(getLastRow(),getLastColumn(),!isLastRowRelative(),!isLastColRelative())).toString();
    }
View Full Code Here
305
306
307
308
309
310
311
312
        field_4_last_column = column;
    }

    public String toFormulaString(SheetReferences refs)
    {
         return (new CellReference(getFirstRow(),getFirstColumn(),!isFirstRowRelative(),!isFirstColRelative())).toString() + ":" +
                (new CellReference(getLastRow(),getLastColumn(),!isLastRowRelative(),!isLastColRelative())).toString();
    }
View Full Code Here
293
294
295
296
297
298
299
300
301
302
        StringBuffer retval = new StringBuffer();
        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
343
344
345
346
347
348
349
350
351
352
353
354
355
356
                    refy1=(short)(y-4);
                    refy2=(short)(y-3);
                }
               
                c = r.getCell((short) y);
                CellReference cr= new CellReference(refx1,refy1);
                ref=cr.toString();
                cr=new CellReference(refx2,refy2);
                ref2=cr.toString();

                c = r.createCell((short) y);
                c.setCellFormula("" + ref + operator + ref2);
               
View Full Code Here
420
421
422
423
424
425
426
427
428
429
430
431
432
433
                    refy1=(short)(y-4);
                    refy2=(short)(y-3);
                }

                c = r.getCell((short) y);
                CellReference cr= new CellReference(refx1,refy1);
                ref=cr.toString();
                cr=new CellReference(refx2,refy2);
                ref2=cr.toString();
               
               
                assertTrue("loop Formula is as expected "+ref+operator+ref2+"!="+c.getCellFormula(),(
                (""+ref+operator+ref2).equals(c.getCellFormula())
                                                         )
View Full Code Here
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
     */
    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
252
253
254
255
256
257
258
259
260
261
262
263
264
265
                    refy1=(short)(y-4);
                    refy2=(short)(y-3);
                }

                c = r.getCell(y);
                CellReference cr= new CellReference(refx1,refy1, false, false);
                ref=cr.formatAsString();
                cr=new CellReference(refx2,refy2, false, false);
                ref2=cr.formatAsString();

                c = r.createCell(y);
                c.setCellFormula("" + ref + operator + ref2);

View Full Code Here
TOP

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

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