Custom Formulas a la VBA

Aspose.Cells Product Family
21

Hi Pradeepac,

I tried with following test code and it works fine.

Workbook wb = new Workbook();
Cell cell = wb.Worksheets[0].Cells["a9"];
cell.SetAddInFormula("ATPVBAEN.XLA", "=YIELD(\"05/09/2006\",\"03/12/2007\",0.0539000000,101.2945148936170213,100,4,0)");

cell = wb.Worksheets[0].Cells["a15"];
cell.SetAddInFormula("ATPVBAEN.XLA", "=YIELD(\"05/09/2006\",\"03/12/2007\",0.0539000000,101.2945148936170213,100,4,0)");

cell = wb.Worksheets[0].Cells["a10"];
cell.SetAddInFormula("ATPVBAEN.XLA", "=YIELD(\"05/09/2006\",\"03/12/2007\",0.0539000000,101.2945148936170213,100,4,0)");
wb.Save("d:\\test\\abc.xls");

Could you please post your code to reproduce this problem? Thank you very much.

22

Hi Pradeepac,

The previous fix works fine on ExcelXP or 2003 but may have some problems with Excel 97, 2000 or so.

Please try the attached fix. It should solve the problem and you may use any version of MS Excel (97-2003) to open your output file generated by Aspose.Cells.

Thank you.

Thank you.