/
tc_axis.rb
87 lines (74 loc) · 3.46 KB
/
tc_axis.rb
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
require 'tc_helper.rb'
class TestAxis < Test::Unit::TestCase
def setup
@axis = Axlsx::Axis.new 12345, 54321, :gridlines => false, :title => 'Foo'
end
def teardown
end
def test_initialization
assert_equal(@axis.axPos, :b, "axis position default incorrect")
assert_equal(@axis.tickLblPos, :nextTo, "tick label position default incorrect")
assert_equal(@axis.tickLblPos, :nextTo, "tick label position default incorrect")
assert_equal(@axis.crosses, :autoZero, "tick label position default incorrect")
assert(@axis.scaling.is_a?(Axlsx::Scaling) && @axis.scaling.orientation == :minMax, "scaling default incorrect")
assert_raise(ArgumentError) { Axlsx::Axis.new( -1234, 'abcd') }
assert_equal('Foo', @axis.title.text)
end
def test_color
@axis.color = "00FF00"
str = '<?xml version="1.0" encoding="UTF-8"?>'
str << '<c:chartSpace xmlns:c="' << Axlsx::XML_NS_C << '" xmlns:a="' << Axlsx::XML_NS_A << '">'
doc = Nokogiri::XML(@axis.to_xml_string(str))
assert(doc.xpath("//a:srgbClr[@val='00FF00']"))
end
def test_cell_based_axis_title
p = Axlsx::Package.new
p.workbook.add_worksheet(:name=>'foosheet') do |sheet|
sheet.add_row ['battle victories']
sheet.add_row ['bird', 1, 2, 1]
sheet.add_row ['cat', 7, 9, 10]
sheet.add_chart(Axlsx::Line3DChart) do |chart|
chart.add_series :data => sheet['B2:D2'], :labels => sheet['B1']
chart.valAxis.title = sheet['A1']
assert_equal('battle victories', chart.valAxis.title.text)
end
end
end
def test_axis_position
assert_raise(ArgumentError, "requires valid axis position") { @axis.axPos = :nowhere }
assert_nothing_raised("accepts valid axis position") { @axis.axPos = :r }
end
def test_label_rotation
assert_raise(ArgumentError, "requires valid angle") { @axis.label_rotation = :nowhere }
assert_raise(ArgumentError, "requires valid angle") { @axis.label_rotation = 91 }
assert_raise(ArgumentError, "requires valid angle") { @axis.label_rotation = -91 }
assert_nothing_raised("accepts valid angle") { @axis.label_rotation = 45 }
assert_equal(@axis.label_rotation, 45 * 60000)
end
def test_tick_label_position
assert_raise(ArgumentError, "requires valid tick label position") { @axis.tickLblPos = :nowhere }
assert_nothing_raised("accepts valid tick label position") { @axis.tickLblPos = :high }
end
def test_format_code
assert_raise(ArgumentError, "requires valid format code") { @axis.format_code = 1 }
assert_nothing_raised("accepts valid format code") { @axis.tickLblPos = :high }
end
def test_crosses
assert_raise(ArgumentError, "requires valid crosses") { @axis.crosses = 1 }
assert_nothing_raised("accepts valid crosses") { @axis.crosses = :min }
end
def test_gridlines
assert_raise(ArgumentError, "requires valid gridlines") { @axis.gridlines = 'alice' }
assert_nothing_raised("accepts valid crosses") { @axis.gridlines = false }
end
def test_to_xml_string
str = '<?xml version="1.0" encoding="UTF-8"?>'
str << '<c:chartSpace xmlns:c="' << Axlsx::XML_NS_C << '" xmlns:a="' << Axlsx::XML_NS_A << '">'
doc = Nokogiri::XML(@axis.to_xml_string(str))
assert(doc.xpath('//a:noFill'))
assert(doc.xpath("//c:crosses[@val='#{@axis.crosses.to_s}']"))
assert(doc.xpath("//c:crossAx[@val='#{@axis.crossAx.to_s}']"))
assert(doc.xpath("//a:bodyPr[@rot='#{@axis.label_rotation.to_s}']"))
assert(doc.xpath("//a:t[text()='Foo']"))
end
end