Class ColumnInfoRecord

All Implemented Interfaces:
Cloneable

public final class ColumnInfoRecord extends StandardRecord implements Cloneable
Title: COLINFO Record (0x007D)

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)

  • Field Details

  • Constructor Details

    • ColumnInfoRecord

      public ColumnInfoRecord()
      Creates a column info record with default width and format
    • ColumnInfoRecord

      public ColumnInfoRecord(RecordInputStream in)
  • Method Details

    • setFirstColumn

      public void setFirstColumn(int fc)
      set the first column this record defines formatting info for
      Parameters:
      fc - - the first column index (0-based)
    • setLastColumn

      public void setLastColumn(int lc)
      set the last column this record defines formatting info for
      Parameters:
      lc - - the last column index (0-based)
    • setColumnWidth

      public void setColumnWidth(int cw)
      set the columns' width in 1/256 of a character width
      Parameters:
      cw - - column width
    • setXFIndex

      public void setXFIndex(int xfi)
      set the columns' default format info
      Parameters:
      xfi - - the extended format index
      See Also:
    • setHidden

      public void setHidden(boolean ishidden)
      set whether or not these cells are hidden
      Parameters:
      ishidden - - whether the cells are hidden.
    • setOutlineLevel

      public void setOutlineLevel(int olevel)
      set the outline level for the cells
      Parameters:
      olevel - -outline level for the cells
    • setCollapsed

      public void setCollapsed(boolean isCollapsed)
      set whether the cells are collapsed
      Parameters:
      isCollapsed - - whether the cells are collapsed
    • getFirstColumn

      public int getFirstColumn()
      get the first column this record defines formatting info for
      Returns:
      the first column index (0-based)
    • getLastColumn

      public int getLastColumn()
      get the last column this record defines formatting info for
      Returns:
      the last column index (0-based)
    • getColumnWidth

      public int getColumnWidth()
      Returns:
      column width in units of 1/256 of a character width
    • getXFIndex

      public int getXFIndex()
      get the columns' default format info
      Returns:
      the extended format index
      See Also:
    • getHidden

      public boolean getHidden()
      Returns:
      whether the cells are hidden.
    • getOutlineLevel

      public int getOutlineLevel()
      Returns:
      outline level for the cells
    • getCollapsed

      public boolean getCollapsed()
      Returns:
      whether the cells are collapsed
    • containsColumn

      public boolean containsColumn(int columnIndex)
    • isAdjacentBefore

      public boolean isAdjacentBefore(ColumnInfoRecord other)
    • formatMatches

      public boolean formatMatches(ColumnInfoRecord other)
      Parameters:
      other - the format to match with
      Returns:
      true if the format, options and column width match
    • getSid

      public short getSid()
      Description copied from class: Record
      return the non static version of the id for this record.
      Specified by:
      getSid in class Record
      Returns:
      he id for this record
    • serialize

      public void serialize(LittleEndianOutput out)
      Description copied from class: StandardRecord
      Write the data content of this BIFF record. The 'ushort sid' and 'ushort size' header fields have already been written by the superclass.

      The number of bytes written must equal the record size reported by RecordBase.getRecordSize()} minus four ( record header consisting of a 'ushort sid' and 'ushort reclength' has already been written by their superclass).

      Specified by:
      serialize in class StandardRecord
      Parameters:
      out - the output object
    • getDataSize

      protected int getDataSize()
      Specified by:
      getDataSize in class StandardRecord
    • toString

      public String toString()
      Description copied from class: Record
      get a string representation of the record (for biffview/debugging)
      Overrides:
      toString in class Record
    • clone

      public ColumnInfoRecord clone()
      Overrides:
      clone in class Record