JPS59202567A - Calculating processor of table data - Google Patents

Abstract

PURPOSE:To attain calculating processing automatically for various operations by discriminating the types of a ruled line sectioning table data so as to attain automatically the calculating processing such as a total or a grand total and provide the significance of multiplication and division to the ruled line. CONSTITUTION:A start point and an end point data are stored respectively to a start point pointer SPT and an end point pointer EPT by a light pen LTP via a display controller CRTC, the type of a straight line or a dual line or the like is decided by a signal from a type register SHR so as to draw to lines. A ruled line discriminating section KHT stores the data of the lines to a row line information register CHR and a column line information register LHR. The operations above are repeated for plural number of times and when the forming of a table is finished, an item data is stored to an item register KMG and a display memory HM displaying color from a key input section KEY. A calculation control section SCT corresponds the data in the register KMG to the data in the registers CHR, LHR by using a control section CCT so as to attain required calculation such as a total and a grand total.

Description

DETAILED DESCRIPTION OF THE INVENTION [Technical Field of the Invention] The present invention relates to a table data calculation processing device, and more particularly to a table data calculation processing device that performs calculation processing in the vertical and horizontal directions of table data displayed in a matrix.

[Prior art]

Conventionally, matrix display aggregation is often used for computer processing in the sales cycle.

For example, regarding sales, the type of product name, month, week, etc. are displayed separately in the horizontal and vertical directions, and the respective tabulations are performed and displayed in the horizontal and vertical directions. Further, an operation of multiplying a specific unit price by the number of pieces, that is, multiplication, is performed horizontally and vertically and displayed at a specific position. This kind of display has the characteristic that it is easy to see monthly sales by product name, etc., and annual sales.

2. Not only in accounting, but also in office calculations, matrix summary tables are often used to evaluate and calculate the interrelationships between items, departments, etc.

On the other hand, calculations performed using these summary tables include subtotals, additions and subtractions such as totals, multiplication to find the total from the vehicle price and number of pieces, and four arithmetic operations such as multiplication to find the average unit price from the total and number of pieces. I need.

Calculation of data displayed in a matrix as described above can be roughly divided into two methods.

The first method is COBOL, FORTRAN, BA
Using a high-level language such as STC, the user creates a program according to the purpose, and uses that program to calculate tabulations and item data in the vertical and horizontal directions.

The second method is to tabulate using a programless language.
Using data displayed in a matrix, vertical direction,
Calculations in the horizontal direction are performed using a roughly defined calculation formula. This method is programless, but as described above, calculations in the vertical and horizontal directions are defined and used.

[Problems with conventional technology]

The calculation methods for data displayed in a matrix as described above each have the following drawbacks. The first method requires the user to create a program for processing, and the number of people who can use it is limited. That is, C0
Only those who could create programs such as BOL, FORTRAN, and RASIC could perform such calculations. Moreover, creating such a program required a great deal of time and effort. The second method does not require creating a program as described above, so it can be used by anyone, but it requires defining horizontal and vertical calculations for aggregation, so it is not programless. In the end, I had to put together a program.

This definition differs from that of general high-level languages, and the method of definition varies depending on the device used. Therefore, the user had to refer to the manual for each definition method, and could not use it as easily as with an abacus or the like.

[Purpose of the invention]

The present invention is intended to solve the above-mentioned problems, and its purpose is to calculate vertical and horizontal subtotals, totals for one intermediate needle, etc. in a matrix summary table, as well as totals (multiplication) from unit price and number of pieces. To provide a spreadsheet data calculation processing device that can easily perform spreadsheet calculations without creating a program for calculation formulas or defining calculation formulas for performing four arithmetic operations such as average unit price (division) from the total and number of pieces.

[Summary of the Invention] The present invention is characterized in that an apparatus for calculating tabular data in at least one direction, horizontal or vertical, includes:
Generally, when drawing a table, regular single lines are used to separate items, but when it comes to dividing subtotals or totals, special rules such as double lines or thick lines or rules of different colors may be used. By focusing on the table data and determining the types of borders that separate table data, it is possible to automatically calculate subtotals, totals, etc. by simply drawing borders, without having to define subtotals or totals. Located in the data calculation processing device. A further feature of the present invention is that the ruled lines have the meaning of multiplication, division, etc., and the spreadsheet data calculation processing device can automatically perform calculations such as multiplication and division just by drawing the ruled lines. be.

[Embodiments of the invention]

Hereinafter, the present invention will be explained in detail using the drawings.

FIG. 1 (al shows a first display example in the apparatus of the present invention.

Products a to d indicate, for example, the names of the products that have arrived.

The unit price P indicates the general unit price of the received product, and the quantity N indicates the number of the received product. And the amount PE
indicates the total amount at that time, that is, the value obtained by multiplying the unit price P by the quantity. For example, if it is product a, the amount PE of product a
is 1500×5, so it becomes 7500. The loss rate indicates, for example, a percentage of the above-mentioned amount, and the actual amount is the result of multiplying the amount PE by the loss rate. Ruled line 11, which is one straight line! o is simply a line separating them.

Ruled line x+ is two lines: a straight line and a dashed dotted line.

12 is a line that means multiplication, and in Figure 1 (Al, only the horizontal direction is shown, but the data immediately before the horizontal or vertical direction of the two lines, a single straight line and a dashed dotted line, and the data immediately before that) Indicates that the data from one row or column before is multiplied and the result is placed immediately after that line, that is, in the right column or lower row.In other words, as mentioned above, for example, in the case of ruled line l!1, each product a~ The result of multiplying the unit price P of d by the quantity N is included in the amount PE.Similarly, in the case of ruled line 12, the amount P
The result of multiplying E by the loss rate M is the real amount RP.

The two straight lines ρ3 indicate whether the lower row or right column of the straight line is a subtotal or a total. That is, the cumulative total of J@price P, amount PE, and real amount RP of products a to d is included in the total T. Note that the total quantity and loss rate have no meaning, so they are left blank.

FIG. 1 (bl shows a second display example in the device of the present invention. Product names al+-24, b, , b, , C1 to C3 indicate product names of a sales book, for example. Subtotals a, b.

C is the subtotal of product name a+-a4 and product name b+, respectively.

Subtotal of b2, product name C [-Shows subtotal of C3. The total d indicates the sum of subtotals a, b, and c. A shown in the top row
-F is a classification such as month and day, and G indicates the total for the month and day. The ruled line M++ is a line that separates each item on the matrix table vertically and horizontally. The two-line text 12 is a line in which the lower row or right column indicates a subtotal or total.

The present invention performs the aggregation process using the above-mentioned ruled line information, and in the case of FIG. 1(a), two lines or one line are used. Also, detect 2, multiply the immediately previous data in the horizontal or vertical direction by the data one row or one column before the previous data, and output the result immediately after that line, that is, in the right column or lower column. I will do it.

Two more lines and 3. +2+2 (Fig. 1(b)) is detected, and each subtotal in the row direction or column direction is divided into two lines or 3. Also, the summaries are output to the right column or lower row of I2. Furthermore, if there are two connected lines, the lower row displays the total.

FIG. 2 shows a first embodiment of the invention. The control unit OCT includes a key input unit KEY, a ruled line creation unit KST, and a ruled line discrimination unit KH.
T. Display control unit CRTC.

Calculation control unit SCT controls item register KMG.

The key human power is permitted by the control unit OCT, and the key human power unit K
Ruled line data is output from EY and stored in type register SHH. Further, a command signal, that is, a control signal necessary for creating ruled lines, is outputted to the control unit OCT by the key human power unit KEY. This signal is output when the operator presses the KEY. This signal causes the control unit CCT to
controls the display control unit CRTC.

When the key at the starting point of the ruled line is pressed, the control unit CCT receives the signal and controls the display control unit CRTC.
is controlled to read the pointer indicated by the light pen LTP, and the result is stored in the starting point pointer. Similarly, when the end point key is pressed, the control unit O
The CT controls the display control unit CRTC, causes it to read the pointer indicated by the light pen LTP, and causes the result to be stored in the end point pointer. With these two inputs, the respective pointers of the start point and end point are changed to the start point pointer SPT,
It is stored in the end point pointer EPT.

The result of the above-mentioned pointer is input to the ruled line creation section KST and the ruled line discrimination section KHT. The ruled line creation section KST connects the points indicated by the pointers SPT and EPT with ruled line data, such as a straight line or various types of double lines, and stores the data in the display memory HM.

The ruled line creation section KST outputs a completion signal to the control section OCT every time the display between each pointer is completed.

In addition, you can specify whether the two straight lines are a straight line or two dotted lines, for example, a straight line or a one-dot chain line, using the type register SHR.
determined by the signal input from The signal of the type register SHR is also input to the ruled line discrimination section KHT.

The ruled line discrimination unit KHT creates each data of row line information 2 column line information from the data obtained from the start point pointer SPT and the end point pointer EPT and the data obtained from the type register SHR, and writes the row line information register CHR and the column line information register LHR
and outputs a completion signal to the control unit OCT. Each process in the ruled line creation unit KST and ruled line determination unit KHT described above is performed every time a start point pointer and an end point pointer are specified. That is, it is performed multiple times in each row and column direction.

When all table creation is completed, item data is output from the key manual section KEY and taken into the item register KMG under the control of the control section CCT. This is the number of rows x number of columns of the matrix made up of all the data or displays. However, unnecessary numerical data etc. may not be input.

Note that the item data stored in the item register KMG is stored in the display memory HM almost at the same time as being stored. Display memory is 3-color memory H: red, green, and blue.
It has M-R, HM-G, and HM-B, respectively, and has a function of displaying a plurality of colors. In the calculation control unit SCT, the data stored in the item register KMG and the row line information and column line information stored in the row line information register CHR1 and the column line information register LHH are calculated by the control start signal sent from the control unit OCT. Read out the corresponding data and perform the necessary calculations. If the calculation is a subtotal or total, the subtotal register STR and total register GTR are used to perform the subtotal and total in the column and row directions. The results are stored in the item register KMG on a row-by-row and column-by-column basis, as well as in the display memory HM. When all calculation operations are completed, a completion signal is output from the calculation control unit SCT to the control unit OCT. The small hand and summation operations are performed using an address register provided inside the calculation control unit SCT.

The display section CRT is a device that displays data stored in the display memory, and is also used to detect the position indicated by the light pen LTP. These displays and detections are performed by the display control unit CRTC.

FIG. 3(a) shows an example of 8-bit line type data in the type register SHR. Bits b6 to b4 are bits indicating the display color of the line, and red, green, and blue correspond to each bit. In the embodiment of the present invention, since each bit has a binary value, it is possible to display a total of seven colors including white.

Further, bits b3 to bo are line shape bits. When this data is '1000'(" indicates binary), there is one straight line.

'1001' has two straight lines, '0010' has a broken line, '1010' has two straight lines and a broken line, “
0011' is a one-dot chain line, ``1011' is a straight line and a one-dot chain line, and ``0100'' is a two-dot chain line.

'1100'' Two lines: straight line and two-dot chain line, 0101'
``At 1101°, two lines, a straight line and a wavy line,
"0110" is indicated by a thick line.This data is generated from the key input unit KEY and stored in the type register SHR in units of 8 bits.

FIG. 3 (bl, (CI is the line information register CHR in the first display example of the apparatus of the present invention shown in FIG. 1 (al).

Each processing result data of the column line information register LHH is shown. α is character data, D is numerical data.

X is a symbol indicating multiplication result data, and GT is a symbol indicating total data. Symbols corresponding to the row and column directions are encoded and stored in the aforementioned row line information register CHR and column line information disk LHR. .

FIG. 3 fdl, (el, (fl is the row line information register C in the display column of the device of the present invention shown in FIG. 1 (bl)
HR1 column line information and register LHR1 item register KMG data showing the respective processing results. Figure 3(d).

α in te+ is character data, D is numerical data, ST
is a symbol indicating subtotal data, and GT is a symbol indicating total data. The symbols arranged in the matrix direction are encoded and stored in the aforementioned row line information register CHR5 and column line information register LHR.

Before the item data is input, there are only numerical data D, multiplication data X, subtotal data ST, and total data GT, and there is no instruction for character data α. This is because only the results of the input of ruled lines have been input, and no item data has been input.

In other words, from each ruled line 4J in FIG. This is because only the subtotal data ST and the total data GT can be discriminated, and the numerical data D and the character data α cannot be discriminated.

The character data α can be determined when the item data is input to the item register KMG shown in FIG. 3 (fl), and at this time the numerical data D is converted to character data.

If no character data is input, all item data becomes numerical data and is subject to aggregation.

Figure 3 (gl is row line information @ (column line information is also in the same format)
This shows another example of storing . The ruled line data K is inserted into the row line information, and the ruled line data includes data indicating that the points sandwiched by other ruled line data K are character data or numerical data. In this case, the subtotal data ST is treated in the same way as ruled lines. For example, Figure 3 (g
Subtotal data ST exists between numerical data D in l, indicating that the next item is a subtotal.

FIG. 4 shows a second embodiment of the invention. The operation is similar to that of the first embodiment, but the processing is performed by the processor CPU.

The ruled line discrimination section KHP and the ruled line generation section KSP are constructed of memories in which programs for performing respective processes, that is, a ruled line discrimination process and a ruled line generation process, are stored. The ruled line discriminator KHP includes a type register SHR.

The read-only memory ROM stores processing programs other than the ruled line creation processing and ruled line discrimination processing (such as total processing) and other processing programs not directly related to the present invention.

The display memory CRTM is a memory in which a display to be displayed on the display device CRT is stored, and has memories for storing three colors, red, green, and blue, respectively. Display control unit CRTC is Light Pen LT
Processes data obtained from P and controls display memory.

The key manual section KEY is an input device through which an operator inputs control commands and item data, and has input keys. The memory RAM is a random access memory and is used as a work area when executing each process. For example, the stack area of the processor CPU is also allocated to its memory RAM.

Item register I (MG, row line information register CHR1 column line information register LHR, start point boiling SPT.

The end point pointer EPT, subtotal register STR, and total register CTR correspond to the registers of the first embodiment of the present invention described above, and are composed of random access memories. The above-mentioned ruled line discrimination unit KHP and ruled line creation unit KS
P, memory ROM, display memory CRTM, display control device CRTC, key human power section KEY, memory RA
M, each register KMG, CHR, L) IR, SPT, E
P.T.

STR and GTR are connected to the hash line B of the processor CPtJ.

The second embodiment of the invention shown in FIG. 4 performs the same processing as the first embodiment of the invention shown in FIG.

5 to 8 show the above-mentioned first embodiment of the present invention. Each processing flow of the second example is shown.

FIG. 5 is a processing flow for displaying line lines and creating line information. The type of row line, that is, the type of ruled line is the key to human power department K.
Input from EY and set (Se). Next, the starting point of the ruled line is input using the light pen LTP (S2), and the starting point pointer (xl, y+) is determined (S3). The result is stored in the starting point pointer SPT (S3). Similarly, it is input from the end point by the light pen LTP (S4),
The end point pointer (X2.y2) is determined (S5).

At this point, the type of ruled line and the starting point of the ruled line,
Each pointer of the end point (x+, y+).

(X2.)+2) is determined, the ruled line creation unit KSP is executed (Se) and displayed on the display device CRT (S7
)do. Next, a line area for item data is secured (Se). Securing rows and areas (Se) is a process of securing a usage location of the item register KMG corresponding to the number of rows. This process is not necessary if the number of rows is predetermined. Next, in the same way as the execution (Se) of the ruled line creation part described above, the type of ruled line and the pointers (x
+, y+), (X2, 1 y2) is used to execute the ruled line determination unit KHP (Se) to obtain line information and store the data in the line information register CHH. This process is repeated for the corresponding number of rows. Whether or not this process is finished is determined by the completion determination (SIo). When the process shown in FIG. 5 is completed, the line information register CHR stores line number information as shown in ta+ and fcl in FIG.

Column line information is also obtained in the same manner as the processing flow shown in FIG. 5 described above. The 3rd page is displayed after the processing of column information is completed.
The column line information shown in the figure (bl, (dl) is stored in the column line information register LHH. Furthermore, the display device C
A matrix chart is displayed on RT.

Figure 6 shows ruled line discrimination K in the processing flow shown in Figure 5 above.
This is a processing flow showing HP execution (Se) in more detail.

First, it is determined whether the ruled line is a straight line (Ql). If Y is a straight line, it is assumed that the ruled line is numerical or character data, and numerical data D is stored or set (S++) in the row line information register CHR (column line information register LHR in the case of column line information processing). If it is not a straight line (N
), then it is determined whether there are two straight lines (Q2). If there are not two straight lines, it is determined whether N' is a straight line or a chain line. If there are two lines, a straight line and a dashed-dotted line (
For Y"'), set multiplication data X in the row line information register CHR (column line information register LHR in case of column line information processing) (S13). If the line is not a straight line and a dashed-dotted line (N"') performs other processing, such as error processing for input errors. If there are two straight lines (Y'), determine whether the previous ruled line was two straight lines (Q3) L
, if there are no two straight lines (N''), subtotal data ST
If there are two straight lines (Y”), the total data GT
is stored in the row line information register CHR (in the case of column line information processing, the register LHR) (Se 2.Sep), and the process ends. The aforementioned multiplication data , 312.
Sζ2゜513) means setting flags X, D, ST, and GT in the line information register corresponding to each item data. Judgment of ruled lines Ql, Q2. Q3 and Q4 are determinations for all line shapes, but as shown in parentheses in FIG. 6, when the types of ruled lines are classified by color, color determination is performed. FIG. 7 shows a processing flow for inputting item data. This process is executed after the row lines shown in FIG. 5 are displayed, the process for creating row line information and the column lines are completed, and the creation of column line information is completed.

First, item data is input from the key personnel department (Se 4). Next, the data is input to the item register (S15). Furthermore, it is determined whether the data is an alpha character, that is, character data (S16). This determination (S16)
If it is character data, the numerical data D at the position of the corresponding row line information register CHR1 column line information register LHR is rewritten to character data α (SI7>, set, ie, D) and the lag is set to the α flag. If it is not character data (N
) is numerical data, so the rewriting process (S
17) Jump. That is, rewriting processing (SI7)
Proceed to the next process without executing.

Next, it is determined whether the item data is finished (S18),
If the process is finished (Y), the input process is finished, and if the process is not finished (N), the process returns to the input process (S14) again and item data is input. The above process is repeated until all item data is input. Note that during the input process, depending on the item, the item data may not be required, but in that case, blank data or data such as zero is input.

FIG. 8 (al is the processing flow of the calculation explanation program of the calculation control unit SCT of the first embodiment and the processor of the second embodiment. This process is executed when all item data are input. In FIG. 8 (al to Fdl, the cross mark is a symbol indicating that the execution moves to the terminal (■).

When this process starts executing (fa+5TART in FIG. 8), first, line-by-line processing is performed. First, perform the initial settings. That is, the subtotal register STR and total register GTR are each cleared (Tl, T?). Clearing these registers (TI, T?) is the initial setting for performing a new row-by-row summation. Furthermore, the cents of the top address of row line information and the top address of column line information (T3.T4
)I do. The cents of these top addresses (T3°T a ) are the cents of the top addresses where input data for the processing to be performed from now on is stored. Initialization is completed by clearing the registers (TI, T2) and sending the top address (T3, T4).

Next, processing of subtotal 1 total in the row direction is performed. The line information is read (T, +)L, and it is determined whether the line information is character data α, subtotal data ST, or total data GT (T 6 , T 7 , T e ).

If even one of these determinations (T a, T 7. T e) is a match (Y), execution is moved to the processing terminal ■. If all of them are mismatched (N), that is, if they are data, then the column line information will be read)” (T9)
do. Even if the discrimination result processed earlier is data, if the column line information is character data α, there is no need to perform addition processing, so it is necessary to determine whether the column line information is character data α (Too). If there is a match (Y), execution is moved to the processing terminal ■. The above discrimination (Too) does not match (N
), it is either data, multiplication, or subtotal 2 total, so these are determined and the corresponding processing is performed. That is, first, it is determined whether the column line information is multiplication (Te
1) Do. If it is a multiplication (Y), the values are before and after the current column address LADR, i.e. (LADR+1), (
Determine whether LADR-1) is an item data area (T
I2) Do it. If it is outside the area, it is an error (ERR), so error processing (ERJOB) is executed. If it is within the area, it is normal (OK), so the current column address (
The contents of the item register KMG specified by the address (LADR-1) immediately before the column address (LADR) and the current column address (L
ADR), and the result is multiplied by the contents of the item register KMG specified by the current column address (ADR).
Store ('+3) in the item register KMG specified by LADR-1-1). Determine whether it is multiplication (T
++), if it is not multiplication (N), execution starts from terminal ■. That is, it is determined whether the column line information is the subtotal ST (Te4). Column line information is a subtotal (Y)
If so, the contents of the subtotal register STR are stored in the memory specified by the matrix address (Te5), and the subtotal register STR is further cleared (T22). If the column line information is not a subtotal, that is, if the determination (1'14) is a mismatch (N), then it is determined whether it is a total (T"+6). If this determination is a match (Y), the total register is The contents of are stored in the register specified by the matrix address (TI7), and the total register is cleared (Tlθ).If the column line information total determination (Te6) is a mismatch (N), it is data, so the matrix The contents of the register specified by the address are read (T19), added to the contents of the total register GT, and the result is stored in the total register GT (T2O). The read contents and the contents of the subtotal register ST are added and stored in the subtotal register ST (T21). Processing T18゜T
21. The column data address constant Zβ is added to the column line information address in the execution after the completion of the execution in T22 and in the execution from the terminal (2) (T23). A column data address constant is a constant that indicates a change in the address corresponding to the next column in the same row of specified item data. That is, if the row line information address and the column line information address specify the register storing the item data "'10" in the upper left corner of FIG. 1, the column data address constant 77! is assigned to the column line information address. After adding (T23), the register in which the item data "8pa" on the right side is stored is specified.

Next, it is determined whether the column line information has ended (T24). That is, it is determined whether or not processing in the row direction has been completed for one row. If it is not completed (N'), connect the terminal from terminal A to ■
Execute again from the return line information 1 node (T5).

If it has been completed (Y), the row data address constant Zc is added to the row line information address (T25), and the column line information top address is set (T26). Through these processes (T25, T26), the first column of the next row is designated by the matrix information address. Next, it is determined whether the line information has ended (T24). That is, it is determined whether all processing in each row direction has been completed. If the process is not completed, the above operation is repeated again. If the process is completed, the execution of the terminal (■) is started if the process is completed.

The processing from terminal ■ is aggregation processing in the column direction, and is almost the same as the processing in the row direction described above. Since the subtotal 1 total in the column direction has not yet been executed, the aggregation process in the row direction was executed excluding the subtotal row 1 total row. Since the processing in the column direction has been performed first, the aggregation processing is not performed only when the row line information and column line information are character data, and in other cases, it is performed in the column direction in the same manner as described above. First, clear the subtotal 2 total register (T2 e, T2 !l)
.

Row line 9 column line information top address cent (T2O.

T 31 ) is executed. This operation is the same as the initial setting (T+ to T a ) in the row direction. Next, read column line information and 1 row line information T32. T33), it is determined whether it is character data (T34, T35), and it is determined whether it is column line information or multiplication (T36).

If both are neither character data nor multiplication data, subtotal and total determination of line and line information is performed (T3?, T3B). Note that the subtotal and total of multipliers in the case of multiplied data have no meaning and are therefore excluded in this flowchart. Line information is subtotal data.

If it is not total data, read the contents of the register specified by the matrix address (T39), add it to the total register and store it in the total register (Ta).

), added to the subtotal register and stored in the subtotal register (T4
Perform the process i). If it is subtotal data, the contents of the subtotal register are stored in the item register specified by the matrix address (Ta+)L, and the subtotal register is cleared (Ta2). If it is total data, store the contents of the total register in the item register specified by the matrix address (Ta3)L
, clear the total register (T4a).

Since these processes are performed on a column-by-column basis, the row data address constant Zc is added to the row line information address (Taa)i,
Then, it is determined whether the - column has ended using the row line information address (Ta7). If the process has not been completed, the execution moves from the terminal tap to the terminal (2) and is executed again from the column line information read (T32).

- When the column processing is completed, add the column address constant ZX to the column line information address, and then perform the row line information top address cent (Ta9). Furthermore, it is determined whether or not the processing in the column line direction has been completed (T2O), and if it has not been completed, the processing is executed again from terminal (2). In case of termination (Y)
In this case, the execution of this process ends, assuming that all aggregation processes have been completed.

By the above-described operation, the multiplication subtotal 1 total data is displayed at the designated position.

FIG. 9 is a processing flow diagram in the ruled line creation units KST and KSP, and shows the process S6 shown in FIG. 5 in detail. That is, this is a process of generating data to be displayed on the display section CRT based on the input data of the line type, starting point, and ending point. First, it is determined whether the input X-axis coordinates match (R+). If they match (Y
), a process (R3) for calculating the difference between two points is executed.

If they do not match (N), it is determined whether the X-axis coordinates match (R2). If they do not match in this determination, other processing is executed as error processing. If they match (Y), process (R3) is executed. These two discrimination processes (R1, R2,) are for determining whether the line segment connecting the input start point and end point is tilted with respect to the X axis or the y axis.If it is not tilted, that is, the X axis Alternatively, when the line is parallel to the y-axis, it is determined based on the condition that the X-coordinate values or X-coordinate values of each point are equal. If the X coordinates or the X coordinates match, the process (R3) is executed as described above. The process (R3) is a process for calculating the interval between the input starting point and ending point.

In other words, the difference between the X coordinates ΔX, Δy, <ΔX
=lX2-XI 1. Find Δy=ly2−y+l). Here, (x+,)'l) is the coordinate of the starting point, (X2.
y2) is the coordinate of the end point.

Next, determine whether the difference ΔX in the X coordinate is zero (R4)
do. This determination is a process of determining whether the object is parallel to the X axis or the y axis. If ΔX is not zero (N>, a horizontal line for one character is calculated according to the input line type (R5) and displayed on the display section. If it is displayed, it will be automatically displayed by writing data to the display memory HM. Then, subtract the value of one character from the value of △X <(Ra). In other words, the value of ΔX is decremented. Then, it is determined whether ΔX is zero or not (R7).
do. If it is not zero (N), process R5 is performed again, and it is repeated in sequence until it becomes zero. The above operation is performed on the horizontal axis, i.e.
This is a process when drawing a line segment in the axial direction.

If the above-described determination (R4) is zero (y), a process of drawing a line segment in the y-axis direction is performed. That is, in the same way as in the X-axis direction, first draw a vertical line for one character according to the line type <(Rs). Then Δy is decremented (R
9) L, further determine whether the value is zero (R+o
)do. If it is not zero, the process (R8) is performed again. Then, the above-described process is repeated until Δy becomes zero.

When the above-described operation is completed (END), a straight line in the X-axis or y-axis direction is drawn on the display section.

In other words, the starting point and ending point are connected by the specified line segment.

FIG. 10 is a configuration diagram of the ruled line creation section KST mentioned above.

From the start point pointer SPT and end point pointer EPT to the calculation section K
The addresses stored in each pointer are entered manually in the STS. Although the input line is shown as a single line, each input line is input using a plurality of lines. In the calculation unit KSTS, the work register KSTW is
The difference between the x and X coordinates is calculated using The result is input to the addressing unit KSTA via the control unit KSTC. The address specifying section KS'TA selects the display memory H corresponding to the screen from the address information of the ruled lines to be displayed.
The address of M is generated and output to the display memory HM.

On the other hand, the ruled line type data from the type register SHR is applied to the ruled line data generation section KSTD and converted into data to be written into the display memory HM.

This conversion generates data one character at a time.

The aforementioned address designation section KSTA and ruled line data generation section KS
All TDs operate under the control of control signals from the control unit KSTC. Furthermore, control of each section of the control section KSTC is started by a one line generation start signal from the control section OCT, and ends when a termination signal is generated from the control section OCT from the control section KSTC at the end of one line generation. At this time, the ruled line information is also sent to the control unit OCT, and the control unit CCT acquires the area of the item register KMG.

Although FIG. 10 is a block diagram of the ruled line creation section KST, the program in the ruled line creation section KSP in the apparatus using the processor CPU shown in FIG. 4 operates in a similar manner.

FIG. 11 is a block diagram showing the ruled line discrimination section KHT in more detail.

The control unit KHTC receives a start signal from the control diagram CCT,
Ruled line type discrimination unit KHTH, row/column discrimination unit KHTD
, row line rank determination unit KHTJ, column line rank determination unit KHTI,
Row line information area designation part KHTN.

It controls the column line information area specifying unit KHTM and generates 3 row line information and 2 column line information. First, upon receiving a start signal from the control section CCT, a discrimination signal is input to the ruled line type discrimination section KHTH. As a result, the ruled line type discrimination section KHTH enters a discrimination operation, discriminates the ruled line type data inputted from the one type register SHR, and sends the result to the flag data generation section K.
Output from HTF. The flag data generating section KHTF generates coded data to be stored in the row line information register C'HR, column line information and disk LHR based on the input results. This coded data is then stored in each of the registers C
Stored in HR and LHH. Incidentally, at this time, the coded data is processed by the row/column discriminator Kl-TrD, the row/line rank determining unit KHTJ, and the column line rank discriminator KHTI.

Row line information area specification section 2 column line information area specification section KHTM
Registers CHR and LH specified by the row line information address or column line information address generated by the operation of
It is stored at the address of R.

That is, first, the start point pointer SPT, the end point pointer EPT
A row/column discriminating unit KHTD determines whether the line is a row line or a column line based on the added starting and ending point data. and a corresponding direction ranking discriminator, ie.

If it is a row line, it outputs the start point and end point data to the row line rank determining section KHTJ.If it is a 1 column line, it outputs the start point and end point data to the column line rank determining section. The row/column line rank determination unit KHTJ (KHTI) determines the rank of the row line (column line) using a control signal from the control unit KHTC. In other words, each currently stored ruled line position data is compared with the input data to determine the position of the input ruled line data, that is, in which position in the order of the currently stored ruled line position data the input ruled line data is located. Ask for support. Then, data in that order, that is, rank data, is stored in the row, column, and line information area designation section KHTN (KHTM
).

The row line (column line) information area specifying section outputs the address of the row line (column line) information register CHR (LHR) of the corresponding order based on the order data input by the control signal of the control section KHTC. This allows the row line (column line) information register CH
A specific register of R (LHR) is designated, and the output data of the flag data generation section is stored in the specific register. Then, at the same time as storing the above-mentioned data, the control unit KHTC
The present invention has been described in detail using embodiments.

In the embodiment of the present invention, the ruled lines corresponding to the two subtotals are two straight lines, but these may be replaced by other lines, such as dotted lines.

A broken line or the like may also be used. Further, the dividing line for the subtotal and the dividing line for the total may be different ruled lines. Furthermore, the same applies to multiplication.

In the embodiment of the present invention, multiplication is performed only in the horizontal direction, but this is also possible in the vertical direction. still,
At this time, vertical multiplication processing is required.

Further, according to the present invention, in addition to the four arithmetic operations, various calculations such as percentage calculations can be performed by appropriately selecting ruled lines.

Furthermore, in the embodiment of the present invention, a light pen is used to determine the starting point,
Although the end point address has been specified, this can also be input from the key manual section.

〔Effect of the invention〕

As described above, according to the table data calculation processing device of the present invention, the tabulation processing method is input at the same time as the table is created.
Aggregation and calculation processing of various data displayed in a matrix can be easily performed with simple operations.

Furthermore, since there is no need to create a complicated program, anyone can perform aggregation and calculation processing. Furthermore, according to the present invention, the subtotal area, total area, and multiplication area of the created table are divided by specific lines such as two straight lines or other two lines, so that the table is very easy to read. There is also the effect that it can be done.

[Brief explanation of the drawing]

Figures 1+a) and (b) are diagrams showing display examples of the first and second tables by the apparatus of the present invention, Figure 2 is a circuit configuration diagram showing the first embodiment of the present invention, and Figure 3 ( al is a diagram showing the relationship between the types of ruled lines and coded data, Figure 3 (bl, +d+ is a data configuration diagram of an example of row line information, Figure 3 (C1, (el is a data configuration diagram of an example of column line information, FIG. 3(f) is a data configuration diagram of an example of information in the item register; FIG. 3(f) is a data configuration diagram showing another example of line information; FIG. Example circuit configuration diagram, Figures 5 to 8 tal~(
dl, FIG. 9 is a processing flowchart of an embodiment of the present invention, FIG. 10 is a detailed configuration diagram of the ruled line creation section, and FIG. 11 is a detailed configuration diagram of the ruled line discrimination section. KEY...Key human resources department, KST...ruled line creation department, SPT...start point pointer, EPT...
・End point pointer, SHR...type register,
CC, T, KSTC, KHTC...control unit,
HM...display memory, CRTC...display control unit, LTP...light pen,
KHT... ruled line discrimination section, KMG... item register, STR... subtotal register, GTR
...total register, CRT...display device. Patent applicant: Casio Computer Co., Ltd. Representative Patent Attorney Yoshiyuki Osuga Figure 1 (0) Figure 1 (b) Figure 3 (0) (R) (G) (B) <C) Figure 3 (b) ) Figure 8 (d) Procedural amendment Written by Kazuo Wakasugi, Commissioner of the Japan Patent Office 2, Invention title table data calculation processing device 3, Relationship with the person making the amendment Patent applicant address 2-chome Nishi-Shinjuku, Shinjuku-ku, Tokyo 6 No. 1 No. 4, Agent
Cloud 100 Heavy (03) 591-87165, Date of amendment order Vol. 7, Contents of amendment (11 Add "Patent application pursuant to the proviso to Article 38 of the Patent Act" in the upper right corner of the application. (21rl, Invention Next to the column ``Name of Claims'', a column 11' and a column 21 indicating the number of claimed inventions are added.

Claims (8)

[Claims] (1) In a device that calculates tabular data in at least one direction, horizontally or vertically, a discriminating means for discriminating the type of ruled line that divides the tabular data, and a discriminating means for discriminating the type of ruled line that separates the tabular data, and a discriminating means for calculating the tabular data in at least one direction, horizontally or vertically. Tabular data comprising: calculation means for performing calculations on table data in at least one horizontal or vertical direction; and output means for outputting information obtained from the calculation means to a predetermined position. Computing processing device. (2) The table data calculation according to claim 1, wherein the calculating means performs different calculations depending on the type of ruled line when the determining means determines the type of the ruled line. Processing equipment. (3) The spreadsheet data calculation processing device according to claim 1, wherein the calculation means performs multiplication, division, addition, or subtraction. (4) The calculation means has a multiplication means for multiplying the data before the line of the specific line type by the data immediately before the line when the discrimination means discriminates the type of the ruled line, and the output means 2. The spreadsheet data calculation processing apparatus according to claim 1, wherein the output of the multiplication means is output immediately after the line of the specific line type. (5) The spreadsheet data calculation processing device according to claim 1, wherein the determining means determines the type of ruled line based on the color in the display. (6) The table data calculation processing apparatus according to claim 1, wherein the determining means determines the type of ruled line based on the shape of the ruled line in the display. (7) The table data calculation processing apparatus according to claim 1, wherein the determining means determines whether the ruled line is located at a position based on calculation. (8) In a device that calculates table data in at least one direction, horizontally or vertically, a ruled line creating means for creating lines that divide the table data, and a type of line created by the ruled line creating means. A table data calculation processing device comprising: a discrimination means for making a discrimination; and a calculation means for performing calculations on the table data in at least one horizontal or vertical direction of the table data based on the information obtained by the discrimination means. .