Contents

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

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

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

  def test_defined_name01
    @xlsx = 'defined_name01.xlsx'
    workbook  = WriteXLSX.new(@xlsx)
    worksheet1 = workbook.add_worksheet
    worksheet2 = workbook.add_worksheet
    worksheet3 = workbook.add_worksheet('Sheet 3')

    worksheet1.print_area('A1:E6')
    worksheet1.autofilter('F1:G1')
    worksheet1.write('G1', 'Filter')
    worksheet1.write('F1', 'Auto')
    worksheet1.fit_to_pages(2, 2)

    workbook.define_name("'Sheet 3'!Bar", "='Sheet 3'!$A$1")
    workbook.define_name("Abc",           "=Sheet1!$A$1")
    workbook.define_name("Baz",           "=0.98")
    workbook.define_name("Sheet1!Bar",    "=Sheet1!$A$1")
    workbook.define_name("Sheet2!Bar",    "=Sheet2!$A$1")
    workbook.define_name("Sheet2!aaa",    "=Sheet2!$A$1")
    workbook.define_name("_Egg",          "=Sheet1!$A$1")
    workbook.define_name("_Fog",          "=Sheet1!$A$1")

    workbook.close
    compare_xlsx_for_regression(
                                File.join(@regression_output, @xlsx),
                                @xlsx,
                                ["xl/printerSettings/printerSettings1.bin",
                                 "xl/worksheets/_rels/sheet1.xml.rels"],
                                {
                                  '[Content_Types].xml' => ['<Default Extension="bin"'],
                                  'xl/worksheets/sheet1.xml' => ['<pageMargins', '<pageSetup']
                                }
                                )
  end
end

Version data entries

42 entries across 42 versions & 1 rubygems

Version	Path
write_xlsx-0.54.0	test/regression/test_defined_name01.rb
write_xlsx-0.51.0	test/regression/test_defined_name01.rb