How do Formula

[GoogleCodeExporter]

I have this example

---------------------------------------------------------------

var sheet:Sheet = new Sheet();
sheet.resize(10, 10);

sheet.setCell(0, 0, "Today's date:");
sheet.setCell(0, 1, new Date());

for(var i:int=1; i<4; i++)
{
  var valor:int = 13*i;
  sheet.setCell(i, 1, valor);
}

var tokens:ByteArray = new ByteArray();

var formula:Formula = new Formula(4, 1, tokens, BIFFVersion.BIFF8, sheet);
sheet.setCell(4, 1, formula);

var xls:ExcelFile = new ExcelFile();
xls.sheets.addItem(sheet);
var bytes:ByteArray = xls.saveToByteArray();

var sFilePath:String = "myfile.xls";

var fr:FileReference = new FileReference(); 
fr.save(bytes, sFilePath); 

---------------------------------------------------------------

I want apply Sum Formula to cell {[1,1], [2,1], [3,1]}

any idea?

Original issue reported on code.google.com by miguelhpm on 7 Nov 2011 at 2:54