From 3d6c0f526293626dfc99777938d48d4f58aa5068 Mon Sep 17 00:00:00 2001
From: Jesse Luehrs <doy@tozt.net>
Date: Mon, 13 May 2013 17:36:40 -0500
Subject: also support the full range of options here

---
 lib/Spreadsheet/Template/Generator/Parser/Excel.pm | 20 ++++++++++++++++++--
 1 file changed, 18 insertions(+), 2 deletions(-)

diff --git a/lib/Spreadsheet/Template/Generator/Parser/Excel.pm b/lib/Spreadsheet/Template/Generator/Parser/Excel.pm
index e4bf47a..a7f97cd 100644
--- a/lib/Spreadsheet/Template/Generator/Parser/Excel.pm
+++ b/lib/Spreadsheet/Template/Generator/Parser/Excel.pm
@@ -107,6 +107,8 @@ sub _parse_cell {
             4 => 'fill',
             5 => 'justify',
             6 => 'center_across',
+            # XXX this isn't supported by Spreadsheet::WriteExcel
+            7 => 'distributed',
         );
 
         my %valign = (
@@ -114,11 +116,25 @@ sub _parse_cell {
             1 => 'vcenter',
             2 => 'bottom',
             3 => 'vjustify',
+            # XXX this isn't supported by Spreadsheet::WriteExcel
+            4 => 'vdistributed',
         );
 
         my %border = (
-            0 => 'none',
-            5 => 'thin',
+            0  => 'none',
+            1  => 'thin',
+            2  => 'medium',
+            3  => 'dashed',
+            4  => 'dotted',
+            5  => 'thick',
+            6  => 'double',
+            7  => 'hair',
+            8  => 'medium_dashed',
+            9  => 'dash_dot',
+            10 => 'medium_dash_dot',
+            11 => 'dash_dot_dot',
+            12 => 'medium_dash_dot_dot',
+            13 => 'slant_dash_dot',
         );
 
         if (!$format->{IgnoreFont}) {
-- 
cgit v1.2.3-54-g00ecf