JPH05274324A - Table calculating system - Google Patents

Abstract

PURPOSE:To easily grasp plural data without being accompanied with a large sight line movement by arranging plural data on one display area. CONSTITUTION:In a processor 3, a data arrangement control part 3a, a data display area control part 3b, and a field analyzing part 3c are provided. The data arrangement control part 3a generates a set from a field designated by an input device in each field on a storage device 1. The data display area control part 3b generates an area for displaying the field for constituting the set generated by the data arrangement control par 3a on one cell. That is, by control of the data arrangement control part 3a, the set of data arranged on the same display area is determined, and by control of the data display area control part 3b, a display area which can display the data for constituting the set is set, and plural data are arranged on it display area.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a spreadsheet calculation method for controlling display of data on a spreadsheet used for spreadsheet calculation.

[0002]

2. Description of the Related Art Spreadsheet software is widely used when data is aggregated using a computer. This spreadsheet software displays a table on the display screen and inputs (places) data in any item (data placement area) on this table to obtain the total result reflecting the contents of each item. be able to.

Specifically, the table on the display screen is composed of a plurality of rows and columns, one row is called a record, one column is called a field, and the data arrangement position (item) specified by the row and column is further defined. I call it a cell. For each record, field, or cell, by setting a symbol that identifies the data to be referred to or a calculation formula that is composed of a calculation symbol, it is possible to realize the desired calculation with reference to only predetermined data, Moreover, the calculation result can be read from the table.

The data referred to in displaying and calculating are
The data is stored in a storage device (magnetic storage device or the like) in record units, and data is sequentially arranged in each record. When extracting predetermined data used for calculation from this record, desired data can be extracted from the record by calculating the position on the record from the field number prepared separately.

FIG. 2 shows an explanatory view of a conventional spreadsheet system. It is assumed that the first record R1 and the second record R2 are stored in the storage device 1. Each record is composed of six data arranged sequentially. The position where the data is arranged on the record can be specified as the first to sixth fields F1 to F6 by, for example, counting the number of bits from the beginning or the identification signal recorded on the record.

When the contents of the first record R1 and the second record R2 are displayed on the display screen 2, first, a table T of a preset format is displayed. In this table T, record numbers “1” and “2” that specify the first and second records R1 and R2 are arranged (displayed) as headings of rows. Similarly, field names that specify the first to sixth fields F1 to F6 are arranged (displayed) as column headings.

The record number "1" is information specifying the first row, and the record number "2" is information specifying the second row. Also, the first, third and fifth fields F1, F3, F
Corresponding to No. 5, the field name “actual” that specifies the first, third, and fifth columns is the second, fourth, and sixth fields F.
The field names "elongation rate" for identifying the second, fourth, and sixth columns are displayed corresponding to 2, F4, and F6.

When the display of the record number and the field name is completed, the contents of the first and second records R1 and R2 are displayed in the display area (cell: the broken line section in the figure) specified by the record number and the field number. It will be.
In this display, when the reading of the first record R1 from the storage device 1 is started, the contents of the first field F1 to the sixth field F6 are sequentially recognized, and each is identified by the record number “1” on the table T. Are placed in the cells of the row to be edited (first row). Similarly, the content of the second record R2 is placed in the cell of the row (second row) specified by the record number “2” on the table T.

The first record R1 contains data "110",
Since it is composed of "10", "120", "20", "130", and "30", the data "110", "10", and "10" in the first column to the sixth column of the first row, respectively. "120", "20", "130
“,” “30” are arranged (displayed). Similarly, the second record R2 has data “150”, “50”, “180”, “8”.
As it is composed of 0 ”,“ 140 ”, and“ 40 ”, the second
In the first to sixth columns of the row, data "150",
"50", "180", "80", "140", "40" are arranged (displayed).

[0010]

Now, in Table T,
The first and second rows, the third and fourth rows, the fifth and sixth rows,
The data are related to each other. However, when performing spreadsheets, there are many situations in which related data are arranged (displayed) in other adjacent cells. Generally, when a tabulation table or the like is created using a word processor or the like, related data tends to be collectively arranged (displayed) in one area. This is to enable a large amount of data to be grasped at once without shifting the line of sight to many areas. When one piece of data is arranged in one area, there is a problem that the eyes must be moved to a plurality of areas in order to recognize related data.

The present invention has been made in view of the above points, and it is an object of the present invention to provide a spreadsheet method capable of realizing grasping of a plurality of data without moving the line of sight.

[0012]

The spreadsheet system of the present invention is
A plurality of data are sequentially arranged to construct a record, each data is managed in the unit of the record, the record is divided into a plurality of fields which are a predetermined unit area, and the each data is extracted from the record. Then, the respective data are arranged in a plurality of display areas set on the table displayed on the display screen, and an arithmetic expression is generated by the field number specifying the field, and the table calculation of the table is performed. In this case, a data arrangement control unit that determines a set composed of a plurality of the data and a display area control unit that arranges the set in one display area are provided.

[0013]

This method is controlled by the data arrangement control unit.
A set of data to be arranged on the same display area is determined, a display area capable of displaying the data forming the set is set under the control of the display area control unit, and a plurality of data are arranged on this display area. ..

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 is an explanatory diagram of a spreadsheet system of the present invention. In the figure, a storage device 1 and a display screen 2, and a processor 3 and an input device 4 are shown. The storage device 1 is
The processor 3 accesses the storage device 1 and the display screen 2
Display control, and further executes a predetermined calculation based on the data stored in the storage device 1. The input device 4 is composed of a keyboard, a pointing device, and the like.

The processor 3 includes a data allocation control unit 3
a, a data display area control unit 3b, and a field analysis unit 3c are provided. The data arrangement control unit 3a generates a set from a plurality of fields designated by the input device 4 among the fields on the storage device 1.

The data display area control unit 3b is for generating an area for displaying a plurality of fields constituting the set generated by the data arrangement control unit 3a on one cell. The field analysis unit 3c performs control to specify a field in which specific data designated by the input device 4 is stored, out of a plurality of data displayed on the cell.

When the processor 3 having the above configuration changes the table T shown in FIG. 2 to the display of the table T1 shown in FIG.
The input device 4 is used to select arbitrary data displayed on the table T, and an instruction to generate a set is given.

In the generation of this set, a boxed display flag indicating whether or not the set is formed and the context of other data is included in each data, and the set is set vertically in the field on the table T1. A boxed display orientation flag is set which indicates whether to arrange them horizontally or horizontally. The boxed display flag is composed of, for example, 2 bits, and the boxed display direction flag is composed of 1 bit.

By the way, as the construction form of the table T1, there can be mentioned two forms, that is, a front head form and a front side formation.
The table top format is an arrangement of cells for identifying records in the vertical direction and identifying fields in the horizontal direction. The front-side format is an arrangement of cells for identifying records in the horizontal direction and identifying fields in the vertical direction. Table T1 shown in FIG.
Is an example in which cells are arranged in a front-end format.

With the above configuration, it is assumed that the display of the table T shown in FIG. 2 is completed. After that, when the table T1 is generated, the boxing display flag is set for each data under the control of the data arrangement control unit 3a.

Specifically, the data "110" is displayed before, the data "10" is displayed after, and the data "1" is displayed.
20 "is set to the previous display, data" 20 "is set to the subsequent display, and other data is similarly set to the previous display or the subsequent display.

For example, the content "0" is set in the case where there is no boxed display, the content "1" is set in the case of the previous display, and the content "2" is set in the case of the rear display. In this case, the data set with the front display is the head, and the set with the data set with the rear display is determined. Next, the data placement control unit 3a sets a boxed display orientation flag that determines whether each set of data is placed vertically or horizontally.

The process after the flag setting is completed will be described with reference to the drawings of FIGS.
FIG. 3 is a first flowchart according to the present invention. When the flag setting under the control of the data arrangement control unit 3a is completed, the data display area control unit 3b is activated, and it is determined whether the arranging direction is vertical or horizontal based on the contents of the boxed display direction flag. (Step S1).

If the result of step S1 is NO, the number of lines to be arranged, that is, the number of fields is determined (step S2). In step S2, if the content of the boxed display flag is "0" indicating no boxed display, it is determined that the number of fields is "1", and in other cases, the number of fields is "2". ..

When the result of step S2 is "2", the data for which the rear display has been set (the right field) is overlaid under the data for which the previous display has been set (the left field) and is placed in one cell. It is displayed (step S3), and the process ends.
The above procedure is the process for generating the table T1 shown in FIG.

If the result of step S2 is "1", 1
In order to display one data in the cell and to arrange the data vertically, one data is divided into two stages and displayed (step S4). The process in step S4 is shown in FIG.
Will be described with reference to.

FIG. 4 shows a first explanatory diagram related to the split display. In the figure, the content is “11111111” in field 1, the content is “22222222” in field 2, and the content is “333333” in field 3.
In the example when 33 "is set, it is the case that the previous display is set for the data of field 1 and the non-display is set for other data. Therefore, only the data of field 1 is displayed separately (boxed display). It becomes the target, and the 8-digit data is divided into 4-digits and displayed in two rows above and below.

Returning to FIG. 3 again, the result of step S1 is Y
In the case of ES, the number of fields is determined similarly to step S2 (step S5). If the result of step S5 is “2”, for example, a half-width blank (half-width space) is set after the data for which the previous display is set, and then the data for which the subsequent display is set is connected to form one cell. It is displayed (step S6), and the process ends.

The process in step S6 will be described with reference to FIG. FIG. 5 shows a first explanatory diagram related to group display. In the figure, the content is “11111111” in field 1, the content is “22222222” in field 2, and the content is “33” in field 3.
This is an example of the case where "333333" is set, in the case where the previous display is set for the data of the field 1 and no display is set for the other data.

Therefore, field 1 and field 2
Data is subject to group display (boxing display), a half-width blank is set between a pair of 8-digit data, and two data are displayed on the same line. Note that step S5
If the result is "1", one cell and one data is displayed, and the process is terminated without changing the display of the table.

Next, the case of the front side format will be described with reference to the drawings starting from FIG. FIG. 6 is a second flowchart according to the present invention. When the flag setting under the control of the data arrangement control unit 3a is completed, the data display area control unit 3b is activated, and it is determined whether the arranging direction is vertical or horizontal based on the contents of the boxed display direction flag. (Step S11).

If the result of step S11 is NO, the number of lines to be arranged, that is, the number of fields is determined (step S1).
2). In step S12, if the content of the boxed display flag is "0" indicating no boxed display, it is determined that the number of fields is "1", and in other cases, the number of fields is "2". ..

If the result of step S12 is "2", for example, a half-width blank (half-width space) is set after the data for which the front display has been set, and then the data for which the rear display has been set are connected to form one Display in cell (step S1
3), the process ends. A display example when step S13 is performed will be described with reference to FIG.

FIG. 7 is a second explanatory diagram related to group display. In the figure, the content is “11111111” in field 1, the content is “22222222” in field 2, and the content is “333333” in field 3.
In the example when 33 ”is set, the data of field 1 is displayed before, the data of field 2 is displayed after, and field 3 is displayed.
This is the case when no display is set for the data.

Therefore, the data of the field 1 and the field 2 are subject to boxing display, a half-width blank is set between a pair of 8-digit data, and two data are displayed on the same line. If the result of step S12 is "1", one cell one data is displayed, so the display is not changed and the process ends.

Returning to FIG. 6, the result of step S11 is YE.
In the case of S, if the result of step S11 is YES, the number of fields is determined similarly to step S12 (step S
14). If the result of step S14 is "2", the data set for the front display (the left field) is displayed under the data set for the rear display (the right field) (step S15), and the process is performed. To finish. Step S15
A display example in the case of performing will be described with reference to FIG.

FIG. 8 shows a third explanatory diagram related to the split display. In the figure, the content is “11111111” in field 1, the content is “22222222” in field 2, and the content is “333333” in field 3.
In the example when 33 ”is set, the data of field 1 is displayed before, the data of field 2 is displayed after, and field 3 is displayed.
This is a case where no display is set in the data of.

Therefore, field 1 and field 2
The data of is displayed in the group display (boxed display), and the data set for the rear display (right field) is overlaid on the data set for the front display (left field).
Display in one cell.

Returning to FIG. 6, when the result of step S14 is "1", one data is displayed in one cell, and one data is divided into two rows for display in order to arrange them vertically. (Step S16). A display example when step S16 is performed will be described with reference to FIG.

FIG. 9 shows a second explanatory diagram related to the group display. In the figure, the content is “11111111” in field 1, the content is “22222222” in field 2, and the content is “333333” in field 3.
In the example when 33 "is set, it is the case that the previous display is set for the data of field 1 and the non-display is set for other data. Therefore, only the data of field 1 is displayed separately (boxed display). As a result, 8-digit data is divided into 4-digits and displayed in two rows above and below.By the procedure described above, a plurality of data are arranged in one cell (display area),
Can be related.

When the input device 4 gives an instruction to construct a calculation formula, the field analysis unit 3c of the processor 3 is activated. The field analysis unit 3c allows the item instruction of the calculation formula by the input device 4 in the unit of data when a plurality of data are displayed in the cell, and in the unit of a cell when the plurality of data is not displayed in the cell. .. Based on the data or cell designated by the input device 4, a process of constructing a calculation formula is performed.

[0042]

As described above, according to the spreadsheet system of the present invention, a plurality of data can be arranged in one display area, so that a plurality of data can be easily arranged without a large eye movement. You can grasp the data.

[Brief description of drawings]

FIG. 1 is an explanatory diagram of a spreadsheet method of the present invention.

FIG. 2 is an explanatory diagram of a conventional spreadsheet method.

FIG. 3 is a first flowchart according to the present invention.

FIG. 4 is a first explanatory diagram related to split display.

FIG. 5 is a first explanatory diagram related to group display.

FIG. 6 is a second flowchart according to the present invention.

FIG. 7 is a second explanatory diagram related to group display.

FIG. 8 is a second explanatory diagram related to split display.

FIG. 9 is a third explanatory diagram related to group display.

[Explanation of symbols]

 3 processor 3a data arrangement control unit 3b data display area control unit 3c field analysis unit

Claims (1)

[Claims] 1. A record is constructed by arranging a plurality of data sequentially, and each data is managed in a unit of the record, and the record is divided into a plurality of fields which are predetermined unit areas, The respective data are extracted, the respective data are arranged in a plurality of display areas set on a table displayed on a display screen, and an arithmetic expression is generated by a field number specifying the field, and the table is displayed. And a data display area control section for arranging the set in one of the display areas. Spreadsheet method.