summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJesse Luehrs <doy@tozt.net>2013-05-13 17:36:40 -0500
committerJesse Luehrs <doy@tozt.net>2013-05-13 17:36:40 -0500
commit3d6c0f526293626dfc99777938d48d4f58aa5068 (patch)
treefe4b036b04a1ea1928acfb8e8645605a122b2094
parentebc7788e1e3b0c3128ea50fcbb072349ca78e9f1 (diff)
downloadspreadsheet-template-3d6c0f526293626dfc99777938d48d4f58aa5068.tar.gz
spreadsheet-template-3d6c0f526293626dfc99777938d48d4f58aa5068.zip
also support the full range of options here
-rw-r--r--lib/Spreadsheet/Template/Generator/Parser/Excel.pm20
1 files 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}) {