calc error on R1C1

I tried to use OOo Novell ver. becaouse could use R1C1 in Calc but I 
disappointed.

when I use calc in R1C1 notation mode, push autoSUM(sigma)button,
come error "#name?"

in function wizard,  drag the spreadsheet, A1 notation displayed in dialog 
but inR1C1 mode.

or input cell Number directly in R1C1 notation, displayed "#name?"

OOo Novell ver. is good because I can use R1C1 notation. but It's not 
perfect.
so MS Excel is better now.