Q

Comparing multiple OpenOffice spreadsheets

Office suite expert Solveig Haugland gives two different ways to compare OpenOffice spreadsheets next to each other.

Is there a feature in OpenOffice to compare to spreadsheets , side-by-side, like in Excel?

This feature was available in StarOffice 5.2, but isn't available as an automatic feature any more. However, it's

possible to simply size the spreadsheets appropriately and view them side-by-side.

Use Window > Split or Window > Freeze to help scroll more effectively through each.

You can also reduce the zoom by finding the zoom field at the bottom of the work area. Double-click it to bring up a window where you can specify any zoom, or right-click to get a list of commonly used zoom percentages like 75% and 150%.

This was first published in July 2006

Dig deeper on Enterprise applications for Linux

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close