From 3bdb2d71698f4630c275e72f80a838b905c8cd11 Mon Sep 17 00:00:00 2001
From: Jan-Hendrik Hühne <jan.huehne@googlemail.com>
Date: Thu, 24 May 2012 11:13:36 +0200
Subject: Examples

---
 examples/data_validation.rb | 46 +++++++++++++++++++++++++++++++++++++++++----
 1 file changed, 42 insertions(+), 4 deletions(-)

diff --git a/examples/data_validation.rb b/examples/data_validation.rb
index 84677066..56248ec3 100644
--- a/examples/data_validation.rb
+++ b/examples/data_validation.rb
@@ -5,8 +5,46 @@ require 'axlsx'
 
 p = Axlsx::Package.new
 p.workbook.add_worksheet do |ws| 
-  data_validation_1 = { :type => :whole, :formula1 => '4', :formula2 => '10'}
-
-  ws.add_data_validation("A1", data_validation_1)
+  ws.add_data_validation("A10", { 
+    :type => :whole, 
+    :operator => :between, 
+    :formula1 => '5', 
+    :formula2 => '10', 
+    :showErrorMessage => true, 
+    :errorTitle => 'Wrong input', 
+    :error => 'Only values between 5 and 10', 
+    :errorStyle => :information, 
+    :showInputMessage => true, 
+    :promptTitle => 'Be carful!', 
+    :prompt => 'Only values between 5 and 10'})
+  
+  ws.add_data_validation("B10", { 
+    :type => :textLength, 
+    :operator => :greaterThan, 
+    :formula1 => '10', 
+    :showErrorMessage => true, 
+    :errorTitle => 'Text is too long', 
+    :error => 'Max text length is 10 characters', 
+    :errorStyle => :stop, 
+    :showInputMessage => true, 
+    :promptTitle => 'Text length', 
+    :prompt => 'Max text length is 10 characters'})
+  
+  8.times do |i|
+    ws.add_row [nil, nil, i*2]
+  end
+  
+  ws.add_data_validation("C10", { 
+    :type => :list, 
+    :formula1 => 'C1:C8', 
+    :showDropDown => false,
+    :showErrorMessage => true, 
+    :errorTitle => '', 
+    :error => 'Only values from C1:C8', 
+    :errorStyle => :stop, 
+    :showInputMessage => true, 
+    :promptTitle => '', 
+    :prompt => 'Only values from C1:C8'})
 end
-p.serialize 'data_validations.xlsx'
+
+p.serialize 'data_validation.xlsx'
\ No newline at end of file
-- 
cgit v1.2.3