From e13f842776ec5eaed40ec4426ebb46366bdd8a71 Mon Sep 17 00:00:00 2001
From: Jan-Hendrik Hühne <jan.huehne@googlemail.com>
Date: Tue, 22 May 2012 15:41:14 +0200
Subject: Bugfix

---
 lib/axlsx/workbook/worksheet/worksheet.rb | 10 +++++++---
 1 file changed, 7 insertions(+), 3 deletions(-)

(limited to 'lib')

diff --git a/lib/axlsx/workbook/worksheet/worksheet.rb b/lib/axlsx/workbook/worksheet/worksheet.rb
index 58284fa6..56c17f32 100644
--- a/lib/axlsx/workbook/worksheet/worksheet.rb
+++ b/lib/axlsx/workbook/worksheet/worksheet.rb
@@ -214,7 +214,7 @@ module Axlsx
     def add_data_validation(cells, data_validation)
       dv = DataValidation.new(data_validation)
       dv.sqref = cells
-      @data_validations << data_validation
+      @data_validations << dv
     end
 
     # Creates merge information for this worksheet.
@@ -519,8 +519,12 @@ module Axlsx
        str.concat cf.to_xml_string
      end
      
-     @data_validations.each do |df|
-       str.concat df.to_xml_string
+     unless @data_validations.empty?
+       str.concat "<dataValidations count=\"#{@data_validations.size}\">"
+       @data_validations.each do |df|
+         str.concat df.to_xml_string
+       end
+       str.concat '</dataValidations>'
      end
      str + '</worksheet>'
     end
-- 
cgit v1.2.3