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:
type the first in sequence (ex Amit_aga_001)
Follow the below sequence to create a macro:
[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.
Some people say that OpenOffice doesn\’t completely suit their requirement as compared to the Microsoft Office. Though most of the times I do not have that problem 🙂 But there are still couple of things that do not work with OO seamlessly and thus if you want better OO (with respect to working with MS files more seamlessly) here\’s something worth a try.
You can try the go-oo OO.
If you are using a rpm based distro like Fedora and have yum installed then simply add the yum repo create a file called go-oo.repo in /etc/yum.repos.d with the below content:
name = GoOo OpenOffice.org packages
baseurl = http://go-oo.mirrorbrain.org/stable/linux-i586/
type = rpm-md
enabled = 1
gpgcheck = 0
Now once this is done, just intall OpenOffice using the frontend of you choice like PackageKit or Yumex or any other frontend. Ensure that there will now be two versions:- one from Fedora repo and one from the GoOo repo. Install the one from the GoOo repo. You are done.
There is a catch in doing this, whenever you are updating the packages though, the soffice might be broken because the Go-Oo provides openoffice.org-ure which is mostly a version below the one provided by the Fedora repo. So if you want that the system update does not break this, then you should install the protectbase plugin of the yum and add the below line in the go-oo.repo and you are done.
Here is a screenshot of the suite.
Here is a list of the features that the suite boasts of :
Rich fields support
Better Startup Performance
Unix systray quick-starter
Improved Excel interoperability
Text Grid rendering
Improved EMF rendering
WordPerfect Graphics import
Lotus Word Pro import
GoOo repository for Fedora at http://go-oo.mirrorbrain.org/stable/linux-i586/ has released the new version of GoOo packages.