JP2000235606A - Table calculation processor and storage medium storing table calculation processing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To presentably display data whose width and height, which are required for display, remarkably differ in the same cell column or cell row by providing a space row setting means and a cell width setting means which can differently set the width of a cell through a space row. SOLUTION: CPU 11 obtains space row position data or space column position data from the position of a space row and a space column, which are designated. They are stored in the space row position storage area 1151 and the space column position storage area 1153 of RAM 113. When the space row and the space column are newly arranged, data of a cell width storage area 1131 and a cell height storage area 1132 are added. Different cell widths are set in one cell column by adjusting them to the number of the digits of inputted data and the size of a character. Thus, data different in widths required in display can presentably be displayed in the same cell column.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

TECHNICAL FIELD The present invention relates to a spreadsheet processing apparatus,
More specifically, with respect to a storage medium storing a spreadsheet processing program, in more detail, by a simple operation and processing, extremely different data of width and height required for display are displayed in the same cell column or cell row properly and appropriately. The present invention relates to a spreadsheet processing device capable of being displayed and a storage medium storing a spreadsheet processing program.

[0002]

2. Description of the Related Art Conventionally, a spreadsheet processing apparatus and a storage medium storing a spreadsheet processing program for performing spreadsheet processing are well known. 2. Description of the Related Art In a conventional spreadsheet processing apparatus and a spreadsheet processing program using a spreadsheet processing program in a storage medium storing a spreadsheet processing program, a worksheet in which partitions (cells) are set by a plurality of vertical and horizontal frame lines is displayed. I do. Then, in each cell, data such as characters, numerical values, and formulas are obtained and calculation processing is performed, and the obtained characters, numerical values, and calculation processing results are also displayed as data in the corresponding cells. Such spreadsheet processing has been widely used, mainly in tabulation and calculation, such as creation of quotes and invoices and creation of business plans, and has significantly improved office productivity.

A conventional spreadsheet processing apparatus as described above,
In the spreadsheet processing by the storage medium storing the spreadsheet processing program, the width and height of the cell are changed by dragging the vertical frame line and the horizontal frame line one by one with a mouse. It can be set and changed uniformly in column units or cell row units. By setting the width of each cell column and the height of each cell row according to the data that requires the largest width and height in that cell column and cell row, the data is completely stored in the cell. It can be displayed.

FIG. 18 shows an example of a state in which a table is created on a worksheet displayed in a spreadsheet process according to the prior art. The worksheet 150 shown in FIG.
Two tables (Table 1 and Table 2) have been created. In this worksheet 150, column A is used as a column for a product name, column B is used as a column for a unit price, and column C is used as a column for a purchased quantity. A table indicating the purchase quantity (Table 1) is created, and from the seventh to eleventh rows, a table (Table 2) indicating the unit price and the purchase quantity for a large amount of low-priced products is created. As described above, in the spreadsheet processing, it is common to create a plurality of tables in one worksheet. In the worksheet 150 shown in FIG. 18, the width of the column B is set according to the unit price in Table 1, and the width of the column C is set according to the quantity in Table 2.

[0005]

However, when data having extremely different widths required for display is displayed in the same cell column due to a difference in the number of digits or the size of a character, the number of lines or the number When displaying data having extremely different heights required for display due to the difference in the character size, the width of the cell column or the height of the cell row should be maximized as in the worksheet 150 shown in FIG. If the data is set according to the required data, the cells for displaying the data having a small width or height required for display may appear to be elongated, making it difficult to read the data and degrading the appearance, and further wasting space. On the other hand, if the cell column width or cell row height is set to a small value, data that is large in width or height required for display may protrude from the cell, or may not be displayed overlapping with the next cell. I will. As described above, in a conventional spreadsheet processing apparatus and a storage medium storing a spreadsheet processing program,
In the spreadsheet process, the cell width is set the same for each cell column, and the cell height is set the same for each cell row. There is a problem that it is not possible to appropriately and appropriately display a cell column or a cell row.

As a method of displaying a table in which the same cell column has different column widths in the same cell row and a table in which the same cell row has different heights set in one sheet, a OLE (Object Linking and Enbedding) has been conventionally used. There is a method of using a function to create a table of different column widths and row heights as separate objects, and to paste them into a word processing document or the like. However, this method imposes a heavy load on a processing device such as a personal computer, and the operation is complicated and troublesome for the operator.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problem, and extremely simple data and data required for display can be stored in the same cell column or cell row by simple operation and processing. It is an object of the present invention to provide a spreadsheet processing device capable of displaying a form in a proper manner and a storage medium storing a spreadsheet processing program.

[0008]

According to a first aspect of the present invention, there is provided data acquisition means for acquiring data corresponding to the cells of a worksheet divided into cells by vertical and horizontal frame lines; A table calculation unit that performs a spreadsheet process based on the data acquired by the acquisition unit, and the worksheet is displayed, and the data acquired by the data acquisition unit or the spreadsheet is displayed in a cell of the displayed worksheet. Worksheet display means for displaying data after spreadsheet processing, frame position setting means for setting the position of the frame line, and dividing the worksheet into a cell group formed by a plurality of adjacent cells And a section setting unit for performing the setting, wherein the frame line position setting unit sets the frame lines over a plurality of sections divided by the section setting unit differently. To achieve the object by enabling set in different positions relative to the minute. In the invention according to claim 2, in the spreadsheet processing device according to claim 1,
The division setting unit divides the worksheet by setting a space row or a space column that is not involved in the spreadsheet processing between the divisions. In the invention described in claim 3,
3. The spreadsheet processing device according to claim 1, wherein the worksheet display unit displays the worksheet so that the sections divided by the section setting unit can be identified. According to a fourth aspect of the present invention, in the spreadsheet processing apparatus according to the first, second, or third aspect, the worksheet display means may include a frame line set at a different position for different sections. In response to this, the worksheet is displayed so that the correspondence between the frame lines in each section can be confirmed. According to a fifth aspect of the present invention, in the spreadsheet processing apparatus according to the fourth aspect, the worksheet display unit displays a connection line connecting frame lines set at different positions for different sections. A connection line display means; According to the invention described in claim 6, a data acquisition function for acquiring data corresponding to the cell of the worksheet partitioned into cells by vertical and horizontal frame lines, and a data acquisition function based on the data acquired by the data acquisition function. A spreadsheet function for performing spreadsheet processing and displaying the worksheet, and displaying data obtained by the data acquisition function or data after spreadsheet processing by the spreadsheet function in cells of the displayed worksheet. A computer having a worksheet display function, a frame line position setting function of setting the position of the frame line, and a division setting function of dividing the worksheet into a cell group formed by a plurality of adjacent cells. A storage medium storing a computer-readable spreadsheet processing program for realizing, wherein the frame position setting function includes The border over a plurality of sections which are divided by a constant function, to be set in different positions relative to the different sections.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A spreadsheet processing apparatus according to the present invention will now be described.
A preferred embodiment of a storage medium storing a spreadsheet processing program will be described in detail with reference to the drawings.

(1) Outline of Embodiment In this embodiment, when the mouse is right-clicked while pointing on the worksheet, a space row / column setting mode is set. In this state, the horizontal frame line is clicked with the mouse in the border. Thus, a space row not involved in the spreadsheet is arranged between the cell rows on both sides of the horizontal frame line (space setting means). Even if the vertical frame line is moved by dragging, the vertical frame line does not move through this space row, and the column width is set differently in one cell column. Further, by clicking the vertical frame line with the mouse in the border in the space row / column setting mode, a space column not involved in the spreadsheet is arranged between the cell columns on both sides of the vertical frame line. Then, even if the horizontal frame line is moved by dragging, the horizontal frame line does not move through this space column, and the height of one cell row is set differently.

(2) Details of Embodiment FIG. 1 shows an embodiment of a spreadsheet processing apparatus according to the present invention.
1 is a block diagram illustrating a configuration of a computer from which a spreadsheet processing program according to an embodiment of the present invention has been read. As shown in FIG. 1, the spreadsheet processing device (computer) includes a control unit 11 for controlling the entire device. The control unit 11 includes a keyboard 12 and a mouse 13 as input devices, a display device 14, a printing device 15, a storage device 16, a storage medium driving device 17, a communication control device 18 via a bus line 21 such as a data bus. , And input / output I / F 19,
Also, a character recognition device 20 is connected. Control unit 1
1 includes a CPU 111, a ROM 112, and a RAM 113. The ROM 112 is a read-only memory in which various programs and data for the CPU 111 to perform various controls and calculations are stored in advance.

The RAM 113 is a random access memory used as a working memory by the CPU 111. In the RAM 113, the cell columns A, B, C,
..., cell width storage area 113 for storing the width of IU, IV
1, a cell height storage area 1132 for storing the height of each cell row 1, 2, 3,... 999; A data storage area 1141, a space row position storage area 1151, a space row height storage area 1152, a space column position storage area 1153, a space column width storage area 1154, and other various areas to be stored corresponding to cells are secured. It has become.

FIG. 2 is an explanatory diagram showing the contents of the cell width data stored in the cell width storage area in this embodiment. As shown in FIG. 2, the cell width storage area 1131 stores, for each worksheet, each cell row A, B, C,.
Are stored as five values. This value is 4
The cell width of each cell column that changes via the three space rows Sg1 to Sg4 is shown in order from the first row side of the worksheet. For example, in column A of sheet 1 shown in FIG. 2, the dot width is 120 dots from the first row to the bottom row, and in column B, the cell width is 168 from the first row to the first space row Sg1, and this space row Sg1 and next space line Sg
2, the cell width is 72, between Sg2 and Sg3,
The cell width is 120 between g3 and Sg4, and from Sg4 to the bottom row.

The value of the width of each cell row stored here is a unit based on a display screen such as a dot unit or a pixel unit, a unit based on an input character or a symbol such as a half-width unit or a full-width unit of a character. , Mm, inch, etc., and may be a unit based on a length, and in the present embodiment, is expressed in a dot unit. In the present embodiment,
The numerical value of the cell width storage area 1131 is (A; 120, 120, 120, 120, 12) in all the cell columns.
0), (B; 120, 120, 120, 120, 12)
0), etc., the initial value is set to 120 dots.

FIG. 3 is an explanatory diagram showing the contents of the cell height data stored in the cell height storage area in this embodiment. As shown in FIG. 3, the cell height storage area 1132 stores, for each worksheet, each cell row 1, 2, 2,.
The cell heights at 3,... 999 are stored as five values. This value indicates the cell height of each cell row, which changes through the four space columns Sr1 to Sr4, as A in the worksheet.
It is shown in order from the column side. For example, in the first row of sheet 1 shown in FIG. 3, from column A to the first space column Sr
The cell height is 24 up to 1, 36 from the space column Sr1 to the space column Sr2, and 24 from the Sr2 to the rightmost row.
It has become.

The value stored here is a unit based on the display screen such as a dot unit or a pixel unit, a unit based on an input character or a symbol such as a full width unit of a character, or a length such as a mm unit or an inch unit. In this embodiment, the unit is expressed in dots.
In the present embodiment, the numerical value of the cell height storage area 1132 is (1; 24, 2) in all the cell rows.
4, 24, 24, 24), (2; 24, 24, 24, 2)
4, 24,), the initial value is set to 24 dots.

FIG. 4 is an explanatory diagram showing the contents of the space line position data stored in the space line position storage area 1151 in this embodiment. In the space row position storage area 1151, as shown in FIG. 6, a set of cell rows adjacent to each other is stored (Sheet 1; 5-6, 10-11, 11).
38-39, 112-156), (Sheet 2; 8-9,
25-26), 0 to 4 for each worksheet
Stored in pairs. Then, a space row that is not involved in the spreadsheet processing is arranged between the set of these cell rows. For example, in sheet 1 shown in FIG.
Between rows 11 and 11, between rows 38 and 39, and between rows 112 and 156, respectively.
Sg3 and Sg4 are arranged, and in worksheet 2, space rows Sg1 are located between rows 8 and 9 and between rows 25 and 26.
Sg2 is arranged. In the worksheet 3, no space line is arranged. In the present embodiment, in the space row position storage area 1151, the number of cell rows in the initial state is 0 in any worksheet.

FIG. 5 is an explanatory diagram showing the contents of the space line height data stored in the space line height storage area in the present embodiment. Space row height storage area 11
As shown in FIG. 5, 0 to 4 space row heights are stored in each worksheet 52. The height of the space row for each worksheet corresponds to the space row for each worksheet stored in the space row position storage area 1151 (FIG. 4) described above. Accordingly, from FIG. 4 and FIG.
A space row Sg1 having a height of 24 is arranged between rows 5 and 6, and a space row Sg having a height of 36 is arranged between rows 11 and 12.
2 are arranged, between lines 38 and 39, 112 and 113
Between the rows, space rows Sr3 each having a height of 24
Sr4 will be arranged.

The value of the height of the space line is a unit based on a display screen such as a dot unit or a pixel unit, a unit based on an input character or a symbol such as a full width unit of a character, or m.
It is expressed in a unit based on a length such as an m unit or an inch unit. If the value of the space row height is 0, the space row is not substantially displayed on the display device, and normal cell rows to which data can be input are displayed adjacent to each other. Also, cell rows 1 to 999 and space rows Sr1, Sr2,.
Can be set only in a range where the sum of each row is equal to or less than 24072, which is the height of the entire sheet.

FIG. 6 is an explanatory diagram showing the contents of the space column position data stored in the space column position storage area in this embodiment. Space row position storage area 11
As shown in FIG. 4, as shown in FIG. 53, a set of adjacent cell rows includes (Sheet 1; DE, JK, AY-AZ,
0 to 4 sets are stored for each worksheet, such as (BD-BE) and (Sheet 2; EF, CA-CB). Space columns that are not involved in the spreadsheet processing are arranged between these sets of cell columns. For example, in the sheet 1 shown in FIG. 6, space rows Sr1 and Sr2 are provided between the rows E and F, between the rows J and K, between the rows AY and AZ, and between the rows BD and BE, respectively. , Sr3, Sr4 are arranged, and in the sheet 2, a space row (space row Sr1) is arranged only between the P row and the Q row. In the present embodiment, in the space column position storage area 1153, in the initial state, the number of cell columns is zero in any worksheet.

FIG. 7 is an explanatory diagram showing the contents of the space column width data stored in the space column width storage area in this embodiment. As shown in FIG. 7, the space column width storage area 1154 stores 0 to 4 space column widths for each worksheet. The width of the space column for each worksheet corresponds to the space column for each worksheet stored in the space width position storage area 1153 (FIG. 6) described above. Accordingly, from FIGS. 6 and 7, in the sheet 1, the space row Sr1 having a width of 80 is arranged between the row D and the row E, and between the row J and the row K, between the row AY and the row AZ, and Space rows Sr2, Sr3, Sr4 having a width of 120 are arranged between the BD row and the BE row.

The value of the width of the space column may be a unit based on a display screen such as a dot unit or a pixel unit, a unit based on an input character or a symbol such as a full width unit of a character, or mm.
It is expressed in units based on length such as units or inches. If the value of the width of the space column is 0, the space column is not substantially displayed on the display device, and normal cell columns into which data can be input are displayed adjacent to each other. Further, the width of the cell columns A to IV and the space columns Sr1, Sr2,... Can be set only in a range where the total of each row is 3200 or less which is the width of the entire sheet.

The keyboard 12 is provided with various keys such as a kana key and a numeric keypad for inputting a kana character, a function key for executing various functions, a cursor key, and the like. Data such as character strings and numerical formulas used for processing are acquired. The mouse 13 is a pointing device,
When the operator clicks a key, an icon, or the like displayed on the display device 14, the input device specifies a corresponding function or cell.

As the display device 14, for example, a CRT or a liquid crystal display is used. The display device 14 performs work based on worksheets divided into cells by vertical and horizontal frame lines, data such as character strings and numerical values obtained from the keyboard 12 or the mouse 13, and these data. The result of the spreadsheet process is displayed. The printing device 15
This is for printing a table or the like created based on the worksheet displayed on the display device 14. As the printing device 15, various printing devices such as a laser printer, a dot printer, an ink jet printer, a page printer, a thermal printer, and a thermal transfer printer are used.

The storage device 16 comprises a readable and writable storage medium, and a drive device for reading and writing various information such as programs and data on the storage medium.
As a storage medium used for the storage device 16, a hard disk is mainly used, but a readable and writable storage medium among various storage media used in a storage medium driving device 17 described later may be used. Good. The storage device 16 stores the kana-kanji conversion dictionary 161 and the program storage unit 1
62, a table format storage unit 163 for storing a plurality of types of predetermined table formats (settings such as ruled line types, shading, etc. in the table) created on the worksheet, and other storage units (not shown) For example, a storage unit for backing up programs, data, and the like stored in the storage device 16 is provided.

The program storage unit 162 stores a program for performing the spreadsheet processing according to the present embodiment.
Data is obtained from input devices such as a keyboard 12 and a mouse 13, a storage device 16, a storage medium driving device 17, a communication control device 18, and the like corresponding to cells of a worksheet divided into cells by vertical and horizontal frame lines. Data acquisition program, spreadsheet program that performs spreadsheet processing based on the acquired data, worksheet display program that displays worksheets and corresponding data in their cells, and sets the positions of vertical and horizontal lines The worksheet is divided into a group of cells formed by a plurality of adjacent cells, and can be identified by each of these divisions by interposing and setting a space row or a space column that is not involved in the spreadsheet processing. Vertical and horizontal lines whose positions are set differently between sections In addition to the connecting line display program for connecting the cats, a kana-kanji conversion program for converting a kana character string input using the kana-kanji conversion dictionary 161 into a mixed-kanji sentence, a data and a calculation result obtained by the calculation processing. Graphing programs that create graphs based on
Various programs are stored.

The storage medium drive 17 is a drive for the CPU 111 to read a computer program, data including table data, and the like from an external storage medium. The computer programs stored in the storage medium include programs for various processes executed by the spreadsheet processing device of the present embodiment, and dictionaries and data used therein. Here, the storage medium refers to a storage medium in which computer programs, data, and the like are stored.
Specifically, a magnetic storage medium such as a floppy (registered trademark) disk, a hard disk, and a magnetic tape; a semiconductor storage medium such as a memory chip and an IC card;
O, PD (phase change rewritable optical disk) and other storage media from which information can be read optically, storage media using paper (such as paper cards and tapes) (and media having functions equivalent to paper), and various other types A storage medium in which a computer program or the like is stored in the method is included. As a storage medium used in the spreadsheet processing device of the present embodiment, a CD-ROM or a floppy disk is mainly used.
The storage medium drive 17 reads a computer program from these various storage media, and also stores the RAM 1 in a writable storage medium such as a floppy disk.
13 and the data stored in the storage device 16 can be written.

In the spreadsheet processing apparatus of the present embodiment, the CPU 111 of the control section 11 reads a computer program from an external storage medium set in the storage medium drive 17 and stores it in each section of the storage device 16 (installation).
I do. When executing various processes such as a spreadsheet process according to the present embodiment, the corresponding program is read from the storage device 16 into the RAM 113 and executed.
However, not from the storage device 16 but the storage medium drive 1
7, it is also possible to read the program directly from the external storage medium into the RAM 113 and execute the program. In addition, depending on the spreadsheet processing device, various programs for performing the spreadsheet processing of the present embodiment may be stored in the ROM 112 in advance, and the CPU 111 may execute them.

The communication control device 18 can transmit and receive various data to and from other personal computers and word processors. Input / output I /
F19 is an interface for connecting various devices such as a speaker that outputs sound, music, and the like. The character recognition device 20 is a device for recognizing characters written on paper or the like in various formats such as a text format or HTML, and is configured by an image scanner, a character recognition program, and the like.

In the present embodiment, in addition to the data input from the keyboard 12 (stored in a predetermined storage area of the RAM 113), the data read out from the storage medium drive 17 using the data created externally and stored in a predetermined storage medium, Various data such as data stored in a database in advance, data downloaded from the communication control device 18, and the like can be acquired as data to be subjected to spreadsheet processing (data acquisition means).

Next, one embodiment of the spreadsheet processing method of the present invention, which is an operation of the spreadsheet processing apparatus having the above-described configuration, will be described with reference to FIGS.

FIG. 8 is a flowchart showing the operation of the spreadsheet processing according to this embodiment. In a spreadsheet processor,
As shown in FIG. 8, when the spreadsheet processing is started, first, the CPU 111 enables a new worksheet or a new worksheet to be readable from the RAM 113, the storage device 16, and the storage medium drive device 17 by input from an operator or the like. Get specifications for any of the saved worksheets. When the saved worksheet is designated, the cell width storage area 1131, the cell height storage area 1132, the data storage area 1141, and the space row position storage of the RAM 113 based on the data of the designated worksheet. The values of the area 1151, the space row height storage area 1152, the space column position storage area 1153, and the space column width storage area 1154 are rewritten. Next, a worksheet is displayed on the display device 14 based on the data of each area of the RAM 113 (step 11). When a new worksheet is designated, the values of the above-described areas in the RAM 113 remain at the initial values, and a worksheet based on the initial values is displayed.

FIG. 9 is a diagram showing an example of a state in which a worksheet is displayed on the display device at the start of the spreadsheet processing in the present embodiment. As shown in FIG. 9, in the present embodiment, the upper edge of the worksheet 50 is the first border 51 that displays the column numbers (A, B, C,...), And the left edge is Is a second border 52 for displaying line numbers (1, 2, 3,...). In the present embodiment, the display device 14 displays, on the upper side of the worksheet 50, an active cell coordinate display in which the position of a cell (active cell) to which data is to be input is represented by coordinates using column numbers and row numbers. 53 and an input line 54 for displaying data to be input to the active cell.

After displaying a new worksheet or an existing worksheet on the display device 14, the CPU 11 checks whether a new space row or space column is designated (step 13). The position of the space row or the position of the space column is designated by the operator by the horizontal frame 55 at the position where the space row is inserted or the vertical frame 56 at the position where the space column is inserted (for example, five and six space lines are inserted). If it is desired to insert a line between the lines, this is done by designating a horizontal frame 55) between these lines.

FIG. 10 is a diagram showing a state in which the position of the space row is specified in the worksheet displayed on the display device. In the present embodiment, when the mouse is right-clicked on the worksheet, a space row / column setting mode is set, and the mark of the pointer 57 changes as shown in FIG. And in this space row / column setting mode,
By pointing the horizontal frame line 55 or the vertical frame line 56 and clicking the mouse, the position of the space row or space column is designated, and the space row or space column is arranged at the position of the horizontal frame line 55 or the vertical frame line 56. It has become so.

If the position of a new space row or space column has not been designated (step 13; N), the process directly proceeds to step 21. When the position of a space row or space column is newly specified (step 13; Y),
The CPU 11 obtains space row position data or space column position data from the designated space row or space column position, and stores these data in the space row position storage area 1151 and space column position storage area 1153 of the RAM 113, respectively. (Step 15). At this time, if four data in the space row position storage area 1151 and four data in the space column position storage area 1153 are already stored, the oldest data is discarded and the acquired data is stored. The space row position is stored in Sr1 to Sr4 of the space row position storage area 1151 in accordance with the order of the rows of the worksheet, and the space column position is stored in Sg1 to Sg of the space column position storage area 1153.
4 is stored according to the order of the columns in the worksheet.

The CPU 11 further stores a space row height storage area 1152 and a space column width storage area 1154.
The row height of the newly acquired space row and the column width of the space column are stored as initial values in the space row position storage area 1.
151 and the space row of the space row height storage area 1152, and the space column position storage area 1153 and the space column of the space column width storage area 1154 are associated with each other.
When a space row or space column is newly arranged, the CPU 11 accompanies the cell width storage area 1.
131 and the data of the cell height storage area 1132 are added. That is, when a space column is newly arranged, the data of the cell width storage area 1131 is increased by one, and when a space row is newly arranged, the data of the cell height storage area 1132 is increased by one. .

By clicking on the designated space line position or space column position, the designation of the space line position or space column position is canceled. If the designation of the position is canceled, Is C
The PU 11 discards the corresponding data stored in the space row position storage area 1151 and the space column position storage area 1153 of the RAM 113, and the data in the space row space row height storage area 1152 and the space column width storage area 1154. , The remaining data is rearranged in the order of rows or columns and stored again.

Subsequently, the CPU 111 checks again whether or not the position of the new space row or space column has been designated (step 17). If a new position has been designated (step 17; Y), the CPU 111 returns to step S17. Return to step 15. If no new position is specified (step 17; N), the space row position and space column position stored in the space row position storage area 1151 and space column position storage area 1153, and the space row height storage area Based on 1152 and the space column width storage area 1154, a worksheet 50 in which space rows and space columns are arranged is displayed (step 19).

FIG. 11 is a diagram showing an example of a worksheet displayed after a space row position and a space column position are designated. As shown in FIG. 11, after the position of the space row or space column is newly designated, the worksheet 5
At 0, a new space row or space column is arranged at the designated position, and the cell rows after this new space row are moved to the last cell row side (the lower side in FIG. 11), and The cell row is moved to the last cell row side (right side in FIG. 11) and displayed. At this time, the row height of the space row and the column width of the space column are set to values stored in the space row height storage area 1152 and the space column width storage area 1154. Therefore, when a new worksheet is initially selected, all space rows and space columns are displayed with the row height and column width based on the initial values, and the worksheet is read from a recording medium or the like. In some cases, a newly specified space row or space column is displayed with the default row height or column width, and the space row or space column that was previously placed on the read worksheet is read. It is displayed as a row height or space column.
Space rows and space columns are displayed with a different background color from cell rows and cell columns to which data can be input.

Further, as shown in FIG. 11, the CPU 111 displays a horizontal connecting line 58 connecting the corresponding horizontal frame lines 55 through the space column in the space column, and displays the space line in the space row. Corresponding vertical frame line 56
A vertical connection line 59 connecting the two is displayed. Horizontal connecting line 58
Detects the position where the vertical frame line 56 defining the space column intersects with the corresponding horizontal frame line 55 which forms the same cell row through the space column, and connects the intersection positions to each other. Is displayed. The vertical connection line 59 detects the position where the horizontal frame line 55 that defines the space row intersects with the corresponding vertical frame line 56 that forms the same cell column and that corresponds to the space column through the space row. Displayed by linking.

Next, the CPU 111 checks whether the positions of the horizontal frame line 55 and the vertical frame line 56 have been changed (step 21).
The positions of the horizontal frame line 55 and the vertical frame line 56 are changed by the operator dragging the horizontal frame line 55 and the vertical frame line 56 with a mouse.

FIG. 12 is a diagram showing a state where the column width of the cell column is changed in the worksheet. In the present embodiment, as shown in FIG.
When the mouse is pointed at 5 or the vertical frame line 56 at a place other than the first border 51 and the second border 52, the design of the pointer 57 is changed. In this state, by dragging the horizontal frame line 55 up and down or the vertical frame line 56 left and right and moving it to a desired position, the horizontal frame line 55 and the vertical frame line 56 to be moved and their changes are changed. Later positions are obtained.

At this time, the vertical frame line 56 corresponds to the space row Sg
1, Sg2,... Do not move, and the horizontal frame line 55 does not move beyond the space columns Sr1, Sr2,. That is, the vertical line frame 56 by the pointer 57
Are specified by the space lines Sgn and Sg including the pointer 57.
n + 1, or the first border 51 and the space row S
Only the area between g1 and g1 is effective, and only the vertical frame line 56 between them is moved to the dragged position in the left-right direction. Similarly, the designation of the horizontal frame line 55 by the pointer 57 is performed when the space columns Srm and Srm + 1 including the pointer 57
Or only between the second border 52 and the space row Sr1 is valid, and only the horizontal frame line 55 between them is moved up and down to the dragged position. For example, as shown in FIG. 12, when the vertical frame line 56 is moved rightward above the space line Sg1, the vertical frame line 56 is moved only above the space line Sg1 including the pointer 57, and is moved from the space line Sg1. Below, the vertical frame line 56 is not moved. Note that when a vertical line frame 56 between the first border 51 and the space row Sg1 or a horizontal line frame 55 between the second border 52 and the space column Sr1 is designated and dragged with the mouse, the first frame is displayed. Border 51
Of the column numbers (A, B,...) Or the line numbers (1, 2,...) Of the second border 52 also move with the movement of the vertical line frame 56 or the horizontal line frame. I do.

If the position of neither the horizontal frame line 55 nor the vertical frame line 56 has been changed (step 21; N), the process directly proceeds to step 31. If the horizontal frame line 55 or the vertical frame line 56 has been moved (step 21; Y), the CP
U11 calculates the changed width of the cell column, the height of the cell row, the height of the cell row, the height of the space row, and the value of the space column from the changed position of the acquired horizontal frame line 55 or vertical frame line 56. One of the column width data is obtained, and the cell width storage area 1131 and the cell height storage area 113 of the RAM 113 are acquired.
2. The corresponding data in the space row height storage area 1152 and the space column width storage area 1154 is rewritten (step 23). Note that the movement of the horizontal frame line 55 corresponds to that of the horizontal frame line 5.
5 and only the height of the cell row or space row located above the horizontal frame line 55 is changed.
Similarly, when the vertical frame line 56 is moved, only the width of the cell column or space column that is defined by the vertical frame line 56 and disposed to the left of the vertical frame line 56 is changed.

Subsequently, the CPU 11 again sets the horizontal frame 55
And whether the position of the vertical frame line 56 has been changed (step 2
5) If the position is changed (step 25; Y), the process returns to step 23 again. If there is no change in the position of the horizontal frame line 55 or the vertical frame line 56 (Step 25; N), the cell width storage area 1131, the cell height storage area 1132,
Based on the column width of the cell column stored in the space row height storage area 1152 and the space column width storage area 1154, the row height of the cell row, the space row height, and the space column width,
The worksheet is displayed again (step 27).

FIG. 13 is a diagram showing an example of a worksheet redisplayed after the positions of the horizontal and vertical frame lines are changed. As shown in FIG. 13, in the worksheet 50 after the positions of the horizontal frame line 55 and the vertical frame line 56 are changed, the vertical connection line 5
9 and the horizontal connection line 58 are also changed and displayed in accordance with the positions of the horizontal frame line 55 and the vertical frame line 56.

If the height of the space line is set to 0, the space line is not displayed substantially, so that the vertical frame is displayed as if it were cut off here. If the width of the space column is set to 0, the space column is not displayed substantially, so that the horizontal frame is displayed as if it were cut off here.

Thereafter, similarly to the conventional spreadsheet apparatus and spreadsheet processing method, data is acquired corresponding to each cell by input from an operator's keyboard or the like (step 31). Then, each data and calculation result are displayed (step 33), and the spreadsheet processing of the present embodiment ends. Note that the acquired data is not assigned to the space row and the space column and is not displayed.

FIG. 14 is a diagram showing an example of a state in which data is displayed on a worksheet to create a table. In this worksheet 50, two tables similar to the worksheet 150 (FIG. 15) created by the conventional technique are displayed. The data displayed in the table is the same as that of the prior art. However, this worksheet 50 according to this embodiment
In, the column B used as the unit price column is set wide in the first to fifth rows used in Table 1 of high-priced products, and is set to be 1 to 6 rows used in Table 2 of low-priced products.
On the 0th line, the width is set narrow. Further, the column C used as a column for the purchase quantity is set narrow in the first to fifth rows used in Table 1 having a small quantity, and is set to be narrow from the sixth row used in Table 2 having a large quantity. The tenth line is set wide. As described above, in the present embodiment, even in one worksheet 50, the width of the cell column and the height of the cell row can be set differently according to the data.

In this embodiment, similarly to the prior art, it is also possible to draw a ruled line of various line types on the worksheet 50 or to shade the worksheet to edit and display or print the table. . The vertical connecting lines 59 and the horizontal connecting lines 58 can be displayed and printed in the same manner as the ruled lines.

As described above, in this embodiment, the cell rows 1 and
2, 3,..., A space row Sg1, Sg2,.
Is inserted into the space rows Sg1 and Sg.
.. Can be set with different cell widths via the cell rows A, B, C,. Therefore, according to the present embodiment, by setting different cell widths in one cell row according to the number of digits of input data and the size of characters, data having different widths required for display can be stored in the same cell row. Can be displayed in a good format. In this embodiment, the space column Sr is located between the cell columns A, B, C,.
, Sr2,... Are inserted through the space columns Sr1, Sr2,.
Can be set at different cell heights. Therefore, according to the present embodiment, different cell heights can be set in one cell row according to the number of input data lines and the size of characters, and data having different heights required for display can be set. It becomes possible to display in the same cell row in style.

According to the present embodiment, the space columns Sr1,
.. And the space rows Sg1, Sg2,... Do not participate in the spreadsheet processing, so that the data area is not deformed.

According to this embodiment, the height of the cell rows 1, 2, 3,... And the cell columns A, B, C,.
Can be set differently, without using the OLE function, reducing the burden on the device and the labor of the operator,
Cells can be set according to the number of rows and digits of data and the size of characters.

According to the present embodiment, the same cell row is formed by the horizontal connection line 58, and the corresponding horizontal frame lines 55 are connected and displayed via the space column. Therefore, the space column is interposed in the middle. It can be easily recognized that the cell rows are the same cell row. In addition, since the same cell column is formed by the vertical connection line 59 and the corresponding vertical frame lines 56 are connected and displayed via the space row, the same is applied to the cell column in which the space row exists in the middle. It can be easily recognized as a cell column.

It should be noted that the present invention is not limited to the above-described embodiment, and can be appropriately changed without departing from the gist of the present invention. For example, in the above embodiment, a computer is used as the spreadsheet processing device. However, the present invention is not limited to the computer, and may be a word processor having a spreadsheet processing function. In the above-described embodiment, the division of the cell group is set by setting the space row and the space column by the space setting means, and each division can be identified.
The method of setting the division of the cell group and the method of displaying each division in an identifiable manner are not limited to those in which a space column or space row is interposed. For example, as shown in FIG.
It is also possible to adopt a method of displaying a frame line in a section in a different color, a different pattern thickness, or the like from other frame lines so as to be identifiable, or a method of changing the background color of cells in adjacent sections and displaying them.

In the above-described embodiment, the position of the space row (cell group division) is acquired by designating the horizontal frame 55, and a space row is inserted between the cell rows on both sides of the horizontal frame 55 (space row insertion). Means), the position of the space column (cell group division) is acquired by designating the vertical frame line 56, and the vertical frame line 56 is obtained.
The space column is inserted between the cell columns on both sides of the column (space column insertion means), but the setting of the space row and the space column by the space row setting means and the space column setting means is not limited to this. , The cell row is changed to a space row not involved in the spreadsheet (space row changing means), and by specifying the cell column, the cell row is changed to a space row not involved in the spreadsheet (space Column changing means). In this case, the name (address) of the cell row displayed on the first border 51 and the name (address) of the cell column displayed on the second border are set to be shifted by the space row and the space column. Preferably. This is because deformation of the data area can be avoided.

In the above embodiment, the positions of the space rows and the space columns are designated by pointing with the mouse. However, the method of acquiring the positions of the space rows and the space columns is not limited to this. For example, from the keyboard, enter a cell row pair or cell column pair that sets a space row or space column between them, or enter a cell row that you want to change to a space row or a cell column that you want to change to a space column, etc. It may be. In the above-described embodiment, the column widths of the cell columns and the space columns, and the row heights of the cell rows and the space rows are obtained by dragging and moving the vertical frame lines or the horizontal frame lines with a mouse. May be obtained by inputting the numerical value of.

In the above embodiment, data is input after setting the space row and the space column and changing the column width of the cell column and the space column and the row height of the cell row and the space column. A space row and a space column can be set later, and the column width of the cell and space columns and the row height of the cell row and the space column can be changed. In the above-described embodiment, the space line is arranged by designating the position from the operator. However, after the data is acquired, a space line position detecting unit that detects the position where the space line is arranged is provided based on the acquired data. The space line setting means may automatically arrange the space lines based on the position detected by the space line position detecting means. In the above-described embodiment, the space column is arranged according to the position specified by the operator, but after data acquisition, based on the acquired data,
Space row position detecting means for detecting a position at which the space row is arranged may be provided, and the space row setting means may automatically arrange the space row based on the position detected by the space row position detecting means. . The height of the space row and the width of the space column may be set with only one predetermined value, or may be set by selecting from a plurality of predetermined values.
In the above-described embodiment, only four space columns and four space rows can be set. However, the present invention is not limited to this. The number of space columns and space rows may be set without any particular limitation in a worksheet displayable range. .

In the above embodiment, the connecting lines (horizontal connecting line 58, vertical connecting line 5
Although 9) is displayed, as shown in FIGS. 15 and 16, the connection line 58 ′ may be displayed even when no space column or space row is set. Although FIGS. 15 and 16 illustrate the case where the position of the vertical frame line is different, the same method can be adopted when the position of the horizontal frame line is different. Selection means for selecting whether to display the vertical connection line 59 or the horizontal connection line 58 may be provided.

In the above-described embodiment, the column width of the cell column is obtained by specifying the position of the vertical frame line from the operator. After the data is obtained, the first to the first space line, the space between each space line, and the last line are obtained. It is also possible to provide a column width optimizing means for detecting an appropriate column width based on the data acquired for each of the last row from the space row, and arranging the vertical frame line with this column width. In the above-described embodiment, the row height of the cell row is obtained by the designation of the horizontal frame line position by the operator. After the data is obtained, from column A to the first space column, between each space column,
It is also possible to provide a row height optimizing means for detecting an appropriate row height based on data acquired for each of the last column from the last space column, and arranging a horizontal frame line at this row height. .

In the above embodiment, a plurality of tables having different cell widths and cell heights are displayed on one worksheet.
You can also create a table with different cell widths and heights. In the above-described embodiment, data is displayed one row at a time in one cell. However, as shown in FIG. 17, two or more rows of data can be displayed in one cell. The present invention in which the row height can be changed particularly when displaying a plurality of rows in one cell is useful. In the case where two or more rows of data of one cell can be displayed, it is preferable that the rows are evenly arranged in each of the cells for displaying one row of data and for displaying the data of a plurality of rows. Note that each device, each unit, each operation, each process, and the like described in the above-described embodiment are each a unit (to be referred to as a unit) as a general concept including them.
Thus, the embodiment can be configured. For example, “space line position obtaining means” or “space column position obtaining means” may be configured for the description “acquire space row and space column position (step 13)”. For the description "the appropriate column width is detected based on the data obtained from the first row to the first space row, between each space row, and from the last space row to the last row,""Width detecting means" may be configured. Similarly, for various other operations, "~ (operation)
The embodiment may be configured by a generic concept such as “means”.

[0063]

As described above, according to the spreadsheet processing apparatus according to the first to fifth aspects of the present invention, the worksheet is divided by the division setting means, and each worksheet is divided by the frame position setting means. By simple operation and processing of setting a frame line at a different position for each division, cells with different widths and different heights are set in the same cell column and cell row, and data with different widths and heights required for display Can be displayed in the same cell column and cell row.

According to the spreadsheet processing apparatus according to the second aspect of the present invention, the worksheet can be divided and the division can be identified by setting the space column or space row which is not involved in the spreadsheet processing by the space setting means. Can be displayed.

According to the spreadsheet processing apparatus according to the third and fourth aspects of the present invention, the divisions set in the worksheet are displayed by the worksheet display means so as to be identifiable. Tabulation and reading operations can be easily performed.

According to the spreadsheet processing apparatus according to the fifth aspect of the present invention, the vertical frame line and the horizontal frame line whose positions are set differently on the way are connected by the connection line by the worksheet display means. Is displayed, so you can enter data, create a table,
The reading operation can be easily performed.

According to the storage medium storing the spreadsheet processing program according to the sixth aspect of the present invention, it is possible to provide a computer with a section setting function for dividing a worksheet by section setting means, and a frame line position setting means. Since a frame line position setting means for setting a frame line at a different position for each section is realized, by simple operation and processing, cells having different widths and different heights are set in the same cell column or cell row, Data having different widths and heights required for display can be displayed in the same cell column and cell row in a good format.

[Brief description of the drawings]

FIG. 1 is an embodiment of a spreadsheet processing device of the present invention,
1 is a block diagram illustrating a configuration of a computer from which a spreadsheet processing program according to an embodiment of the present invention has been read.

FIG. 2 is an explanatory diagram showing contents of cell width data stored in a cell width storage area in the embodiment of FIG.

FIG. 3 is an explanatory diagram showing contents of cell height data stored in a cell height storage area in the embodiment of FIG.

FIG. 4 is an explanatory view conceptually showing a space column position data table stored in a space column position storage area in the embodiment of FIG. 1;

FIG. 5 is an explanatory view conceptually showing a space width position data table stored in a space row width storage area in the embodiment of FIG. 1;

FIG. 6 is an explanatory view conceptually showing a space row position data table stored in a space row position storage area in the embodiment of FIG. 1;

FIG. 7 is an explanatory view conceptually showing a space row height data table stored in a space row height storage area in the embodiment of FIG. 1;

FIG. 8 is a flowchart illustrating an operation of a spreadsheet process according to the embodiment of FIG. 1;

FIG. 9 is a diagram illustrating an example of a state in which a worksheet is displayed on a display device at the start of a spreadsheet process in the embodiment of FIG. 1;

FIG. 10 is a diagram illustrating a state in which a position of a space row is specified in a worksheet displayed on the display device of the embodiment of FIG. 1;

11 is a diagram illustrating an example of a worksheet displayed after a space row position and a space column position are specified in the embodiment of FIG. 1;

FIG. 12 is a diagram illustrating a state in which a column width of a cell column is changed in a worksheet displayed on the display device of the embodiment in FIG. 1;

FIG. 13 is a diagram illustrating an example of a worksheet redisplayed after the positions of horizontal and vertical frame lines are changed in the embodiment of FIG. 1;

FIG. 14 is a diagram illustrating an example of a state in which data is displayed on a worksheet and a table is created in the embodiment of FIG. 1;

FIG. 15 is a diagram showing a worksheet displayed in another embodiment of the spreadsheet processing apparatus of the present invention and a storage medium storing the spreadsheet processing program of the present invention.

FIG. 16 is a diagram showing a worksheet displayed in another embodiment of the spreadsheet processing device of the present invention and a storage medium storing the spreadsheet processing program of the present invention.

FIG. 17 is a diagram showing a worksheet displayed in another embodiment of a spreadsheet processing device of the present invention and a storage medium storing a spreadsheet processing program of the present invention.

FIG. 18 illustrates an example of a state in which a table is created on a worksheet displayed in a spreadsheet process by a program outside a storage medium storing a spreadsheet processing apparatus and a spreadsheet processing program according to the related art.

[Explanation of symbols]

 11 control unit 112 ROM 113 RAM 1131 cell width storage area 1132 cell height storage area 1141 data storage area 1151 space row position storage area 1152 space row height storage area 1153 space column position storage area 1154 space column width storage area 12 keyboard 13 Mouse 14 display device 15 printing device 16 storage device 161 kana-kanji conversion dictionary 162 program storage 163 table format storage

Claims (6)

[Claims] 1. A data acquisition unit for acquiring data corresponding to the cells of a worksheet divided into cells by vertical and horizontal frame lines, and a spreadsheet process based on the data acquired by the data acquisition unit. And a worksheet display means for displaying the worksheet and displaying data acquired by the data acquisition means or data after spreadsheet processing in the spreadsheet cells in cells of the displayed worksheet. A frame line position setting unit that sets the position of the frame line; and a division setting unit that divides the worksheet into a cell group formed by a plurality of adjacent cells. The setting means is capable of setting the frame lines over a plurality of sections divided by the section setting means at different positions for different sections. Computing device. 2. The spreadsheet according to claim 1, wherein the division setting means sets the worksheets by setting a space row or a space column that is not involved in the spreadsheet processing between the divisions. Processing equipment. 3. The worksheet display unit displays the worksheet so that the sections divided by the section setting unit can be identified.
Alternatively, the spreadsheet processing device according to claim 2. 4. The worksheet display means displays the worksheet with respect to a frame line set at a different position for a different section so that correspondence of the frame line in each section can be confirmed. The spreadsheet processing device according to any one of claims 1 to 3, wherein 5. The worksheet display device according to claim 4, wherein said worksheet display device includes a connection line display device for displaying a connection line connecting frame lines set at different positions for different sections. Spreadsheet processing device as described. 6. A data acquisition function for acquiring data corresponding to the cells of a worksheet divided into cells by vertical and horizontal frame lines, and a spreadsheet process based on the data acquired by the data acquisition function. And a worksheet display function of displaying the worksheet and displaying data acquired by the data acquisition function or data after spreadsheet processing by the spreadsheet function in cells of the displayed worksheet. A frame line position setting function of setting the position of the frame line; and a partition setting function of partitioning the worksheet into a cell group formed by a plurality of adjacent cells. A storage medium storing a computer-readable spreadsheet processing program, wherein the frame position setting function is performed by the section setting function. Partitioned plurality of the border over the division, different storage medium spreadsheet processing program is stored, which is a settable in different positions relative to the segment.