Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm writing a paper for college in which I would like to either display or link to a large spreadsheet. I'm using OpenOffice Writer and Calc.

I've tried importing the spreadsheet as an OLE object, however this only displays a small part of the sheet (albeit with scroll bars). I'd like to find a good solution to display the entire sheet, or create a link to the separate file.

I've considered taking a screenshot of the spreadsheet and just importing the image, but this is less than preferred since it would be a static image.

Is there any better way to do this, or am I stuck with using an OLE?

share|improve this question
up vote 0 down vote accepted

When embedding the spreadsheet as OLE object, you can set the size of the OLE object as desired. To do so, double-click on the object, or right-click and select Edit. Now, you can drag the corners and borders of the OLE object to display the entire sheet.

Alternatively, you could use a hyperlink. With a hyperlink, you could even select a sheet inside the spreadsheet file as target:

Hyperlink1

  1. Select Document as Target;
  2. Enter path to document or select the file;
  3. Open the targets dialog using the target button:

Select target

Complete settings for hyperlink

share|improve this answer
    
Thank you this is some good information. I didn't know about the hyperlink and that should suit my needs well. – brack Aug 20 '13 at 13:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .