From Code to Community: Sponsoring The Perl and Raku Conference 2025 Learn more

NKH / Spreadsheet-Perl-0.12 / Perl / Function.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
97
98
99
100
101
102
103
104
105

              
package Spreadsheet::Perl ;
use 5.006 ;
use Carp ;
use strict ;
use warnings ;
require Exporter ;
our @ISA = qw(Exporter) ;
our %EXPORT_TAGS = 
        (
        'all' => [ qw() ]
        ) ;
our @EXPORT_OK = ( @{ $EXPORT_TAGS{'all'} } ) ;
our @EXPORT ;
push @EXPORT, qw( StoreFunction FetchFunction StoreOnFetch DeleteFunction) ;
our $VERSION = '0.01' ;
#-------------------------------------------------------------------------------
sub StoreFunction
{
confess "First argument to 'StoreFunction' should be a description" unless '' eq ref $_[0] ;
return bless [@_], "Spreadsheet::Perl::StoreFunction" ;
}
#-------------------------------------------------------------------------------
sub FetchFunction
{
confess "First argument to 'FetchFunction' should be a description" unless '' eq ref $_[0] ;
return bless [@_], "Spreadsheet::Perl::FetchFunction" ;
}
#-------------------------------------------------------------------------------
sub StoreOnFetch
{
return bless [@_], "Spreadsheet::Perl::StoreOnFetch" ;
}
#-------------------------------------------------------------------------------
sub DeleteFunction
{
return bless [@_], "Spreadsheet::Perl::DeleteFunction" ;
}
#-------------------------------------------------------------------------------
1 ;
__END__
=head1 NAME
Spreadsheet::Perl::Function - Function support for Spreadsheet::Perl
=head1 SYNOPSIS
  sub SumRowsAbove
  {
  my $ss = shift ;
  my $address  = shift ;
  my @arguments = @_ ;
   
  my ($x, $y) = Spreadsheet::Perl::ConvertAdressToNumeric($address) ;
   
  my $sum = 0 ;
   
  for my $current_y (1 .. ($y - 1))
        {
        my $cell_value = $ss->Get("$x,$current_y") ;
         
        $sum += $cell_value if (is_numeric($cell_value)) ;
        }
         
  return($sum) ;
  }
  $ss{A1} = FetchFunction(\&SumRowsAbove, $arg1, $arg2, ...)
   
=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>.
=cut