Contents

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

class TestWriteHyperlink < Test::Unit::TestCase
  def setup
    @workbook = WriteXLSX.new(StringIO.new)
    @worksheet = @workbook.add_worksheet('')
  end

  def test_write_hyperlink_external
    hyperlink = Writexlsx::Worksheet::Hyperlink.factory('')
    @worksheet.__send__('write_hyperlink_external', hyperlink, 0, 0, 1)
    result = @worksheet.instance_variable_get(:@writer).string
    expected = '<hyperlink ref="A1" r:id="rId1"/>'
    assert_equal(expected, result)
  end

  def test_write_hyperlink_internal_sheet2
    hyperlink = Writexlsx::Worksheet::Hyperlink.factory('internal:Sheet2!A1', 'Sheet2!A1')
    @worksheet.__send__('write_hyperlink_internal', hyperlink, 0, 0)
    result = @worksheet.instance_variable_get(:@writer).string
    expected = '<hyperlink ref="A1" location="Sheet2!A1" display="Sheet2!A1"/>'
    assert_equal(expected, result)
  end

  def test_write_hyperlink_internal_quoted_sheet
    hyperlink = Writexlsx::Worksheet::Hyperlink.factory("internal:'Data Sheet'!D5", "'Data Sheet'!D5")
    @worksheet.__send__('write_hyperlink_internal', hyperlink, 4, 0)
    result = @worksheet.instance_variable_get(:@writer).string
    expected = %q{<hyperlink ref="A5" location="'Data Sheet'!D5" display="'Data Sheet'!D5"/>}
    assert_equal(expected, result)
  end

  def test_write_hyperlink_internal_tooltip
    hyperlink = Writexlsx::Worksheet::Hyperlink.factory('internal:Sheet2!A1', 'Sheet2!A1')
    hyperlink.tip = 'Screen Tip 1'
    @worksheet.__send__('write_hyperlink_internal', hyperlink, 17, 0)
    result = @worksheet.instance_variable_get(:@writer).string
    expected = '<hyperlink ref="A18" location="Sheet2!A1" tooltip="Screen Tip 1" display="Sheet2!A1"/>'
    assert_equal(expected, result)
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
write_xlsx-0.75.0	test/worksheet/test_write_hyperlink.rb
write_xlsx-0.74.0	test/worksheet/test_write_hyperlink.rb
write_xlsx-0.73.0	test/worksheet/test_write_hyperlink.rb
write_xlsx-0.72.3.beta1	test/worksheet/test_write_hyperlink.rb