Binding spreadsheet cells to objects

Details Binding spreadsheet cells to objects Binding spreadsheet cells to objects

1999-06-15

2004-03-02

Feild, Joseph H. (Department: 2176)

Data processing: presentation processing of document, operator i

Presentation processing of document

Layout

C715S252000, C715S252000, C715S965000

Reexamination Certificate

active

06701485

ABSTRACT:

FIELD OF THE INVENTION
The invention generally concerns the use of computer spreadsheets, and in particular, relates to binding spreadsheet cells to external objects.
BACKGROUND OF THE INVENTION
During the past decade, computer software has evolved from independent applications running alone, to integrated suites of applications capable of sharing information between applications in the suite. The applications may be running either on the same computer or on different computers connected via a network. In order to share information between different software applications, a communication scheme for transferring the data is required. One such scheme is the Dynamic Data Exchange (DDE) protocol that is used to transfer data between application programs running on Microsoft Corporation's WINDOWS™ operating systems.
DDE is a standard inter-application communication protocol built into Microsoft Corporation's WINDOWS™ operating systems, such as WINDOWS™ 3.x, WINDOWS 95™, WINDOWS 98™, and WINDOWS NT™, (hereinafter collectively or singularly referred to as WINDOWS™ operating systems. This protocol allows WINDOWS™ programs that support DDE to exchange data between themselves. DDE can be thought of as a direct conversation between two application programs. In most cases, one application is providing some form of data (either text or graphics) to another application. The application that is the source of the data is called the “server” and the application that is receiving the data is called the “client.”
Each data item that a server application can provide has a unique identifier consisting of three parts: a DDE Application Name; a DDE Topic; and a DDE Item Name. The DDE Application Name is almost always the executable filename for the server application (without the “.exe” extension). The DDE Topic typically identifies a group or category of data in the server application, and each data item that a server can provide has a unique DDE Item Name. Thus, the Application Name, Topic, and Item Name uniquely identify the source of the data in a server application that is to be linked to a client application.
DDE links are always initiated in the client application. The client initiates a DDE link by broadcasting a message containing a DDE Application Name, a DDE Topic, and optionally a DDE Item to all other applications currently running. If a server application is running that can provide the data, it responds to the “DDE initiate” command and the operating system opens a “link” between the two applications. Fortunately, most WINDOWS™ programs that support DDE insulate the user from the low-level details of establishing DDE links and simply allow the user to specify the Application Name, Topic, and Item Name for a specific piece of data and the link is then automatically established by the user's application program.
More recent versions of the WINDOWS™ operating systems support a feature called “Network DDE.” Network DDE allows DDE data to be passed across a network from one computer to another, allowing the client and server applications to run on different computers connected across a network. Network DDE must be enabled in Windows by running the program “NETDDE.EXE” before any data can be transferred.
It is often desirable to link or “bind” information in a spreadsheet cell to information contained in an external data source. For example, a spreadsheet that calculates gross revenues for a business may contain cells that are linked to data contained in another application program, such as a database application. For example, DDE can be used to dynamically link a cell in a Microsoft EXCEL™ spreadsheet to a data field in the database application program running on another computer. A user would enter the following formula in the spreadsheet cell and then press the Enter key:
=\\ComputerName\NDDE$|$MyPage.dde!Field  (1).
The formula contains the three parts necessary to successfully link the client application to server the application program, including the Network DDE Application Name, which is referenced by the name of the computer running the DDE Server program, followed by a single slash and the word “NDDE$.” The DDE Topic appears after the dollar sign, referenced by the “Page Name” that is assigned in the ClipBook application, followed by a period and the word “dde.” Finally, the specific DDE Item Name (‘Field(1)’) is included.
Upon activation of the Enter key, EXCEL™ will automatically establish a DDE link between the field in the server application program and the spreadsheet cell. (The server application program must be running on a computer coupled to the computer running the client application over a network in order for the above link formula to be successful). After the link is established, any data in the text box “Field(1)” in the server application program will automatically appear in the “linked” cell in the spreadsheet. Also, whenever the data for Field(1) in the server application program changes, the contents of the spreadsheet cell will automatically be updated with the new data. Effectively, the operating system does an automatic cut and paste from the server application to the client application whenever the server application's data changes.
Either application involved in a DDE data link can terminate the link. Some applications have menu options that allow a user to selectively terminate any open DDE links. Closing either of the linked applications also causes all active links between the two programs to be terminated.
The process of setting up a network DDE connection is fairly simple and involves using the “ClipBook” application found in the “Main” program group in the WINDOWS™ operating systems. The ClipBook extends the concept of the WINDOWS™ Clipboard across a network. The ClipBook allows a user to create “ClipBook Pages” that can be “shared” with other computers on a network. Once a user creates and shares a page on one computer, other computers on the network can “connect” to that page. If the page contains data from a DDE server, then the user can set up DDE links to the data, and the data will be passed to any client application on the network just as if the client application were running on the same local computer as the server application.
After a user creates a “Page Name” using the ClipBook application and pastes data from a DDE server into the page, the page name and the DDE connection data contained in it will continue to exist even after the ClipBook application is closed on both computers. The WINDOWS™ operating systems can even shut down on both computers without terminating the link, since upon restarting, the client application will be able to re-establish the DDE link using the same Network DDE Application, Topic, and Item Name.
While DDE and Network DDE are beneficial, they have their limitations. These protocols communicate by passing messages between “windows” (each application in the WINDOWS™ operating systems runs in it own separate “window”). Each application must process the messages it receives through its event loop message processing sequence, which leads to extra overhead and slows down throughput. The server application must also create and send a message to all external clients every time a linked field changes its value. In addition, only WINDOWS™ programs support DDE and Network DDE. Thus, a user cannot establish a link to data contained in a non-WINDOWS™ application program using DDE or Network DDE.
Clearly, it would be desirable to provide a scheme that enables a user to bind spreadsheet cells to various external data sources (objects), while providing faster throughput and less overhead than when using DDE. It would also be advantageous to provide a scheme that enables data from bound objects to be retrieved from computers that use operating systems other than the WINDOWS™ operating systems, and from applications that are written in different languages. In addition, it would be desirable to be able to link spreadsheet cells to the methods exposed by such external

Affiliated with

Also associated with

Rating

Binding spreadsheet cells to objects does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Binding spreadsheet cells to objects, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Binding spreadsheet cells to objects will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3196941