Formulas and xl_rowcol_to_cell

Hello!

How can I use xl_rowcol_to_cell and formulas? I tried this,
with no sucess:

$a = xl_rowcol_to_cell(13, 23);
$b = xl_rowcol_to_cell(14, 23);
$worksheet->write_formula(14,24,"=($a / $b) *
100",$format);

The message I'm receiving when running this is:

Couldn't parse formula: =($a / $b) * 100

Should this work?

Regards

Roger Jochem

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Spreadsheet::WriteExcel" group.
To post to this group, send email to
spreadsheet-writeexcelgooglegroups.com
To unsubscribe from this group, send email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/spreadsheet-writeexcel
?hl=en
-~----------~----~----~----~------~----~------~--~---

Not it is working!

I found a good sample about that use in:

http://search.cpan.org/src/
JMCNAMARA/Spreadsheet-WriteExcelXML-0.10/examples/sales.pl

2007/8/15, Roger Jochem <roger.jochemgmail.com>:
> Hello!
>
> How can I use xl_rowcol_to_cell and formulas? I tried
this, with no sucess:
>
> $a = xl_rowcol_to_cell(13, 23);
> $b = xl_rowcol_to_cell(14, 23);
> $worksheet->write_formula(14,24,"=($a / $b) *
100",$format);
>
> The message I'm receiving when running this is:
>
> Couldn't parse formula: =($a / $b) * 100
>
> Should this work?
>
> Regards
>
> Roger Jochem
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Spreadsheet::WriteExcel" group.
To post to this group, send email to
spreadsheet-writeexcelgooglegroups.com
To unsubscribe from this group, send email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
For more options, visit this group at http://groups.google.com/group/spreadsheet-writeexcel
?hl=en
-~----------~----~----~----~------~----~------~--~---