R1C1 References using OLE2

[krindler]

Hello...Can anyone help me figure out why the following Formula reference does not work? It does not put anything into the cell...

args := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG ( args, v_can_ctr + 7 );
OLE2.ADD_ARG ( args, 10 );
cell := OLE2.GET_OBJ_PROPERTY ( worksheet, 'Cells', args );
OLE2.DESTROY_ARGLIST ( args );

OLE2.SET_PROPERTY(cell,'ForumulaR1C1','=(R[-5]C-R[-1]C)');
OLE2.SET_PROPERTY ( cell, 'NumberFormat', '$#,##0.00' );
font := OLE2.GET_OBJ_PROPERTY ( cell, 'font' );
OLE2.SET_PROPERTY ( font, 'bold', true );

OLE2.RELEASE_OBJ ( cell );

Any help anyone could give me would be much appreciated.

Thanks In Advance!!

 

[sfvb]

I looks like FormulaR1C1 is misspelled.

 

[krindler]

Thank You soooo much...I must be having one of those days!!