Spreadsheet::Engine::Function::counter - base class for counting functions
use base 'Spreadsheet::Engine::Function::count'; sub calculate { return sub { my $type = shift; return is_match($type) }; }
This provides a base class for spreadsheet functions that count the number of values in a list that match a certain type (COUNT, COUNTA, COUNTBLANK, etc).
By default all such functions take one or more argument.
This is always a number.
Returns a subref that is given each type in turn and returns a true/false value for whether or not it should be counted in the total.
This is a Modified Version of code extracted from SocialCalc::Functions in SocialCalc 1.1.0
Portions (c) Copyright 2005, 2006, 2007 Software Garden, Inc. All Rights Reserved.
Portions (c) Copyright 2007 Socialtext, Inc. All Rights Reserved.
Portions (c) Copyright 2007, 2008 Tony Bowden
The contents of this file are subject to the Artistic License 2.0; you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.perlfoundation.org/artistic_license_2_0
To install Spreadsheet::Engine, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Spreadsheet::Engine
CPAN shell
perl -MCPAN -e shell install Spreadsheet::Engine
For more information on module installation, please visit the detailed CPAN module installation guide.