module RubyXL::WorkbookConvenienceMethods

# File lib/rubyXL/convenience_methods.rb, line 6
def [](ind)
  case ind
  when Integer then worksheets[ind]
  when String  then worksheets.find { |ws| ws.sheet_name == ind }
  end
end

# File lib/rubyXL/convenience_methods.rb, line 16
def add_worksheet(name = nil)
  if name.nil? then
    n = 0

    begin
      name = SHEET_NAME_TEMPLATE % (n += 1)
    end until self[name].nil?
  end

  new_worksheet = Worksheet.new(:workbook => self, :sheet_name => name)
  worksheets << new_worksheet
  new_worksheet
end

# File lib/rubyXL/convenience_methods.rb, line 52
def application
  root.document_properties.application && root.document_properties.application.value
end

# File lib/rubyXL/convenience_methods.rb, line 56
def application=(v)
  root.document_properties.application ||= StringNode.new
  root.document_properties.application.value = v
end

# File lib/rubyXL/convenience_methods.rb, line 61
def appversion
  root.document_properties.app_version && root.document_properties.app_version.value
end

# File lib/rubyXL/convenience_methods.rb, line 65
def appversion=(v)
  root.document_properties.app_version ||= StringNode.new
  root.document_properties.app_version.value = v
end

# File lib/rubyXL/convenience_methods.rb, line 114
def borders # Stylesheet should be pre-filled with defaults on initialize()
  stylesheet.borders
end

# File lib/rubyXL/convenience_methods.rb, line 102
def cell_xfs # Stylesheet should be pre-filled with defaults on initialize()
  stylesheet.cell_xfs
end

# File lib/rubyXL/convenience_methods.rb, line 43
def company
  root.document_properties.company && root.document_properties.company.value
end

# File lib/rubyXL/convenience_methods.rb, line 47
def company=(v)
  root.document_properties.company ||= StringNode.new
  root.document_properties.company.value = v
end

# File lib/rubyXL/convenience_methods.rb, line 86
def created_at
  root.core_properties.created_at
end

# File lib/rubyXL/convenience_methods.rb, line 90
def created_at=(v)
  root.core_properties.created_at = v
end

# File lib/rubyXL/convenience_methods.rb, line 70
def creator
  root.core_properties.creator
end

# File lib/rubyXL/convenience_methods.rb, line 74
def creator=(v)
  root.core_properties.creator = v
end

# File lib/rubyXL/convenience_methods.rb, line 34
def date1904
  workbook_properties && workbook_properties.date1904
end

# File lib/rubyXL/convenience_methods.rb, line 38
def date1904=(v)
  self.workbook_properties ||= RubyXL::WorkbookProperties.new
  workbook_properties.date1904 = v
end

# File lib/rubyXL/convenience_methods.rb, line 30
def each
  worksheets.each{ |i| yield i }
end

# File lib/rubyXL/convenience_methods.rb, line 110
def fills # Stylesheet should be pre-filled with defaults on initialize()
  stylesheet.fills
end

# File lib/rubyXL/convenience_methods.rb, line 106
def fonts # Stylesheet should be pre-filled with defaults on initialize()
  stylesheet.fonts
end

# File lib/rubyXL/convenience_methods.rb, line 118
def get_fill_color(xf)
  fill = fills[xf.fill_id]
  pattern = fill && fill.pattern_fill
  color = pattern && pattern.fg_color
  color && color.rgb || 'ffffff'
end

# File lib/rubyXL/convenience_methods.rb, line 94
def modified_at
  root.core_properties.modified_at
end

# File lib/rubyXL/convenience_methods.rb, line 98
def modified_at=(v)
  root.core_properties.modified_at = v
end

# File lib/rubyXL/convenience_methods.rb, line 78
def modifier
  root.core_properties.modifier
end

# File lib/rubyXL/convenience_methods.rb, line 82
def modifier=(v)
  root.core_properties.modifier = v
end

# File lib/rubyXL/convenience_methods.rb, line 150
def modify_alignment(style_index, &block)
  xf = cell_xfs[style_index].dup
  xf.alignment ||= RubyXL::Alignment.new
  xf.apply_alignment = true
  yield(xf.alignment)
  register_new_xf(xf)
end

# File lib/rubyXL/convenience_methods.rb, line 167
def modify_border(style_index, direction, weight)
  old_xf = cell_xfs[style_index].dup
  new_border = borders[old_xf.border_id].dup
  new_border.set_edge_style(direction, weight)

  new_xf = old_xf.dup
  new_xf.apply_border = true

  new_xf.border_id = borders.find_index { |x| x == new_border } # Use existing border, if it exists
  new_xf.border_id ||= borders.size # If this border has never existed before, add it to collection.
  borders[new_xf.border_id] = new_border

  register_new_xf(new_xf)
end

# File lib/rubyXL/convenience_methods.rb, line 158
def modify_fill(style_index, rgb)
  xf = cell_xfs[style_index].dup
  new_fill = RubyXL::Fill.new(:pattern_fill =>
               RubyXL::PatternFill.new(:pattern_type => 'solid',
                                       :fg_color => RubyXL::Color.new(:rgb => rgb)))
  new_xf = register_new_fill(new_fill, xf)
  register_new_xf(new_xf)
end

# File lib/rubyXL/convenience_methods.rb, line 125
def register_new_fill(new_fill, old_xf)
  new_xf = old_xf.dup
  new_xf.apply_fill = true
  new_xf.fill_id = fills.find_index { |x| x == new_fill } # Use existing fill, if it exists
  new_xf.fill_id ||= fills.size # If this fill has never existed before, add it to collection.
  fills[new_xf.fill_id] = new_fill
  new_xf
end

# File lib/rubyXL/convenience_methods.rb, line 134
def register_new_font(new_font, old_xf)
  new_xf = old_xf.dup
  new_xf.apply_font = true
  new_xf.font_id = fonts.find_index { |x| x == new_font } # Use existing font, if it exists
  new_xf.font_id ||= fonts.size # If this font has never existed before, add it to collection.
  fonts[new_xf.font_id] = new_font
  new_xf
end

# File lib/rubyXL/convenience_methods.rb, line 143
def register_new_xf(new_xf)
  new_xf_id = cell_xfs.find_index { |xf| xf == new_xf } # Use existing XF, if it exists
  new_xf_id ||= cell_xfs.size # If this XF has never existed before, add it to collection.
  cell_xfs[new_xf_id] = new_xf
  new_xf_id
end