Formular Error!

[Farmer]

It''s a big bug?

if i write
sheet.Range["A1"].Formula= "AB1*0.1";

In Excel,In A1,it''s formula is B1*0.1

Can u help me!

[Administrator]

Hi Cradle, Sorry for the delay in getting back to you. Could you please let me know the version of ExcelRW that you are using. I tested for this issue in version 3.0.1.6 and it seems to work fine. Please run this Samplef25667formulaissue.zip and let me know what value in cell "A1". Thanks, Stephen. >It''s a big bug? > >if i write >sheet.Range["A1"].Formula= "AB1*0.1"; > >In Excel,In A1,it''s formula is B1*0.1 > > >Can u help me!

[Farmer]

hi,

stephen,
I have resolved it by using excel API,
my EXCELRW''s version is 2.0.5.0,
I think in this version,ExcelRW have this bug,

I just let Range[A1].Formula="AB1*0.1".
But in Excel,A1''s Fomular is B1*0.1

Cradle