JPH01196662A - Matrix converting and displaying device for table data - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

Description

DETAILED DESCRIPTION OF THE INVENTION (a) Industrial Application The present invention relates to a matrix conversion display device for tabular data, and is mainly used for electronic display devices having a function of displaying tabular data.

(B) Prior Art Conventionally, tabular data in the above-mentioned electronic equipment is usually displayed as a list on the screen of a display device provided in the electronic equipment.

(c) Problems to be solved by the invention However, if the screen of the display device is large, it is possible to check the row data of the table all at once, but if the width of the screen is small, the row data of the table Since it is not possible to check all the information at once, it is necessary to switch the screen display and move the table horizontally for each confirmation location, which requires complicated operations.

As a solution to this problem, the transposed matrix of the table is found using a general formula, and the row and column parts of the table are swapped by swapping the row part and the 71 part of the memory where the table data is stored, and the row data is stored all at once. Is it possible to confirm this, but the process takes time and is not practical?

This invention has been made with these circumstances in mind, and therefore displays the rows and columns of tabular data by interchanging the screen display positions of the tabular data without replacing the memory in which the tabular data is stored. Thereby, the present invention provides a matrix conversion display device for tabular data that allows row data to be checked all at once even on a small screen.

(d) Means to solve the problem FIG. 1 is a block diagram showing the configuration of the present invention.

In this figure, 101 is a key input means, 102 is a display means, +03 is a first storage means that sequentially stores a plurality of data input from the key input means lot at a predetermined address, and 104 is an address of the first storage means 103. A second storage means 105 stores data in association with the display position of each data in the table. Key input is performed so that the rows and columns of the table are exchanged based on the display position of the second storage means 104. A converting means rewrites the address of the second storage means +04 with activated water from the means 101, and 106 reads the contents stored in the first storage means 103 and the second storage means 104 to create a table and display it on the display means 102. This is a reading means for reading the data.

As the display means 102 of the present invention, for example, a liquid crystal display device or a CRT display is used.

Further, as the converting means 105 and the reading means 106,
Usually CPU, ROM, RA? vl,
[/ A microcomputer consisting of 0 ports is used, and the 11th second storage means contains RA N=1
is commonly used.

(E) A plurality of data inputted from the function key input means lot are sequentially stored in predetermined addresses of the first storage means +03, and the addresses and the display positions of each data in the table are associated with each other, and It is stored in the storage means 104.

When an instruction is received from the key input means lot, the conversion means +05 causes the second storage means 104 to switch rows and columns of the table arranged based on the display position of the second storage means 104. address will be rewritten.

Further, the reading means 106 reads the data from the first storage means 103.
The contents stored in the second storage means 104 are read out, a table is created, and the table is displayed on the display means 102.

Therefore, when an instruction is received from the key input means 101, a plurality of pieces of data are displayed on the display means 102 without interchanging the rows and columns.
Instead of replacing the contents of the first storage means 103 storing a plurality of data with a transposed matrix, the conversion means"05
By rewriting the address of the second storage means 104, the rows and columns of the table are exchanged, so even on a small screen, row data can be checked all at once. becomes.

(f) Examples Hereinafter, the present invention will be described in detail based on examples shown in the drawings. Note that this invention is not limited to this.

FIG. 2 is a perspective view showing the appearance of an embodiment in which the present invention is applied to a multifunction desk calculator (hereinafter referred to as a multifunction calculator).

In the figure, reference numeral 1 denotes a multifunctional calculator body, which is called an "electronic notebook" and can store telephone numbers, schedules, etc. The multifunctional calculator main body 1 has an added function of creating various tables for sales management. 3 is a CD (liquid crystal display) that displays messages, calculation results, table data, and the results of the pond management function of the "electronic notebook"; in this embodiment, it is configured with a dot matrix. This is an input key for inputting various information on the SSi2 using the LCD.

FIG. 3 is a block diagram showing the structure of the multifunctional calculator main body l shown in FIG. 2.

In this figure, IO is a CPU, which controls the entire multifunctional calculator main body 1, controls input/output operations, and performs arithmetic processing. Reference numeral 11 denotes an LCD driver for driving the LCD 3. The LCD 3 is driven via the LCD driver 11 based on the control signal from CPt and 'IO, and displays calculation results, messages, tables, and the like.

12 is the I10 boat, and the input information from input key 4 is this! 10 is processed by CPU10 via port I2.

A ROM 13 stores an operation control program for the CPU 1O, and a control program for the input/output device of the multifunction calculator main body 1 is mainly stored in the RAM 13. 14 is a temporary memory used for the operation control program in ROM13, and I'(
AM, 15 is an RTC (real-time clock) that measures time, and 16 is a battery that supplies power to the multifunction calculator main body l.

FIG. 4 is an explanatory diagram showing the key arrangement of the input key 4, and FIG. 5 and FIGS. 6(a) to 6(c) are explanatory diagrams showing the display contents of the LCD 3.

The input key 4 is the mode setting key 5, as shown in FIG.
, an operation key 6, a numerical value key 7 for inputting numerical values, and a sales management table key 8 for calculating the price list and results (for sales management) and their spreadsheets.

The mode setting key 5 includes keys for setting modes such as calendar, schedule, calculation, telephone, and memo, and a spreadsheet key 5a for setting a spreadsheet mode. On/off key 6
It has a cursor key 6b for moving the cursor and a cursor, and a Roman character input key 60 for inputting character information in Roman characters.

Further, the sales management table key 8 includes a price list key 8a for specifying a price list, and a performance table key 8b for specifying a performance table.
, and a column Φ row display switching key 8C for switching the display between rows and columns.

To create a sales management table, press “Person/Cut key 61”
Press the ``ON'' key to turn on the power, or press the spreadsheet key 5a to switch to the spreadsheet usage mode if you are using it in the storage mode. Press the table key 8a or the performance table key 8b to select either one (in this example, select the price list)
, input the title of the table using the Roman alphabet key 60 and the numerical value key 7, and then input the table data to create a table as shown in FIG. 5 and store it in the RAM 14. let

After creating a table, to transpose the rows and columns of the table, switch to spreadsheet mode and display the screen shown in Figure 6 (a) on the LCD 3 screen.
), select the title, call the input table data from RAM l4, and display the contents of the input table data as shown in Figure 6(b). Make it.

In this state, if you press the row/column display switching key 8C, the table data will be converted into rows and columns, and the input table data will be displayed as shown in Figure 6(c). Nitro.

In such a configuration, the operation will be described below based on the flowchart shown in FIG. 7 and the operation block diagram shown in FIG. 8.

First, press the "ON" key of the human/off key 6a to turn on the power to the multi-function calculator main body (step 201), and the eighth
A program is loaded from the ROM 13 to the CPU I0 shown in the figure, and the CPU I0 becomes operational.

Next, enter the spreadsheet mode, select either the price list or the performance list, and enter the table data as shown in Figure 5 (step 202).
Each address of the display data stored in the data area 14a is stored in the data area 14a of the MI4, and each address of the display data stored in the data area 14a is stored in the display pointer +4b corresponding to the display position of the display buffer 3a. Note that the table data here is from the 8th
They are arranged in the table buffer 3a shown in the figure and displayed on the LCD 3, and in FIG. ! ?
A display device 2 is shown in which the display buffer 3a and the display buffer 3a are integrated.

To display the contents of table data, switch to spreadsheet mode and
After the display shown in FIG. 6(a) is displayed on the screen of the LCD 3, when a title is selected, the table data in the data area 14a is read out by the CPU 10. This reading is performed according to the storage contents of the display pointer 14b.
It is determined in which address of the data area 14a the tabular data is to be written to which position in the display buffer 3a, and the tabular data is sequentially written in the display buffer 3a in a matrix format, and the contents are displayed on the LCD 3. It is displayed on the screen (step 203).

Here, if you press the column middle row display switching key 8c (step 2
04), the rows and columns of the displayed table are swapped as follows.

First, CPUl0 displays the display pointer! 4b is read out, and the display pointer + address of the data area 14a stored in 4b is changed (step 20).
8) Next, the contents of the display buffer 3a are rewritten to data that has undergone matrix conversion based on the display pointer 14b (step 209), and the display buffer 3a is
The contents of a are output to the LCD 3, and the conversion result as shown in Figure s6 (c) is displayed on the screen (Step 2
10).

To explain the above conversion in more detail using the detailed flowchart of FIG.
A program is loaded into the CP (step 205), and the CP that receives the matrix conversion command by executing the program
Matrix transformation is performed by Ul0 (step 206
).

When the display pointer 14b is changed, the position of the display data in the display buffer 3a is rewritten so that the display contents are swapped between rows and columns. It is calculated by cputo according to the contents written in (step 207).

Then, as shown in FIG. 7, the content of the display pointer 1413, that is, the address of the data area 14a, is rewritten (step 208), and table data is read out from the data area 14a according to the rewritten address and displayed. The display contents of the buffer 3a are converted and rewritten in rows and columns (step 209).
, is displayed on the screen (step 210).

In this way, when the column middle row display switch key is pressed,
The rows and columns of the table data are exchanged and displayed on the LCD screen, and the rows and columns of the display buffer are converted by rewriting the address of the data area stored in the display pointer. If you replace them, you can quickly check all the line data all at once, even on a small screen.

(G) Effects of the Invention According to this invention, when an instruction is received from the key input means, the rows and columns of a plurality of data arranged and displayed in a table are exchanged and displayed on the display means, and furthermore, The rows and columns of the table are swapped by rewriting the address of the second storage means instead of replacing the contents of the first storage means storing a plurality of data with a transposed matrix. Therefore, a matrix conversion display device for tabular data is provided that allows row data to be checked all at once even on a small screen.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing the configuration of the present invention, FIG. 2 is a perspective view showing the appearance of an embodiment in which the invention is applied to a multi-function calculator, and FIG. Block diagram showing the configuration, 4th rf! J is an explanatory diagram showing the key arrangement of the input key, and Figures 5 and 6 (a) to 6 (c) are L.
An explanatory diagram showing the display contents of the CD, Fig. 7 is a flowchart showing the matrix conversion operation of the multi-function calculator, Fig. 8 is an operation block diagram showing the operation of the multi-function calculator, and Fig. 9 is a matrix conversion operation. The operation is shown in detail with detailed flowcharts and diagrams. 1...Takuma calculator body, 2...Display device, 3...LCD. 3a...display/output, 4...human key-15...mode setting key, 6...
Operation keys, 7...Numeric key-18...
・Sales management table key, lO...c p x:, 1
1...LCD driver, 12...I10
Boat, 13...RO\■, 14...
RA X=1% 15...RTC. l6...Battery. Fig. 1 Fig. 2 Mouth Fig. 3 Fig. 1 Diagonal Ofu Fig. 5 Kui-men Kaku Table 1〉 Title, stone: wo child] Duck Fig. 6 (a) (b) (C) Fig. 7 Figure 8

Claims (1)

[Claims] 1. A display device for arranging a plurality of data to create a table and displaying the table, comprising a key input means, a display means, and a plurality of data inputted from the key input means in a predetermined manner. a first storage means that sequentially stores data in the addresses of the first storage means; a second storage means that stores the addresses of the first storage means in association with the display positions of each data in the table; a conversion means for rewriting the address of the second storage means according to an instruction from the key input means so that the rows and columns of the table are interchanged; and a conversion means for reading and displaying the contents stored in the first storage means and the second storage means. A matrix conversion display device for tabular data, comprising reading means for creating and displaying on the display means.