Tag: openoffice

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

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.

More windows Microsoft like openoffice and keet it working.

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:

[GoOo]
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.

protect=1

Here is a screenshot of the suite.

\"Openofficeorg

Here is a list of the features that the suite boasts of :

SVG support
3D transitions
Rich fields support
Better Startup Performance
Unix systray quick-starter
Calc solver
Improved Excel interoperability
VBA support
GStreamer integration
Text Grid rendering
Improved EMF rendering
MS-Works import
WordPerfect Graphics import
Lotus Word Pro import

GoOo released new version of Open Office.

GoOo repository for Fedora at http://go-oo.mirrorbrain.org/stable/linux-i586/ has released the new version of GoOo packages.