JPH0567099A - Document preparing device and document preparing method - Google Patents

Abstract

PURPOSE:To make it possible to automatically start and execute a macro performing an automatic execution of a data copy processing and a calculation processing on a sheet in a document preparing software without an operation that the macro is selected from plural macro lists. CONSTITUTION:A cell 3 composing a sheet 1 is composed of an input stage 21 in which input data enters and a macro stage 22 setting a macro instruction performing the automatic execution of a data copy processing and a calculation processing. The cell detects that data is inputted in the input stage 21 and performs a program control so that the macro instruction set in the macro stage 22 may be automatically executed.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a document preparation apparatus and method, and more particularly to document preparation software having a tabular calculation function.

[0002]

2. Description of the Related Art FIG. 6 shows a conventional document creation software.
It shows the mechanism of data reference between two sheets. In the figure, 1 is a sheet A, 2 is a sheet B, 3 is a sheet cell, 4 is a sheet row number, 5 is a sheet column number,
6 is the data of the cell in the 1st row and 2nd column of the sheet B, which is 1 in the sheet A.
A process of transcribing to a cell of a row 2 column and a process 7 is a process of transposing data of a cell of the row 1 column 4 of the sheet B to a cell of the row 1 column 4 of the sheet A. FIG. 7 shows a macro for executing the processing 6 and the processing 7. In the figure, 8 is a macro A operating on the sheet A, 9 is a macro instruction for transferring the data of the cell of the 1st row and 2nd column of the sheet B to the cell of the 1st row and 2nd column of the sheet A,
Reference numeral 10 denotes a macroinstruction for transposing the data of the cell of the 1st row and 4th column of the sheet B to the cell of the 1st row and 4th column of the sheet A. SHEET of macro instruction 9 and macro instruction 10 (sheets B and F
(1,2)) and SHEET (sheets B, F (1,
4)) is a function that refers to the data in the cells of the 1st row and 2nd column and the 1st row and 4th column of sheet B, F (1, 2) and F (1), respectively.
(1,4) indicates the cells in the 1st row and 2nd column and the 1st row and 4th column of the sheet. FIG. 8 shows a macro execution operation. In the figure, 11 is a display screen, 12 is a state in which the macro A is selected, and 13 is an execute button.

Next, the operation will be described. FIG. 9 is a flowchart showing the operation of the conventional technique. In the figure, in process 14, a macro A is selected from a plurality of macro lists on the display screen 11 and executed. Then, process 15
Then the macro A is read into the memory. In process 16, the macro instruction 9 is executed and the data of the cell of the 1st row and 2nd column of the sheet B is transferred to the cell of the 1st row and 2nd column of the sheet A. continue,
In process 17, the macro instruction 10 is executed and the data of the cell of the 1st row and 4th column of the sheet B is transferred to the cell of the 1st row and 4th column of the sheet A.

[0004]

In the prior art, since the sheet and the macro are separate, even when the above-described data transfer processing on the sheet is automatically executed by the macro, as shown in FIG. I had to specify and execute the required macro from the list of macros in.
Therefore, there have been problems such as deterioration of operability and erroneous macro designation.

The present invention has been made in order to solve the above problems, and executes macros for performing data transfer processing and calculation processing on a sheet without selecting them from a plurality of macro lists. The purpose is to be able to.

[0006]

The document creating apparatus according to the first aspect of the present invention automatically functions by inputting data to a corresponding function of associating an arbitrary cell on a sheet with a macro in a 1: 1 relationship. And has an execution function for executing and activating a macro associated with the cell, and has the following elements. (A) A plurality of cells having a data holding function, (b) an instruction storage unit that stores a predetermined instruction for accessing the data of the cell, and (c) the cell and the instruction storage unit are stored in association with each other. Corresponding storage means,
(D) Execution means for executing an instruction in the instruction storage section corresponding to the cell stored by the correspondence storage means by inputting predetermined data to the cell.

In the document creating method according to the second aspect of the present invention, a step of inputting a macro into an arbitrary cell on a sheet and a step of inputting predetermined data for executing the macro into the cell execute the macro. And the following steps. (A) An instruction input step of inputting an instruction for accessing data of a plurality of cells by a predetermined method in association with a cell to which data can be input, (b) after the instruction input step, predetermined data is input to the cell A cell input step of inputting, (c) an instruction execution step of executing an instruction input in association with the cell in the instruction input step based on predetermined data input in the cell input step.

[0008]

In the first aspect of the present invention, the correspondence storage means associates a specific cell on the sheet with a specific macro stored by the instruction storage means in a 1: 1 relationship in advance so that the execution means stores data in the cell. Detects the input of and automatically executes the associated macro.

In the second aspect of the invention, the macro is input in advance by associating with a specific cell in the instruction input step, and when the predetermined data is input in the cell input step, the instruction execution step corresponds. Run the macro.

[0010]

【Example】

Example 1. An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a diagram showing the structure of a cell, which is shown in FIG.
In the figure, 20 is one cell, 21 is an input stage in which cell input data is stored, and 22 is a macro stage for setting a macro instruction. That is, the conventional cell was composed of only the input stage 21, but in the present invention, a macro stage 22 for setting a macro is newly provided to have a cell structure integrated with the input stage 21. Although the input stage 21 is displayed as usual, the macro stage is not normally displayed, and is displayed only in a specific case such as when a macro instruction is input or when it is executed.

FIG. 2B shows how data is referred to between sheets according to the present invention. In the figure, 1 is a sheet A, 2 is a sheet B, 3 is a cell of a sheet, 4 is a row number of a sheet, 5 is a column number of a sheet, and 6 is data of a cell of the 1st row and 2nd column of the sheet B of the sheet A. A process of transcribing to the cell of the 1st row and the 2nd column of the sheet B is shown at 7 for transposing data of the cell of the 1st row and the 4th column of the sheet B to the cell of the 1st row and the 4th column of the sheet A. Also,
Reference numeral 23 is a macro instruction 9 for executing the processing 6 and processing 7
Is a cell in which the macro instruction 10 for executing is set, and shows the state in which the data @ is input to this cell.

Next, FIG. 2 shows an outline of the document preparation apparatus. In the figure, 1 is a sheet, 3 is a cell, 42 is data input to the cell, or data and instruction storage for storing macroinstructions. Parts, 43 is a data storage unit, 44 is an instruction storage unit, 41 is each cell and data of the sheet, and each data storage unit 43 of the instruction storage unit 41 and the instruction storage unit 44 is 1: 1.
Is a correspondence storage means for taking correspondence of, for example, "1,
“1, S” is a pointer that points to the data storage unit in which the data input to the input stage of the cell in the first row and first column is stored, and “1,1, M” is the pointer in the cell in the first row and first column. It is a pointer that points to an instruction storage unit in which a macro instruction input to the macro stage is stored. Reference numeral 43 is document creation software, which serves as an execution means for executing a macro.

Next, FIG. 3 shows a flowchart of the document creating method. In step 51, a sheet format is created, in step 52 a macro is registered for a specific cell, and in step 53, each macro is registered. Enter data in the cell. When the input data is the specific data determined in advance (data @ in this case), it is determined that the macro execution is requested, and if the macro instruction is registered, the macro instruction is processed in step 57. If executed and not registered, an error message is displayed in process 58. If the data input in the process 53 is not @, it is stored in the cell as normal data in the process 55.

In FIG. 3, reference numeral 61 is an instruction input step of registering a macro in a cell, 62 is a cell input step of inputting data to the cell, and 63 is an execution step of executing the macro when data @ is input.

FIG. 4 shows that after the data @ is input, FIG.
3 is a flowchart when executing the macro shown in FIG. 2. First, when data (for example, @) is input to the input stage 21 of the cell (one row and one column of the sheet A) which is the process 24, it is detected that the data @ is input in the process 25, and the macro of the macro stage is detected. The macro instruction 9 which is set to the executable state and is pointed to by "1, 1, M" in the process 27.
Is executed and the data of the cell of the 1st row and 2nd column of the sheet B is transferred to the cell of the 1st row and 2nd column of the sheet A. Next, in process 27, the next macro instruction 10 is executed and the data of the cell of the 1st row and 4th column of the sheet B is transferred to the cell of the 1st row and 4th column of the sheet A.

As described above, in this embodiment, a tabular sheet formed on the memory of the computer and having cells having a data input function, and writing, reading, and calculation processing of data in the cells are performed. Instructions that realize functions and instructions that control the execution order of these instructions (macro instructions)
And a group of macro instructions (macro) in which these macro instructions are written in order to perform calculation processing between cells of the sheet and data transfer processing to cells, and this macro is read out and written in it. In a computer program having a function of sequentially executing the described macro instructions, a function of associating an arbitrary cell with a macro in a 1: 1 ratio, and automatically associating with the cell by inputting data to the cell. The document creation software having the function of executing and activating the specified macro has been described.

Embodiment 2. In the above embodiment, the input stage 21 and the macro stage 22 have the same size, but the sizes may be different as shown in FIG. Since the macro stage 22 is normally not displayed, the size may be different. When displayed at the time of input or at the time of execution, it may be displayed by being overlaid on another cell as shown in FIG. Further, the display position may be a place separate from the cell.

Example 3. In the above embodiment, the macro instruction 9 and the macro instruction 10 are directly set in the macro stage 22 to be associated with the cells. However, even if the macro is made independent as a separate file and the file name is set in the macro stage. Good. In this case, the processing 25 detects that the data @ has been input, reads the macro file set in the macro stage, and makes the macro executable.

[0019]

As described above, according to the present invention, an arbitrary cell on a sheet and a macro are associated with each other at a ratio of 1: 1 and data is automatically associated with the cell by inputting data to the cell. Since the macro is executed and activated, there is an effect that the macro for performing the data transfer processing and the calculation processing on the sheet can be executed without selecting it from the plurality of macro lists.

[Brief description of drawings]

FIG. 1 is a diagram showing a structure of cells of a sheet and an operation of referring to data between sheets according to an embodiment of the present invention.

FIG. 2 is a schematic diagram of a document creation device of the present invention.

FIG. 3 is a flowchart showing a flow of operations according to the embodiment of the present invention.

FIG. 4 is a flowchart showing a flow of operation according to the embodiment of the present invention.

FIG. 5 is a diagram showing another embodiment of the present invention.

FIG. 6 is a diagram showing an operation of referring to data between sheets by the conventional document creation software.

FIG. 7 is a diagram showing an example of a macro for performing data reference between sheets in a conventional example.

FIG. 8 is a diagram showing a macro execution operation of a conventional example.

FIG. 9 is a flowchart showing a flow of operations in a conventional example.

[Explanation of symbols]

 1 sheet A 2 sheet B 8 macro 9 macro instruction 10 macro instruction 20 cell 21 input stage 22 macro stage

Claims (2)

[Claims] 1. A document creation device having the following elements: (a) a plurality of cells having a data holding function; (b) an instruction storage unit that stores a predetermined instruction for accessing the data of the cells; ) Corresponding storage means for storing the cell and the command storage portion in association with each other, (d) By inputting predetermined data to the cell, a command in the command storage portion corresponding to the cell stored by the correspondence storage means. Execution means to execute. 2. A document creating method having the following steps: (a) an instruction input step of inputting an instruction to access data of a plurality of cells by a predetermined method in association with a cell into which data can be input; ) After the command input step, the cell input step of inputting predetermined data to the cell, (c) based on the predetermined data input by the cell input step, the instruction input corresponding to the cell in the command input step is input. Instruction execution step to be executed.