Added formula_values options and specs for sheet format pr.

This lets cache formula values and specify the default row height so
that iOS and Max OSX previews render properly

2 files changed, 12 insertions, 3 deletions

diff --git a/examples/example.rb b/examples/example.rb
index 47b0a67f..94b81444 100755
--- a/examples/example.rb
+++ b/examples/example.rb
@@ -44,7 +44,7 @@ examples << :conditional_formatting
 examples << :streaming
 examples << :shared_strings
 examples << :no_autowidth
-
+examples << :cached_formula
 p = Axlsx::Package.new
 wb = p.workbook
 #```
@@ -724,11 +724,20 @@ if examples.include? :no_autowidth
   wb.add_worksheet(:name => "Manual Widths") do | sheet |
     sheet.add_row ['oh look! no autowidth']
   end
-  p.validate.each { |e| puts e.message }
   p.serialize("no-use_autowidth.xlsx")
 end
 #```
 
 
 
+if examples.include? :cached_formula
+  p = Axlsx::Package.new
+  p.use_shared_strings = true
+  wb = p.workbook
+  wb.add_worksheet(:name => "cached formula") do | sheet |
+    puts sheet.sheet_format_pr
+    sheet.add_row [1, 2, '=A1+B1'], :formula_values => [nil, nil, 3]
+  end
+  p.serialize 'cached_formula.xlsx'
+end
 
diff --git a/examples/ios_preview.rb b/examples/ios_preview.rb
index 15367a81..60b3010f 100644
--- a/examples/ios_preview.rb
+++ b/examples/ios_preview.rb
@@ -10,5 +10,5 @@ p.use_shared_strings = true
 s = p.workbook.add_worksheet(:name => "Formula test")
 s.add_row [1, 2, 3]
 s.add_row %w(a b c)
-s.add_row ["=SUM(A1:C1)"]
+s.add_row ["=SUM(A1:C1)"], :formula_values => [6]
 p.serialize "ios_preview.xlsx"