[Solved] Using 'OFFSET' and 'ROW' to copy every nth cell

[snoop911]

I'm transitioning from Excel, so haven't quite figured out all the subtle nuances between the programs. For example, in Excel the following works fine to list every 9th element onto an adjacent column:

=OFFSET($A$2, (ROW()-2)*9,0)

Where I have data starting in A2 down to A90002, with this formula pasted in B2 down to B10002

Unfortunately using the setup in Calc, I get an Err:508.

Seems pretty straighforward, but not matter how I try to manipulate it, I get this error. Are these functions not exactly equivalent in functionality as the ones in excel?

Update:
Thanks acknak that worked perfectly!

[acknak]

So close.

Try =OFFSET($A$2;(ROW()-2)*9;0)