Contents

# -*- coding: utf-8 -*-
##########################################################################
# test_23_note.rb
#
# Tests for some of the internal method used to write the NOTE record that
# is used in cell comments.
#
# reverse('©'), September 2005, John McNamara, [e-mail]
#
# original written in Perl by John McNamara
# converted to Ruby by Hideo Nakamura, [e-mail]
#
#########################################################################
require 'helper'
require 'stringio'

class TC_note < Test::Unit::TestCase

  def setup
    @workbook   = WriteExcel.new(StringIO.new)
    @worksheet  = @workbook.add_worksheet
  end

  def teardown
    @workbook.close
  end

  def test_blank_author_name
    data = @worksheet.comment_params(2, 0, 'Test')
    row      = data[0]
    col      = data[1]
    author   = data[4]
    encoding = data[5]
    visible  = data[6]
    obj_id   = 1

    caption = sprintf(" \tstore_note")
    target  = %w(
        1C 00 0C 00 02 00 00 00 00 00 01 00 00 00 00 00
    ).join(' ')
    result = unpack_record(
        @worksheet.store_note(row, col, obj_id, author, encoding, visible))
    assert_equal(target, result, caption)
  end

  def test_defined_author_name
    data = @worksheet.comment_params(2,0,'Test', :author => 'Username')
    row      = data[0]
    col      = data[1]
    author   = data[4]
    encoding = data[5]
    visible  = data[6]
    obj_id   = 1

    caption = sprintf(" \tstore_note")
    target  = %w(
        1C 00 14 00 02 00 00 00 00 00 01 00 08 00 00 55
        73 65 72 6E 61 6D 65 00
    ).join(' ')
    result = unpack_record(
        @worksheet.store_note(row,col,obj_id,author,encoding,visible))
    assert_equal(target, result, caption)
  end

  ###############################################################################
  #
  # Unpack the binary data into a format suitable for printing in tests.
  #
  def unpack_record(data)
    data.unpack('C*').map! {|c| sprintf("%02X", c) }.join(' ')
  end

end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
writeexcel-0.6.6	test/test_23_note.rb
writeexcel-0.6.5	test/test_23_note.rb
writeexcel-0.6.4	test/test_23_note.rb
writeexcel-0.6.3	test/test_23_note.rb
writeexcel-0.6.2	test/test_23_note.rb
writeexcel-0.6.1	test/test_23_note.rb
writeexcel-0.6.0	test/test_23_note.rb