Package org.openoffice.xmerge.converter.xml.sxc

Examples of org.openoffice.xmerge.converter.xml.sxc.ColumnRowInfo

159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
    // Collect Columns from worksheet and add them to the vector
    for(Enumeration e  = ws.getColInfos();e.hasMoreElements();) {
      ColInfo ci = (ColInfo)e.nextElement();
      int repeated = ci.getLast() - ci.getFirst() + 1;
      ColumnRowInfo colInfo = new ColumnRowInfo(  ci.getColWidth(),
                            repeated,
                            ColumnRowInfo.COLUMN);
      colRowVector.add(colInfo);
    }

    // Collect Rows from worksheet and add them to the vector
    for(Enumeration e  = ws.getRows();e.hasMoreElements();) {
      Row rw = (Row)e.nextElement();
      // We will use the repeat field for number (unlike columns rows
      // cannot be repeated, we have unique record for each row in pxl
      int repeated = rw.getRowNumber();   
      ColumnRowInfo rowInfo = new ColumnRowInfo(  rw.getRowHeight(),
                            repeated,
                            ColumnRowInfo.ROW);
      colRowVector.add(rowInfo);
    }   
    Debug.log(Debug.TRACE,"Getting " + colRowVector.size() + " ColRowInfo records");
View Full Code Here
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
    int nCols = 0;
    int nRows = 0;

    Debug.log(Debug.TRACE,"Workbook: addColInfo()");
    for(Enumeration e = columnRows.elements();e.hasMoreElements();) {
      ColumnRowInfo cri =(ColumnRowInfo) e.nextElement();
      int ixfe = 0;
      int size = cri.getSize();
      int repeated = cri.getRepeated();
      if(cri.isColumn()) {
        Debug.log(Debug.TRACE,"Workbook: adding ColInfo width = " + size);
        ColInfo newColInfo = new ColInfo(  nCols,
                          nCols+repeated-1,
                          size, ixfe);
        currentWS.addCol(newColInfo);
        nCols += repeated;
      } else if(cri.isRow()) {
     
        Debug.log(Debug.TRACE,"Workbook: adding Row Height = " + size);
        if(!cri.isDefaultSize()) {         
          for(int i=0;i<repeated;i++) {
            Row newRow = new Row(nRows++, size, cri.isUserDefined());
            currentWS.addRow(newRow);
          }
        } else {
          // If it is the Default Row we don't need to add it
          nRows += repeated;
View Full Code Here
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
    int nCols = 0;
    int nRows = 0;

    Debug.log(Debug.TRACE,"Workbook: addColInfo()");
    for(Enumeration e = columnRows.elements();e.hasMoreElements();) {
      ColumnRowInfo cri =(ColumnRowInfo) e.nextElement();
      int ixfe = 0;
      int size = cri.getSize();
      int repeated = cri.getRepeated();
      if(cri.isColumn()) {
        Debug.log(Debug.TRACE,"Workbook: adding ColInfo width = " + size);
        ColInfo newColInfo = new ColInfo(  nCols,
                          nCols+repeated-1,
                          size, ixfe);
        currentWS.addCol(newColInfo);
        nCols += repeated;
      } else if(cri.isRow()) {
     
        Debug.log(Debug.TRACE,"Workbook: adding Row Height = " + size);
        if(!cri.isDefaultSize()) {         
          for(int i=0;i<repeated;i++) {
            Row newRow = new Row(nRows++, size, cri.isUserDefined());
            currentWS.addRow(newRow);
          }
        } else {
          // If it is the Default Row we don't need to add it
          nRows += repeated;
View Full Code Here
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
    int nCols = 0;
    int nRows = 0;

    Debug.log(Debug.TRACE,"Workbook: addColInfo()");
    for(Enumeration e = columnRows.elements();e.hasMoreElements();) {
      ColumnRowInfo cri =(ColumnRowInfo) e.nextElement();
      int ixfe = 0;
      int size = cri.getSize();
      int repeated = cri.getRepeated();
      if(cri.isColumn()) {
        Debug.log(Debug.TRACE,"Workbook: adding ColInfo width = " + size);
        ColInfo newColInfo = new ColInfo(  nCols,
                          nCols+repeated-1,
                          size, ixfe);
        currentWS.addCol(newColInfo);
        nCols += repeated;
      } else if(cri.isRow()) {
     
        Debug.log(Debug.TRACE,"Workbook: adding Row Height = " + size);
        if(!cri.isDefaultSize()) {         
          for(int i=0;i<repeated;i++) {
            Row newRow = new Row(nRows++, size, cri.isUserDefined());
            currentWS.addRow(newRow);
          }
        } else {
          // If it is the Default Row we don't need to add it
          nRows += repeated;
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
    // Collect Columns from worksheet and add them to the vector
    for(Enumeration e  = ws.getColInfos();e.hasMoreElements();) {
      ColInfo ci = (ColInfo)e.nextElement();
      int repeated = ci.getLast() - ci.getFirst() + 1;
      ColumnRowInfo colInfo = new ColumnRowInfo(  ci.getColWidth(),
                            repeated,
                            ColumnRowInfo.COLUMN);
      colRowVector.add(colInfo);
    }

    // Collect Rows from worksheet and add them to the vector
    for(Enumeration e  = ws.getRows();e.hasMoreElements();) {
      Row rw = (Row)e.nextElement();
      // We will use the repeat field for number (unlike columns rows
      // cannot be repeated, we have unique record for each row in pxl
      int repeated = rw.getRowNumber();   
      ColumnRowInfo rowInfo = new ColumnRowInfo(  rw.getRowHeight(),
                            repeated,
                            ColumnRowInfo.ROW);
      colRowVector.add(rowInfo);
    }   
    Debug.log(Debug.TRACE,"Getting " + colRowVector.size() + " ColRowInfo records");
View Full Code Here
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
    int nCols = 0;
    int nRows = 0;

    Debug.log(Debug.TRACE,"Workbook: addColInfo()");
    for(Enumeration e = columnRows.elements();e.hasMoreElements();) {
      ColumnRowInfo cri =(ColumnRowInfo) e.nextElement();
      int ixfe = 0;
      int size = cri.getSize();
      int repeated = cri.getRepeated();
      if(cri.isColumn()) {
        Debug.log(Debug.TRACE,"Workbook: adding ColInfo width = " + size);
        ColInfo newColInfo = new ColInfo(  nCols,
                          nCols+repeated-1,
                          size, ixfe);
        currentWS.addCol(newColInfo);
        nCols += repeated;
      } else if(cri.isRow()) {
     
        Debug.log(Debug.TRACE,"Workbook: adding Row Height = " + size);
        if(!cri.isDefaultSize()) {         
          for(int i=0;i<repeated;i++) {
            Row newRow = new Row(nRows++, size, cri.isUserDefined());
            currentWS.addRow(newRow);
          }
        } else {
          // If it is the Default Row we don't need to add it
          nRows += repeated;
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
    // Collect Columns from worksheet and add them to the vector
    for(Enumeration e  = ws.getColInfos();e.hasMoreElements();) {
      ColInfo ci = (ColInfo)e.nextElement();
      int repeated = ci.getLast() - ci.getFirst() + 1;
      ColumnRowInfo colInfo = new ColumnRowInfo(  ci.getColWidth(),
                            repeated,
                            ColumnRowInfo.COLUMN);
      colRowVector.add(colInfo);
    }

    // Collect Rows from worksheet and add them to the vector
    for(Enumeration e  = ws.getRows();e.hasMoreElements();) {
      Row rw = (Row)e.nextElement();
      // We will use the repeat field for number (unlike columns rows
      // cannot be repeated, we have unique record for each row in pxl
      int repeated = rw.getRowNumber();   
      ColumnRowInfo rowInfo = new ColumnRowInfo(  rw.getRowHeight(),
                            repeated,
                            ColumnRowInfo.ROW);
      colRowVector.add(rowInfo);
    }   
    Debug.log(Debug.TRACE,"Getting " + colRowVector.size() + " ColRowInfo records");
View Full Code Here
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
    int nCols = 0;
    int nRows = 0;

    Debug.log(Debug.TRACE,"Workbook: addColInfo()");
    for(Enumeration e = columnRows.elements();e.hasMoreElements();) {
      ColumnRowInfo cri =(ColumnRowInfo) e.nextElement();
      int ixfe = 0;
      int size = cri.getSize();
      int repeated = cri.getRepeated();
      if(cri.isColumn()) {
        Debug.log(Debug.TRACE,"Workbook: adding ColInfo width = " + size);
        ColInfo newColInfo = new ColInfo(  nCols,
                          nCols+repeated-1,
                          size, ixfe);
        currentWS.addCol(newColInfo);
        nCols += repeated;
      } else if(cri.isRow()) {
     
        Debug.log(Debug.TRACE,"Workbook: adding Row Height = " + size);
        if(!cri.isDefaultSize()) {         
          for(int i=0;i<repeated;i++) {
            Row newRow = new Row(nRows++, size, cri.isUserDefined());
            currentWS.addRow(newRow);
          }
        } else {
          // If it is the Default Row we don't need to add it
          nRows += repeated;
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
    // Collect Columns from worksheet and add them to the vector
    for(Enumeration e  = ws.getColInfos();e.hasMoreElements();) {
      ColInfo ci = (ColInfo)e.nextElement();
      int repeated = ci.getLast() - ci.getFirst() + 1;
      ColumnRowInfo colInfo = new ColumnRowInfo(  ci.getColWidth(),
                            repeated,
                            ColumnRowInfo.COLUMN);
      colRowVector.add(colInfo);
    }

    // Collect Rows from worksheet and add them to the vector
    for(Enumeration e  = ws.getRows();e.hasMoreElements();) {
      Row rw = (Row)e.nextElement();
      // We will use the repeat field for number (unlike columns rows
      // cannot be repeated, we have unique record for each row in pxl
      int repeated = rw.getRowNumber();   
      ColumnRowInfo rowInfo = new ColumnRowInfo(  rw.getRowHeight(),
                            repeated,
                            ColumnRowInfo.ROW);
      colRowVector.add(rowInfo);
    }   
    Debug.log(Debug.TRACE,"Getting " + colRowVector.size() + " ColRowInfo records");
View Full Code Here
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
    int nCols = 0;
    int nRows = 0;

    Debug.log(Debug.TRACE,"Workbook: addColInfo()");
    for(Enumeration e = columnRows.elements();e.hasMoreElements();) {
      ColumnRowInfo cri =(ColumnRowInfo) e.nextElement();
      int ixfe = 0;
      int size = cri.getSize();
      int repeated = cri.getRepeated();
      if(cri.isColumn()) {
        Debug.log(Debug.TRACE,"Workbook: adding ColInfo width = " + size);
        ColInfo newColInfo = new ColInfo(  nCols,
                          nCols+repeated-1,
                          size, ixfe);
        currentWS.addCol(newColInfo);
        nCols += repeated;
      } else if(cri.isRow()) {
     
        Debug.log(Debug.TRACE,"Workbook: adding Row Height = " + size);
        if(!cri.isDefaultSize()) {         
          for(int i=0;i<repeated;i++) {
            Row newRow = new Row(nRows++, size, cri.isUserDefined());
            currentWS.addRow(newRow);
          }
        } else {
          // If it is the Default Row we don't need to add it
          nRows += repeated;
View Full Code Here
TOP

Related Classes of org.openoffice.xmerge.converter.xml.sxc.ColumnRowInfo

  • org.openoffice.xmerge.converter.xml.sxc.pexcel.PocketExcelDecoder
  • org.openoffice.xmerge.converter.xml.sxc.pexcel.records.Workbook
    • 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.