Craeating a sequence in OpenOffice.org calc.

Creating a numberd list in the calc with alphabets can be really tiresome sometimes. I found a simple solution to this. Create the numbered list in vim and then paste it into Openoffice.org calc. Here’s how I do it:

Open vim

type the first in sequence (ex Amit_aga_001)

Follow the below sequence to create a macro:

Esc

[Atl]+q+(any alphabet say ’a’)  — this will start recording the macro

yy  – yank the current line