examples/data_validate.rb in writeexcel-1.0.4 vs examples/data_validate.rb in writeexcel-1.0.5

@@ -10,11 +10,10 @@
 #
 # original written in Perl by John McNamara
 # converted to Ruby by Hideo Nakamura, [e-mail]
 #
 
-require 'rubygems'
 require 'writeexcel'
 
 workbook  = WriteExcel.new('data_validate.xls')
 worksheet = workbook.add_worksheet
 
@@ -150,10 +149,10 @@
 
 worksheet.write(row, 0, txt)
 worksheet.data_validation(row, 1,
     {
         :validate        => 'list',
-        :source          => '=E4:G4'
+        :source          => '=$E$4:$G$4'
     })
 
 
 #
 # Example 7. Limiting input to a date in a fixed range.