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...

2004-12-08

2008-12-16

Lu, Kuen S (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07467148

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: 5319777 (1994-06-01), Perez
patent: 5778385 (1998-07-01), Pratt
patent: 5966716 (1999-10-01), Comer et al.
patent: 6049799 (2000-04-01), Mangat et al.
patent: 6157934 (2000-12-01), Khan et al.
patent: 6567822 (2003-05-01), Cudahy et al.
patent: 6631497 (2003-10-01), Jamshidi et al.
patent: 6898760 (2005-05-01), Bedford et al.
patent: 6973656 (2005-12-01), Huynh et al.
patent: 2004/0039743 (2004-02-01), Maleport et al.
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.
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.
Person et al., Using Microsoft Word and Excell 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).
U.S. Appl. No. 11/007,008 filed Dec. 8, 2004, entitled “Reporting Status of External References in a Spreadsheet Without Updating”, Inventors: Jesse Raymond Bedford et al.
U.S. Official Action mailed Jul. 29, 2008 in U.S. Appl. No. 11/007,008, Bedford et al., 6 pages.

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-4048383