Sha256: 67e7ab068cc9c98835a465be59d9fa4f7198dffe54da2c229c952d3d9b760c2c

Contents?: true

Size: 1.46 KB

Versions: 17

Compression:

Stored size: 1.46 KB

Contents

require 'rubygems'
require 'rubyXL'

describe RubyXL::Workbook do
  before do
    @workbook  = RubyXL::Workbook.new
    @worksheet = @workbook.add_worksheet('Test Worksheet')

    (0..10).each do |i|
      (0..10).each do |j|
        @worksheet.add_cell(i, j, "#{i}:#{j}")
      end
    end

    @cell = @worksheet[0][0]
  end

  describe '.new' do
    it 'should automatically create a blank worksheet named "Sheet1"' do
      @workbook[0].sheet_name.should == 'Sheet1'
    end
  end

  describe '[]' do
    it 'should properly locate worksheet by index' do
      @workbook[1].sheet_name.should == 'Test Worksheet'
    end

    it 'should properly locate worksheet by name' do
      @workbook['Test Worksheet'].sheet_name.should == 'Test Worksheet'
    end
  end

  describe '.add_worksheet' do
    it 'when not given a name, it should automatically pick a name "SheetX" that is not taken yet' do
      @workbook.add_worksheet
      @workbook['Sheet2'].sheet_name.should == 'Sheet2'
    end
  end

  describe '.write' do
    #method not conducive to unit tests
  end

  describe '.get_fill_color' do
    it 'should return the fill color of a particular style attribute' do
      @cell.change_fill('000000')
      @workbook.get_fill_color(@workbook.cell_xfs[@cell.style_index]).should == '000000'
    end

    it 'should return white (ffffff) if no fill color is specified in style' do
      @workbook.get_fill_color(@workbook.cell_xfs[@cell.style_index]).should == 'ffffff'
    end
  end

end

Version data entries

17 entries across 17 versions & 1 rubygems

Version Path
rubyXL-2.5.4 spec/lib/workbook_spec.rb
rubyXL-2.5.3 spec/lib/workbook_spec.rb
rubyXL-2.5.2 spec/lib/workbook_spec.rb
rubyXL-2.5.1 spec/lib/workbook_spec.rb
rubyXL-2.5.0 spec/lib/workbook_spec.rb
rubyXL-2.4.4 spec/lib/workbook_spec.rb
rubyXL-2.4.3 spec/lib/workbook_spec.rb
rubyXL-2.4.2 spec/lib/workbook_spec.rb
rubyXL-2.4.1 spec/lib/workbook_spec.rb
rubyXL-2.4.0 spec/lib/workbook_spec.rb
rubyXL-2.3.4 spec/lib/workbook_spec.rb
rubyXL-2.3.3 spec/lib/workbook_spec.rb
rubyXL-2.3.2 spec/lib/workbook_spec.rb
rubyXL-2.3.1 spec/lib/workbook_spec.rb
rubyXL-2.3.0 spec/lib/workbook_spec.rb
rubyXL-2.2.0 spec/lib/workbook_spec.rb
rubyXL-2.1.1 spec/lib/workbook_spec.rb