JPH0573589A - Automatic execution device for table calculation program - Google Patents

Abstract

PURPOSE:To automatically execute optional processing by simple operation without allowing a user to be conscious of internal data such as an automatic execution data name or a reference file name. CONSTITUTION:An input means 10 inputs automatic execution data or the like. An information setting means 20 executes the registering/deleting/updating processing of an optional cell in a spread sheet and the automatic execution data in/from a relational information table 50. An automatic execution starting means 30 selects an optional cell by using the data registered in the table 50 to start an automatic execution function. An output means 40 outputs an automatic execution result.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an automatic execution device for a spreadsheet program, and more particularly to a spreadsheet program which allows a user to automatically execute a process by a simple operation without being aware of internal data such as an automatic execution data name. It relates to an automatic execution device.

[0002]

2. Description of the Related Art Conventionally, in a spreadsheet program, when a user automatically executes a process using an automatic execution function, the following operation is usually required. 1. Select an auto-execute command. 2. Select a subcommand such as "register", "execute", or "delete". 3. Specify the device name where internal data such as automatic execution data exists. 4. Enter or select internal data such as auto-run data name (display a list of internal data names if necessary). 5. The operation for confirming the inputs 3 and 4 is performed.

[0003]

In the above-mentioned conventional technique, internal data such as an automatic execution data name must be designated. However, in many cases, the user who registers the automatic execution data is not the same as the user who automatically executes the process based on the registered data. In that case, the user who executes the registration data must set the data name as a parameter, and therefore it is necessary that this is notified from the data creator. If the data name cannot be specified, it cannot be executed automatically. In particular, since the data name given by another person is easy to forget, there is a possibility that the conventional method often cannot be automatically executed.

Even when a large amount of automatic execution data is registered, it is difficult to remember each data name. In some cases, operability may be better if the command execution is performed manually rather than searching the data list.

Even if the data name is easy to understand, the operation procedure (number of inputs) from function selection to automatic execution is long.

[0006] Therefore, an object of the present invention is to provide an automatic execution device for a spreadsheet program whose operation is simplified.

[0007]

In the automatic execution apparatus for the spreadsheet program according to the present invention, the activation of the automatic execution function is associated with the cell arbitrarily designated by the user. That is, in the automatic execution apparatus of the spreadsheet program according to the present invention, the automatic execution data and the arbitrary cell in the spreadsheet are associated and registered in the information table,
The registered data is used to select a cell to activate the automatic execution function.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, a more detailed description will be given with reference to the drawings showing an embodiment of the present invention.

Referring to FIG. 1, one embodiment of the present invention is
Input means 10 for inputting automatic execution data and the like, information setting means 20 for registering / deleting / updating an arbitrary cell in the spread sheet and automatic execution data in the association information table 50, and registered data It has an automatic execution starting means 30 for using the cell selection to start the automatic execution function, and an output means 40 for outputting the result of the automatic execution.

Referring to FIG. 2, in the input means 10, the keyboard 11 and the mouse 12 both input respective parameters at the time of registration / deletion / change of the automatic execution data, and designate the cell range or position to start the processing. It is used to encourage. The input control device 13 converts an input from the keyboard 11 or the mouse 12 into a required format such as cell position information or automatic execution data name.

In the information setting means 20, the cell position analyzing device 21 checks whether or not the cell position information obtained by the input control device 13 is registered in the information table 50. The information table control device 22 registers or deletes activation information. In addition, the automatic execution data associated with the cell is also searched here.

In the automatic execution starting means 30, the automatic execution processing starting device 31 starts necessary processing according to the retrieved automatic execution data. The automatic execution device 32 corresponds to an automatic execution device such as a catalog macro function of a spreadsheet program.

In the output means 40, the display 41
Is a table screen consisting of multiple cells, a parameter input screen,
Displays the cursor that indicates a specific cell, the mouse cursor, and the result of automatic execution.

The operation of this embodiment will be described with reference to FIGS.
The display screen on the display 41 will be described as an example. Now, as shown in FIG. 3, the following three types of tables are created as spread data, and it is assumed that the number will continue to increase in the future.・ Sales table for each store by month (Fig. 3 (A) January-December 1
・ 2 sheets for each store sales table by product (Fig. 3 (B) 1 product 1 sheet)
100 sheets in total ・ Sales chart by store (Fig. 3 (C) 1 sheet for each step)
40 sheets in total) FIG. 4 shows a screen display of December store sales charts by the spreadsheet program. 40 store names vertically,
The 100 product name is entered next to it. For this table,
When the cell containing the store name is selected with the key or the mouse, the sales chart for each store can be developed as shown in FIG.

In order to realize such automatic execution processing, the user registers the data in the following procedure. 1. Select the automatic execution function with the command and select "Register" to register it in the data file to automatically execute the series of processes and to develop it in the corresponding spreadsheet. 2. Select a subcommand such as "register cell switch" and set a range to be a switch and an automatic execution data name. In this example, the file name of the automatic execution data for developing the spreadsheet of the sales chart for each store is registered for each cell containing each store name.

In the state where the data is registered by the above procedure, the following operation is only required to perform automatic execution. 1. Double-click the cell (or cell range) that is the switch. 2. Select the cell (or cell range) that is a switch with the mouse and press the function key. 3. Move the cursor to the cell (or cell range) that is a switch and press the function key.

By performing the above operation, the registration table is searched internally for whether the selected cell is registered as a switch. If you are registered,
The process is automatically executed by the name of the associated automatic execution file. By executing this function, the following processing can be further performed.

As long as the program can register the multitask or pseudo multitask processing in the automatic execution data, other programs can be started and displayed by selecting the cell switch. For example, in the above example, by putting each store information, each product information, etc. in another document data or graphic data and selecting the cell containing the store name or product name, the word processor It is also possible to activate software or graphic software and display related data as shown in FIG.

[0019]

As described above, according to the present invention,
By associating the activation of the automatic execution function with the cell that the user arbitrarily specifies, the user can automatically execute arbitrary processing with a simple operation without being aware of the internal data such as the automatic execution data name and reference file name. it can.

By inputting an easy-to-understand numerical value or character string in the cell, the function can be automatically executed immediately from the screen image. Further, since any function can be assigned to any cell, user customization (user function definition) is easy.

[Brief description of drawings]

FIG. 1 is a functional block diagram of an embodiment of the present invention.

FIG. 2 is a more detailed functional block diagram of one embodiment of the present invention.

FIG. 3 is a diagram in which a table is displayed on a screen by a spreadsheet program according to an embodiment of the present invention.

FIG. 4 is a diagram for explaining the operation of the embodiment of the present invention.

FIG. 5 is a diagram showing table data displayed by an automatic execution process activated by cell selection according to an embodiment of the present invention.

FIG. 6 is a diagram showing document data and graphic data displayed by an automatic execution process activated by cell selection according to an embodiment of the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 Input means 11 Keyboard 12 Mouse 13 Input control device 20 Information setting means 21 Cell position analysis device 22 Information table control device 30 Automatic execution starting means 31 Automatic execution processing starting device 32 Automatic execution device 40 Output means 41 Display 50 Information table

Claims (3)

[Claims] 1. A spreadsheet program, information setting means for associating automatically executed data with an arbitrary cell in a spreadsheet and registering the information in an information table, and performing cell selection using the registered data. An automatic execution device for a spreadsheet program, comprising automatic execution starting means for starting an automatic execution function, input means for setting parameters for the two means, and output means for outputting a result. 2. The information setting means performs a cell position analysis unit for checking whether the input cell position information is registered in the information table and registration / deletion of activation information for the information table. An automatic execution device for a spreadsheet program according to claim 1, further comprising: an information table control unit that searches for automatic execution data associated with the cell. 3. The automatic execution starting means has an automatic execution processing starting section for starting necessary processing according to the searched automatic execution data, and an automatic execution section having a catalog macro function of a spreadsheet program. An automatic execution device for a spreadsheet program according to claim 2.