diff options
author | Christopher Burger <burgerc@freeside.biz> | 2017-11-30 10:49:10 -0500 |
---|---|---|
committer | Christopher Burger <burgerc@freeside.biz> | 2017-11-30 10:49:10 -0500 |
commit | 1f24086e325f98eb92b0bc0f6aa60119d3c0340f (patch) | |
tree | d4d48986ffc8aa85e53939449073edfefc87b2d9 | |
parent | ef7e87f054b8dc7c68caa020ddc9876b4e09641f (diff) |
RT# 78019 - updated csv and excel export to set two decimal for revenue columns.
-rw-r--r-- | httemplate/graph/elements/report.html | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/httemplate/graph/elements/report.html b/httemplate/graph/elements/report.html index 70c3a9e..6e6c382 100644 --- a/httemplate/graph/elements/report.html +++ b/httemplate/graph/elements/report.html @@ -52,10 +52,10 @@ any delimiter and linked from the elements in @data. % % my @bottom_total = (); % my $row = 0; -% foreach ( @items ) { +% foreach my $i ( @items ) { % % my $col = 0; -% my @row = map { sprintf($sprintf, $_) } @{ shift(@data) }; +% my @row = map { sprintf($sprintf_fields->{$i} ? $sprintf_fields->{$i} : $sprintf, $_) } @{ shift(@data) }; % my $total = sum(@row); % push @row, sprintf($sprintf, $total) unless $opt{'nototal'}; % unless ($opt{'no_graph'}[$row]) { @@ -101,7 +101,7 @@ any delimiter and linked from the elements in @data. % } % % my @bottom_total = (); -% foreach ( @items ) { +% foreach my $i ( @items ) { % $row++; % $col = 0; % my $total = 0; @@ -109,7 +109,7 @@ any delimiter and linked from the elements in @data. % foreach ( @{ shift( @data ) } ) { % $total += $_; % $bottom_total[$col-1] += $_ unless $opt{no_graph}[$row]; -% $worksheet->write_number($row, $col++, sprintf($sprintf, $_) ); +% $worksheet->write_number($row, $col++, sprintf($sprintf_fields->{$i} ? $sprintf_fields->{$i} : $sprintf, $_) ); % } % if ( !$opt{'nototal'} ) { % $bottom_total[$col-1] += $total unless $opt{no_graph}[$row]; |