}
-=item spreadsheet_format
+=item spreadsheet_format [ OVERRIDE ]
Returns a hashref of this user's Excel spreadsheet download settings:
'extension' (xls or xlsx), 'class' (Spreadsheet::WriteExcel or
-Excel::Writer::XLSX), and 'mime_type'.
+Excel::Writer::XLSX), and 'mime_type'. If OVERRIDE is 'XLS' or 'XLSX',
+use that instead of the user's setting.
=cut
+# is there a better place to put this?
my %formats = (
XLS => {
extension => '.xls',
sub spreadsheet_format {
my $self = shift;
+ my $override = shift;
- my $f = $self->option('spreadsheet_format')
- || $conf->config('spreadsheet_format')
- || 'XLS';
+ my $f = $override
+ || $self->option('spreadsheet_format')
+ || $conf->config('spreadsheet_format')
+ || 'XLS';
$formats{$f};
}