>> I am also trying to make the totals "line" to stretch (colspan) over the table to create a line to divide the sections on this table
Here's a patch that shows one way of making a solid Total line. It's a bit of cop-out because, rather than attempting to span columns, it's highlighting all cells on rows that contain "Total:".
@@ -47,6 +47,7 @@
foreach my $row ( @{$some_data} )
{
my $k = 0;
+my $is_total_line = grep {$_ eq 'Total:'} @$row;
foreach my $cell ( @{$row} )
{
@@ -67,7 +68,7 @@
font_color => '#4D4D4D', #
justify => "left",
};
- }elsif ( ($cell eq 'Total:') ){
+ }elsif ( $is_total_line ){
$cell_props->[$j]->[$k] = {
background_color => '#FFCA00', #