Options

2013R2 Excel Buffer - excel formula

rocopsarocopsa Member Posts: 38
](*,) 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 :cry: and displays "Exception from HRESULT: 0x800A03EC"..... ](*,)
Could any experts please help? I searched many posts already but cannot find the answer.....

Thanks in advance!

Answers

  • Options
    JamieHurstJamieHurst Member Posts: 25
    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.
  • Options
    rocopsarocopsa Member Posts: 38
    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!
Sign In or Register to comment.