Mar 23, 2011

Fix OpenOffice.org Calc Row(s) / Column(s) Repeat Printing Problem



Visit Format -> Print Ranges -> Edit
You can select the range, repeat row(s), repeat column(s) when print this spreadsheet.
Somehow, when you click "OK" to accept the settings, an error - Invalid sheet reference may occurs.


We discovered that which is a bug reported from Launchpad (#374708) and Debian (#527535)

It is strange bug. If you install the official OpenOffice.org from OpenOffice.org
This bug will not appear. (That means this bug comes from Distribution ?)

Nevermind. Let's fix this bug first.
Visit Tools -> Options


Visit OpenOffice.org Calc -> Formula


Re-select Calc A1 at Formula Syntax


Then press OK, and this bug is fixed.


4 comments:

FoxMulder said...

You're still using OpenOffice? The project has forked, and Ubuntu, PCLinuxOS and other distros now use LibreOffice -- the new fork. It's being developed and fixed at a better rate than Oracle is doing with OpenOffice. You should take a look and see if the problems you're having are fixed with the new supported fork :)

MR. A said...

Yes.
I know LibreOffice will replace OpenOffice.org, but some people still using OpenOffice.org, and we should know how to fix this problem by myself.
Thank you for your comment.

Anonymous said...

THANX

zohaib anwar said...

open this,,,

Post a Comment

Twitter Delicious Facebook Digg Google Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Best Hostgator Coupon Code