# -*- coding: utf-8 -*-

require 'helper'

class TestRegressionQuoteName01 < Minitest::Test
  def setup
    setup_dir_var
  end

  def teardown
    @tempfile.close(true)
  end

  def test_quote_name01
    @xlsx = 'quote_name01.xlsx'
    workbook  = WriteXLSX.new(@io)

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

    # Test quoted/non-quoted sheet names.
    worksheet = workbook.add_worksheet('Sheet 1')
    chart = workbook.add_chart(type: 'pie', embedded: 1)

    worksheet.write('A1', data)
    chart.add_series(values: ["'Sheet 1'", 0, 4, 0, 0])
    worksheet.insert_chart('E6', chart, 26, 17)

    sheetnames = [
      'Sheet 2', "Sheet!3", 'Sheet"4',
      'Sheet#5', 'Sheet$6', 'Sheet%7', 'Sheet&8'
    ]

    sheetnames.each do |sheetname|
      worksheet = workbook.add_worksheet(sheetname)
      chart = workbook.add_chart(type: 'pie', embedded: 1)

      worksheet.write('A1', data)
      chart.add_series(values: [sheetname, 0, 4, 0, 0])
      worksheet.insert_chart('E6', chart, 26, 17)
    end

    workbook.close
    compare_for_regression
  end
end
