Contents

# frozen_string_literal: true

require_relative './xlsx_func_testcase'

class TestDefinedName < XlsxWriterTestCase
  test 'defined_name01' do |wb, t|
    t.ignore_elements = { 'xl/worksheets/sheet1.xml' => ['<pageMargins'] }
    wb.add_worksheet do |ws|
      ws.paper = 9
      ws.vertical_dpi = 200
      ws
        .print_area(0, 'A', 5, 'E')
        .autofilter(0, 'F', 0, 'G')
        .write_string(0, 'G', 'Filter')
        .write_string(0, 'F', 'Auto')
        .fit_to_pages(2, 2)
    end

    wb.add_worksheet
    wb.add_worksheet 'Sheet 3'

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

  test 'defined_name02' do |wb|
    wb.add_worksheet 'sheet One'
    wb.define_name 'Sales', "='sheet One'!$G$1:$H$10"
  end

  test 'defined_name03' do |wb, t|
    t.ignore_elements = { 'xl/worksheets/sheet1.xml' => ['<pageMargins'] }
    wb.add_worksheet('sheet One')
    wb.define_name 'Sales', '=\'sheet One\'!G1:H10'
  end

  test 'defined_name04' do |wb, t|
    t.ignore_elements = { 'xl/worksheets/sheet1.xml' => ['<pageMargins'] }
    wb.add_worksheet
    wb.define_name '\\__',                 '=Sheet1!$A$1'
    wb.define_name 'a3f6',                 '=Sheet1!$A$2'
    wb.define_name 'afoo.bar',             '=Sheet1!$A$3'
    wb.define_name "\xc3\xa9tude",         '=Sheet1!$A$4'
    wb.define_name "e\xc3\xa9sum\xc3\xa9", '=Sheet1!$A$5'
    wb.define_name 'a',                    '=Sheet1!$A$6'
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
xlsxwriter-0.2.2	test/test_defined_name.rb