I am generating a spreadsheet using Spreadsheet::WriteExcel. Everything is working fine except a formula containing =SUMIF(A5:A10, C15,C5:C10). The formula gets generated correctly in the spreadsheet but in order to get the resulting value to be displayed in the cell, you have to edit the cell (i.e., click in the edit bar, hit enter). After performing an edit (without changing anything), the formula is evaluated correctly and displays the value.
Is there any way to get the formula to evaluate without having to edit the cell? The spreadsheets that I am creating are locked so the user cannot make changes to the formulas. The script that creates the spreadsheet will create hundreds of spreadsheets each time it is run. I have attempted to force a recalculation of the spreadsheet from within Excel but that does not solve the issue. The version of the module as shown from PPM query is: Spreadsheet-WriteExcel-Simple [0.03] A simple single-sheet Excel document Your assistance is appreciated. Ronald G. Nichols Director of Information Technology Knouse Foods Cooperative 717 677-7111 Ext. 3470 [EMAIL PROTECTED]
_______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs