JPH0619892A - Table frame forming method - Google Patents

Abstract

PURPOSE:To disperse with manual changing of width and to improve operability at the time of preparing a table by automatically extending a string width having the input area of the data within the size of paper desired to print a display in accordance with the size of data at the time of inputting data in the table. CONSTITUTION:In an information processor, when data is inputted, display data is prepared, and extension string width serching part 202 decides whether the extension of a present data input area is necessary or not, a necessary display data length is set in a changing string table 203 from a string where a necessary data input area exists and maximum display data in the string and a string width storage table 201 is updated like 201a. Furthermore, a paper size decision part 204 prepares a string width storage table 201b by recalculating the string width so as to match with paper when the sum (TW) of the string widths of the all the strings of the string width storage table 201a is larger than the width (SW) of paper desired to print. Thus, a table is prepared by automatically changing the string width along with data input.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table frame shaping method for creating a table using an information processing device such as a computer.
In particular, it relates to a table frame shaping method that enables high-speed table shaping according to the paper size and improves operability.

[0002]

2. Description of the Related Art Conventionally, when creating or modifying a table, as described in, for example, Japanese Patent Laid-Open No. 59-68038, numerical values, character data are input and an arbitrary data input area is displayed while looking at a display screen. An interactive method was adopted in which the calculation results were automatically calculated according to the values entered in and a table was created. At the stage of creating the table, the length of the input data, the calculation result by the calculation formula, the display format of the data set in each data input area, and the width of the column with an arbitrary data input area can be changed depending on the paper size of the table. Will be needed. As a method of changing the width of the data input area, after creating the data in the table format, the data is manually changed so as to match the display data and the paper size on which the table is printed.
As described in Japanese Patent No. 268366, there is a method in which data is created in a tabular form and then a table frame that matches the length of each data is created by handling the character data by an automatic form creation method.
In addition to this, as described in JP-A-63-75964 and JP-A-3-38774, the data input area is changed depending on the length of the text data input to each data input area. There was a method of making a table by partially modifying the data input area width of the containing row and column and automatically changing the data input area width.

[0003]

In the former method shown in the above-mentioned prior art, since the data using the spreadsheet function is automatically created as the text data on the displayed paper size, the interactive table No consideration was given to the display during creation and modification, and there were problems such as confirmation of the data layout on the front screen at the creation stage and lack of the display area of the data input area for the data. In the latter case, no consideration is given to the case where the data input to each data input area is other than text data or when the display data changes due to other factors, and the calculation set for each data input area is not taken into consideration. The problem that does not change the data input area width for the calculation result calculated by the formula or the format of the display data, or when the data input area width is changed by the input data, the created table does not fit the paper size you want to print. , There was a problem of having to set again. An object of the present invention is to provide a table frame shaping method suitable for improving such problems and improving operability when creating a table.

[0004]

In order to achieve the above object, in the table frame shaping method of the present invention, data is input by designating one of the data input areas, or is set for each data input area. Calculate the formula and specify the size (paper size)
When the length of the data to be displayed is larger than the column width of the column having the data input area, the expanded width search unit in the column width change processing unit outputs the column including the data input area. Calculates the optimum column width for display, and the paper size determination unit determines whether or not the entire table created with that column width fits within the specified size. Is reset by the ratio of the optimum column width calculated above, and the column width is automatically changed according to the display data.

[0005]

According to the present invention, when the length of the data displayed by the data input and the calculation result of the calculation formula is larger than the column width of the column having the data input area for displaying the data, the display is performed. Calculate the length of the data to determine the optimal column width. In addition, it is determined whether the size of the entire table created with the changed column width fits in the desired paper size, and the column width of each column is expanded or reduced by the ratio of the column width calculated above, To create. This eliminates the need to manually change the column width and improves the operability when creating a table.

[0006]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail below with reference to the drawings. FIG. 1 is a functional configuration diagram of an information processing apparatus according to an embodiment of the present invention. In FIG. 1, the input unit 101
Is an input device such as a pointing device or a keyboard. Further, the data analysis unit 102 includes the input unit 10
The data input from 1 is the numerical value for the data input area,
It is determined whether it is an input of a character and a calculation formula, an input indicating execution of a command, or an input of data for executing a set calculation formula. As a result, when the input data indicates the execution of the command, the command control unit 103 selects the required command processing from the command group processing unit 109 and operates it. Also, the calculation formula control unit 1
04 is the data input by the data analysis unit 102, or the result of processing the command by the command control unit 103,
It operates when it is necessary to execute the set calculation formula, executes the calculation formula set in an arbitrary data input area, and calculates a value. Further, the data input area attribute determination unit 105, when displaying the input data, the calculation output, and the command processing result in each data input area, specifies the character arrangement and the numerical value in the data input area set in each data input area. The attribute such as the designation of the number of display digits is determined and passed to the column width change processing unit 106 together with the output data. Column width change processing unit 1
06 determines whether the display data determined by the data input area attribute determination unit 105 can fit within the data input area. If not, the column width of the column having the data input area is set to the paper size. Then, the data is passed to the screen control unit 107. This data is
It is displayed on the screen display unit 108. The screen display unit 10
Reference numeral 8 is an output device such as a CRT display.

The table frame shaping method of this embodiment will be described next. FIG. 2 is a diagram showing an outline of the function of the column width change processing unit in the embodiment of the present invention, and FIG. 3 is a flow chart showing the table frame shaping method in the embodiment of the present invention. As shown in FIG. 3, when data, commands, and calculation formulas are input to the table being created (301), data setting, command execution, and calculation formula execution (302) are performed to create the data to be displayed. (303). When the data to be displayed is created, the display format of the data is determined according to the attribute of each data input area, and the data to be displayed is reconstructed (30
4). Next, in the column width change processing unit 106, the extended column width search unit 202 shown in FIG. 2 refers to the column width representing the data input area of each column from the column width storage table 201 (30
5) It is determined whether or not there is display data that requires expansion of the data input area (306). If so, a column having a data input area that requires expansion is searched (307), and the data in that column is searched. A table 203 having the maximum length is searched for among the display data which requires expansion of the input area (308), and the display data length and column number obtained by adding 2 bytes of the margin are changed.
Set to. Based on this information, the column width storage table 20
Update 1 as 201a (update by display data length)
(309). Further, the paper size determination unit 204 determines whether the sum of the column widths (TW) of all columns of the updated column width storage table 201a is larger than the set paper width (SW) (310). As a result, when the width is large, the column width of each column is reset so that the table fits the width of the sheet. Therefore, the column width set in the column width storage table 201a is the sum of the column widths of all columns and the sheet width. (311), and re-updated (re-updated by paper width) as in the column width storage table 201b (312). The column width of each column is determined from the column width storage table 201b (31
3). Display data is displayed in each data input area according to the display format with the column width (314). As a result of the determination by the paper size determination unit 204, the column width storage table 201
If the sum of the column widths (TW) of all the columns of a is not larger than the set sheet width (SW), the process directly skips to step 313. In this way, the column width is automatically changed according to the display data in accordance with the input.

[0008]

According to the present invention, each time data is input in the table creation stage, it is determined whether the data fits in the data input area frame, and if it does not fit, the length of the input data and the output As a result, the column width can be automatically expanded within the size of the paper size on which the table is printed. This eliminates the need to wait for the final table creation result before adjusting to the paper size, and during data entry, the column width cannot be changed manually by not being able to display the data within the data entry area frame. improves.

[0009]

[Brief description of drawings]

FIG. 1 is a functional configuration diagram of an information processing apparatus according to an embodiment of the present invention.

FIG. 2 is a diagram showing an outline of a function of a column width change processing unit in the embodiment of the present invention.

FIG. 3 is a flowchart showing a table frame shaping method according to an embodiment of the present invention.

[Explanation of symbols]

 101 Input Unit 102 Data Analysis Unit 103 Command Control Unit 104 Calculation Formula Control Unit 105 Data Input Area Attribute Determination Unit 106 Column Width Change Processing Unit 107 Screen Control Unit 108 Screen Display Unit 109 Command Group Processing Unit

Claims (1)

[Claims] 1. A method of creating and displaying a table having a plurality of data input areas arranged in a matrix within a specified size, wherein the length of data to be displayed is a column of columns having the data input area. If the width is larger than the width, the optimum column width for displaying the column including the data input area is calculated from the length of the display data, and the size of the entire table created with the calculated column width falls within the specified size. As described above, the table frame shaping method is characterized in that the column width is automatically changed according to the display data.