# -*- coding: utf-8 -*-
require 'helper'

class TestRegressionSetColumn05 < Test::Unit::TestCase
  def setup
    setup_dir_var
  end

  def teardown
    File.delete(@xlsx) if File.exist?(@xlsx)
  end

  def test_set_column05
    @xlsx = 'set_column05.xlsx'
    workbook    = WriteXLSX.new(@xlsx)
    worksheet   = workbook.add_worksheet
    chart       = workbook.add_chart(:type => 'line', :embedded => 1)

    bold        = workbook.add_format(:bold   => 1)
    italic      = workbook.add_format(:italic => 1)
    bold_italic = workbook.add_format(:bold   => 1, :italic => 1)

    # For testing, copy the randomly generated axis ids in the target xlsx file.
    chart.instance_variable_set(:@axis_ids, [68311296, 69198208])

    data = [
            [1, 2, 3,  4,  5],
            [2, 4, 6,  8, 10],
            [3, 6, 9, 12, 15]
           ]

    worksheet.write('A1', 'Foo', italic)
    worksheet.write('B1', 'Bar', bold)
    worksheet.write('A2', data)

    worksheet.set_row(12, nil, italic)
    worksheet.set_column('F:F', nil, bold)

    worksheet.write('F13', nil, bold_italic)

    chart.add_series(:values => '=Sheet1!$A$2:$A$6')
    chart.add_series(:values => '=Sheet1!$B$2:$B$6')
    chart.add_series(:values => '=Sheet1!$C$2:$C$6')

    worksheet.insert_chart('E9', chart)

    workbook.close

    compare_xlsx_for_regression(File.join(@regression_output, @xlsx), @xlsx)

  end
end