Class: ColInfoRecord

Inherits:

BiffRecord

• Object
• BiffRecord
• ColInfoRecord

Defined in:

lib/surpass/biff_record.rb

Overview

This record specifies the width for a given range of columns. If a column does not have a corresponding COLINFO record, the width specified in the record STANDARDWIDTH is used. If this record is also not present, the contents of the record DEFCOLWIDTH is used instead. This record also specifies a default XF record to use for cells in the columns that are not described by any cell record (which contain the XF index for that cell). Additionally, the option flags field contains hidden, outline, and collapsed options applied at the columns.

Record COLINFO, BIFF3-BIFF8:

Offset Size Contents 0 2 Index to first column in the range 2 2 Index to last column in the range 4 2 Width of the columns in 1/256 of the width of the zero character, using default font

(first FONT record in the file)

6 2 Index to XF record for default column formatting 8 2 Option flags:

Bits    Mask    Contents
0       0001H   1 = Columns are hidden
10-8    0700H   Outline level of the columns (0 = no outline)
12      1000H   1 = Columns are collapsed

10 2 Not used

Constant Summary

RECORD_ID =

0x007D

Constants inherited from BiffRecord

BiffRecord::BIFF_LIMIT, BiffRecord::CONTINUE_RECORD_ID

Instance Attribute Summary

Attributes inherited from BiffRecord

#record_data

Instance Method Summary

• #initialize(first_col, last_col, width, xf_index, options) ⇒ ColInfoRecord constructor

  A new instance of ColInfoRecord.

Methods inherited from BiffRecord

#record_header, #to_biff

Constructor Details

#initialize(first_col, last_col, width, xf_index, options) ⇒ ColInfoRecord

Returns a new instance of ColInfoRecord.

# File 'lib/surpass/biff_record.rb', line 1500

def initialize(first_col, last_col, width, xf_index, options)
  @record_data = [first_col, last_col, width, xf_index, options, 0].pack('v6')
end