Array Formulas

4 views
Skip to first unread message

John Burnett

unread,
Jul 13, 2009, 4:53:07 PM7/13/09
to Spreadsheet::WriteExcel
Does this conversion support calculations based on the conditions in
an array?

jmcnamara

unread,
Jul 29, 2009, 8:56:48 AM7/29/09
to Spreadsheet::WriteExcel
On Jul 13, 9:53 pm, John Burnett <burnettjc0...@gmail.com> wrote:
> Does this conversion support calculations based on the conditions in
> an array?

Hi John,

I'm not sure what you mean exactly but if you are referring to array
formulas then they aren't currently supported.


They are supported in the Spreadsheet::WriteExcelXML moduleif that is
of any use, see the following (make sure the last bracket is included
in the url):

http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcelXML/lib/Spreadsheet/WriteExcelXML.pm#write_array_formula($first_row,_$first_col,_$last_row,_$last_col,_$formula,_$format)

John.


Reply all
Reply to author
Forward
0 new messages