Examples of ColumnInfoRecord

jxl.read.biff.ColumnInfoRecord
org.apache.poi.hssf.record.ColumnInfoRecord
Title: ColumnInfo Record
Description: Defines with width and formatting for a range of columns
REFERENCE: PG 293 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
@author Andrew C. Oliver (acoliver at apache dot org) @version 2.0-pre

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

        int idx = findColumnIdx( columnNumber, 0 );
        if (idx == -1)
            return;


        // Find the start of the group.
        ColumnInfoRecord columnInfo = (ColumnInfoRecord) records.get( findStartOfColumnOutlineGroup( idx ) );


        // Hide all the columns until the end of the group
        columnInfo = writeHidden( columnInfo, idx, true );


        // Write collapse field
        setColumn( (short) ( columnInfo.getLastColumn() + 1 ), null, null, null, Boolean.TRUE);
    }

View Full Code Here

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

        if (!isColumnGroupCollapsed(idx))
            return;


        // Find the start of the group.
        int startIdx = findStartOfColumnOutlineGroup( idx );
        ColumnInfoRecord columnInfo = getColInfo( startIdx );


        // Find the end of the group.
        int endIdx = findEndOfColumnOutlineGroup( idx );
        ColumnInfoRecord endColumnInfo = getColInfo( endIdx );


        // expand:
        // colapsed bit must be unset
        // hidden bit gets unset _if_ surrounding groups are expanded you can determine
        //   this by looking at the hidden bit of the enclosing group.  You will have

View Full Code Here

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

     * @see org.apache.poi.hssf.record.ColumnInfoRecord
     * @return record containing a ColumnInfoRecord
     */
    public static Record createColInfo()
    {
        ColumnInfoRecord retval = new ColumnInfoRecord();


        retval.setColumnWidth(( short ) 2275);
        // was:       retval.setOptions(( short ) 6);
        retval.setOptions(( short ) 2);
        retval.setXFIndex(( short ) 0x0f);
        return retval;
    }

View Full Code Here

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

    }




    public void setColumn(short column, Short width, Integer level, Boolean hidden, Boolean collapsed)
    {
        ColumnInfoRecord ci = null;
        int              k  = 0;


        for (k = 0; k < records.size(); k++)
        {
            ci = ( ColumnInfoRecord ) records.get(k);
            if ((ci.getFirstColumn() <= column)
                    && (column <= ci.getLastColumn()))
            {
                break;
            }
            ci = null;
        }


        if (ci != null)
        {
            boolean widthChanged = width != null && ci.getColumnWidth() != width.shortValue();
            boolean levelChanged = level != null && ci.getOutlineLevel() != level.intValue();
            boolean hiddenChanged = hidden != null && ci.getHidden() != hidden.booleanValue();
            boolean collapsedChanged = collapsed != null && ci.getCollapsed() != collapsed.booleanValue();
            boolean columnChanged = widthChanged || levelChanged || hiddenChanged || collapsedChanged;
            if (!columnChanged)
            {
                // do nothing...nothing changed.
            }
            else if ((ci.getFirstColumn() == column)
                     && (ci.getLastColumn() == column))
            {                               // if its only for this cell then
                setColumnInfoFields( ci, width, level, hidden, collapsed );
            }
            else if ((ci.getFirstColumn() == column)
                     || (ci.getLastColumn() == column))
            {
                // okay so the width is different but the first or last column == the column we'return setting
                // we'll just divide the info and create a new one
                if (ci.getFirstColumn() == column)
                {
                    ci.setFirstColumn(( short ) (column + 1));
                }
                else
                {
                    ci.setLastColumn(( short ) (column - 1));
                }
                ColumnInfoRecord nci = ( ColumnInfoRecord ) createColInfo();


                nci.setFirstColumn(column);
                nci.setLastColumn(column);
                nci.setOptions(ci.getOptions());
                nci.setXFIndex(ci.getXFIndex());
                setColumnInfoFields( nci, width, level, hidden, collapsed );


                insertColumn(k, nci);
            }
            else
            {
                //split to 3 records
                short lastcolumn = ci.getLastColumn();
                ci.setLastColumn(( short ) (column - 1));


                ColumnInfoRecord nci = ( ColumnInfoRecord ) createColInfo();
                nci.setFirstColumn(column);
                nci.setLastColumn(column);
                nci.setOptions(ci.getOptions());
                nci.setXFIndex(ci.getXFIndex());
                setColumnInfoFields( nci, width, level, hidden, collapsed );
                insertColumn(++k, nci);


                nci = ( ColumnInfoRecord ) createColInfo();
                nci.setFirstColumn((short)(column+1));
                nci.setLastColumn(lastcolumn);
                nci.setOptions(ci.getOptions());
                nci.setXFIndex(ci.getXFIndex());
                nci.setColumnWidth(ci.getColumnWidth());
                insertColumn(++k, nci);
            }
        }
        else
        {


            // okay so there ISN'T a column info record that cover's this column so lets create one!
            ColumnInfoRecord nci = ( ColumnInfoRecord ) createColInfo();


            nci.setFirstColumn(column);
            nci.setLastColumn(column);
            setColumnInfoFields( nci, width, level, hidden, collapsed );
            insertColumn(k, nci);
        }
    }

View Full Code Here

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

        if (column < 0)
            throw new IllegalArgumentException( "column parameter out of range: " + column );
        if (fromIdx < 0)
            throw new IllegalArgumentException( "fromIdx parameter out of range: " + fromIdx );


        ColumnInfoRecord ci;
        for (int k = fromIdx; k < records.size(); k++)
        {
            ci = ( ColumnInfoRecord ) records.get(k);
            if ((ci.getFirstColumn() <= column)
                    && (column <= ci.getLastColumn()))
            {
                return k;
            }
            ci = null;
        }

View Full Code Here

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


    public void collapseColInfoRecords( int columnIdx )
    {
        if (columnIdx == 0)
            return;
        ColumnInfoRecord previousCol = (ColumnInfoRecord) records.get( columnIdx - 1);
        ColumnInfoRecord currentCol = (ColumnInfoRecord) records.get( columnIdx );
        boolean adjacentColumns = previousCol.getLastColumn() == currentCol.getFirstColumn() - 1;
        if (!adjacentColumns)
            return;


        boolean columnsMatch =
                previousCol.getXFIndex() == currentCol.getXFIndex() &&
                previousCol.getOptions() == currentCol.getOptions() &&
                previousCol.getColumnWidth() == currentCol.getColumnWidth();


        if (columnsMatch)
        {
            previousCol.setLastColumn( currentCol.getLastColumn() );
            records.remove( columnIdx );
        }
    }

View Full Code Here

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

     * @see #setColumnWidth(int, int)
     * @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

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

     * @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

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

     * @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

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

    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

0 1 2 3 4 5

TOP

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.