Hardcore Linux

Anything about Ubuntu, Centos, openSuSe and Fedora

Rows to Repeat in OpenOffice Print Ranges Problem

Have you encountered this problem in the newer version of OpenOffice (3.2 in my case), especially in Ubuntu 9.10 and 10.04. When you wish to define the rows to repeat in print ranges (Format->Print Ranges->Edit), it prompts an error which states that the action is erroneous or the range is not properly defined.

After few minutes of  “googling”, I’ve found this solution which needs not reinstallation or modification to the currently installed OpenOffice in your distro. Here’s the word for word steps from https://bugzilla.novell.com/show_bug.cgi?id=502641#c12:

  1. Select Tools/Options… from the menu
  2. In the left tree navigate to OpenOffice.org Calc/Formula
  3. Click on the Arrow right to “Calc A1” to see the list of possible grammars
    and select “Calc A1” explicitely from the dropdown list (even if it was already selected)
  4. Press “OK” to save, after that you can now define the rows to repeat in print ranges.
  5. Done.

One response to “Rows to Repeat in OpenOffice Print Ranges Problem

  1. Margeaux February 25, 2011 at 7:58 pm

    Thank you so much for this post. It completely saved my bacon as I was preparing 76 pages of material for my accountant. I had this same problem and was going crazy because repeating the row was so simple in the older version I had been using. My googling led me to see that other have the same trouble and the developers know about it but you’re the only one to actually offer a simple and direct solution. Thanks Again!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: