Contents

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

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

  def teardown
    @tempfile.close(true)
  end

  def test_cond_format11
    @xlsx = 'cond_format11.xlsx'
    workbook  = WriteXLSX.new(@io)
    worksheet = workbook.add_worksheet

    format = workbook.add_format(
                                 :bg_color => '#FFFF00',
                                 :fg_color => '#FF0000',
                                 :pattern  => 1
                                 )

    worksheet.write('A1', 'Hello', format)

    worksheet.write('B3', 10)
    worksheet.write('B4', 20)
    worksheet.write('B5', 30)
    worksheet.write('B6', 40)

    worksheet.conditional_formatting('B3:B6',
                                     {
                                       :type     => 'cell',
                                       :format   => format,
                                       :criteria => 'greater than',
                                       :value    => 20
                                     }
                                     )

    workbook.close
    compare_for_regression(
      nil,
      { 'xl/workbook.xml' => ['<workbookView'] }
    )
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
write_xlsx-0.86.0	test/regression/test_cond_format11.rb
write_xlsx-0.85.11	test/regression/test_cond_format11.rb
write_xlsx-0.85.10	test/regression/test_cond_format11.rb
write_xlsx-0.85.9	test/regression/test_cond_format11.rb
write_xlsx-0.85.8	test/regression/test_cond_format11.rb
write_xlsx-0.85.7	test/regression/test_cond_format11.rb
write_xlsx-0.85.6	test/regression/test_cond_format11.rb