1 intro to micro apps intergrating the apps copyright 2003 by janson industries this presentation...

1

Intro to Micro AppsIntergrating the Apps

Copyright 2003 by Janson Industries

This presentation can be viewed on line at: http://web.fscj.edu/Janson/CGS1100/2013.8.Integrated.ppt

Assg1 Assg2

Copyright 2013 by Janson Industries2

Objectives Explain

Advantages of s/w suites

How to integrate documents, spreadsheets, databases and presentations

Updating and the effect on other objects

Show how to:

Import, embed and link app objects


Software Suite Advantages Apps are built to work together

You can easily have SS or DB in docs and presentations and visa versa

Don’t have to re-enter all the info

You can drastically cut down on duplicate information

Save space

Faster to update

Fewer mistakes when updating


Tieing Objects Together Several ways to combine objects

Cut and paste

Link

Embed►Office feature: OLE (Object Linking

and Embedding)

Advantages and disadvantages to each


Tieing Objects Together Cut and paste

Really easy to do

However now there are multiple copies of the object

►Takes up more space►Updating the source object will not

update the copies►Takes longer to update because if

changes are needed, must be done to all copies

• If an object is copied into 10 docs, 11 changes must be done

►Because of multiple updates, greater chance of error


Tieing Objects Together Embedded objects

Copied into destination file (like cut and paste)

All the disadvantages of cut and paste

Advantage is that you can update the embedded object with the app that created it

►Cut/pasted objects are updatable by the destination app not the source app

• I.e. an embedded SS in a doc can be edited by Excel

• Cut/pasted SS edited by Word


Tieing Objects Together Linked objects

A link to the object is placed in the destination file

Changes to the source object reflected in the destination file

►No duplication• Less space• Less updating

Kinda like using a cell address in a formula rather than duplicating the data


Tieing Objects Together Which method should you use?

If object is:

Static (non-changing)

Only going into a small number of files

Takes up little space►Cut/paste is easiest and fastest



If object:

Changes infrequently

Goes into a number of files that can be easily kept track of

When duplicated, takes up a non-significant amount of space

►Embed the object



If object:

Changes frequently►OR

Goes into a number of files that cannot be easily kept track of

►OR When duplicated, takes up a

significant amount of space►Link to the object


Our current document that we want to include a Excel sheet into


Current size is 12 KB


Selct and copy


Well that doesn’t look very good!Notice the title pattern and sparklines are is

missing and the col width is distorted


Notice the size with the sheet is 23KB – nearly a 100% increase in size


The sheet is pasted in to the doc as a Word tableSo there are some editing/formatting functions

Like Distribute Columns Evenly


Also, deleted the first column to fit more of the cols


All the info in the table is text – no formulas/functions

So changes in one cell not reflected in others


Cutting and Pasting Could have pasted the data as an

image

Can’t manipulate the content but easier to fit into the document

Also for other SS objects, like charts, Word has very good editing and formatting functions


As an image all the formatting is there – title pattern, sparklines


Notice the size with the image is 47KB – nearly a 300% increase in size


Embedding Copy the sheet

In the Word doc, on the HOME ribbon display the Paste menu and select Past Special

Select Microsoft Worksheet Object


Sheet pasted like an image and can be formatted as an image


The size with the worksheet object is 95KB – nearly a 700% increase in size


Right click the image and select Worksheet Object then Edit


Notice the Excel ribbon is displayed and the sheet now appears in a mini-spreadsheet window


The embedded object has all the functionality of a worksheet


Changes to one cell will be reflected in any other cell that references that cell


However, the changes are not reflected in the original worksheet


To insert a link, do same thing as embedding but specify Paste link


To change the worksheet either start Excel and open it or right click it in the doc and select

Linked Worksheet Object, then Edit Link


An Excel session will be started & the file will be opened

Changes in the Excel session will, of course, be reflected throughout the SS…


… and in the documentDon’t even have to save the SS for the doc to be

updated


If changes are made in the SS and the doc is not open, when the doc is opened a request to

update the doc will be displayed


If you don’t update when opening the doc, you can manually update later but right clicking and

selecting Update Link


Assignment None

1 intro to micro apps intergrating the apps copyright 2003 by janson industries this presentation...

Documents

source object

tieing objects togethercut

itcutpasted objects

destination app

destination filechanges

embedded ss

changes infrequentlygoes

changes frequentlyorgoes