class Row
  attr_accessor :index
  attr_accessor :parent
  attr_accessor :parent_wb
  attr_accessor :cells
  attr_accessor :min_col_index
  attr_accessor :max_col_index
  attr_accessor :total_str
  attr_accessor :xf_index
  attr_accessor :has_default_format
  attr_accessor :height_in_pixels
  
  attr_accessor :height
  attr_accessor :has_default_height
  attr_accessor :height_mismatch
  attr_accessor :level
  attr_accessor :collapse
  attr_accessor :hidden
  attr_accessor :space_above
  attr_accessor :space_below

  def initialize(index, parent_sheet)
    is_int = index.is_a?(Integer)
    in_range = (index >= 0) && (index <= 65535)
    raise "row index #{index} is not valid" unless is_int && in_range
    
    @index = index
    @parent = parent_sheet
    @parent_wb = parent_sheet.parent()
    @cells = []
    @min_col_index = 0
    @max_col_index = 0
    @total_str = 0
    @xf_index = 0x0F
    @has_default_format = 0
    @height_in_pixels = 0x11
    
    @height = 0x00FF
    @has_default_height = 0x00
    @height_mismatch = 0
    @level = 0
    @collapse = 0
    @hidden = 0
    @space_above = 0
    @space_below = 0
  end
  
  def adjust_height(style)
    twips = style.font.height
    points = twips/20.0
    # Cell height in pixels can be calcuted by following approx. formula:
    # cell height in pixels = font height in points * 83/50 + 2/5
    # It works when screen resolution is 96 dpi 
    pix = (points*83.0/50.0 + 2.0/5.0).round
    @height_in_pixels = pix if (pix > @height_in_pixels)
  end
  
  def adjust_boundary_column_indexes(*args)
    args.each do |a|
      is_int = (a.to_i == a)
      in_range = (0 <= a) && (a <= 255)
      raise "invalid boundary index #{a}" unless is_int && in_range
      @min_col_index = a if a < @min_col_index
      @max_col_index = a if a > @max_col_index
    end
  end
  
  # TODO can we get rid of this? Tests pass if it is commented out.
  def style=(style)
    adjust_height(style)
    @xf_index = @parent_wb.styles.add(style)
    @has_default_format = 1
  end
  
  def cells_count
    @cells.length
  end
  
  def to_biff
    height_options = (@height & 0x07FFF)
    height_options |= (@has_default_height & 0x01) << 15
    
    options =  (@level & 0x07) << 0
    options |= (@collapse & 0x01) << 4
    options |= (@hidden & 0x01) << 5
    options |= (@height_mismatch & 0x01) << 6
    options |= (@has_default_format & 0x01) << 7
    options |= (0x01 & 0x01) << 8
    options |= (@xf_index & 0x0FFF) << 16
    options |= (@space_above & 0x01) << 28
    options |= (@space_below & 0x01) << 29

    args = [@index, @min_col_index, @max_col_index, height_options, options]
    RowRecord.new(*args).to_biff
  end
  
  def cells_biff
    cells.collect {|c| c.to_biff }.join
  end
  
  def cell(col_index)
    cells.select {|c| c.index == col_index}.first
  end
  
  def write(col, label, style)
    case style
    when StyleFormat
      # leave it alone
    when Hash
      style = StyleFormat.new(style)