examples/example.rb in axlsx-1.2.1 vs examples/example.rb in axlsx-1.2.2

@@ -53,26 +53,26 @@
 
   # You can also apply cell style overrides to a range of cells
   sheet["A1:D1"].each { |c| c.color = "FF0000" }
   sheet['A1:D2'].each { |c| c.style = Axlsx::STYLE_THIN_BORDER }
 end
-#```
+##```
 
 ##Using Custom Border Styles
 
 #```ruby
 #Axlsx defines a thin border style, but you can easily create and use your own.
 wb.styles do |s|
-  red_border =  s.add_style :border => { :style => :thick, :color =>"FFFF0000" }
-  blue_border =  s.add_style :border => { :style => :thick, :color =>"FF0000FF" }
+  red_border =  s.add_style :border => { :style => :thick, :color =>"FFFF0000", :edges => [:left, :right] }
+  blue_border =  s.add_style :border => { :style => :thick, :color =>"FF0000FF"}
 
   wb.add_worksheet(:name => "Custom Borders") do |sheet|
     sheet.add_row ["wrap", "me", "Up in Red"], :style => red_border
     sheet.add_row [1, 2, 3], :style => blue_border
   end
 end
-#```
+##```
 
 
 ##Styling Rows and Columns
 
 #```ruby
@@ -99,22 +99,22 @@
 
     sheet.rows[3].hidden = true
     sheet.rows[1].outlineLevel = 2
   end
 end
-#```
+##```
 
 
 ##Specifying Column Widths
 
 #```ruby
 wb.add_worksheet(:name => "custom column widths") do |sheet|
   sheet.add_row ["I use autowidth and am very wide", "I use a custom width and am narrow"]
   sheet.add_row ['abcdefg', 'This is a very long text and should flow into the right cell', nil, 'xxx' ]
   sheet.column_widths nil, 3, 5, nil
 end
-#```
+##```
 
 ##Merging Cells.
 
 #```ruby
 wb.add_worksheet(:name => 'Merging Cells') do |sheet|
@@ -125,11 +125,11 @@
   sheet.add_row ["total", "", "", "=SUM(D2:D3)"]
   sheet.merge_cells("A4:C4")
   sheet["A1:D1"].each { |c| c.color = "FF0000"}
   sheet["A1:D4"].each { |c| c.style = Axlsx::STYLE_THIN_BORDER }
 end
-#```
+##```
 
 ##Add an Image with a hyperlink
 
 #```ruby
 wb.add_worksheet(:name => "Image with Hyperlink") do |sheet|
@@ -167,20 +167,20 @@
 wb.add_worksheet(:name => "日本語でのシート名") do |sheet|
   sheet.add_row ["日本語"]
   sheet.add_row ["华语/華語"]
   sheet.add_row ["한국어/조선말"]
 end
-#```
+##```
 
 ##Using formula
 
 #```ruby
 wb.add_worksheet(:name => "Using Formulas") do |sheet|
   sheet.add_row ['col 1', 'col 2', 'col 3', 'col 4']
   sheet.add_row [1, 2, 3, "=SUM(A2:C2)"]
 end
-#```
+##```
 
 ##Auto Filter
 
 #```ruby
 wb.add_worksheet(:name => "Auto Filter") do |sheet|
@@ -193,10 +193,11 @@
 end
 #```
 
 ##Automatic cell types
 
+
 #```ruby
 wb.add_worksheet(:name => "Automatic cell types") do |sheet|
   date_format = wb.styles.add_style :format_code => 'YYYY-MM-DD'
   time_format = wb.styles.add_style :format_code => 'hh:mm:ss'
   sheet.add_row ["Date", "Time", "String", "Boolean", "Float", "Integer"]
@@ -207,27 +208,27 @@
 # Hyperlinks in worksheet
 wb.add_worksheet(:name => 'hyperlinks') do |sheet|
   # external references
   sheet.add_row ['axlsx']
   sheet.add_hyperlink :location => 'https://github.com/randym/axlsx', :ref => sheet.rows.first.cells.first
-
   # internal references
+  sheet.add_hyperlink :location => "'Next Sheet'!A1", :ref => 'A2', :target => :sheet
   sheet.add_row ['next sheet']
 end
 
 wb.add_worksheet(:name => 'Next Sheet') do |sheet|
   sheet.add_row ['hello!']
 end
-#```
+###```
 
 ##Number formatting and currency
 wb.add_worksheet(:name => "Formats and Currency") do |sheet|
   currency = wb.styles.add_style :num_fmt => 5
   red_negative = wb.styles.add_style :num_fmt => 8
   comma = wb.styles.add_style :num_fmt => 3
-  super_funk = wb.styles.add_style :format_code => '[Green]"super funk: " #'
-  sheet.add_row %w(Currency RedNegative, Comma Custom)
+  super_funk = wb.styles.add_style :format_code => '[Green]#'
+  sheet.add_row %w(Currency RedNegative Comma Custom)
   sheet.add_row [1500, -122.34, 123456789, 594829], :style=> [currency, red_negative, comma, super_funk]
 end
 
 ##Generating A Bar Chart
 
@@ -237,11 +238,11 @@
   %w(first second third).each { |label| sheet.add_row [label, rand(24)+1] }
   sheet.add_chart(Axlsx::Bar3DChart, :start_at => "A6", :end_at => "F20") do |chart|
     chart.add_series :data => sheet["B2:B4"], :labels => sheet["A2:A4"], :title => sheet["A1"]
   end
 end
-#```
+##```
 
 ##Hide Gridlines in chart
 
 #```ruby
 wb.add_worksheet(:name => "Chart With No Gridlines") do |sheet|
@@ -469,10 +470,12 @@
 # This is required by Numbers
 p.use_shared_strings = true
 p.serialize("shared_strings_example.xlsx")
 #```
 
-
+#p.validate do |er|
+  #puts er.inspect
+#end
 ##Disabling Autowidth
 
 #```ruby
 p = Axlsx::Package.new
 p.use_autowidth = false