JP2007115024A - Automatic column width adjustment method for table - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an optimized automatic column width adjustment method when displaying a table, capable of automatically adjusting a column width so as to substantially minimize the vertical width of the table, even if the column width of the table is not specified clearly. <P>SOLUTION: The sum of the data lengths of data for the respective columns of the table is obtained, the data length of the data of the entire table is obtained, and the ratio of the data lengths of the respective columns to the data length of the entire table is obtained and defined as the initial value of the ratio of the respective column widths with respect to the entire horizontal width. Among the cells of the respective columns within prescribed rows, the number of newlines of the cell of the maximum column width and the number of newlines of the column, where the number of newlines is maximum, are compared. When the number of newlines of the column, where the number of newlines is maximum, is larger than the number of newlines of the cell of the maximum column width, the processing of adjusting the column width, by reducing the column width of the column of the maximum column width by a prescribed amount and increasing the column width of the column, where the number of newlines is maximum by the reduced prescribed amount is repeated, until the number of newlines of the cell of the maximum column width becomes equal to or larger than the number of line feeds of the column where the number of line feeds is a maximum. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention automatically adjusts the vertical width of the table when the table is displayed on a Web browser, etc., so that the table is contained within a predetermined horizontal width and the table structure itself is easy to see. The present invention relates to a column width automatic adjustment method to be adjusted.

  With the spread of the Internet, browsing web pages has become quite commonplace. In particular, a table structure is often used to make it easy to see the aggregated data.

  Usually, to display the table structure on the Web, for example, a table tag of HTML (HyperText Markup Language) language is used as shown in FIG. FIG. 2 shows a specific example of the table structure displayed on the browser (generic name of software used when browsing a Web page) based on the HTML of FIG. The character string enclosed by td tags shown by 41 to 44 in FIG. 4 corresponds to one cell shown by 21 to 24 in FIG. 2, and is further enclosed by tr tags to make a line delimiter. Is formed.

When the table structure is displayed in this way, the display area may not fit within the screen width of a browser or the like. In order to eliminate this inconvenience, several techniques have been proposed. For example, Patent Document 1 discloses an image conversion technique for output of a facsimile terminal so that an image or a table that protrudes from the browsing screen can be accommodated within the resolution of the facsimile terminal by reducing the image or changing the vertical and horizontal directions. . Patent Document 2 discloses a technique for providing a browser that does not require horizontal scrolling by adjusting an input field on a homepage so as not to exceed the width of the screen. Patent Document 3 discloses a technique for displaying an image by replacing it with a substitute image when the display size of the image exceeds the size of the display screen, and downloading and displaying the image when the image is selected. Has been. Patent Document 4 discloses a technique for adjusting and displaying the display contents so that each portlet display area falls within the screen when the portal screen is displayed.
Japanese Patent Laid-Open No. 11-15749 JP 2002-63016 A JP 2002-91849 A JP 2004-252688 A

  By the way, each of the techniques described in Patent Documents 1 to 4 described above is such that the screen is adjusted so as not to scroll, or the table is adjusted so that the table fits within a predetermined horizontal width. It is not the kind of correction that makes it easy to see. For example, if these conventional techniques are used to display a table without specifying any column width, it is adjusted to an equal width regardless of the amount of data, and the vertical width of the entire table becomes very long. There is a problem that it is difficult to visually grasp the entire table. Although this problem can be solved by manually adjusting the column width, it takes time and effort to do so.

  An object of the present invention is to optimize a column width at the time of a table display which can automatically make the column width almost the minimum even if the column width of the table is not explicitly specified. It is to provide a column width automatic adjustment method.

  In order to achieve the above object, the present invention provides a table column width automatic adjustment method for automatically adjusting each column width of a table when the table is displayed or printed using a computer, the computer comprising a data length The analysis means calculates the sum of the data lengths of the data for each column of the table, and the column width assumption means provided in the computer further sums the sum of the data lengths of the respective columns to add the data length of the data of the entire table Determining the ratio of the data length of each column to the data length of the entire table, and setting the ratio of the data length of each column as an initial value of the ratio of the column width to the horizontal width of the entire table; The final column width determination means provided in the computer compares the number of line breaks in the cell with the maximum column width with the number of line breaks in the column with the maximum number of line breaks, out of the cells in each column in the predetermined row. If the number of line breaks in the column with the largest number of line breaks is greater than the number of line breaks in the cell with the maximum column width, the column width of the column with the maximum column width is reduced by a predetermined amount, and the column of the column with the largest number of line breaks Repeating the process of adjusting the column width by increasing the width by the predetermined amount until the number of line breaks in the cell having the maximum column width is equal to or greater than the number of line breaks in the column having the maximum number of line breaks. Features.

  According to the present invention, the number of line breaks of the cell with the maximum column width is compared with the number of line breaks of the column with the maximum number of line breaks, and the number of line breaks of the column with the maximum number of line breaks is greater than the number of line breaks of the cell with the maximum column width. If the table width is larger, the column width is adjusted between those columns, so even if the table column width is not explicitly specified, the column width is automatically reduced to a smaller overall table width. Can be almost minimized.

  Hereinafter, an embodiment of an optimized column width automatic adjustment method at the time of table display to which the present invention is applied will be described.

  FIG. 1 is a hardware configuration diagram of a system to which a column width automatic adjustment method according to an embodiment of the present invention is applied. Reference numeral 11 denotes an input unit such as a keyboard and a mouse for inputting data. Reference numeral 12 denotes a data processing unit that collects a central processing unit, a main storage device, and the like that process data. Reference numeral 13 denotes an external storage device such as a hard disk. Reference numeral 14 denotes a display unit such as a display. In the data processing unit 12, a Web browser is operating, and a Web page on an intranet or the Internet can be browsed via a network (not shown). Such a configuration can be realized by installing software such as a Web browser on a general-purpose computer. In particular, a program for realizing the column width automatic adjustment method for table display according to the present invention operates by being incorporated into a Web browser in the form of plug-in software, for example.

  FIG. 2 shows a display example of a table before performing automatic column width adjustment according to the present embodiment. Since the column width is not appropriately assigned to the column 22 having the largest data amount, the vertical width of the entire table is extended. In the state of this sample, you can see the whole at a glance, so it is not difficult to see yet, but if it is over many pages, it becomes a very difficult table to see.

  FIG. 3 is a display example of the table after the column width automatic adjustment according to the present embodiment. Since the maximum column width is assigned to the column 32 with the largest amount of data, and the width of each column is optimized according to the amount of data for other columns, the vertical width of the entire table is reduced, It can be seen that the data is easy to see.

  FIG. 4 is an HTML representation of the table of FIG. Data 21 in the table of FIG. 2 corresponds to the representation 41 in FIG. Similarly, 22 in FIG. 2 corresponds to 42 in FIG. 4, 23 in FIG. 2 corresponds to 43 in FIG. 4, and 24 in FIG. 2 corresponds to 44 in FIG. Enclose expressions 41 to 44 with tr tags. A group of tr tags corresponds to one row of the table. Subsequent lines are defined similarly.

  FIG. 5 is an HTML representation of the table of FIG. Data 31 in FIG. 3 corresponds to the representation 51 in FIG. Similarly, 32 in FIG. 3 corresponds to 52 in FIG. 5, 33 in FIG. 3 corresponds to 53 in FIG. 5, and 34 in FIG. 3 corresponds to 54 in FIG. The difference from FIG. 4 is that the column width is specified in the respective td tags of the expressions 51 to 54. 20% in the column 51, 50% in the column 52, 15% in the column 53, and 15% in the column 54, each of which is specified as a percentage, and specifies what percentage of the total width of the table is allocated.

  When a predetermined web page is displayed on the browser in the system of FIG. 1 of the present embodiment, if the table structure is included in the web page, the data processing unit 12 causes the data length of FIG. The analysis step, the column width assumption step of FIG. 7, and the final column width determination step of FIG. 8 are executed in order to automatically adjust the column width. Thereby, for example, the tables as shown in FIGS. 2 and 4 are automatically adjusted as shown in FIGS.

  FIG. 6 is a flowchart showing the data length analysis step. First, the table data is stored in an n × m array (step 62). Hereinafter, the maximum value of the number of rows in the table is n, and i is used as a loop counter for the number of rows. Similarly, the maximum value of the number of columns in the table is m, and j is used as a loop counter for the number of columns. For example, in the tables of FIGS. 2 and 4, n = 5 and m = 4. i takes 0,1, ..., n-1 and j = 0,1, ..., m-1.

  Next, in order to loop the number of rows in the table, 0 is set in the row number counter i (step 63). The following processing is repeated while the value of i is smaller than n (step 64). Initially, each column is processed for the first row of the table (i is 0).

  Next, 0 is set in the column number counter j to loop the number of columns in the table (step 65). The following processing is repeated while the value of j is smaller than m (step 66). The array a [j] is an area for storing the total data length in the column j. For each column, the data length (data length of data to be displayed in the cell of row i and column j (corresponding to the first cell in the table)) is added to this array in bytes (step 67). ). In addition, it is assumed that 0 is stored in the array a [j] as an initial value at the start of the process of FIG. The value of the counter j is incremented by 1, and the processing in step 67 and step 68 is repeated as long as the condition of j <m is satisfied.

  When the condition of j <m is not satisfied, the loop of j is exited, and the value of i is increased by 1 (step 69) in order to process the next line, and the process returns to the state before the determination of step 64.

  Through the above processing, the sum of the data lengths of the columns for the entire table is acquired. When the above processing is completed, the sum of the data lengths of each column j is set in the array a [j]. After the process of FIG. 6, the process of FIG. 7 is performed.

  FIG. 7 is a flowchart showing the column width assumption step. The purpose here is to further add up the data lengths of the columns using the array a created in the data length analysis step of FIG. 6 and assume what percentage of the total width of the table should be assigned to each column. The first indicator is to create.

  First, 0 is set in the column number counter j to loop the number of columns in the table, and 0 is set in the variable total for totaling all data lengths in the table (step 72). The following processing is repeated while the value of j is smaller than m (step 73). The total value for each column is further summed for all columns to obtain the total value of the data length of the entire table (step 74). The value of the counter j is incremented by 1 (step 75), and the processing of step 74 and step 75 is repeated as long as the condition of j <m is satisfied.

  When the condition of j <m is not satisfied, the loop of j is exited (step 73), and 0 is set to the column number counter j to loop again for the number of columns of the table (step 76). The following processing is repeated while the value of j is smaller than m (step 77). What percentage of the total width of the table is allocated for each column is stored in the array b (step 78). The calculation formula is obtained by “(total sum of data length of each column a [j] / total data length of table) × 100 (rounded to the first decimal place)”. The value of the counter j is incremented by 1 (step 79), and the processing of step 78 and step 79 is repeated as long as the condition of j <m is satisfied.

  Through the above processing, the first assigned value for each column for the entire table is acquired. That is, in the processing up to this point, the ratio (% value) of the column width of each column j when the width of the entire table is 100% is set in the array b [j]. After the process of FIG. 7, the process of FIG. 8 is performed.

  FIG. 8 is a flowchart showing the final column width determination step. First, the width value of the entire table is acquired from the system side (specifically, a browser or the like) and set to T_WID (step 82). It is assumed that the width value is expressed in a predetermined unit. For example, a value expressed in millimeters or inches, the number of dots on the display screen, or the number of characters counted with a predetermined font.

  Next, in order to loop the number of rows in the table, 0 is set to the row number counter i (step 83). The following processing is repeated while the value of i is smaller than n (step 84). Here, true is set to the flag flg for determining that the optimization is completed in the currently processed line i (step 85). While flg is true, the optimization process continues (step 86).

  Next, the specific value of the column width in each column of row i is specified (step 87). Since the value acquired in array b [j] is a ratio, the specific width value of each column is identified using the width (T_WID) of the entire table acquired in step 82 and the value of array b [j]. And stored in the array c [j]. This process is performed for each column of the table by a loop process using the counter j, and at this time, the counter value j indicating the column having the maximum column width is held in max_l_j.

  Next, the number of line breaks in each column of row i is specified (step 88). This processing starts from the array c [j] having the specific value of the column width of each column created in step 87 and the data of each column (data to be displayed in the cell of row i column j) in the cell of row i column j. The number of lines that have a new line is calculated and stored in the array d [j]. In this process, the number of lines to be obtained when actually displayed is determined in consideration of the size and format of the display font. Further, this process is performed for each column by a loop process using the counter j, and at this time, a counter value j indicating a column having the maximum number of line breaks is held in max_c_j.

  Next, it is determined whether or not the number of line breaks in the column with the largest number of line breaks (max_c_j column) is greater than the number of line breaks in the column with the maximum column width (max_l_j column) (step 89). Here, if the determination result in step 89 is false, flg is set to false (step 8c), and after the determination in step 86, the value of i is incremented by 1 in step 8d, and the next row of the table Move on to processing. If the determination result in step 89 becomes true, it is determined that the column width is not optimized, and one is subtracted from the value of the column width b [max_l_j] of the maximum column width (step 8a). Then, 1 is added to the value of the column width b [max_c_j] of the column of the maximum number of line breaks (step 8b). Thereafter, the process returns to step 86, and the process of determining whether or not the column width is optimized is performed again, and the process is repeated until flg becomes false. Steps 89, 8a, and 8b are, in summary, comparing the number of line breaks in the cell with the largest number of line breaks with the number of line breaks in the cell with the maximum column width, and if the former is larger, the latter column width is 1%. This is a process of adjusting the column width by increasing the former column width by 1%. Here, the amount is increased or decreased by 1%, but the amount to be increased or decreased is arbitrary.

  By performing the above processing over all rows, an optimized table can be completed in which the vertical width of the table can be reduced to a minimum and the horizontal width is adjusted according to the data amount of each column width. . Finally, since the column width ratio in the percentage expression of each column j is set in the array b [j], the column width designation of each column as shown in 51 to 54 in FIG. Just do it.

  FIG. 9 is an explanatory diagram summarizing FIGS. 2 and 3 before and after applying one embodiment of the present invention. This shows the application image of the present invention in an easy-to-understand manner.

  In the above embodiment, the application example in which the table is displayed by the browser has been described. However, the present invention is not limited to this, and the present invention can be applied to various cases of displaying or printing the table.

It is a hardware block diagram which gives the example of 1 embodiment of this invention. It is a figure which shows the example of a table display before giving one embodiment of this invention. It is a figure which shows the example of a table display after giving one embodiment of this invention. 3 is an HTML representation of FIG. 4 is an HTML representation of FIG. It is a flowchart which shows a data length analysis step. It is a flowchart which shows the assumption step of column width. It is a flowchart which shows the last column width determination step. It is explanatory drawing put together before and after giving one embodiment of this invention.

Explanation of symbols

  11 ... Input unit, 12 ... Data processing unit, 13 ... External storage device, 14 ... Display unit.

Claims (1)

A method for automatically adjusting a column width of a table for automatically adjusting each column width of the table when displaying or printing the table using a computer,
A data length analyzing means provided in the computer, obtaining a sum of data lengths of data for each column of the table;
Column width assumption means provided in the computer further calculates the data length of the data of the entire table by further summing the sum of the data lengths of the columns, and determines the ratio of the data length of each column to the data length of the entire table, Setting the ratio of the data length of each column as an initial value of the ratio of each column width to the horizontal width of the entire table;
The final column width determination means provided in the computer compares the number of line breaks of the cell with the maximum column width with the number of line breaks of the column with the maximum number of line breaks among the cells of each column in the predetermined row, and the cell with the maximum column width When the number of line breaks of the column with the maximum number of line breaks is larger than the number of line breaks of the column, the column width of the column with the maximum column width is reduced by a predetermined amount, and the column width of the column with the maximum number of line breaks is Repeating the process of adjusting the column width by quantitatively increasing the number of line breaks in the cell with the maximum column width until the number of line breaks is equal to or greater than the number of line breaks in the column with the largest number of line breaks. Automatic width adjustment method.

Images