The Perl and Raku Conference 2025: Greenville, South Carolina - June 27-29 Learn more

NKH / Spreadsheet-Perl-0.12 / Perl / Arithmetic.pm 

            

              
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
—
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

              
package Spreadsheet::Perl::Arithmetic ;
use 5.006 ;
use Carp ;
use strict ;
use warnings ;
require Exporter ;
#~ use AutoLoader qw(AUTOLOAD) ;
our @ISA = qw(Exporter) ;
our %EXPORT_TAGS = 
        (
        'all' => [ qw() ]
        ) ;
our @EXPORT_OK = ( @{ $EXPORT_TAGS{'all'} } ) ;
our @EXPORT = qw( ) ;
#our @EXPORT ;
#push @EXPORT, qw( ) ;
our $VERSION = '0.02' ;
use Spreadsheet::Perl ;
use Scalar::Util qw(looks_like_number) ;
#-------------------------------------------------------------------------------
sub Sum
{
my $ss = shift ;
my @addresses  = @_ ;
my $sum = 0 ;
for my $address (@addresses)
        {
        for my $current_address ($ss->GetAddressList($address))
                {
                my $cell_value = $ss->Get($current_address) ;
                 
                #~ if(exists $ss->{DEBUG_MODULE}{ARITHMETIC_SUM})
                        #~ {
                        #~ print $self->{DEBUG}{ERROR_HANDLE} "Sum: $current_address => $cell_value\n" ;
                        #~ }
                 
                $sum += $cell_value if (defined $cell_value && looks_like_number($cell_value)) ; 
                }
         
        }
         
return($sum) ;
}
DefineSpreadsheetFunction('Sum', \&Sum, undef, __PACKAGE__) ;
DefineSpreadsheetFunction('SUM', \&Sum, undef, __PACKAGE__) ;
#-------------------------------------------------------------------------------
1 ;
__END__
=head1 NAME
Spreadsheet::Perl::Arithmetic - Arithmetic functions for Spreadsheet::Perl
=head1 SYNOPSIS
  my $sum = $ss->Sum('A5:B8') ;
  $ss{A5} = PerlFormula('$ss->Sum('A5:B8')') ;
   
=head1 DESCRIPTION
Part of Spreadsheet::Perl.
=head1 AUTHOR
Khemir Nadim ibn Hamouda. <nadim@khemir.net>
  Copyright (c) 2004 Nadim Ibn Hamouda el Khemir. All rights
  reserved.  This program is free software; you can redis-
  tribute it and/or modify it under the same terms as Perl
  itself.
   
If you find any value in this module, mail me!  All hints, tips, flames and wishes
are welcome at <nadim@khemir.net>.
=head1 DEPENDENCIES
B<Spreadsheet::ConvertAA>.
=cut