Package org.apache.poi.ss.util

Examples of org.apache.poi.ss.util.CellRangeAddress

463
464
465
466
467
468
469
470
471
472
473
  {
    final int rowSpan = rectangle.getRowSpan();
    final int columnSpan = rectangle.getColumnSpan();
    if (rowSpan > 1 || columnSpan > 1)
    {
      sheet.addMergedRegion(new CellRangeAddress(row, (row + rowSpan - 1), col, (short) (col + columnSpan - 1)));
      final int rectX = rectangle.getX1();
      final int rectY = rectangle.getY1();

      for (int spannedRow = 0; spannedRow < rowSpan; spannedRow += 1)
      {
View Full Code Here
779
780
781
782
783
784
785
786
787
788
789
  protected void createMergeRegion(JRExporterGridCell gridCell, int colIndex, int rowIndex, HSSFCellStyle cellStyle)
  {
    int rowSpan = isCollapseRowSpan ? 1 : gridCell.getRowSpan();
    if (gridCell.getColSpan() > 1 || rowSpan > 1)
    {
      sheet.addMergedRegion(new CellRangeAddress(rowIndex, (rowIndex + rowSpan - 1),
          colIndex, (colIndex + gridCell.getColSpan() - 1)));

      for(int i = 0; i < rowSpan; i++)
      {
        HSSFRow spanRow = sheet.getRow(rowIndex + i);
View Full Code Here
430
431
432
433
434
435
436
437
438
439
440
        return _fileOpts;
    }


    public HyperlinkRecord(RecordInputStream in) {
        _range = new CellRangeAddress(in);

        _guid = new GUID(in);

        /**
         * streamVersion (4 bytes): An unsigned integer that specifies the version number
View Full Code Here
703
704
705
706
707
708
709
710
711
712
713
   
    /**
     * Initialize a new url link
     */
    public void newUrlLink() {
        _range = new CellRangeAddress(0, 0, 0, 0);
        _guid = STD_MONIKER;
        _linkOpts = HLINK_URL | HLINK_ABS | HLINK_LABEL;
        setLabel("");
        _moniker = URL_MONIKER;
        setAddress("");
View Full Code Here
716
717
718
719
720
721
722
723
724
725
726
    /**
     * Initialize a new file link
     */
    public void newFileLink() {
        _range = new CellRangeAddress(0, 0, 0, 0);
        _guid = STD_MONIKER;
        _linkOpts = HLINK_URL | HLINK_LABEL;
        _fileOpts = 0;
        setLabel("");
        _moniker = FILE_MONIKER;
View Full Code Here
731
732
733
734
735
736
737
738
739
740
741
    /**
     * Initialize a new document link
     */
    public void newDocumentLink() {
        _range = new CellRangeAddress(0, 0, 0, 0);
        _guid = STD_MONIKER;
        _linkOpts = HLINK_LABEL | HLINK_PLACE;
        setLabel("");
        _moniker = FILE_MONIKER;
        setAddress("");
View Full Code Here
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
     * The purpose of this method is to validate the cell state prior to modification
     *
     * @see #notifyArrayFormulaChanging()
     */
    void notifyArrayFormulaChanging(String msg){
        CellRangeAddress cra = getArrayFormulaRange();
        if(cra.getNumberOfCells() > 1) {
            throw new IllegalStateException(msg);
        }
        //un-register the single-cell array formula from the parent XSSFSheet
        getRow().getSheet().removeArrayFormula(this);
    }
View Full Code Here
231
232
233
234
235
236
237
238
239
240
    }

    public void testNewMergedRegionAt() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet();
        CellRangeAddress region = CellRangeAddress.valueOf("B2:D4");
        sheet.addMergedRegion(region);
        assertEquals("B2:D4", sheet.getMergedRegion(0).formatAsString());
        assertEquals(1, sheet.getNumMergedRegions());
    }
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
252
253
    public void testRemoveMergedRegion_lowlevel() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet();
        CTWorksheet ctWorksheet = sheet.getCTWorksheet();
        CellRangeAddress region_1 = CellRangeAddress.valueOf("A1:B2");
        CellRangeAddress region_2 = CellRangeAddress.valueOf("C3:D4");
        CellRangeAddress region_3 = CellRangeAddress.valueOf("E5:F6");
        sheet.addMergedRegion(region_1);
        sheet.addMergedRegion(region_2);
        sheet.addMergedRegion(region_3);
        assertEquals("C3:D4", ctWorksheet.getMergeCells().getMergeCellArray(1).getRef());
        assertEquals(3, sheet.getNumMergedRegions());
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
    ScatterChartData scatterChartData =
        XSSFChartDataFactory.getInstance().createScatterChartData();

    ScatterChartSerie serie = scatterChartData.addSerie();
    serie.setXValues(sheet, new CellRangeAddress(0,0,1,10));
    serie.setYValues(sheet, new CellRangeAddress(1,1,1,10));

    assertEquals(scatterChartData.getSeries().size(), 1);

    chart.plot(scatterChartData, bottomAxis, leftAxis);
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.util.CellRangeAddress

  • accounts.web.ReportPoiController
  • accounts.web.ReportPoiControllerTest
  • AlMaGe.export.ExcelReportDreiJahre
  • AlMaGe.export.ExcelReportFuenfJahre
  • AlMaGe.export.ExcelReportJahr
  • AlMaGe.export.ExcelReportQuartal
  • AlMaGe.export.ExcelReportZehnJahre
  • br.net.woodstock.rockframework.office.spreadsheet.poi.HSSFSpreadsheetDocumentWriter
  • br.net.woodstock.rockframework.office.spreadsheet.poi.XSSFSpreadsheetDocumentWriter
  • com.dtrules.compiler.excel.util.Rules2Excel
    • 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.