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 Sample
f25667formulaissue.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!