Inserting Spreadsheets and Other Objects

The program lets you insert the following into an HTML document:

  • Graphics : any existing raster (GIF, JPG, etc.) graphic.

  • Files : any existing document that can be converted to text, such as HTML or Writer. See Inserting a Text-Based File in this section.

  • OLE objects : new or existing spreadsheet, drawing, chart, image, formula, or presentation. See Inserting Files and Objects in this section.

    Note

    OLE objects aren't dynamically updated. If you change the original, the inserted object doesn't change, and vice versa. The advantage of using OLE objects is that they retain their original properties, and you can edit them in the HTML document.


  • Formulas and charts . See Charts on page 290 and Mathematical Formulas on page 300.

Inserting a Text-Based File

Note

The font size of the file might be a lot different when it's inserted.


  1. Choose Insert > File and navigate to the file you want.

    Insert > File can convert only text-based files. To insert other files, use one of the other Insert menu options.

  2. Select the closest filter to convert with, if you're prompted to, and click OK.

    The contents of the file will be inserted, with their original formatting in an editable format.

Inserting Files and Objects

A very useful feature you might have overlooked is inserting OLE objectsit's just a techy way of inserting another file, like a drawing or a spreadsheet, into your document. OLE stands for object linking and embedding; it means you can edit the file using its native editing capabilities, even when it's inserted in a different document. OLE objects include new or existing spreadsheets, drawings, charts, images, formulas, and presentations.

You can't move OLE objects to other applications via the clipboard or drag and drop in or out of the program.

Inserting an Existing Object

Editing OLE objects that exist as separate files varies, depending on which files are open .

  • If you edit the inserted OLE object, the original never changes.

  • If the original and the HTML file containing the inserted object are both open, changes you make in the original take effect only in the inserted object.

  • If the HTML document is not open, the changes take place only in the original.

Once you've inserted the object, the next time you save the HTML document, the object will be saved and a .gif file, such as sv335337.gif , will be created in the same directory as the HTML file. A new .gif will be created each time you save the HTML file.

  1. Choose Insert > Object > OLE Object.

  2. In the Insert OLE Object, select Create from file and select the file you want.

  3. The file will appear in the HTML document (see Figure 16-8).

    Figure 16-8. Inserted object

    graphics/16fig08.jpg

  4. If Navigator is active, a form of the Navigator will appear, allowing you to manage the object.

  5. To edit the object in your HTML document, right-click it and choose Edit. See the notes at the beginning of this procedure on how editing is affected by which files are open.

    graphics/16inf01.jpg

Inserting a New Object
  1. Choose Insert > Object > OLE Object.

  2. In the Insert OLE Object window (Figure 16-9), select Create New, then select the type of object to insert.

    Figure 16-9. Inserting a new object

    graphics/16fig09.jpg

  3. Click OK; the new object will appear.

  4. If Navigator is active, a form of the Navigator will appear, allowing you to manage the object.

    Click in the object to access the file type's object bar. Right-click to access the standard options (Figure 16-10).

    Figure 16-10. New OLE spreadsheet inserted into an HTML document

    graphics/16fig10.jpg



OpenOffice. org 1.0 Resource Kit
OpenOffice.Org 1.0 Resource Kit
ISBN: 0131407457
EAN: 2147483647
Year: 2005
Pages: 407

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net