JP3056124B2 - Electronic sheet display device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a device for displaying an electronic sheet of spreadsheet software, and in particular, designates a specific row or column as a row or column indicating a constituent item instead of a column number row or a row number column. Electronic sheet display device.

[0002]

2. Description of the Related Art Conventionally, in a spreadsheet software, in order to display a table format, a row or a column serving as an item name can be converted into fixed information at a designated cell position on an electronic sheet. Since the row and column indicating the row number are always displayed in the cell data display area of the electronic sheet, when the row or column of the item name is converted to fixed information on the electronic sheet, it can be input / displayed in a table format on the display screen. There was a problem that the number of rows and columns decreased. This problem becomes more serious in a display device such as a portable information terminal having a small screen display area (a display device having a small number of displayable rows / columns). In order to explain this situation, referring to FIG. 7 showing a screen in a conventional tabular display of the electronic sheet 30 shown in FIG. 3, when “base point cell C12” is designated for the electronic sheet 30, The display screen 71 is displayed due to the restriction on the display format. When an item name of a row and a column is designated as fixed information in the fixed position information 72 on the display screen 71, a number row 731, a number column 733, an item row 732, and an item column 734 are displayed as shown on the display screen 73. Is done. For the user, the display screen 73 has duplicate contents. Excluding this overlap, the number of rows and columns can be increased one by one, which is a great advantage for a small screen size.

[0003]

In the prior art, when a row number, a column number, and an item name are fixed information in a row or a column on a display screen of an electronic sheet, the number of lines that can be input / displayed on the screen is set. And the number of columns is reduced. The reason is that the columns or rows that have been converted to fixed information narrow the cell data display area. An object of the present invention is to omit a number column or a number line that is unnecessary for recognizing display contents when a row or a column is fixed information of an item name at an arbitrary position in an electronic sheet, and to display cell data. The aim is not to reduce the number of rows and columns.

[0004]

An electronic sheet display device according to the present invention displays rows and columns that have been converted into fixed information on a display screen of an electronic sheet in a column number or row number display area. More specifically, an input control unit for inputting fixed position information indicating which position on the electronic sheet is to be fixed information as a row or a column of an item name, and fixed position information input from the input control unit Position information storage unit for writing data into the memory, a screen display unit 13 for editing column numbers, row numbers, and cell data of electronic sheets in a table format, and output control for visualizing and displaying the table format on a display device. And a memory for storing fixed position information and electronic sheet data.
Further, the screen display unit includes a column number display control unit that displays a row that has been fixed information as an item name in a column number display area, and a row number display control that displays a column that has been fixed information as an item name in a row number display area. And an electronic sheet cell data display control unit for displaying cell data in the electronic sheet in each cell of the table area.

[0005] The input control unit inputs which row or column on the electronic sheet is to be converted into fixed information, and the specification of the input fixed position information is stored in the memory by the fixed position information storage unit. The column number display control unit of the screen display unit receives information as to whether or not the row is fixed as fixed position information from the fixed position information storage unit. If the line is fixed, the fixed information line is displayed as the item name in the column number display area of the screen.
If the line is not fixed, the column number is displayed in the column number display area of the screen. The row number display control unit of the screen display unit receives, from the fixed position information storage unit, information as to whether or not the column is fixed as fixed position information. If columns are fixed,
Displays the column converted to fixed information as the item name in the line number display area of the screen. If the column is not fixed, the line number is displayed in the line number display area. As described above, the number of rows and columns that can be input / displayed in the electronic sheet does not decrease even when there are rows and columns that have been converted to fixed information in the electronic sheet.

[0006]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described with reference to the drawings. FIG. 1 shows a configuration of an embodiment of the present invention.
, The fixed position information storage unit 12 is for storing, in the memory 15, the position information of rows and columns to be fixed in the electronic sheet input from the input control unit 11. The column number display control unit 131 reads the specification of the fixed position information 151 from the memory 15 and determines whether or not the line is specified in the fixed position information 151. If the line is fixed, the fixed information is converted to an item name. Is displayed in the row of the column number. The row number display control unit 132 reads the specification of the fixed position information 151 from the memory 15 and determines whether or not the column is specified as the fixed position information. If the column is fixed, the fixed position information 151 is set as the item name. Is displayed in the column of the row number. The electronic sheet cell data display control unit 133 is for reading out the electronic sheet data 152 from the memory 15 and displaying it in a cell in a table format.

Next, the operation of this embodiment will be described with reference to FIG. The position information to be converted into fixed information in the electronic sheet and the information on whether the line is fixed or the column is provided from the input control unit 11 are provided to the fixed position information storage unit 12. The fixed position information storage unit 12 writes the fixed position information and the fixed information of the row or column in the fixed position information 151 of the memory, and passes control to the screen display unit 13. Screen control unit 1
The third column number display control unit 131 reads the fixed position information from the fixed position information 151 in the memory 15 and determines whether or not the line is fixed. In the case of row fixing, the row designated at the fixed position is read from the electronic sheet data 152 of the memory 15 and displayed in the column number display area, and then control is passed to the row number display control unit 132. If the fixed position information does not specify the line fixation, the column number display area displays the column number as it is, and then passes control to the line number display control unit 132.
The row number display control unit 132 reads the fixed position information from the fixed position information 151 in the memory 15 and determines whether or not the column is fixed. In the case of column fixing, the column designated at the fixed position is read from the electronic sheet data 152 of the memory 15 and displayed in the row number display area, and then control is passed to the electronic sheet cell data display control unit 133. When the fixed column is not specified, the row number is displayed in the row number display area as it is, and the control is performed by the electronic sheet cell data display control unit 13.
Hand over to 3. The electronic sheet cell data display control unit 133 includes:
The data is read from the electronic sheet data 152 in the memory 15, the cell data is edited in a table format, and the control is output control 1
Hand over to 4. The output control unit 14 visualizes and displays the tabular format edited by the screen display unit 13 on a display.

Next, the operation of this embodiment will be described with reference to FIG. 2 of a flowchart, using FIGS. 3, 4, 5 and 6 showing specific examples. FIG. 2 is a flowchart showing the processing of the screen display unit 13. Steps 21 and 22 are steps for reading the fixed position information 151 from the memory 15 and determining whether or not the line is fixed. In Steps 23 and 24, when the line is fixed (Y in Step 22), the line data specified by the fixed position and the line fixed is read from the electronic sheet data 152 and converted into a character string that can be displayed on the screen. Step 25
Generates a column number character string to be displayed on the screen when the row is not fixed (N in step 22). In step 26, the item of the column designated as the fixed column is displayed as a character string in the column number display area. Steps 27 and 28 are performed in the memory 15
, The fixed position information 151 is read, and it is determined whether or not the column is fixed. When the columns are fixed (Y in step 28) in steps 29 and 30, column data specified by the fixed position and the column fixed is read from the electronic sheet data 152 and converted into a character string that can be displayed on the screen. In step 31, when the column is not fixed (N in step 28), a character string of the line number to be displayed on the screen is generated. Step 32 displays the character string in the line number display area. Steps 33, 34 and 35 read the cell data from the electronic sheet data 152 and edit the cell data into a table format.

Next, the operation of this embodiment will be described with reference to specific columns. Referring to FIG. 3, an exemplary electronic sheet 30 includes:
Column number row 31 from “A” to “F” and “1” to “1”
6 ”, a row number column 32, an item name row 33, and a product name column 3
4, and data is stored in each internal cell in a table format. When a predetermined area of the electronic sheet 30 is taken out and displayed on a screen of a limited size, the display screen when the fixed position information 151 is designated is shown in FIGS. . In the display screen 41 of FIG. 4A, it is assumed that a cell A12 is designated as a base cell (an upper left cell in the screen). It is assumed that information of “fixed position A1” 421, “with fixed line” 422, and “without fixed line” 423 is given from the input control unit 11 as the fixed position information 42 shown in FIG. The fixed position information storage unit 12 stores the fixed position information 42 sent from the input control unit 11 in the fixed position information 151.

Next, the column number display control unit 131 of the screen display unit 13 reads the designation of line fixation from the fixed position information 151 (step 21), and judges whether or not "line fixation" is designated. (Step 22). "Line fixed" 4
When it is designated as 22 (Y in step 22), the “fixed position A1” 421 is read from the fixed position information 42. In the “fixed position A1” 421, one row in column A is specified and the “base point cell is A12”. Therefore, the column number row 31 in the first row and the columns A and B determined by the table format of the screen
The cells in the column, column C, and column D are read from the electronic sheet data 152 (step 23). The “item name”, “unit price”, “quantity”, and “total” of the second row 33 of the electronic sheet data are displayed on the screen in columns A, B, C, and D of the read first row 31. It is converted into a displayable character string format and displayed in the column number display area (steps 24 and 26). The row number display control unit 132 reads the designation of column fixation from the fixed position information 42, and determines whether or not the column fixation is designated (step 27, step 28). "No column fixation" 423 is specified and "base cell A12", so "12", "13", "1" of row number 412
"4", "15" and "16" are generated and displayed in the line number display area (steps 31 and 32).

Next, the electronic sheet cell data display control unit 1
33 is “base cell A12”, so “A12”,
"B12", "C12", "D12", "A13",
Data of “B13”, “C13”, “D13”,..., “D16” is read from the electronic sheet data 152. "TV" of line number "12" of the read electronic sheet data,
“$ 39800”, “4”, “B12 * C12”, “stereo”, “$ 89600”, “8”, “B13 * C1
3 ”,“ B16 * C1 ”of column number“ D ”of row number“ 16 ”
6 is converted into a character string format that can be displayed on the screen and displayed in the cell data display area (step 33, step 3).
4, step 35). The output control unit 14 visualizes and displays the data edited by the screen display unit 13 on a display device, thereby displaying the display screen (base cell A1) of FIG.
2) 41 is displayed on the display screen 43 of FIG.

In FIG. 5C, the base point display cell (upper left cell in the screen) of the screen 51 of FIG.
As a result, the fixed position information 52 in FIG. 5B is obtained from the input control unit 11 as information of “fixed position A1” 521, “no fixed row” 522, and “column fixed” 523 as “2”. It is a display screen 53 displayed.

In FIG. 6C, the base point display cell (upper left cell in the screen) of the screen 61 of FIG.
2 ", the fixed position information 62 in FIG. 6B is changed from the input control unit 11 to the information of" fixed position A1 "621," fixed row "622, and" fixed column "623. It is a display screen 63 obtained.

[0014]

An advantage of the present invention is that when rows and columns are fixed position information in an electronic sheet, the number of rows and columns that can be input / displayed on the screen does not decrease. The reason is,
Instead of displaying the fixed position information in the cell data display area, it is displayed in the row number or column number display area so that the row or column number of the fixed position information does not overlap with the row number or column number. It is.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration of an embodiment of the present invention.

FIG. 2 is a flowchart of a screen display unit according to the embodiment of FIG.

FIG. 3 is a diagram illustrating an electronic sheet.

FIG. 4 (a) is a conventional display screen with “base cell A12”, FIG. 4 (b) is an example of fixed position information, and FIG. 4 (c) is a result of applying the fixed position information. , And the display screen of this embodiment.

FIG. 5 (a) is a conventional display screen with “base cell C12”, FIG. 5 (b) is an example of fixed position information, and FIG. 5 (c) is a result of applying the fixed position information. FIG. 3 is a diagram showing a display screen of this embodiment.

FIG. 6 (a) is a conventional display screen with “base cell C12”, FIG. 6 (b) is an example of fixed position information, and FIG. 6 (c) is a result of applying the fixed position information. 4 shows a display screen of this embodiment.

FIG. 7 (a) is a conventional display screen with “base cell C12”, FIG. 7 (b) is an example of fixed position information, and FIG. 7 (c) is a result of applying the fixed position information. 1 shows a conventional display screen.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 Electronic sheet display apparatus 11 Input control part 12 Fixed position information storage part 13 Screen display part 14 Output control part 15 Memory 131 Column number display control part 132 Line number display control part 133 Electronic sheet cell data display control part 151 Fixed position information 152 Electronic sheet data

Claims (2)

(57) [Claims] 1. A sheet display device that extracts a predetermined area from a table-type electronic sheet having fixed information having a row number column and a column number row and displays cells included in the area in a table format. An electronic sheet display, wherein cells in a predetermined area are edited and displayed in a table format instead of replacing the columns as fixed information columns with the row number columns, or replacing the specified rows as fixed information rows with the column number rows. apparatus. 2. The electronic sheet display device, comprising: an input control unit that inputs fixed position information that specifies the specific column, the specific row, and the predetermined region; and the specific column input from the input control unit. A fixed position information storage unit that stores the specific row and the fixed position information in a memory; based on the fixed position information, extracts a cell in a predetermined area from the electronic sheet, and specifies the specific column as a fixed information column, or The electronic sheet display device according to claim 1, further comprising: a screen display unit that edits a screen in a table format in which a row is a fixed information line; and an output control unit that visualizes the table format.