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

p — paste the current line

$ — go to end

[Ctrl]+a — increment the number by one

[Alt]+q — stop recording

Now type (in figures the count of lines you want) ’@a’

and you are done.. Simply copy paste the sequence here to OpenOffice.org calc.

Feel free to suggest if there are better ways. I am definately looking for one.

Related Articles:

• 2010/04/11   change the window in split screen.
• 2010/04/11  
• 2010/04/06   vim understanding the various modes and using the yanking more efficiently.
• 2010/03/29   vim scripts and tips
• 2010/03/22   More windows Microsoft like openoffice and keet it working.