Package org.apache.poi.hssf.record

Examples of org.apache.poi.hssf.record.ColumnInfoRecord

502
503
504
505
506
507
508
509
510
511
512
513
   * @return <code>null</code> if no column info found for the specified column
   */
  public ColumnInfoRecord findColumnInfo(int columnIndex) {
    int nInfos = records.size();
    for(int i=0; i< nInfos; i++) {
      ColumnInfoRecord ci = getColInfo(i);
      if (ci.containsColumn(columnIndex)) {
        return ci;
      }
    }
    return null;
  }
View Full Code Here
513
514
515
516
517
518
519
520
521
522
  }
  public int getMaxOutlineLevel() {
    int result = 0;
    int count=records.size();
    for (int i=0; i<count; i++) {
      ColumnInfoRecord columnInfoRecord = getColInfo(i);
      result = Math.max(columnInfoRecord.getOutlineLevel(), result);
    }
    return result;
  }
View Full Code Here
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);

    ColumnInfoRecord nci = new ColumnInfoRecord();
    sheet._columnInfos.insertColumn(nci);

    // single column ColumnInfoRecord
    nci.setFirstColumn((short) 2);
    nci.setLastColumn((short) 2);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 2);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 3);
    assertEquals(DEFAULT_IDX, xfindex);

    // ten column ColumnInfoRecord
    nci.setFirstColumn((short) 2);
    nci.setLastColumn((short) 11);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 2);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 6);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 11);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 12);
    assertEquals(DEFAULT_IDX, xfindex);

    // single column ColumnInfoRecord starting at index 0
    nci.setFirstColumn((short) 0);
    nci.setLastColumn((short) 0);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);

    // ten column ColumnInfoRecord starting at index 0
    nci.setFirstColumn((short) 0);
    nci.setLastColumn((short) 9);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 7);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 9);
View Full Code Here
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
     * @see org.apache.poi.hssf.record.ColumnInfoRecord
     * @see #setColumnHidden(int, boolean)
     * @return whether the column is hidden or not.
     */
    public boolean isColumnHidden(int columnIndex) {
        ColumnInfoRecord cir = _columnInfos.findColumnInfo(columnIndex);
        if (cir == null) {
            return false;
        }
        return cir.getHidden();
    }
View Full Code Here
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
     * @return column width in units of 1/256th of a character width
     */

    public int getColumnWidth(int columnIndex) {

        ColumnInfoRecord ci = _columnInfos.findColumnInfo(columnIndex);
        if (ci != null) {
            return ci.getColumnWidth();
        }
        //default column width is measured in characters
        //multiply
        return (256*defaultcolwidth.getColWidth());
    }
View Full Code Here
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
     * @return index of ExtendedFormatRecord associated with
     * ColumnInfoRecord that includes the column index or the
     * index of the default ExtendedFormatRecord (0xF)
     */
    public short getXFIndexForColAt(short columnIndex) {
        ColumnInfoRecord ci = _columnInfos.findColumnInfo(columnIndex);
        if (ci != null) {
            return (short)ci.getXFIndex();
        }
        return 0xF;
    }
View Full Code Here
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);

    ColumnInfoRecord nci = new ColumnInfoRecord();
    sheet._columnInfos.insertColumn(nci);

    // single column ColumnInfoRecord
    nci.setFirstColumn((short) 2);
    nci.setLastColumn((short) 2);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 2);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 3);
    assertEquals(DEFAULT_IDX, xfindex);

    // ten column ColumnInfoRecord
    nci.setFirstColumn((short) 2);
    nci.setLastColumn((short) 11);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 2);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 6);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 11);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 12);
    assertEquals(DEFAULT_IDX, xfindex);

    // single column ColumnInfoRecord starting at index 0
    nci.setFirstColumn((short) 0);
    nci.setLastColumn((short) 0);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);

    // ten column ColumnInfoRecord starting at index 0
    nci.setFirstColumn((short) 0);
    nci.setLastColumn((short) 9);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 7);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 9);
View Full Code Here
50
51
52
53
54
55
56
57
58
59
        return columnInfoRecordsAggregate.serialize(0, new byte[columnInfoRecordsAggregate.getRecordSize()]);
    }

    private ColumnInfoRecord createColumn( short firstCol, short lastCol )
    {
        ColumnInfoRecord columnInfoRecord = new ColumnInfoRecord( );
        columnInfoRecord.setFirstColumn(firstCol);
        columnInfoRecord.setLastColumn(lastCol);
        return columnInfoRecord;
    }
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
*/
public final class TestSheetAdditional extends TestCase {
 
  public void testGetCellWidth() {
    Sheet sheet = Sheet.createSheet();
    ColumnInfoRecord nci = new ColumnInfoRecord();

    // Prepare test model
    nci.setFirstColumn((short)5);
    nci.setLastColumn((short)10);
    nci.setColumnWidth((short)100);
   
   
    sheet._columnInfos.insertColumn(nci);

    assertEquals((short)100,sheet.getColumnWidth((short)5));
View Full Code Here
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);

    ColumnInfoRecord nci = new ColumnInfoRecord();
    sheet._columnInfos.insertColumn(nci);

    // single column ColumnInfoRecord
    nci.setFirstColumn((short) 2);
    nci.setLastColumn((short) 2);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 2);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 3);
    assertEquals(DEFAULT_IDX, xfindex);

    // ten column ColumnInfoRecord
    nci.setFirstColumn((short) 2);
    nci.setLastColumn((short) 11);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 2);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 6);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 11);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 12);
    assertEquals(DEFAULT_IDX, xfindex);

    // single column ColumnInfoRecord starting at index 0
    nci.setFirstColumn((short) 0);
    nci.setLastColumn((short) 0);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 1);
    assertEquals(DEFAULT_IDX, xfindex);

    // ten column ColumnInfoRecord starting at index 0
    nci.setFirstColumn((short) 0);
    nci.setLastColumn((short) 9);
    nci.setXFIndex(TEST_IDX);
    xfindex = sheet.getXFIndexForColAt((short) 0);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 7);
    assertEquals(TEST_IDX, xfindex);
    xfindex = sheet.getXFIndexForColAt((short) 9);
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.ColumnInfoRecord

  • org.apache.poi.hssf.model.InternalSheet
  • org.apache.poi.hssf.model.Sheet
  • org.apache.poi.hssf.model.SheetTest
  • org.apache.poi.hssf.model.TestSheet
  • org.apache.poi.hssf.model.TestSheetAdditional
  • org.apache.poi.hssf.record.aggregates.ColumnInfoRecordsAggregate
  • org.apache.poi.hssf.record.aggregates.TestColumnInfoRecordsAggregate
    • 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.