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

5 entries across 5 versions & 1 rubygems

Version	Path
xlsxwriter-0.2.1.pre.2	test/test-defined-name.rb
xlsxwriter-0.2.1.pre	test/test-defined-name.rb
xlsxwriter-0.2.0	test/test-defined-name.rb
xlsxwriter-0.2.0.pre.2	test/test-defined-name.rb
xlsxwriter-0.2.0.pre	test/test-defined-name.rb