JP2003196577A - Table processing device, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To register one or a plurality of data in each cell constituting a table, and to conduct a predetermined processing based on the registered data. <P>SOLUTION: A table data area 22 is set to register the plurality of data as one integrated data in the one cell. When processing such as regression calculation and graph drawing is carried out for the registered data in the data area 22, the integrated data is distributed to the individual cell to execute the processing after reconstituting the table data. In sorting processing, the sorting processing for changing orders of the cells is conducted based on the data registered in the forefront of the each cell, in addition to the sorting processing in the every cell. A processed result generated by executing statistical processing and the like for the first cell group is made to correspond as related information of the data registered in the first cell group, and displayed. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table processing device for performing a spreadsheet process and a program for the process.

[0002]

2. Description of the Related Art Spreadsheet software uses a section (hereinafter, referred to as a "cell") generated by an intersection of a row and a column of a table as a basic unit when executed by a computer or the like, for one cell. One data representing a character, a numerical value, a formula, etc. is registered, a given operation is performed based on the data registered in the cell, and the result is displayed in the cell.

A normal table has data in the vertical and horizontal directions of the table, but in order to enhance the data processing function of the spreadsheet software, as shown in Japanese Patent Laid-Open No. 2001-101328, the rows, columns, and further tables of the table are further added. By giving each depth a parameter, it is possible to create a table representing data having three or more parameters.

In recent years, such data processing by spreadsheet software has come to be used as a part of learning for solving textbook problems such as mathematics.

[0005]

However, for example, when inputting a plurality of data in one cell in the data input of the textbook question using a matrix or the result of the repeated test, the conventional spreadsheet software is It was necessary to define various input methods. Further, if a special input method for a cell cannot be defined, one user repeatedly inputs one data into one cell, which increases the labor of the user. However, the table created in this way is difficult to understand and may not be suitable for learning, which hinders the use of spreadsheet software.

An object of the present invention is to provide a table processing device which registers one or a plurality of data in cells forming a table and performs given processing based on the registered data.

[0007]

In order to solve the above-mentioned problems, the invention according to claim 1 registers data in each cell forming a table by arranging a plurality of cells vertically and horizontally, and based on the registered data. In a table processing apparatus that performs a given calculation, an input unit (for example, the input unit 12 in FIG. 1) for inputting data to be registered in each cell and data input by the input unit for the cell are If there is a plurality of discriminating means (for example, the CPU 11 in FIG. 1; step A3 in FIG. 7) for discriminating whether or not there is a plurality, the plurality of data are integrated into one. And a storage unit (for example, the table data area 22 in FIG. 2) that integrates the data and stores the data in association with the cell.

According to a thirteenth aspect of the present invention, there is provided a table processing device for registering data in each cell constituting a table, which is arranged vertically and horizontally, and performing a given operation based on the registered data. Input means (for example, the input unit 12 in FIG. 1) for inputting data to be registered in each of the cells, and determination for determining whether or not the data input by the input means for the cell is plural. If a plurality of means (for example, the CPU 11 in FIG. 1; step A3 in FIG. 7) and the above-mentioned discrimination means discriminate the plurality of data, then the plurality of data are integrated into one integrated data to correspond to the cell. Storage means for attaching and storing (for example, the table data area 2 in FIG. 2)
2) and are functionalized.

According to the inventions of claims 1 and 13,
A plurality of data can be input to one cell, and the plurality of data are treated as one piece of data as integrated data. Therefore, it is possible to realize a table processing device that enables registration of a plurality of data while following the conventional method in which only one data can be registered in each cell.

Further, as in the invention described in claim 2, the table processing device according to claim 1 displays a table in which the data stored in the storage means is displayed in each corresponding cell, and If the data is integrated data,
Display means for automatically changing and displaying the size of the corresponding cell (for example, the display unit 13 in FIG. 1; the CPU 11 in FIG. 1;
It may be configured to further include step A6) in FIG. 7.

According to the second aspect of the invention, even when the integrated data in which a plurality of data are integrated is displayed, the size of the cell in which the integrated data is registered is automatically changed. . Therefore, the integrated data can be displayed in an easy-to-see manner.

When changing the size, the width of the column to which the cell belongs or the height of the row may be automatically changed. Further, as a method of displaying the integrated data in the cell, the integrated data may be separated by commas, or may be displayed with a line break or the like.

When the integrated data is stored in the storage means, the table processing apparatus according to the first or second aspect of the invention has a vertical direction from the cell corresponding to the integrated data. Alternatively, the cells are inserted in the horizontal direction to change the configuration of the cells, and each of the plurality of data integrated in the integrated data is stored in association with the inserted individual cell. First updating means for updating the stored contents (for example, CPU 1 in FIG. 1)
1; Step D7 in FIG. 15 may be further provided.

According to the third aspect of the present invention, it is possible to divide each of the plurality of data integrated in the integrated data into individual cells and reconstruct the table.
At that time, a cell for distributing the data is inserted in the vertical direction or the horizontal direction with reference to the cell in which the integrated data is registered. Therefore, it is possible to improve the visibility of whether the data is the integrated data before and after the data is sorted.

Further, as in the invention described in claim 4, the table processing apparatus according to any one of claims 1 to 3 has a specification means (for example, the input unit 12 in FIG. 1) for specifying a plurality of cells, The data registered in each of the plurality of cells designated by the designating means is read from the storage means and integrated as integrated data, and the integrated data is associated with one cell among the designated cells. As you remember
Second updating means (for example, CPU 11 in FIG. 1; step E5 in FIG. 17) for updating the storage contents of the storage means,
May be further provided.

According to the invention described in claim 4, data registered in a plurality of cells can be integrated as integrated data and re-registered in one cell. Of course, the cell designated by the designating means is not limited to one in which one data is registered, but may be a cell in which integrated data is registered.

At this time, as in the invention according to claim 5, the designating means may designate a plurality of cells based on the data registered in the cells. As described above, a plurality of cells may be specified by specifying the range of cells that are connected in the vertical direction and / or the horizontal direction.

According to the invention of claim 5, for example, n
The cell in the column is designated as a cell for designation by the designation means, and this n
The cells to be integrated can be designated depending on whether or not the data registered in the cells in the column are the same (for example, the same “1” is registered).

According to the sixth aspect of the invention, for example, all the cells in the m-th row are designated, or a desired range is designated from the cells arranged vertically and horizontally in the table. It becomes possible.

When the integrated data is stored in the storage means, the table processing device according to any one of claims 1 to 6 is integrated with the integrated data. Sorting means for sorting the order of a plurality of existing data (for example, CPU 11 in FIG. 1; step F in FIG. 19)
8) may be further provided.

According to the invention of claim 7, the order of the integrated data can be changed.

Further, as in the invention described in claim 8, the sorting means in the table processing device according to claim 7 further changes the arrangement position of each cell based on the data registered in each cell. At that time, when the data is integrated data, the arrangement position may be changed based on the data of a predetermined order among the integrated data.

According to the invention described in claim 7, the integrated data registered in the cells can be sorted. However, according to the invention described in claim 8, the cells are sorted in units of cells. Is possible. In addition, since there is a difference in the number of registered data such as a cell in which integrated data is registered or a cell in which only one data is registered, in the case of a cell in which integrated data is registered, for example, Sorting can be done based on the first data in the integrated data.

According to the ninth aspect of the invention, the table processing apparatus according to any one of the first to eighth aspects includes a first cell group designation means (for example, in FIG. 1) for designating the first cell group. CPU1
1) and, if it is integrated data, the number of data integrated into the integrated data is counted, and the same number of data as the number of data registered in each cell of the first cell group is calculated. Second that specifies the registered second cell group
A cell group designating means (for example, the CPU 11 in FIG. 1), an execution means (for example, a CPU) of the first cell group, and an executing means for executing a given process by associating each data of the second cell group with each other. , CPU 11 in FIG. 1; step C11 and step C13 in FIG. 13) may be further provided.

According to the invention of claim 9, for example, the first cell group is the value of the variable X, and the second cell group is the variable Y.
Create statistical graphs and statistical calculations when the value of
It becomes possible.

Further, as in the invention described in claim 10, the table processing device according to claim 9 calculates the related information of the first cell group for each cell included in the first cell group. When calculating means (for example, CPU 11 in FIG. 1; steps J3 to J4 in FIG. 30) and the first cell group, each cell included in the first cell group calculated by the calculating means is displayed. Related information display means (for example, the display unit 1 shown in FIG. 1) for displaying the related information of No.
3; Step K3) in FIG. 31 may be further provided.

According to the tenth aspect of the present invention, for example, the calculation means performs statistical processing on the first cell group,
When the information such as the maximum value cell and the minimum value cell is calculated as the related information, it is possible to make the display such as which cell data has the maximum value visually easy to understand.

Further, in this case, in order to further improve the visibility, as in the invention described in claim 11, the cell to which the related information is associated is identified and displayed according to the related information (for example, the maximum value is displayed). Identification display means (for example, the display unit 13 in FIG. 1; step M in FIG. 33) that shades cells, etc.
1) may be further provided.

Further, as in the invention described in claim 12, the related information display means in the table processing apparatus according to claim 10 or 11 displays the plurality of related information when there are a plurality of related information for the cell. , May be displayed in association with the cell.

According to the twelfth aspect of the present invention, even if a plurality of related information is associated with one cell, it can be displayed without any problem.

[0031]

BEST MODE FOR CARRYING OUT THE INVENTION Hereinafter, an embodiment of a table processing device 1 which is a scientific calculator to which the present invention is applied will be described in detail with reference to FIGS. A plurality of embodiments will be described. First, the table processing device 1 common to the respective embodiments.
The configuration of will be described.

FIG. 1 is a circuit configuration diagram of the table processing apparatus 1, which includes a CPU (Central Processing Unit) 11, an input unit 12, a display unit 13, a communication control unit 14, and a RAM (Random A).
ccess Memory) 15, ROM (Read Only Memory) 1
6, an external storage device 17, and each unit is connected by a bus 19. In addition, the external storage device 1
A storage medium 18 is connected to 7.

The CPU 11 has a ROM 16 and a storage medium 18.
The specified application program among various application programs stored in the
Various data corresponding to various instruction signals input from the RAM 15 are registered in the RAM 15, various types of processing are executed according to the application program registered in the RAM 15 according to the input instruction and the input data, and the processing results are stored in the RAM.
The information is registered in 15, and displayed on the display unit 13. That is, the CPU 11 executes the programs stored in the ROM 16 or the storage medium 18 to cause the table processing device 1 to realize various functions.

The input unit 12 is composed of a numeric keypad or a keyboard, and outputs the input signal to the CPU 11 when the user inputs a numerical value or gives an instruction to execute an application program.

The display unit 13 displays the characters and codes input by the input unit 12, the processing result of the application program, etc., and is an LCD (Liquid Crystal).
Display) etc.

The communication control section 14 is an interface for transmitting and receiving data, signals and the like to an external device via a communication line, and operates by a signal from the CPU 11.

The RAM 15 stores data created by executing various application programs.
Details of the data structure will be described later.

The ROM 16 stores a basic program corresponding to the table processing device 1. For example, a basic program such as a startup program executed when the power of the table processing device 1 is turned on, various function calculation programs, a processing program executed in various processing modes, and the like are stored.

The external storage device 17 is pre-stored with programs, data and the like, and is configured to include a storage medium 18 such as a magnetic or optical storage medium or a semiconductor memory which can be read by the CPU 11.

The storage medium 18 is composed of a portable medium such as a CD-ROM or a fixed medium such as a hard disk. The programs, data, etc. stored in the storage medium 18 may be partially or wholly received from the communication control unit 14 from a server or a client via a transmission medium such as a communication line. May be a storage medium of a server built on the network.
Further, the program may be transmitted to a server or a client via a transmission medium such as a communication line and installed in these devices.

As the processing programs stored in the storage medium 18, data input processing, formula input processing, cell correspondence processing, plural → singular conversion processing, single → plural conversion processing,
There are sort processing, nesting processing, statistical result display processing, statistical processing, information display / non-display processing, identification display processing, approximate value display processing, multiple information display processing, priority order information setting processing, and the like.

FIG. 2 is a diagram showing the data structure of the RAM 15. The RAM 15 includes a work data area 21, a table data area 22, a regression calculation data area 23, a graph drawing data area 24, a statistical calculation data area 25, and an information table 26.

The work data area 21 temporarily stores a designated application program, data input / output to / from the CPU 11, processing results, and the like as the various application programs are executed.

The table data area 22 stores table data to be displayed on the display unit 13. The table data is composed of an array of cells, and one or a plurality of data are stored in each cell. Details of the area will be described later.

The regression calculation data area 23 stores the calculation result of the regression calculation obtained by the cell correspondence processing (see FIG. 12) described later.

The graph drawing data area 24 stores graph drawing data obtained by the cell correspondence processing (see FIG. 12) described later.

The statistical calculation data area 25 stores statistical data obtained by a statistical process (see FIG. 30) described later.

The information table 26 stores relevant information for the data which is set in the statistical processing (see FIG. 30) described later and is the object of the statistical processing. Details of the information table 26 are shown in FIG.
Will be described later with reference to.

FIG. 3 is a diagram showing the data structure of the table data stored in the table data area 22. Table data area 2
A column number, a list name, or the like is stored in the first row of the table data stored in 2, and a row number or the like is stored in the first column. A section is defined by the intersection of rows and columns of table data as a cell, and data such as one or a plurality of numerical values, characters, and mathematical formulas is registered in the cell.

[First Embodiment] A table processing apparatus 1 according to a first embodiment will be described with reference to FIGS. 4 to 7.

4 and 5 are diagrams showing the table displayed on the display unit 13 and the input keys operated when the data input process shown in FIG. 7 is executed.

As shown in FIG. 4A, when the user inputs "1" into the cell (for example, cell (List1,1)) where the cursor 41 is located from the input unit 12, the CPU 11 displays The input content "1" is displayed at the lower left of the table of 4 (a). Then, the user
When the "E" key is pressed, the CPU 11 causes the cell (List
“1” is confirmed as the data to be registered in (1, 1) and displayed in the cell (FIG. 4B), and “1” is registered in the area corresponding to the cell (List1, 1) of the table data area 22. To do.

Further, as shown in FIG. 5A, the cell (Lis
For t1,1), when the user inputs a plurality of pieces of data “{1,2,3}” from the input unit 12,
The CPU 11 displays the input content “{1, 2, 3}” at the lower left of the table of FIG. Next, when the user inputs the "EXE" key, the CPU 11 selects "1, 2," as data to be registered in the cell (List1,1).
“3” is confirmed and displayed in the table cell (FIG. 5B), and “1,2,3” is set as one integrated data in the area corresponding to the cell (List1,1) of the table data area 22. Remember. After data is registered in the cell (List1, 1),
When the cell is selected by the user, FIG.
As shown in, the cursor 41 moves to the cell (List1, 1)
The CPU 11 displays the data registered in the cell at the lower right of the table.

Here, a plurality of data, which are arranged surrounded by curly braces “{” and “}” and separated by commas “,”, indicate integrated data registered in one cell.

FIG. 6 is a diagram showing an example of a table display method when integrated data is registered in one cell. In FIG. 6A, the same number of frames as the data (for example, frames 61 to 63) are displayed in a superimposed manner on a cell in which a plurality of data are registered. Shows the method of displaying the data registered at the beginning of the.

For example, as shown in FIG. 5B, the cell (Li
If three data are registered in st1,1), C
The PU 11 displays the cells (List1, 1) by overlapping the frames 61 to 63, and displays the cells (List) in the foremost frame 61.
"1" which is the data registered at the beginning of 1, 1) is displayed. Then, depending on the user, the frame 62 or 63
Is selected from the input unit 12, the CPU 11 causes the cell (L
The second or third data registered in ist1, 1) is sequentially displayed.

FIG. 6B shows a method of dividing a cell in which a plurality of data are registered into the same number of partitions as the data and displaying the data registered in each partition.

For example, as shown in FIG. 5B, the cell (Li
If three data are registered in st1,1), C
The PU 11 divides the cell (List1, 1) into three and displays the data registered in each of the divided sections.

FIG. 7 is a flow chart for explaining the operation of the data input process executed by the table processing device 1. This process shows the operation of the data input process for one cell, and when data is continuously input to the cell, this process is repeatedly executed.

First, the CPU 11 determines whether or not the user has made a key input from the input unit 12 (step A).
1), the process of step A1 is repeated until there is a key input. When input is made (step A1: Yes), CP
U11 determines whether or not the input data is data to be stored in the table data area 22 (step A2). When the input data is not the data stored in the table data area 22 (step A2: No), the CPU 11 executes other processing.

On the other hand, if the input data is data to be stored in the table data area 22 (step A2: Yes), C
The PU 11 determines whether or not there is a plurality of input data (step A3). If there are not multiple input data (step A
3: No), the CPU 11 displays the input data in the table data area 2
2 is registered (step A4), and the process proceeds to step A7. When there are multiple input data (step A3: Ye
s), the CPU 11 registers a plurality of data in the table data area 22 as one integrated data (step A5).

Subsequently, the CPU 11 performs the extended display process on the cell in which the integrated data is registered in step A5 in the table displayed on the display unit 13 (step A6).
In order to display all or part of the integrated data registered in step A5 in the cell of the table displayed on the display unit 13, the width of the column of the cell or the height of the row is changed. This is the process of displaying.

Next, the CPU 11 displays the data registered in the table data area 22 at step A4 or step A5 in the table cell displayed on the display unit 13 (step A7). Next, when the data is input by the user to end the data input process (step A8: Ye
s), the CPU 11 ends the process. When it is input that the processing is not to be ended (step A8: No), the CPU 11 executes other processing.

As described above, in the data input process executed in the table processing device 1 according to the first embodiment,
Regarding the data input by the user, the CPU 11 determines whether or not there is a plurality of input data, registers the input data in the table data area 22, and displays the input data in the cells of the table displayed on the display unit 13. To do. If the data registered in the cell is integrated data, the CPU 11
Changes the size of the displayed cell and then displays the integrated data in the cell.

Therefore, when a plurality of data are input to one cell, the plurality of data can be registered in the cell without defining a special input method that has been conventionally performed. Therefore, for example, the data of the textbook question and the test result can be expressed in a table in an easy-to-understand manner, and the table processing device 1 that can be easily used for learning can be realized.

[Second Embodiment] Referring to FIGS. 8 to 10, a table processing apparatus 1 according to a second embodiment of the present invention.
Will be described.

FIGS. 8 and 9 are diagrams showing the contents displayed on the display unit 13 and the input keys operated when the formula input process shown in FIG. 10 is executed. When the CPU 11 reads the processing program stored in the storage medium 18 and executes the formula data input process, the CPU 11 is in a state of waiting for the formula input by the user. In the second embodiment, the expression is
It is a command statement for registering data in a cell, and RO
Input using the program command or the like stored in M16.

First, as shown in FIG. 8A, when the user inputs "{1, 2, 3} → List1" and further inputs the "EXE" key, the CPU 11 displays "{1 , 2, 3} → List1 ”is confirmed, and“ 1 ”is added to the first cell of the column of List1 in the table data area 22.
, "2" in the second cell and "3" in the third cell.

Subsequently, when the user inputs “List1”, the CPU 11 displays the contents of the data registered in the column of List1 in the table data in the table data area 22 as shown in FIG. 8B. It is displayed on the display unit 13.

Further, as shown in FIG. 9A, the user may select "{{1,2,3}, {4,5,6}, {7,8,
9}} → List1 ”and then the“ EXE ”key is input, the CPU 11 displays“ {{1,2,3}, {4,5,6}, {7,8,
9}} → List1 ”, and L of the table data area 22 is confirmed.
"1,2,3" is set in the first cell of the column of ist1, "4,5,6" is set in the second cell, and "7,8," is set in the third cell.
9 ”is registered.

Subsequently, when the user inputs "List1", the CPU 11 displays the contents of the data registered in the column of List1 in the table data in the table data area 22 as shown in FIG. 9B. It is displayed on the display unit 13.

FIG. 10 is a flow chart for explaining the operation of the expression input process executed by the table processing device 1.
This processing shows the operation of the data input processing for one cell group, for example, the column, and when data is continuously input, this processing is repeatedly executed.

First, the CPU 11 determines whether or not the user has made a key input from the input unit 12 (step B
1), the process of step B1 is repeated until there is a key input. When the input is made (step B1: Yes), it is determined whether or not the input data is formula data indicating that the data is stored in the table data area 22 (step B).
2). If not formula data (step B2: No), C
The PU 11 executes other processing.

On the other hand, if it is expression data (step B
2: Yes), the CPU 11 determines whether or not there are a plurality of data to be registered in one cell (step B3). When the data is not plural (step B3: No), the CPU 11 compiles the expression data (step B4) and registers the data in the table data area 22 (step B5). And C
PU11 advances a process to step B9.

When there are a plurality of data to be registered in one cell (step B3: Yes), the CPU 11 compiles the expression data (step B6) and registers the plurality of data in the table data area 22 as one integrated data ( Step B7). Subsequently, the CPU 11 performs the extended display process on the cell in which the integrated data is registered in step B7 in the table displayed on the display unit 13 (step B8).

Next, the CPU 11 stores the data registered in the table data area 22 in step B5 or step B7,
It is displayed in the cell of the table displayed on the display unit 13 (step B9). Next, when the data is input by the user to end the data input processing (step B10: Yes), C
The PU 11 ends the process. When it is input that the processing is not to be ended (step B10: No), the CPU 11 executes other processing.

As described above, in the expression input processing executed in the table processing device 1 according to the second embodiment, the CP
U11 is the formula data input by the user,
It is determined whether or not there is a plurality of data registered in one cell. Then, the CPU 11 registers the data in the table data area 22 and displays the data in the corresponding cell of the table displayed on the display unit 13. If the data registered in the cell is integrated data, the CPU 11 changes the size of the cell to be displayed and then displays the integrated data in the cell.

As described above, by inputting the formula data using the program command, a plurality of data can be registered in one cell, and the data registration for a plurality of cells can be collectively executed. .

[Third Embodiment] With reference to FIGS. 11 to 13, a table processing apparatus 1 according to a third embodiment will be described.

FIG. 11 is a diagram showing the contents displayed on the display unit 13 and the processing result when the cell correspondence processing shown in FIG. 12 is executed. The cell correspondence process is a process of performing a given process by associating each data of two cell groups having the same number of data.

For example, when the CPU 11 executes the cell correspondence processing on the columns of List1 and List2 in the table shown in FIG. 11A, the data registered in the cells of the same row of List1 and List2 are associated with each other. . At this time, the CPU 11 counts the number of lines and the number of data of List1 and List2. If the number of rows and the number of data are the same, for a cell in which multiple data are registered, concatenate the cells and insert a new cell to change the cell configuration and layout, and then merge the cells registered in the cell. Allocate the data to each individual cell and register it. The table data at this time is as shown in FIG.

Then, the process proceeds to the next process according to the user's input instruction. In the present embodiment, regression calculation and graph drawing will be described as the content of the processing instructed by the user, but the content of the processing is not limited to this.

When performing regression calculation on the table data displayed in FIG. 11A, the user selects the CALC button 110 by the input unit 12. As a result, the CPU 11 causes the selection item column 1 as shown in FIG.
11 is displayed, and when the user selects “3: REG”, the selection item column 112 is further displayed. Then, when the user selects, for example, “1: Linear”, the CPU 11 executes the cell correspondence process.

Then, the CPU 11 carries out a linear regression calculation based on the table data shown in FIG. 11B, using the data registered in the column of List1 as the variable X and the data registered in the column of List2 as the variable Y. It is executed and the execution result is displayed on the display unit 13 (FIG. 11D).

When the graph drawing is executed for the table data displayed in FIG.
The RPH button 113 is selected by the input unit 12. As a result, the CPU 11 displays the selection item column 114 as shown in FIG. Then, when the user selects, for example, “1: S-Gph1”, the CPU 1
1 executes a cell correspondence process.

Then, the CPU 11 sets the data registered in the column of List1 to X coordinate data (or Y coordinate data) based on the table data shown in FIG.
The data registered in the column of t2 is Y coordinate data (or X coordinate data), a graph is created based on the processing of the graph instructed by the user, and is displayed on the display unit 13 (FIG. 1).
1 (d ')).

12 and 13 are flow charts for explaining the operation of the cell correspondence processing executed by the table processing device 1. First, the CPU 11 determines whether or not a command is input from the input unit 12 by the user (step C1), and repeats the process of step C1 until a command is input. When input is made (Step C1: Ye
s), it is determined whether or not the content of the command is a process that requires execution of the cell corresponding process (step C2). When it is not necessary to execute the cell corresponding process (step C2: N
o), the CPU 11 executes other processing.

On the other hand, if the command is a process that requires execution of the cell corresponding process (step C2: Yes), the CPU
Reference numeral 11 indicates the first cell group (for example, the column of List1 in FIG. 11A) and the second cell group (for example, the column of List2 in FIG. 11A) of the table data displayed on the display unit 13. The table data stored in the table data area 22 is read and stored in the work data area 21 (step C
3).

Subsequently, the CPU 11 causes the work data area 2
The presence or absence of integrated data registered in one cell of the table data stored in 1 is determined (step C4). When there is no integrated data (step C4: No), CPU1
1 determines whether the first cell group and the second cell group stored in the work data area 21 have the same number of rows (step C).
5). If the number of lines is the same (step C5: Yes), CP
U11 advances the process to step C10. When the number of lines is different (step C5: No), the CPU 11 causes the display unit 13
An error message is displayed on the screen (step C7), and the process ends.

On the other hand, if there is integrated data (step C
4: Yes), the CPU 11 determines whether or not the number of rows of the first cell group and the second cell group stored in the work data area 21 is the same (step C6). When the number of rows is different (step C6: No), the CPU 11 shifts the processing to step C7.

When the number of rows is the same (step C6: Ye
s), the CPU 11 determines whether or not the cells in the same row in which the integrated data of the first cell group and the second cell group are registered have the same number of data (step C8). When the number of data is different (step C8: No), the CPU 11 shifts the processing to step C7.

When the number of data is the same (step C8: Y
es), the CPU 11 changes the cell configuration and arrangement by inserting a new cell by connecting to the cell in which integrated data is registered in the table stored in the work data area 21. Allocate the integrated data registered in the cell to the individual cells that have been inserted and register. (Step C9).

Then, the CPU 11 determines whether the instruction input by the user is regression calculation or graph drawing (step C10). When a regression calculation instruction is input (step C10: regression), the CPU 11 executes R
The regression calculation is executed based on the regression calculation formula stored in the OM 16 and the table data stored in the work data area 21, and the calculation result is stored in the regression calculation data area 23 (step C11). Subsequently, the CPU 11 displays the data stored in the regression calculation data area 23 on the display unit 1.
3 (step C12), and the process proceeds to step C15.

On the other hand, when a graph drawing instruction is input (step C10: graph), the CPU 11 creates a graph based on the table data stored in the work data area 21 and draws the graph drawing data. The data is stored in the data area 24 (step C13). Then C
The PU 11 displays a graph on the display unit 13 based on the data stored in the graph drawing data area 24.
(Step C14).

Next, in the case where the user inputs that the process which needs to execute the cell corresponding process is ended (step C1)
5: Yes), the CPU 11 ends the process. When it is input that the processing is not to be ended (step C15: No), the CPU
11 executes other processing.

As described above, in the cell correspondence processing executed in the table processing device 1 according to the third embodiment, C
The PU 11 reads out the table data of the first cell group and the second cell group for which the processing is designated from the table data stored in the table data area 22, stores it in the work data area 21, and stores it in the work data area 21. The number of rows and the number of data for the first cell group and the second cell group are counted and compared.
If the number of rows and the number of data are the same, change the cell configuration and arrangement by inserting a new cell by concatenating to the cell where the integrated data is registered, and registering in the cell. Register the integrated data by dividing it into each inserted cell. Based on the table data stored in the work data area 21 thus reconstructed, the CPU 11
Performs a given process.

Accordingly, when a given process is executed on a table including cells in which integrated data is registered in one cell, the user can combine the integrated data registered in one cell into individual cells. It is not necessary to sort and re-input, and the table processing device 1 can easily execute processing such as regression calculation and graph drawing.

[Fourth Embodiment] With reference to FIGS. 14 and 15, a table processing apparatus 1 according to a fourth embodiment of the present invention will be described.

FIG. 14 is a diagram showing the contents displayed on the display unit 13 and the processing result when the plural-to-singular conversion process shown in FIG. 15 is executed. The plural-to-single conversion process is a process in which, in a cell in which integrated data is registered, each data is sorted and registered in individual cells.

First, the user sets the cursor 140 in the cell of the column for performing the plural-to-singular conversion process (see FIG. 14).
(A)), The CONU button 141 is selected by the input unit 12. As a result, as shown in FIG.
11 displays a selection item column 142, and when the user selects “1: Norm”, the CPU 11 has a plurality of →
Perform singular conversion processing.

Next, when the integrated identifier is stored in the cell to be processed in the plural-to-singular conversion process, the CPU 11 inputs the column number of the column in which the integrated identifier is registered, as shown in FIG. 14C. Is displayed. Here, the integrated identifier is identification information indicating whether or not it is integrated data, and is a unique number for each integrated data. The user can select whether to acquire the integrated identifier.

Next, when the user inputs, for example, "3" as the column number of the column for registering the integrated identifier, and then the "EXE" key is input, the CPU 11 causes the List to be changed.
It is confirmed that the integrated identifier is registered in the column of 3 (FIG. 14).
(D)). Then, the CPU 11 executes the plural-to-singular conversion process, and the processing result is displayed on the display unit 13 as shown in FIG.
To display.

Here, List3 is used as the integrated identifier of the data registered in the cell of List1 in FIG. 14 (e).
The data registered in the cell will be described. Li
The data registered in the first to third cells of st1 are
Before the plural-to-single conversion process, since it is the integrated data registered in the first cell of List1,
"1" is registered in all cells in the third row. See also Lis
Similarly, the data registered in the 4th and 5th lines of t1 are the integrated data registered in the second cell of List1 before the plural-to-singular conversion process.
"2" is registered in the cell of the row. The data registered as the integrated identifier may be a symbol such as an alphabet other than the cell number.

FIG. 15 is a flow chart for explaining the operation of the plural-to-singular conversion process executed by the table processing device 1. First, the CPU 11 causes the user to input the input unit 12
It is determined whether or not a command has been input (step D
1), the process of step D1 is repeated until a command is input. When input is made (step D1: Yes),
It is determined whether or not the input command is a command instructing execution of the plural-to-singular conversion process (step D2). When the command is not a command to execute the plural-to-singular conversion process (step D2: No), the CPU 11 executes another process.

When the command is an instruction to execute the plural-to-singular conversion process (step D2: Yes), the CPU 11
Is based on instruction data entered by the user
It is determined whether to acquire the integrated identifier (step D
3). When the integrated identifier is not acquired (step D3: N
o), the CPU 11 advances the process to step D6.

When obtaining the integrated identifier (step D
3: Yes), and the input section 143 for inputting the column for registering the integrated identifier is displayed on the display unit 13. Then, the user inputs the column number for registering the integrated identifier (step D4).
Then, the CPU 11 registers the cell number of the data in the table data stored in the table data area 22 in the cell of the column number input in step D4 (step D5).

Next, the CPU 11 reads out the table data of the cell to be processed and the integrated identifier from the table data stored in the table data area 22, and the work data area 21 is read.
(Step D6). Subsequently, in the table data stored in the work data area 21, the CPU 11 changes a cell configuration and arrangement by inserting a new cell by connecting to the cell in which integrated data is registered,
The integrated data registered in the cell is sorted and registered in each inserted cell. (Step D7). Then, the CPU 11 displays the reconstructed table data stored in the work data area 21 on the display unit 13 (step D8).

Next, when the user inputs to finish the plural-to-singular conversion processing (step D9: Yes),
The CPU 11 ends the process. When it is input that the processing is not to be ended (step D9: No), the CPU 11 executes other processing.

As described above, in the plural-to-singular conversion process executed in the table processing device 1 according to the fourth embodiment, among the table data stored in the table data area 22,
When the user selects an instruction to acquire the integrated identifier for the data registered in the processing-specified cell group, the CPU 11 acquires the integrated identifier for the data and stores it in the table data area 22. Then, out of the table data stored in the table data area 22, the table data of the cell group and the integrated identifier for which the process is designated is read out and stored in the work data area 21, and the cells for which the integrated data is registered are read out. Then, a new cell is connected to the cell to insert a new cell to change the cell configuration and arrangement, and the integrated data registered in the cell is distributed and registered to each individual cell. Then, the CPU 11 displays the reconstructed table data in the work data area 21 on the display unit 13.

As a result, when a table including cells in which integrated data is registered in one cell is converted into a table in which one data is registered in one cell, the user allocates the data to individual cells. Therefore, it is not necessary to re-input the data, and the table processing apparatus 1 can be made to easily continue the processing such as regression calculation and graph drawing.

[Fifth Embodiment] With reference to FIGS. 16 and 17, a table processing apparatus 1 according to a fifth embodiment of the present invention will be described.

FIG. 16 is a diagram showing the contents displayed on the display unit 13 and the processing result when the singular-to-plural conversion processing shown in FIG. 17 is executed. The singular-to-plurality conversion process is a process in which data registered in individual cells are collectively registered in one cell as integrated data.

First, as shown in FIG. 16A, the user sets the cursor 150 in the cell of List1 which is the column for performing the singular → plural conversion process, and selects the CONU button 151 by the input unit 12. Thereby, as shown in FIG. 16B, the CPU 11 displays the selection item column 152. When “2: Expnd” is selected by the user, FIG.
As in (c), the CPU 11 displays the input field 153 for inputting the column number in which the integrated identifier of the data registered in the cell of List1 is registered. Then, as shown in FIG. 16D, the user inputs, for example, “3” as the column number in which the integrated identifier is stored, and subsequently, the “EXE” key is input. As described above, the CPU 11 executes the singular-to-plurality conversion process on the data registered in the column of List1 based on the integrated identifier registered in the column of List3. And CPU
11 displays the processing result.

FIG. 17 is a flow chart for explaining the operation of the single-to-plural conversion processing executed by the table processing device 1. First, the CPU 11 causes the user to input the input unit 12
It is determined whether or not a command has been input (step E
1), the process of step E1 is repeated until a command is input. When the input is made (step E1: Yes),
It is determined whether or not the input command is a command for instructing execution of single-to-plurality conversion processing (step E2). If the command is not a command to execute the singular-to-plural conversion process (step E2: No), the CPU 11 executes another process.

If the command is an instruction to execute the singular-to-plural conversion process (step E2: Yes), the CPU 11
Displays on the display unit 13 an input field 153 for inputting a column in which the integrated identifier of the column to be processed is registered. Then, the user inputs the column number in which the integrated identifier is registered. (Step E3). Next, the CPU 11 reads out the table data including the column to be processed and the column in which the integrated identifier is registered from the table data area 22 and stores it in the work data area 21 (step E4).

Then, the CPU 11 uses the work data area 2
The table data stored in 1 is based on the integrated identifier,
The data registered in each cell is registered in one cell as integrated data, and the cell configuration arrangement is changed (step E5). Subsequently, the CPU 11 causes the work data area 2
The reconstructed table data stored in No. 1 is displayed on the display unit 13.
Is displayed (step E6).

Next, when the user inputs to end the cell correspondence processing (step E7: Yes), the CPU
11 ends the process. When it is input that the processing is not to be ended (step E7: No), the CPU 11 executes other processing.

As described above, in the singular-to-plural conversion process executed in the table processing device 1 according to the fifth embodiment, among the table data stored in the table data area 22,
The table data in the work data area 21 reconfigured by registering the data registered in each cell as integrated data in one cell based on the integrated identifier for the data registered in the processing-specified cell group. Is displayed on the display unit 13.

As a result, by executing the singular-to-plurality conversion process described in the fifth embodiment, the integrated data that has been distributed and registered in individual cells can be registered again in one cell.

[Sixth Embodiment] With reference to FIGS. 18 to 20, a table processing apparatus 1 according to a sixth embodiment of the present invention.
Will be described.

FIG. 18 is a diagram showing the contents displayed on the display unit 13 and the processing result when the sorting process shown in FIG. 19 is executed. The sort process is a process of rearranging the data registered in the cell group in ascending order or descending order.

First, as shown in FIG. 18A, the user moves the cursor 1 to the cell of List1 which is the column for performing the sorting process.
90 is set, and the SORT button 191 is selected by the input unit 12. As a result, as shown in FIG.
The PU 11 displays the selection item column 192. Here, "1:
“SortH” indicates ascending sort, and “2: SortD” indicates descending sort. For example, depending on the user, "1: Sort
When "H" is selected, the CPU 11 sorts one of the registered data in the cell or the order of the integrated data for each cell based on the data registered at the head of the cell,
As shown in FIG. 18C, an input field 193 for inputting whether or not to further sort the cell order is displayed. Then, as shown in FIG. 18D, when the user inputs “0” and then the “EXE” key, the CPU 11
Will sort the data registered in the column of List1 cell by cell and display the result of the sorting process on the display unit 13 as shown in FIG.

Further, for the input field 193, FIG.
As shown in (d '), the user inputs "1",
Then, when the "EXE" key is pressed, the CPU 11 sets L
The data registered in the column of ist1 is sorted for each cell, and the cell order is sorted based on the data registered at the beginning of the cell. Then, as shown in FIG. 18 (e ′), the CPU 11 displays the result of the sorting process on the display unit 13.

19 and 20 are flow charts for explaining the operation of the sort process executed by the table processing device 1. First, the CPU 11 causes the user to input the input unit 1
It is determined from step 2 whether or not a command is input (step F1), and the process of step F1 is repeated until the command is input. When input is made (step F1: Ye
s), it is determined whether or not the input command is a command instructing execution of sort processing (step F2). If the command is not an instruction to execute sort processing (step E
2: No), the CPU 11 executes other processing.

Next, the user inputs whether to perform ascending sort or descending sort (step F3),
Then, it is input whether or not to sort the cell order (step F4). If the user inputs that the cell order is to be sorted (step F4: Yes), the CPU1
1 substitutes 1 for the variable C (step F5). When it is input that the cell order is not sorted (step F
4: No), the CPU 11 substitutes 0 for the variable C (step F6).

Next, the CPU 11 reads out the table data of the column to be processed from the table data area 22 and stores it in the work data area 21 (step F7), and executes the sort processing for the cells in which the integrated data is registered (step F7). Step F
8). Subsequently, the CPU 11 determines the value of the variable C (step F9), and when C = 0 (step F9: No), C
PU11 advances a process to step F11. On the other hand, C =
In the case of 1 (step F9: Yes), the CPU 11 executes the sorting process of the cell order based on the head data of each cell of the table data stored in the work data area 21 (step F10).

Then, the CPU 11 displays the sorted table data stored in the table data area 21 on the display unit 1.
3 is displayed (step F11). If the user subsequently inputs that the sorting process is to be ended (step F
12: Yes), the CPU 11 ends the process. When it is input that the processing is not to be ended (step F12: No), CP
U11 executes other processing.

As described above, in the sort processing executed in the table processing device 1 according to the sixth embodiment, the CP
U11 is the table data stored in the table data area 22,
Sort processing is performed for each cell on a plurality of data registered in the designated cell group. Further, according to the user's selection, the CPU 11 executes the sorting process of the cell order based on the data registered at the head of the cell.

As a result, when the integrated data is registered in one cell, the sorting process can be executed without the user having to divide the integrated data into individual cells and re-input.

[Seventh Embodiment] With reference to FIGS. 21 to 25, a table processing apparatus 1 according to a seventh embodiment of the present invention.
Will be described.

21 to 24 are diagrams showing the contents displayed on the display unit 13 and the processing result when the nesting process shown in FIG. 25 is executed. Nesting processing is the processing that when the range of another cell, for example, the column number of a different column, is registered as the data to be registered in the cell, the same data as the data registered in the column of that column number is registered in the cell. Is.

FIGS. 21 and 22 show C when a user registers another cell range, for example, a column number, in the cell.
PU11 has shown the case where the said column number is displayed in a cell. First, as shown in FIG. 21A, the user designates a column for registering data with the cursor 221, inputs “{List1, List2, 3}” as the data, and finally inputs the “EXE” key. As a result, the CPU 11 sets Lis to the first cell of List3 in the table data area 22.
The data registered at t1 is Lis to the second cell.
The data registered in t2 is set to "3" in the third cell.
Are registered in association with each other, and as shown in FIG.
To display.

The user can also execute a data nesting process by inputting an expression. For example, as shown in FIG.
As in (a), “{List1, List2, 3} →
Enter "List3" and finally press the "EXE" key. As a result, the CPU 11 causes the Li of the table data area 22 to
The data registered in List1 in the first cell of st3, the data registered in List2 in the second cell, and "3" are registered in the third cell in association with each other, as shown in FIG. Is displayed on the display unit 13.

23 and 24 show the case where the data registered in the column having the column number registered by the user is displayed in the cell.

First, as shown in FIG. 23A, the user designates a column for registering data with the cursor 231 and inputs "{List1, List2, 3}" as data,
Finally, press the "EXE" key. This allows the CPU
Reference numeral 11 denotes data registered in List1 in the first cell of List3 in the table data area 22 "1, 2,
"3" is registered in the second cell, which is the data registered in List2, "4, 5", and the third cell is registered in association with "3", and as shown in FIG. Display to 13

When the user executes the data nesting process by inputting the expression, for example, as shown in FIG. 24A, “{List1, List2, 3} → List3”.
And then press the "EXE" key. As a result, the CPU 11 sets the data “1, 2, 3” registered in List1 in the first cell of List3 in the table data area 22 to the data “4, 4 registered in List2 in the second cell. "5" is registered by associating "3" with the third cell and displayed on the display unit 13 as shown in FIG. 24 (b) (FIG. 24 (b)).

By executing the nesting process by the CPU 11 as shown in FIGS. 21 to 24, List1 and cells (List) are executed.
Since the contents of (3, 1) are associated, the CPU 11 automatically changes the contents of the data registered in the cell of List1 by the user (List3, List3).
Change the contents of the data registered in 1), and
The contents of the cell displayed in 3 are also changed at the same time.

FIG. 25 is a flow chart for explaining the operation of the nesting process executed by the table processing device 1.
First, the CPU 11 determines whether or not the user has made a key input from the input unit 12 (step G1), and repeats the processing of step G1 until a key input is made. When the input is made (step G1: Yes), it is determined whether or not the input data is data indicating the nesting process (step G2). When there is no data indicating the nesting processing (step G2: No), the CPU 11 executes other processing.

On the other hand, when the data indicates the nesting process (step G2: Yes), the CPU 11 compiles the data input by the expression input (step G3). Then, the input data (for example, List1) is displayed as it is in the cell in which the data is registered, or the data registered in the cell group indicated by the input data (for example, registered in the column of List1). The selected input of the displayed data “1, 2, 3”) is awaited. Then, when an input is made to display the input data as it is (step G4: Yes), the input data is registered in association with the designated cell (step G5), and the CPU 11 advances the process to step G8. .

On the other hand, when it is input to display the data registered in the cell group indicated by the input data in the specified cell (step G4: No), the CPU
In step 11, the data registered in the cell group indicated by the input data is registered in association with the designated cell (step G6), and the expanded display processing for changing the size of the cell is performed (step G7).

Then, the CPU 11 displays the table data stored in the table data area 22 on the display unit 13 (step G8), and subsequently, when the user inputs to end the nesting process (step G9: Yes), CPU1
1 ends the process. When it is input that the processing is not to be ended (step G9: No), the CPU 11 executes other processing.

As described above, in the nesting process executed in the table processing device 1 according to the seventh embodiment, the data to be registered in a cell includes a range of another cell, for example, data including column numbers of different columns. When input by the user, the CPU 11 registers the same data as the data registered in the cell group indicated by the input data. Also, CP
When registering data in the cell, U11 processes whether to display the column number or the data registered in the column of the column number according to the user's instruction.

As a result, nesting processing can be realized in a table in which a plurality of data are registered in one cell, and complicated data processing can be performed.

[Eighth Embodiment] Referring to FIGS. 26 to 39, table processing apparatus 1 according to an eighth embodiment of the present invention.
Will be described.

FIG. 26A is a diagram showing table data displayed on the display unit 13, and FIG. 26B is a diagram showing FIG.
Of the table data shown in (a), the processing result (hereinafter referred to as “information”) when the statistical processing (see FIG. 30) is performed on the data registered in List1.
It is the figure which showed. The processing result shown in FIG. 26B is stored in the statistical calculation data area 25.

26 (a) and 26 (b) show the display unit 1 at the same time.
3 is not displayed, but is switched and displayed according to a screen switching instruction from the user. In addition to switching and displaying the two screens in this manner, a method of correlating data with each other and displaying the data on one screen will be described.

In FIG. 27A, an information column is created in the column next to List1 in the table data shown in FIG. 26A, and the result of the statistical processing matches with the data registered in List1. FIG. 7 is a diagram showing items of calculation results registered and displayed in a cell that is in the same row as the data and is a column of information.

Referring to the result of the statistical processing of FIG. 26B, since minX = 1, the item “minX” is registered in the cell adjacent to the first registered “1” of List1. . Further, from maxX = 7, 4 in List1
The item next to the 7th registered “7” is “ma”.
xX ”is registered. The correspondence relationship between the data in the table data and the statistical calculation items is stored in the information table 26. The information table 26 is shown in FIG.
This will be described in detail later with reference to FIG.

Further, FIG. 27B is a diagram in the case where the information column is hidden, and at this time, information regarding the statistical processing of List1 is displayed in the information table 2.
In order to show that it is stored in No. 6, "Li
A mark 271 is displayed on the left side of "st1".

FIG. 28 shows the information table 2
It is a figure showing the data structure of No. 6. The information table 26 is set in the statistical processing described later,
The vertical direction is the target data for statistical processing (List1 in FIG. 26A), and the horizontal direction is the item (information) obtained by the statistical processing. For example, in FIG.
Referring to (b), from the result of statistical processing, minX = 1
Therefore, a flag is set in an area where "1" in the vertical direction and "minX" in the horizontal direction of the information table 26 intersect. In the figure, a circle indicates that the flag is set.

FIG. 29 is a flow chart for explaining the operation of the statistical result display process executed by the table processing device 1. First, the CPU 11 substitutes the column number of the column for which the statistical processing is performed into the variable A (step H1) and performs the statistical processing (step H2). Then, the user selects a mode regarding the result display or the display setting (step H).
3). The CPU 11 displays or hides the information (step H4), the identification display process (step H5), and the approximate value display process (step H) according to the mode input by the user.
6), one of the multiple information display process (step H7) and the priority order information setting process (step H8) is executed.

Subsequently, when the user inputs that another display process is to be performed (step H9: Yes), the CPU
11 shifts the processing to step H3. When it is input that no other display processing is performed (step H9: No), C
The PU 11 determines whether to end the process (step H1).
0). When the input is made when the processing ends (step H1
0: Yes), the CPU 11 ends the process. When it is input that the processing is not to be ended (step H10: No), the CPU
11 executes other processing.

FIG. 30 is a flow chart for explaining the operation of the statistical processing executed by the table processing device 1. First, the CPU 11 executes the statistical processing on the column A according to the statistical processing program stored in the ROM 16 in advance (step J1). Then, the CPU 11 stores the calculation result in the statistical calculation data area 25.

Next, the CPU 11 substitutes 1 into the variable n (step J2), and compares the data registered in the nth cell of the column A with the calculation result stored in the statistical calculation data area 25. (Step J3). If there is no calculation result that matches the data registered in the n-th cell in column A (step J3: mismatch), the CPU 11 advances the process to step J5. If there is a calculation result that matches the data registered in the nth cell of column A (step J3: match), the data registered in the nth cell of column A in the information table 26 and the processing result A flag is set in the area corresponding to the item (step J4), and 1 is added to the variable n (step J5).

Subsequently, the CPU 11 determines whether or not data is registered in the nth cell in the column A (step J
6). If the data is registered (step J6:
Yes), the CPU 11 shifts the processing to step J3. If the data is not registered (step J6: none), C
The PU 11 ends the statistical processing.

As described above, in the statistical processing executed in the table processing device 1, the CPU 11 executes the statistical calculation on the data registered in the processing designated column, and the calculated result is displayed in the statistical calculation data area 25. Remember. And CP
U11 compares the data registered in the column designated for processing with the calculation result, and if there is matching data, sets a flag in the corresponding area of the information table 26.

FIG. 31 is a flow chart for explaining the operation of the information display / non-display processing executed by the table processing device 1. First, the CPU 11 determines whether or not to display the information of the statistical processing corresponding to the column A stored in the information table 26 based on the key input by the user (step K1). When displaying information (step K1: Yes), the CPU 11 inserts an information column into the column adjacent to the column A of the table data displayed on the display unit 13 (step K2), and stores it in the information table 26. Items are displayed in the information column according to the statistical processing information corresponding to the existing column A (step K3).

If no information is displayed (step K
1: No), the CPU 11 deletes the information column displayed next to the column A (step K4), and the information of the statistical processing corresponding to the data registered in the column A is stored in the information table 26. A mark is displayed in the column number column to indicate that the column number is present (step K5). Then, the CPU 11 ends the process.

As a result, as shown in FIG. 27A, the data to be statistically processed and the statistically processed result can be associated with each other and displayed on the display unit 13 at the same time. For this reason,
The user can visually recognize the result of the statistical processing in an easy-to-understand manner.

FIG. 32 is a diagram showing a display screen relating to the identification display processing of step H5 in the statistical result display processing of FIG. In the identification display process, as shown in FIG. 32, the shade and the color are set in advance corresponding to the items of the result of the statistical processing, and among the data that is the target of the statistical processing, data that matches the result of the statistical processing and This is a process of applying setting contents to a cell in which the data is registered and displaying it.

For example, when the item minX is set by hatching, referring to the result of the statistical processing of FIG. 26 (b), the first cell of “1” registered in List1 of FIG. 32 is It is displayed as shaded. Also, item m
If axX is set with polka dots, List1
The cell of "7" registered in the 4th of is displayed by dot meshing.

FIG. 33 is a flow chart for explaining the operation of the identification display processing executed by the table processing device 1. The CPU 11 color-displays the data of the column A displayed on the display unit 13 based on the information of the result of the statistical processing corresponding to the column A stored in the information table 26 (step M1). Here, the shading, the character color, etc. are set in advance corresponding to each information. Then, the CPU 11 ends the process.

As described above, according to the identification display process, the data that matches the result of the statistical process is identified and displayed, so that the data can be displayed visually easily.

FIG. 34 is a diagram showing a display screen relating to the approximate value display processing of step H6 in the statistical result display processing of FIG. As shown in FIG. 34, the approximate value display process is a process of displaying the data that is the target of the statistical processing by associating the items of the statistical processing with the data that is close to the result of the statistical processing.

For example, referring to the result of the statistical processing of FIG. 26B, xσ _n-1 is 2.16024689, but there is no matching data in the data registered in List1 of FIG. Therefore, since the sixth “2” of the data registered in List1 is the closest to the value of xσ _n−1 , the CPU 11 sets “2” in the table data area 22.
“Xσ _n−1 ” is registered in the cell next to, and is displayed on the display unit 13, and a mark 341 for indicating an approximate value is displayed together with “xσ _n−1 ”.

FIG. 35 is a flow chart for explaining the operation of the approximate value display processing executed by the table processing device 1. First, the CPU 11 uses the information table 2
Among the information of the result of the statistical processing corresponding to the column A of No. 6, the data closest to the calculation result of the item having no flag is searched from the data registered in the column A (step N1). If the flag is set for all the items, or if the data close to the calculation result of the item for which the flag is not set does not exist in the column A (step N1: none), the CPU
11 ends the process.

When there is data close to the calculation result of the item for which the flag is not set in the column A (step N1:
Yes, the CPU 11 sets a flag indicating an approximate value in the corresponding area of the information table 26 (step N2). Subsequently, the CPU 11 inserts an information column into the column adjacent to the column A (step N3),
Mark information with a flag indicating that it is an approximate value 3
And 41 (step N4). And CPU1
1 ends the process.

As described above, according to the approximate value display processing, the data which is the object of the statistical processing is further displayed by associating it with the items that are similar to the result of the statistical processing and the similar items. More information can be provided about the results of statistical processing.

FIG. 36 is a diagram showing a display screen relating to the plural information display processing of step H7 in the statistical result display processing of FIG. As shown in FIG. 36, in the multiple information display process, in addition to the display of FIG. 27A, when one data subject to the statistical processing matches the results of the multiple statistical processing, the CPU 11 registers the data. In this process, a plurality of items are registered as integrated data in the adjacent cell, and a mark 361 is displayed to the right of the item to indicate that a plurality of calculation results are registered.

Referring to the result of the statistical processing of FIG. 26B, the values of xσ _n , Q1 and Mod are “2”, and when xσ _n−1 which is an approximate value is included, a total of four items are “2”. 2 ”. Therefore, four items of xσ _n , Q1, Mod, and xσ _n-1 are registered in the cell next to the sixth “2” of List1, and the cell displayed on the display unit 13 has 1
The item registered at the beginning of the number is displayed together with the mark 361. Further, the CPU 11 sequentially displays other values by the user's key operation from the input unit 12.

FIG. 37 is a flow chart for explaining the operation of the multiple information display process executed by the table processing device 1. First, the CPU 11 inserts an information column into the column next to the column A (step P1), reads the information of the result of the statistical processing corresponding to the data registered in the column A from the information table 26, and reads the information column. (Step P2). Also CPU
11 displays the mark 361 for the cell in which the integrated data is registered among the cells in the information column (step P3), and ends the processing.

Thus, according to the multiple information display processing,
When there are a plurality of results that match the data to be statistically processed, a plurality of items can be registered as integrated data in the cell to display more information regarding the statistical processing.

FIG. 38 is a diagram showing a display screen relating to the priority order information setting process of step H8 in the statistical result display process of FIG. The priority information setting process is shown in FIG.
As shown in FIG. 36, a screen for setting the display order when a plurality of items are registered in one cell is displayed as shown in FIG. The priority is set for each item by the user, and 1
When a plurality of items are registered in one cell as integrated data, the CPU 11 displays them according to the set priority.

FIG. 39 is a flow chart for explaining the operation of the priority order information display process executed by the table processing device 1. First, the CPU 11 inserts an information column into the column adjacent to the column A (step Q1), reads the information of the result of the statistical processing corresponding to the data registered in the column A from the information table 26, and reads the information column. (Step Q2).

Next, the CPU 11 displays on the display unit 13 a screen for setting the priority order for displaying information. When the priority is set by the user (step Q
3) The CPU 11 rearranges the information on the cells in which the integrated data is registered based on the set priority, and further displays a mark 361 indicating that the integrated data is registered in the cell (step Q4). ), The processing ends.

As described above, according to the priority order information setting process, the user sets the display order of the data for the cell in which the integrated data is registered, so that the environment that is easy for the user to use can be set.

By using the table processing device 1 as described above,
Since a plurality of data can be registered as integrated data in one cell, it is possible to easily input matrix data and the like, which were difficult to process by the conventional method, and to display the data in a more understandable manner. Further, by dividing the integrated data into individual cells and registering them, it is possible to execute processing such as regression calculation and graph drawing. Further, by data input by the nesting process, data registered in other rows or columns can be designated and registered in one cell. Even if the integrated data is registered in one cell by the sorting process, the sorting can be easily performed. At that time, it is possible to select either a sort to be executed for each cell or a sort in which the order of the cells is further exchanged, and the user can execute a desired sort process. Further, since the related information on the data registered in the cell can be registered in another cell in correspondence with the data, the related information on the data can be displayed in an easy-to-understand manner.

[0178]

According to the invention described in claims 1 and 13, 1
You can enter multiple data for one cell,
The plurality of data are handled as one piece of data as integrated data. Therefore, it is possible to realize a table processing device that enables registration of a plurality of data while following the conventional method in which only one data can be registered in each cell.

According to the second aspect of the invention, even when displaying integrated data in which a plurality of data are integrated,
The size of the cell in which the integrated data is registered is automatically changed. Therefore, the integrated data can be displayed in an easy-to-see manner.

According to the third aspect of the present invention, it is possible to divide each of the plurality of data integrated in the integrated data into individual cells and reconstruct the table. At that time, a cell for distributing the data is inserted in the vertical direction or the horizontal direction with reference to the cell in which the integrated data is registered. Therefore, it is possible to improve the visibility of whether the data is the integrated data before and after the data is sorted.

According to the invention described in claim 4, the data registered in a plurality of cells are integrated as integrated data, and 1
You can re-register in one cell. Of course, the cell designated by the designating means is not limited to one in which one data is registered, but may be a cell in which integrated data is registered.

According to the invention of claim 5, for example, n
The cell in the column is designated as a cell for designation by the designation means, and this n
The cells to be integrated can be designated depending on whether or not the data registered in the cells in the column are the same (for example, the same “1” is registered).

According to the invention of claim 6, for example, m
It is possible to specify all the cells in the row or to specify a desired range from the cells arranged vertically and horizontally in the table.

According to the invention described in claim 7, the order of the integrated data can be changed.

According to the invention described in claim 8, it is possible to sort cells in units of cells.

According to the invention described in claim 9, for example, when the first cell group is set to the value of the variable X and the second cell group is set to the value of the variable Y, statistical calculation or a statistical graph is created. It becomes possible.

According to the invention of claim 10, for example,
When the calculation means performs statistical processing on the first cell group and calculates information such as the maximum value cell or the minimum value cell as the related information, the display such as which cell data has the maximum value is visually displayed. You can make it easier to understand.

Further, in this case, in order to further improve the visibility, as in the invention described in claim 11, there is further provided an identification display means for identifying and displaying the cell associated with the related information according to the related information. You may comprise so that it may be equipped.

According to the twelfth aspect of the present invention, even when a plurality of related information is associated with one cell, it can be displayed without any problem.

[Brief description of drawings]

FIG. 1 is a circuit configuration diagram of a table processing device 1.

FIG. 2 is a diagram showing a data configuration of a RAM.

FIG. 3 is a diagram showing a data structure of a table data area.

FIG. 4 is a diagram showing a table displayed on a display unit and input keys operated when a data input process is executed.

FIG. 5 is a diagram showing a table displayed on a display unit and an input key operated when a data input process is executed.

FIG. 6 is a diagram showing a method of displaying a table when integrated data is registered in one cell.

FIG. 7 is a flowchart illustrating an operation of data input processing.

FIG. 8 is a diagram showing the contents displayed on the display unit and the input keys operated when the formula input process is executed.

FIG. 9 is a diagram showing the contents displayed on the display unit and the input keys operated when the formula input process is executed.

FIG. 10 is a flowchart illustrating an operation of a formula input process.

FIG. 11 is a diagram showing the contents displayed on the display unit and the processing result when the cell correspondence processing is executed.

FIG. 12 is a flowchart illustrating an operation of cell correspondence processing.

FIG. 13 is a flowchart for explaining the operation of cell correspondence processing, which follows FIG. 12;

FIG. 14 is a diagram showing the contents displayed on the display unit and the processing result when the plural-to-singular conversion process is executed.

FIG. 15 is a flowchart illustrating the operation of plural-to-singular conversion processing.

FIG. 16 is a diagram showing the contents displayed on the display unit and the processing result when the singular → plurality conversion processing is executed.

FIG. 17 is a flowchart illustrating the operation of single-to-plural conversion processing.

FIG. 18 is a diagram showing the contents displayed on the display unit and the processing result when the sorting process is executed.

FIG. 19 is a flowchart illustrating the operation of sorting processing.

FIG. 20 is a flowchart illustrating an operation of a sorting process subsequent to FIG. 19;

FIG. 21 is a diagram showing the contents displayed on the display unit and the processing result when the nesting process is executed.

FIG. 22 is a diagram showing the contents displayed on the display unit and the processing result when the nesting process is executed.

FIG. 23 is a diagram showing the contents displayed on the display unit and the processing result when the nesting process is executed.

FIG. 24 is a diagram showing the contents displayed on the display unit and the processing result when the nesting process is executed.

FIG. 25 is a flowchart illustrating the operation of nesting processing.

FIG. 26 is a diagram showing table data stored in a table data area and data stored in a statistical result data area.

FIG. 27 is a diagram showing a processing result displayed on the display unit when information display / non-display processing is executed.

FIG. 28 is a diagram showing a data structure of an information table 26.

FIG. 29 is a flowchart illustrating the operation of statistical result display processing.

FIG. 30 is a flowchart illustrating an operation of statistical processing.

FIG. 31 is a flowchart illustrating the operation of information display / non-display processing executed by the table processing device.

FIG. 32 is a diagram showing a processing result displayed on the display unit when the identification display processing is executed.

FIG. 33 is a flowchart illustrating the operation of identification display processing.

FIG. 34 is a diagram showing a processing result displayed on the display unit when the approximate value display processing is executed.

FIG. 35 is a flowchart illustrating an operation of approximate value processing.

FIG. 36 is a diagram showing a processing result displayed on the display unit when the multiple information display processing is executed.

FIG. 37 is a flowchart illustrating the operation of multiple information display processing.

FIG. 38 is a diagram showing a processing result displayed on the display unit when the priority information setting display processing is executed.

FIG. 39 is a flowchart illustrating the operation of priority order information setting processing.

[Explanation of symbols]

1 Table processing device 11 CPU 12 Input section 13 Display 14 Communication control unit 15 RAM 21 Work data area 22 Table data area 23 Regression calculation data area 24 Graph drawing data area 25 Statistical calculation data area 26 Information table 16 ROM 17 External storage device 18 storage media

Claims (13)

[Claims] 1. A table processing apparatus that registers data in each cell constituting a table by arranging a plurality of rows and columns and performs a given operation based on the registered data, and inputs the data to be registered in each cell. An input means for determining, a determination means for determining whether or not the data input to the cell by the input means is plural, and when the determination means determines that the data is plural,
A table processing device comprising: a storage unit that stores the plurality of data items into one integrated data item and stores the integrated data item in association with the cell item. 2. The table processing device according to claim 1, wherein a table in which the data stored in said storage means is displayed in each corresponding cell is displayed, and when the data is integrated data, A table processing apparatus further comprising display means for automatically changing and displaying the size of a corresponding cell. 3. The table processing device according to claim 1, wherein when the storage unit stores integrated data, a cell is inserted from a cell corresponding to the integrated data in a vertical direction or a horizontal direction. While changing the configuration arrangement of, each of the multiple data integrated in the integrated data,
A table processing apparatus further comprising a first updating unit for updating the storage content of the storage unit so as to store the inserted cells in association with each other. 4. The table processing device according to claim 1, wherein the storage means stores the data registered in each of the plurality of cells designated by the designation means and the designation means for designating a plurality of cells. A second updating unit for reading the data from the storage unit, integrating the integrated data as integrated data, and updating the stored content of the storage unit so as to store the integrated data in association with one of the designated cells. A table processing apparatus further comprising: 5. The table processing device according to claim 4, wherein the designating unit designates a plurality of cells based on the data registered in the cells. 6. The table processing apparatus according to claim 4, wherein the designating unit designates a plurality of cells by designating a range of cells connected in the vertical direction and / or the horizontal direction. apparatus. 7. The table processing device according to claim 1, wherein when the storage unit stores integrated data, a sort for sorting the order of a plurality of data integrated in the integrated data. A table processing device further comprising means. 8. The table processing device according to claim 7, wherein the sorting means further changes the arrangement position of each cell based on the data registered in each cell.
When the data is integrated data, the table processing device is characterized in that the arrangement position is changed based on the data of a predetermined rank among the integrated plurality of data. 9. The table processing apparatus according to claim 1, wherein a first cell group designating means for designating a first cell group and integrated data, if the integrated data, are integrated into the integrated data. Second cell group designating means for designating a second cell group in which the same number of data as the number of data registered in each cell of the first cell group is counted by counting the number of existing data. A table processing device further comprising: and an executing unit that executes a given process by associating each data of the first cell group with each data of the second cell group. 10. The table processing device according to claim 9, wherein the first cell group includes a calculating unit that calculates the related information of the first cell group for each cell included in the first cell group. When displaying, related information display means for displaying the related information of each cell included in the first cell group calculated by the calculating means in association with the corresponding cell, further comprising: Table processing device. 11. The table processing apparatus according to claim 10, further comprising identification display means for identifying and displaying a cell associated with the related information in accordance with the related information. 12. The table processing apparatus according to claim 10, wherein when there are a plurality of related information for the cell, the related information display unit displays the plurality of related information in association with the cell. A table processing device characterized by: 13. A table processing apparatus that registers a plurality of data in each cell that is arranged vertically and horizontally to form a table and performs a given operation based on the registered data, and inputs the data to be registered in each cell. For determining whether the data input to the cell by the input means is one or more, and when the determination means determines that there is a plurality of data,
A program for causing a storage unit that integrates the plurality of data into one integrated data and stores the data in association with the cell.