NAME
Spreadsheet::Engine - Core calculation engine for a spreadsheet
SYNOPSIS
use Spreadsheet::Engine::Sheet;
my $sheet = {};
parse_sheet_save( [] => $sheet );
execute_sheet_command($sheet => 'set A1 value n 2');
execute_sheet_command($sheet => 'set A2 value n 4');
execute_sheet_command($sheet => 'set A3 formula SUM(A1:A2)');
recalc_sheet($sheet);
print $sheet->{datavalues}{A3}; # 6DESCRIPTION
This provides back-end spreadsheet functionality for creating a sheet, setting cells to have value or formulae, and performing all necessary calculations. There is no front-end UI provided - this is purely the calculation engine.
Over 110 spreadsheet functions are provided: see Spreadsheet::Engine::Functions for the full list.
WARNING
Although the core underlying code is relatively mature and featureful, there will be significant interface changes and refactoring going forward with this version. There are very few automated tests as yet, so this process is likely to introduce bugs. Please pay close attention to the CHANGES file if you upgrade this package.
HISTORY
The original Spreadsheet::Engine code was taken from SocialCalc version 1.1.0, which in turn originated as wikiCalc(R) version 1.0.
AUTHORS
wikiCalc was developed by Dan Bricklin, at Software Garden, Inc.
SocialCalc 1.1.0 was developed by Dan Bricklin, Casey West, and Tony Bowden, at Socialtext, Inc.
Spreadsheet::Engine is developed and maintained by Tony Bowden <tony@tmtm.com>
COPYRIGHT
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 Tony Bowden
LICENSE
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