Craeating a sequence in OpenOffice.org calc.

2010-05-06 135 words 1 min read

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.


author

Authored By Amit Agarwal

Amit Agarwal, Linux and Photography are my hobbies.Creative Commons Attribution 4.0 International License.

We notice you're using an adblocker. If you like our webite please keep us running by whitelisting this site in your ad blocker. We’re serving quality, related ads only. Thank you!

I've whitelisted your website.

Not now
This website uses cookies to ensure you get the best experience on our website. Learn more Got it