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.
Related Articles:
- 2010/04/11 change the window in split screen.
- 2010/04/11 bash script to change vim colorscheme based on the available themes
- 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.
Authored By Amit Agarwal
Amit Agarwal, Linux and Photography are my hobbies.Creative Commons Attribution 4.0 International License.