Contents

require 'test_helper'

class RegressionsTest < MiniTest::Test

  def setup
    @axlsx = Axlsx::Package.new
    @workbook = @axlsx.workbook
  end

  def test_dxf_cell
    @workbook.add_worksheet do |sheet|
      sheet.add_row (1..2).to_a
      sheet.add_style "A1:A1", { bg_color: "AA0000" }

      sheet.add_row (1..2).to_a
      sheet.add_style "B1:B1", { bg_color: "CC0000" }

      sheet.add_row (1..2).to_a
      sheet.add_style "A3:B3", { bg_color: "00FF00" }

      highlight = @workbook.styles.add_style(bg_color: "0000FF", type: :dxf)

      sheet.add_conditional_formatting(
        "A2:B2",
        {
          type: :cellIs,
          operator: :greaterThan,
          formula: "1",
          dxfId: highlight,
          priority: 1
        }
      )
    end

    serialize("test_dxf_cell")

    #puts @workbook.styles.dxfs.map{|x| x.to_xml_string}
    assert_equal @workbook.styles.dxfs.count, 1

    #puts @workbook.styles.cellXfs.map{|x| x.to_xml_string}
    assert_equal @workbook.styles.cellXfs.count, 6
  end

end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
axlsx_styler-1.2.0	test/unit/regresssions_test.rb
axlsx_styler-1.1.0	test/unit/regresssions_test.rb