X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Felements%2Fsearch-xls.html;h=8334497d2ec00a59973257ed5dedc2e0d4717048;hb=03dfd875f74410d283060a4e54eaedf845bfcd39;hp=bc844a57974bba4123c1b6d56ba5a5663adf6e5e;hpb=67e981bedc57f0834bdb43069366e6026c058705;p=freeside.git diff --git a/httemplate/search/elements/search-xls.html b/httemplate/search/elements/search-xls.html index bc844a579..8334497d2 100644 --- a/httemplate/search/elements/search-xls.html +++ b/httemplate/search/elements/search-xls.html @@ -32,7 +32,10 @@ my $XLS = new IO::Scalar \$data; my $workbook = $format->{class}->new($XLS) or die "Error opening Excel file: $!"; -my $worksheet = $workbook->add_worksheet(substr($opt{'title'},0,31)); +my $title = $opt{'title'}; +$title =~ s/[\[\]\:\*\?\/\/]//g; +$title = substr($title, 0, 31); +my $worksheet = $workbook->add_worksheet($title); $worksheet->protect();