1 / 7

Importing spread sheet into document

Importing spread sheet into document. Aim Able to choose copy-paste or import by link Problem You are to write a report on the health for last year The numbers are not complete yet You have to start writing nevertheless Numbers in a table in a spread sheet

anika
Download Presentation

Importing spread sheet into document

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Importing spread sheet into document • Aim • Able to choose copy-paste or import by link • Problem • You are to write a report on the health for last year • The numbers are not complete yet • You have to start writing nevertheless • Numbers in a table in a spread sheet • Table should be part of a document • What happens if data in the table needs to be changed?

  2. Copy-Paste • Two copies of the table on the hard disk • Changes in spread sheet NOT propagated to document Copy - Paste

  3. Import by link • One table on the hard disk • Link • Changes in spread sheet propagated to the document Import by link

  4. Procedures Copy-paste Import by link Open both files Insert the table into the document such that the link to the spreadsheet is kept Check by changing the spreadsheet • Open both files • Copy the table and paste it into the document • Check by changing the spreadsheet

  5. Two ways Copy - Paste Import by link Inconsistencies when updating the spread sheet Inconsistencies avoided

  6. c Functional dependency • Import by link Changes in spreadsheet  changes in document • Table of contents Pages inserted  Table of contents updated • Formulas in spreadsheet Arguments changed  Result updated • Link from display to data storage • Data changed  Changes propagated to display Other examples?

  7. c c Other use? Are there other types of data than tables where import by link is an advantage? When do we choose Copy-Paste anyhow?

More Related