1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
|
require 'tc_helper.rb'
class TestRow < Test::Unit::TestCase
def setup
p = Axlsx::Package.new
@ws = p.workbook.add_worksheet :name=>"hmmm"
@row = @ws.add_row
end
def test_initialize
assert(@row.cells.empty?, "no cells by default")
assert_equal(@row.worksheet, @ws, "has a reference to the worksheet")
assert_nil(@row.height, "height defaults to nil")
assert([email protected]_height, "no custom height by default")
end
def test_initialize_with_fixed_height
row = @ws.add_row([1,2,3,4,5], :height=>40)
assert_equal(40, row.height)
assert(row.custom_height)
end
def test_style
r = @ws.add_row([1,2,3,4,5])
r.style=1
r.cells.each { |c| assert_equal(c.style,1) }
end
def test_color
r = @ws.add_row([1,2,3,4,5])
r.color = "FF00FF00"
r.cells.each { |c| assert_equal(c.color.rgb, "FF00FF00") }
end
def test_index
assert_equal(@row.row_index, @row.worksheet.rows.index(@row))
end
def test_add_cell
c = @row.add_cell(1)
assert_equal(@row.cells.last, c)
end
def test_add_cell_autowidth_info
cell = @row.add_cell("this is the cell of cells")
width = cell.send(:autowidth)
assert_equal(@ws.column_info.last.width, width)
end
def test_array_to_cells
r = @ws.add_row [1,2,3], :style=>1, :types=>[:integer, :string, :float]
assert_equal(r.cells.size, 3)
r.cells.each do |c|
assert_equal(c.style, 1)
end
r = @ws.add_row [1,2,3], :style=>[1]
assert_equal(r.cells.first.style, 1, "only apply style to cells with at the same index of of the style array")
assert_equal(r.cells.last.style, 0, "only apply style to cells with at the same index of of the style array")
end
def test_custom_height
@row.height = 20
assert(@row.custom_height)
end
def test_height
assert_raise(ArgumentError) { @row.height = -3 }
assert_nothing_raised { @row.height = 15 }
assert_equal(15, @row.height)
end
def test_ph
assert_raise(ArgumentError) { @row.ph = -3 }
assert_nothing_raised { @row.ph = true }
assert_equal(true, @row.ph)
end
def test_hidden
assert_raise(ArgumentError) { @row.hidden = -3 }
assert_nothing_raised { @row.hidden = true }
assert_equal(true, @row.hidden)
end
def test_collapsed
assert_raise(ArgumentError) { @row.collapsed = -3 }
assert_nothing_raised { @row.collapsed = true }
assert_equal(true, @row.collapsed)
end
def test_outlineLevel
assert_raise(ArgumentError) { @row.outlineLevel = -3 }
assert_nothing_raised { @row.outlineLevel = 2 }
assert_equal(2, @row.outlineLevel)
end
def test_to_xml_without_custom_height
doc = Nokogiri::XML.parse(@row.to_xml_string(0))
assert_equal(0, doc.xpath(".//row[@ht]").size)
assert_equal(0, doc.xpath(".//row[@customHeight]").size)
end
def test_to_xml_string
@row.height = 20
@row.s = 1
@row.outlineLevel = 2
@row.collapsed = true
@row.hidden = true
r_s_xml = Nokogiri::XML(@row.to_xml_string(0, ''))
assert_equal(r_s_xml.xpath(".//row[@r=1]").size, 1)
end
def test_to_xml_string_with_custom_height
@row.add_cell 1
@row.height = 20
r_s_xml = Nokogiri::XML(@row.to_xml_string(0, ''))
assert_equal(r_s_xml.xpath(".//row[@r=1][@ht=20][@customHeight=1]").size, 1)
end
end
|
