2013R2 Excel Buffer - excel formula

rocopsa

](*,) Dear Experts,

I am making a report export to Excel by Excel Buffer. In classic client, i can easily make excel formula like:
ExcelBuf.AddColumn('=(RC[-4]*-1)-(RC[-3]+RC[-2]-RC[-1])',TRUE,'',TRUE,FALSE,FALSE,'');

But now in 2013R2, i make it:
ExcelBuf.AddColumn('=(RC[-4]*-1)-(RC[-3]+RC[-2]-RC[-1])',TRUE,'',TRUE,FALSE,FALSE,'',0);

It is not working anymore and displays "Exception from HRESULT: 0x800A03EC"..... ](*,)
Could any experts please help? I searched many posts already but cannot find the answer.....

Thanks in advance!

JamieHurst

rocopsa wrote:

=(RC[-4]*-1)-(RC[-3]+RC[-2]-RC[-1])

Does it work if you use a formula with A1 referencing? I'm not suggesting you re-engineer, but if R1C1 is causing the error, maybe there's a control or setting somewhere.

rocopsa

Dear JamieHurst,

Thanks for your idea.

Actually, the problem is caused by my customization of Excel multi-sheets. Now, it is solved and excel formula is working. \:D/
Like:
ExcelBuf.AddColumnMulti(STRSUBSTNO('SUM(A2:A%1)',LastRowNo),TRUE,'',TRUE,FALSE,FALSE,'#,##0.00',0,vSheet);

Thanks again!