in reply to spreadsheet formula issue
I ran your script using the following modified lines, as it didn't require a database transaction:
#set columns A through D $xWS2->set_column( 'A:D', 20 ); # Add column headers for first worksheet my $R = 0; my $C = 0; $xWS->write( $R, $C++, $_ ) for 'A' .. 'Z'; # Read the query results and write them into the spreadsheet for ( 1 .. 26 ) { ++$R; $C = 0; $xWS->write( $R, $C++, $_ ); }
Results in cells E2:E6:
0 0 0 0 6
The formulas in E2:E5 of the "Summary" sheet evalute to 0 because columns B and D are empty in the spreadsheet your script creates. However, you'll note that the '=1+5' in cell E6 is correctly evaluated.
Hope this is helpful.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: spreadsheet formula issue
by PerlSufi (Friar) on May 01, 2013 at 16:10 UTC |
In Section
Seekers of Perl Wisdom