examples/merge4.rb in write_xlsx-1.10.0 vs examples/merge4.rb in write_xlsx-1.10.1
- old
+ new
@@ -23,56 +23,56 @@
###############################################################################
#
# Example 1: Text centered vertically and horizontally
#
format1 = workbook.add_format(
- :border => 6,
- :bold => 1,
- :color => 'red',
- :valign => 'vcenter',
- :align => 'center'
+ border: 6,
+ bold: 1,
+ color: 'red',
+ valign: 'vcenter',
+ align: 'center'
)
worksheet.merge_range('B2:D3', 'Vertical and horizontal', format1)
###############################################################################
#
# Example 2: Text aligned to the top and left
#
format2 = workbook.add_format(
- :border => 6,
- :bold => 1,
- :color => 'red',
- :valign => 'top',
- :align => 'left'
+ border: 6,
+ bold: 1,
+ color: 'red',
+ valign: 'top',
+ align: 'left'
)
worksheet.merge_range('B5:D6', 'Aligned to the top and left', format2)
###############################################################################
#
# Example 3: Text aligned to the bottom and right
#
format3 = workbook.add_format(
- :border => 6,
- :bold => 1,
- :color => 'red',
- :valign => 'bottom',
- :align => 'right'
+ border: 6,
+ bold: 1,
+ color: 'red',
+ valign: 'bottom',
+ align: 'right'
)
worksheet.merge_range('B8:D9', 'Aligned to the bottom and right', format3)
###############################################################################
#
# Example 4: Text justified (i.e. wrapped) in the cell
#
format4 = workbook.add_format(
- :border => 6,
- :bold => 1,
- :color => 'red',
- :valign => 'top',
- :align => 'justify'
+ border: 6,
+ bold: 1,
+ color: 'red',
+ valign: 'top',
+ align: 'justify'
)
worksheet.merge_range('B11:D12', 'Justified: ' << ('so on and ' * 18), format4)
workbook.close