Reporting status of external references in a spreadsheet...

Details Reporting status of external references in a spreadsheet... Reporting status of external references in a spreadsheet...

2005-05-24

2005-05-24

Hong, Stephen S. (Department: 2179)

Data processing: presentation processing of document, operator i

Presentation processing of document

Layout

C715S252000

Reexamination Certificate

active

06898760

ABSTRACT:
The invention, in one embodiment, is a method and system for reporting the status of external references, or links, of a spreadsheet workbook. In an Edit Links dialog box, the user may view a list of links and their status. The user may select a Check Status button in the Edit Links dialog box to check the status of the links without updating the links because updating the links may require considerable time. A textual status message is displayed for each link in the Edit Links dialog box. The textual status message indicates to the user whether there is s possible problem with the link. As part of checking the status of a link, an analysis is made to determine whether any problems with the source file exist. For instance, it is determined whether the source file is open and whether it is valid. The results of this analysis determine what is displayed in the status column of the Edit Links dialog box.

REFERENCES:
patent: 5778385 (1998-07-01), Pratt
patent: 6049799 (2000-04-01), Mangat et al.
patent: 6157934 (2000-12-01), Khan et al.
Person, et al., Using Microsoft Word and Excel in Office 97 Special Edition, “Chapter 40—Linking, Embedding, and Consolidating Worksheets” (Que Corporation, 1998).*
Richter, Advanced Windows, Third Edition, Chapter 14—“Copying, Deleting, Moving, and Renaming Files” (Microsoft Press, 1997).*
“Broked—A Link Checker” at www.pregnantpause.org/software/broked.htm (Pregnant Pause, 2000).*
Co-operative programming with Windows DDE; Adrian Smith;Proceedings of the International Conference on APL, 1993, pp. 244-250.
Light hypermedia link services: a study of third party application integration; Hugh C. Davis, Simon Knight and Wendy Hall;Proceedings of the 1994 ACM European conference on Hypermedia technology, 1994, pp. 41-50.
Lamond, F.E. (1986)Types of micro/mainframe link. Pergamon Infotech, Maidenhead, Berks., UK.
Microsoft Corporation, “Getting Started with Microsoft® FrontPage™ 97”, 1996 Microsoft Corporation, Redmond, Washington, Document No. 92482-1096, OEM Document No. 000-40639, pp. 1-235.

Affiliated with

Also associated with

Rating

Reporting status of external references in a spreadsheet... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Reporting status of external references in a spreadsheet..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Reporting status of external references in a spreadsheet... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3370180