Contents

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

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

  def teardown
    File.delete(@xlsx) if File.exist?(@xlsx)
  end

  def test_cond_format06
    @xlsx = 'cond_format06.xlsx'
    workbook  = WriteXLSX.new(@xlsx)
    worksheet = workbook.add_worksheet

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

    worksheet.write('A1', 10)
    worksheet.write('A2', 20)
    worksheet.write('A3', 30)
    worksheet.write('A4', 40)

    worksheet.conditional_formatting('A1',
                                     {
                                       :type     => 'cell',
                                       :format   => format1,
                                       :criteria => '>',
                                       :value    => 7
                                     }
                                     )

    workbook.close
    compare_xlsx_for_regression(
                                File.join(@regression_output, @xlsx),
                                @xlsx,
                                nil,
                                { 'xl/workbook.xml' => ['<workbookView'] })
  end
end

Version data entries

42 entries across 42 versions & 1 rubygems

Version	Path
write_xlsx-0.54.0	test/regression/test_cond_format06.rb
write_xlsx-0.51.0	test/regression/test_cond_format06.rb