diff options
| author | Mark Wells <mark@freeside.biz> | 2012-07-06 12:59:28 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2012-07-06 12:59:28 -0700 |
| commit | b3d471fc5a646dc0197dd177873899e5b240ea33 (patch) | |
| tree | e6312c4d35a946c98044a990512d46e7afb3daf6 | |
| parent | 2eac549e2daf3114eed36fc6bc3c86c954c6bba1 (diff) | |
excel number format fix, #17971
| -rw-r--r-- | httemplate/search/cust_bill_pkg_referral.html | 2 | ||||
| -rw-r--r-- | httemplate/search/elements/search-xls.html | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/cust_bill_pkg_referral.html b/httemplate/search/cust_bill_pkg_referral.html index f17cea3d9..1bb6b9179 100644 --- a/httemplate/search/cust_bill_pkg_referral.html +++ b/httemplate/search/cust_bill_pkg_referral.html @@ -190,7 +190,7 @@ my @orwhere; push @orwhere, "(cust_bill_pkg.setup > 0)" if $setup; push @orwhere, "($recur_sql > 0)" if $recur; push @orwhere, "($usage_sql > 0)" if $usage; -push @where, join(' OR ', @orwhere); +push @where, '('.join(' OR ', @orwhere).')' if @orwhere; $join_cust = ' JOIN cust_bill USING ( invnum ) LEFT JOIN cust_main USING ( custnum ) diff --git a/httemplate/search/elements/search-xls.html b/httemplate/search/elements/search-xls.html index 6a19cf2f5..a3a8226c5 100644 --- a/httemplate/search/elements/search-xls.html +++ b/httemplate/search/elements/search-xls.html @@ -49,7 +49,7 @@ my $writer = sub { # Wrapper for $worksheet->write. # Do any massaging of the value/format here. my ($r, $c, $value, $format) = @_; - if ( $value =~ /^\Q$money_char\E(\d+\.?\d*)$/ ) { + if ( $value =~ /^\Q$money_char\E(-?\d+\.?\d*)$/ ) { # Currency: strip the symbol, clone the requested format, # and format it for currency $value = $1; |