test/workbook/worksheet/tc_protected_range.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

# frozen_string_literal: true

require 'tc_helper'

class TestProtectedRange < Test::Unit::TestCase
  def setup
    @p = Axlsx::Package.new
    @ws = @p.workbook.add_worksheet { |sheet| sheet.add_row [1, 2, 3, 4, 5, 6, 7, 8, 9] }
  end

  def test_initialize_options
    assert_nothing_raised { Axlsx::ProtectedRange.new(sqref: 'A1:B1', name: "only bob") }
  end

  def test_range
    r = @ws.protect_range('A1:B1')

    assert_equal('A1:B1', r.sqref)
  end
end