JP2004259301A - List compilation method and list compilation device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a list compilation method and a list compilation device capable of arranging inputted data in a cell in a balanced manner regardless of cell width. <P>SOLUTION: In a list compilation device for compiling a list expressed by combination of rectangular cells, the cells are selected by a selection means composed of a cell-to-cell movement part, a cell selection part and a cell connection part, and a selection region comprising the cells is defined. Next, when a character string is evenly allocated into the selection region selected by the cell selection means, a width equivalent to a character-to-character pitch obtained by dividing the width of the cell by a numerical value of the number of inputted characters + 1 is secured in distances from the middle part between the head character and the last character of the character string outputted to the selected cells to both ends of the respective cells in the selection region by a display control part; and the character string is evenly allocated to the remaining region of the selection region and displayed on a screen of a display part. <P>COPYRIGHT: (C)2004,JPO&NCIPI

Description

  The present invention relates to a table editing method and a table editing apparatus for editing a cell (input field) and setting a format of data in a cell when performing spreadsheet calculation in a document creation processing device such as a workstation, a personal computer, and a word processor. About.

  2. Description of the Related Art Conventionally, as a table editing apparatus, there is an apparatus which edits a cell and processes a format of data in a cell when performing a spreadsheet calculation (see Japanese Patent Application Laid-Open No. 2-132549 (Patent Document 1)). As shown in FIG. 23, the table editing apparatus edits character and numeral data input in a table frame according to the editing attribute data shown in FIG.

  Further, as another table editing device, as shown in FIG. 25, when a character is input to a cell, it is detected whether or not the input character has overflowed from a cell in an area surrounded by a table frame. When overflow is detected, the number of characters that can be input to the cell can be increased based on the current cell's character size, character pitch (character width), line pitch (line spacing), and display / printable registration size. In some cases, a character size, a character pitch, and a line pitch are determined, and character data in a cell is rearranged in accordance with the determined character size, the character pitch, and the line pitch (for example, Japanese Patent Laid-Open No. 2-255958 (Patent Document 2)). )reference).

  Further, as another table editing apparatus, as shown in FIG. 26, cell information is expressed by a cell start character + text + cell end character in units of cells, and a large number of these cell information are connected to form the entire table. There is a configuration that enables editing on a cell-by-cell basis (see, for example, Japanese Patent Application Laid-Open No. 2-289957 (Patent Document 3)).

  Still another table editing apparatus has a means for editing a table represented by a combination of rectangular cells, a means for comparing the contents of data in a cell, and a means for integrating two adjacent cells. (For example, see Japanese Patent Application Laid-Open No. 3-123396 (Patent Document 4)). This table editing apparatus operates a matrix in the table shown in FIG. 27 or edits data in a cell, and when data in two cells having one side having the same length in adjacent cells are equal (for example, FIG. 27). 2A and 4B, 3B and 3C, etc.) and two adjacent cells are integrated into one cell as shown in FIG.

  By the way, in the table editing apparatus described in Japanese Patent Application Laid-Open No. 2-132549, in a cell of a title part (one line in the uppermost row shown in FIG. 23) excluding a cell of a numerical part for which a spreadsheet is calculated, one selection area is provided. It is possible to set the alignment of the data to be left-aligned, right-aligned, center-aligned, and both-end aligned. However, if the data arrangement is centered, the cell width should be well-balanced for title characters as shown in FIG. 29 (A), but if the cell width is particularly wide, FIG. As shown in ()), the characters may be closer to each other than the entire cell width, and the balance may be poor. In addition, when the data arrangement is aligned on both ends, the cell width may be a well-balanced cell width for the title character as shown in FIG. 29 (C). As shown in D), there is a disadvantage that the characters are too far apart from each other, resulting in poor balance and prolongation.

  Further, in the table editing apparatus, in the cell of the title portion, when data is contained in one selected area, an attribute is set in one cell. However, since there is no means for connecting a plurality of cells, the connected cells are not connected. There is a drawback that data attributes cannot be set collectively using a plurality of cell regions as one input unit. For example, when inputting a title that extends over two or more cells arranged in the row direction, input a title only in the first cell as shown in FIG. 30 or input a plurality of titles as shown in FIG. The title data must be divided into cells and entered separately, and the data arrangement in each cell must be set to right alignment, center alignment, left alignment, etc. Therefore, there is a drawback in that data must be input for each of a plurality of cells, and the format setting such as arrangement of the input data is performed for each cell, so that it is troublesome to create a title.

  Further, in the table editing apparatus described in Japanese Patent Application Laid-Open No. Hei 3-123963, cells that are adjacent to each other have the same length, and the cells are integrated when the data in the two cells are equal. The condition that all cells have the same data and the condition that the height of one side of adjacent cells is the same or the cell width is the same are required, so that there is a problem that there are many restrictions and it is difficult to use.

  In all of the above table editing apparatuses, when inputting a title that extends over two or more cells arranged in the column direction, as shown in FIG. Input to the cell of the row with the best balance, and set the format of the cell to be right-aligned, center-aligned, left-aligned, etc. When the number of the plurality of cells is an odd number, as shown in FIG. 33, the data may be arranged in a cell located at the center thereof. However, when the number of the plurality of cells is an even number, as shown in FIG. Since the data cannot be arranged exactly at the center, there is a disadvantage that the balance as the title is poor.

  In all of the above table editing devices, if the cell width is not sufficient, or if you want to create a well-balanced table, the orientation of the title character should be vertical and the cell width should be the minimum necessary. it can. In this case, the title is divided into cells in a well-balanced row for each character and input, and the cell layout is set to right alignment, center alignment, left alignment, etc. It should be placed almost in the center. However, even in vertical writing, if the number of cells is even and the number of characters is odd, or if the number of cells is odd and the number of characters is even, it cannot be placed exactly in the center, so There is a disadvantage that the balance is poor. In addition, "", "" ",". " When there are characters such as "", "," and "-", there is a disadvantage that they are very unsightly as shown in FIGS.

  Further, in the table editing device described in Japanese Patent Application Laid-Open No. 2-255958, as shown in FIG. 25, when there is a character overflowing from a cell, the character size is reduced to fit in the cell. Since the balance of the entire table is not taken into account and the data is simply entered in the preset cells, the table is not easy to read.

In the table editing apparatus described in Japanese Patent Application Laid-Open No. Hei 2-28957, when a cell overflows in a fixed cell width, as shown in FIG. To the next row, so you can't control the line breaks, and the placement of the data in the expanded cell is solid, and to get a well-balanced title, There is a problem that the operation is troublesome because a space character must be appropriately inserted at the end.
JP-A-2-132549 JP-A-2-255958 JP-A-2-289057 JP-A-3-123396

  Therefore, an object of the present invention is to provide a table editing method and a table editing apparatus capable of arranging input data in cells in a well-balanced manner regardless of the cell width.

  In order to achieve the above object, a table editing method according to the present invention is directed to a table editing method for editing a table expressed by a combination of rectangular cells. When arranging columns equally, the character string output to the selected cell has a width corresponding to a character pitch obtained by dividing the width of the cell by the number of input characters + 1 in the area of the selected cell. A distance from the center of the first character and the last character to both ends of each of the cells, and equally allocates the character string to the remaining area of the selected cell area. And

  According to the table editing method, a character string can be arranged in a cell in a well-balanced manner regardless of the cell width.

  Further, the table editing apparatus of the present invention is a table editing apparatus for editing a table represented by a combination of rectangular cells, wherein the cell selecting means for selecting the cell and defining a selection area including the cell, When equally allocating a character string in the selection area selected by the cell selection means, the selected area has a width corresponding to an inter-character pitch obtained by dividing the cell width by the number of input characters + 1. The distance between the center of the first character and the last character of the character string output to the cell and the two ends of each cell is secured, and the character string is evenly distributed over the remaining area of the selection area. And display means for allocating and displaying the information.

  According to the table editing apparatus, the character strings can be arranged in the selected area in a well-balanced manner regardless of the cell width.

  Hereinafter, a table editing method and a table editing apparatus according to the present invention will be described in detail with reference to an embodiment.

  FIG. 1 is a block diagram of a table editing apparatus according to an embodiment of the present invention. The table editing device includes an input unit 20 serving as a data input unit for inputting characters and symbols by key input of a keyboard (not shown) or the like, and a pen or mouse (hereinafter, referred to as a mouse) not shown serving as a keyboard and a pointing device. In this case, a pen is also included.) An inter-cell moving unit 21 for moving an area of a cell to be input by the user, and 1 or 1 with a keyboard or a mouse of the input unit 20 based on the cell area moved by the inter-cell moving unit 21. A cell selection unit 22 for selecting a plurality of continuous cells as a selection area; a cell data input editor unit 23 as data editing means for editing data input from the input unit 20 or data whose contents have been updated; When a continuous cell is selected by the inter-cell moving unit 21 and the cell selecting unit 22, a plurality of cells are selected. And a data arrangement setting unit as a data arrangement setting unit for a selected area, which sets an arrangement format of data input to the selected area. 25, when the data input from the input section 20 or the data edited by the cell data input editor section 23 exceeds the width of the selection area, a selection area for allowing a plurality of rows of data to be input to the selection area. And a multi-line setting unit 26 as a multi-line setting unit for use. Further, when the selection area is set to a plurality of rows by the plurality of rows setting section 26, a cell height expansion section 27 as a cell height expansion means for expanding the height of the selection area, and the plurality of rows setting section 26 A format data storage unit serving as format data storage means for a selection area for storing format data representing the data layout of the selection area set by the data layout setting unit 25 based on the set number of rows; A data storage unit 29 as data storage means for a selected area for storing data input from the memory unit 20 or edited from the cell data input editor unit 23, and format data stored in the data storage unit 29. It has an editing unit 30 as a selection area editing unit for editing based on the format stored in the storage unit 28, and has data edited by the editing unit 30. A display control unit 31 as a display means for displaying the data on a screen of a display unit 33 to be described later, a print control unit 32 for printing a table having data formatted and edited by the editing unit 30, and a display control unit 31 A display unit 33 that receives a display signal and displays a table on an LCD (liquid crystal display) or a CRT (cathode ray tube) or the like; And a printing unit 34 for printing a table. The inter-cell moving unit 21, the cell selecting unit 22, and the cell connecting unit 24 constitute a cell selecting unit.

  FIG. 2 shows the internal data structure of the data storage unit 29 storing the data input to the selection area and the format data storage unit 28 storing the format of the data.

  As shown in FIG. 2, the internal data structures of the data storage unit 29 and the format data storage unit 28 include a header section 210 as header information of a spreadsheet file and a cell for storing all data for each cell in the table. Data 1 (220), cell data 2 (280),..., Cell data Z (290). The header section 210 stores the number of columns 211, the number of rows 212, and other data (date and the like) in the table. The cell data 1 (220) includes an attribute section 230 and a data section 260. The attribute section 230 includes a column number 231 indicating a cell position, a row number 232, a character size 233 of data in the cell, A height 234, a cell width 235, an ID 236 indicating the arrangement of the characters of the data in the cell in the horizontal direction, an ID 237 indicating an arrangement of the characters of the data in the cell in the vertical direction, An ID 238 indicates whether the character of the data in the cell is written horizontally or vertically, an ID 239 indicates whether the cell is connected, and a ruled line is shown in the upper 251 / lower 252 / left 253 / right 254. It is composed of a ruled line ID 250 indicating whether or not there is, and other (data indicating attributes such as font name) 240. The data section 260 includes a data ID 261 representing the type of the data (for example, numerical values, mathematical expressions, and characters), and data 262 in which actual data is stored. The cell data 2 (280) following the cell data 1 (220) stores information of the next cell and has the same configuration as the cell data 1 (220). To the cell data Z (290) storing the information of the last cell of the table composed of the number of columns 211 and the number of rows 212.

  FIG. 22 shows an example of a keyboard used for the input unit 20. An edit key 701 for editing data, an arrangement key 702 for arranging data in the selected area, an arrow key 703 for moving the selected area, 704, 705, 706 (hereinafter abbreviated as arrow keys), an execution key 708, a release key 707, and the like.

  FIG. 21 shows a screen displayed on the display unit 33 when the data layout setting unit 25 shown in FIG. 1 sets the layout format of the data in the selected area. When the layout key 705 shown in FIG. The processing of the arrangement setting in the server starts. In FIG. 21, the horizontal position 410 of the data in the cell is selected from any of the following five types: left-justified 411 / center 412 / right-justified 413 / justified 414 / centered 415. That is, the horizontal position is set by selecting the circle button on the left side of the corresponding item with the mouse, and the selected circle button becomes a double circle. Alternatively, the number can be selected by inputting a numeral on the left side of the corresponding item from the keyboard of the input unit 20 using a numerical key. In addition, the setting of the vertical position 420 of the data in the cell is selected from among five types of top-aligned 421 / center 422 / bottom-aligned 423 / both-end alignment 424 / both-end center 425. The vertical position is set by selecting the circle button on the left side of the item to be set, and the selected circle button becomes a double circle. Alternatively, the number can be selected by inputting a number on the left side of the corresponding item from the keyboard of the input unit 20 using a numerical key.

  The selection of horizontal writing and vertical writing of the data in the cell is made by selecting the circle button on the left side of the Y / character string 450 with the mouse, while the horizontal button on the left side of the T / character string 460 is selected by the mouse. Then, it becomes vertical writing. At this time, the selected round button is a double circle. Also, by inputting "Y" using the keyboard of the input unit 20, horizontal writing can be performed, and by inputting "T", vertical writing can be performed. Then, when ending the format setting in the cell, the user selects the execution button 430 with the mouse or presses the execution key 780 of the input unit 20.

  To cancel the currently set format setting, the user selects the cancel button 440 with the mouse or presses the cancel key 707 of the input unit 20. The initial setting of the cells not set by the data arrangement setting unit 25 is such that the horizontal position is left-justified, the vertical position is the center, and the horizontal / vertical writing is vertical.

  Hereinafter, selection, connection, and movement of a plurality of cells will be described with reference to flowcharts in FIGS. 5 and 6 and display screen examples in FIGS. 7, 8, and 9.

  First, the selection and connection of cells will be described with reference to FIG. As shown in FIG. 7 (a), when the current cell position is at A1, when selecting a cell selection area from B1 to C1, as shown in FIG. Is moved from B to B1. In FIG. 6, it is determined whether or not the current cell is connected in step S3101, and if it is determined that the cell is not connected, the process proceeds to step S3111. Next, in step S3111, it is determined whether to select a plurality of cells, and the process advances to step S3112 to select a plurality of cells. At this time, if it is a key, the selection area is moved by pressing the arrow key while pressing the "Shift" key, thereby selecting the cells B1 to C1 as the selection area as shown in FIG. 7C. In the case of a mouse, the cell from B1 to C1 is selected as a selection area by selecting B1 with the mouse and moving it to C1 by dragging. Next, in step S3113, the plurality of link IDs 261 of the format data storage unit 28 corresponding to the selection areas from B1 to C1 are turned on, and the process advances to step S3114 to display the linked cells as one block. , And ends the cell selection and connection processing.

  On the other hand, if it is determined in step S3111 that a plurality of cells are not to be selected, the process advances to step S3115 to select the current cell position, and ends the cell selection and connection processing. That is, only the currently selected B1 is selected.

  Next, when moving the connected cell, for example, B1 and C1 are connected and B1 to C1 are displayed as one block, and it is assumed that the cell is located at the current cell position or A1 (FIG. 8 (a)). ))). First, in step S3051 shown in FIG. 5, it is determined whether or not the current cell is connected. When the right arrow key is pressed, it is determined in step S3051 that the cells are not connected, and the flow advances to step S3055 to move one cell to B1 (shown in FIG. 8B). Next, the process proceeds to the cell selection and connection processing of FIG. 6, and in step S3101, it is determined whether the current B1 is connected. Since the cells B1 and C1 are connected, it is determined in step S3101 that the cells are connected, and the flow advances to step S3102 to display the plurality of connected cells as one block (in FIG. 8B, B1 And C1). Next, in step S3103, it is determined whether or not to select a plurality of cells. If it is determined that a plurality of cells are not to be selected, the process advances to step S3107 to select the current cell for movement (FIG. 8 (b) )).

  Next, when the right arrow key is pressed, it is determined again in step S3051 whether or not the current cell is connected. If it is determined that the current cell is connected, the process proceeds to step S3053, and the connection is performed. The process moves to D1 outside the range, and proceeds to steps S3101, S3111, and S3115 in the cell selection and connection processing of FIG. 6, and selects the current D1.

  Further, a process of updating the selected area of a plurality of cells will be described with reference to FIG. As shown in FIG. 9A, when cells from B1 to C1 are currently selected and the area is changed to the selection area from B1 to D1, the process proceeds to steps S3101, S3102, S3103, and S3104, and proceeds to step S3104. Select multiple cells. That is, as shown in FIG. 9 (b), when expanding the cell selection area, in the state where B1 to C1 are selected, if the key is pressed, press the right arrow key while pressing the "shift" key. To select the cells from B1 to D1 as a selection area. In the case of a mouse, B1 is selected with the mouse and moved to D1 by dragging, thereby selecting the cells from B1 to D1 as a selection area. As shown in FIG. 9 (c), when the cell selection area is reduced, the cells from B1 to C1 are selected. By pressing and moving the key, only the cell B1 is selected in step S3104. In the case of a mouse, when B1 is selected with the mouse, the cells from B1 to C1 are selected, and only the cell of B1 is selected by dragging from C1 to B1. Then, in step S3105, the link IDs of the cells B1 to C1 previously selected in the format data storage unit 28 are cleared, and the flow advances to step S3106 to select only the cell of B1 currently selected, and The update process ends.

  Hereinafter, the data input / edit processing will be described with reference to the flowchart of FIG.

  As shown in FIG. 10 (E) and FIG. 10 (F), when the both ends are to be centered within one cell, first, in step S305, the selection area is moved by an arrow key or a mouse, and the process proceeds to step S310. Select and concatenate. Then, in step S315, it is determined whether or not the cell is a target cell. If it is determined that the cell is a target cell, the process proceeds to step S320. If it is determined that the cell is not a target cell, the process returns to step S305.

  Next, in step S320, it is determined whether or not data is to be input into the cell. If it is determined that data is to be input into the cell, the process proceeds to step S321. In step S321, data is input. Proceed to S335. On the other hand, if it is determined in step S320 that data is not to be input into the cell, the process proceeds to step S330. Next, in step S330, it is determined whether or not the data in the cell is to be corrected. If the data is to be corrected, the process proceeds to step S331, the edit key 701 is pressed, and the process proceeds to step S333. Then, the data is corrected in step S333. Next, the process proceeds to step S335, where the data input in step S321 and the data corrected in step S333 are stored in the data storage unit 29. Next, in step S336, it is determined whether or not the input data includes a plurality of rows. If the input data does not include a plurality of rows, the process proceeds to step S340 shown in FIG. When the button is pressed, the process proceeds to step S350 to activate the data arrangement setting unit 25. Then, a horizontal position is selected in step S351, a vertical position is selected in step S352, and the direction of the character string is selected in step S353. That is, in the in-cell arrangement setting screen (shown in FIG. 21) displayed on the display unit 33, for example, the horizontal position is set at the center 415 at both ends, and the vertical position and the character direction are respectively the default values of the center 422 and the horizontal. The direction is 450. When the execute button 430 is executed in step S359, the process proceeds to step S360, and the data arrangement setting unit 25 stores the set attribute data in the format data storage unit 28.

  Next, in step S370, it is determined whether to increase the height of the connected cells. That is, it is determined whether or not to increase the height of the selected region including a plurality of connected cells. If the height of the connected cells is to be increased in step S370, the process proceeds to step S377. If the height of the connected cells is not to be increased, the process proceeds to step S378. Next, in step S378, the display unit 33 displays a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit. At this time, for example, if the attribute of the cell is the center 415 at both ends as the center of both ends, the width of the cell is divided by the number of characters input to the cell + 1, and the result is set as the character pitch CP1. The character string is displayed on the screen of the display unit 33 so that a space for CP1 / 2 is automatically arranged before the first character and after the last character (FIG. 10F). Then, the selection of the cell is canceled in step S379.

  Next, in step S390, it is determined whether or not there is a print instruction. If there is a print instruction, the process proceeds to step S391. If there is no print instruction, this process ends. Then, in step S391, the printing unit 34 prints a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28, and ends this processing. At this time, if the attribute is the center 415 at both ends, the cell width is divided by the number of input characters + 1, and the result is set as the inter-character pitch CP1, before the first character and after the last character of the character string. Printing is performed by the printing unit 34 so that a space corresponding to CP1 / 2 is automatically arranged (FIG. 10F).

  FIG. 10E is a display example when the width of the cell is not so large. FIGS. 10A and 10B show a conventional display example in which both ends are aligned, and FIGS. 10C and 10D show a conventional display example in which the center is aligned. Further, FIGS. 10A, 10C, and 10E are display examples when the cell width is not so wide, and FIGS. 10B, 10D, and 10F are when the cell width is wide. 5 is a display example.

  Next, as shown in FIG. 11, a description will be given of an arrangement of data over a plurality of cells continuous in the row direction.

  First, in step S305, the cell selection area is moved using the arrow keys or the mouse, and the flow advances to step S310 to select cells B1 to D1 as selection areas using the arrow keys or the mouse on the keyboard. That is, in the case of the keyboard, B1 is first selected with the arrow keys, and the arrow keys are moved while pressing the "shift" key, thereby selecting the cells from B1 to D1 as the selection area. In the case of a mouse, the cell from B1 to D1 is selected as a selection area by selecting B1 with the mouse and moving it to D1 by dragging.

  Then, in step S315, it is determined whether or not the cell is a target cell. If it is determined that the cell is a target cell, the process proceeds to step S320. If it is determined that the cell is not a target cell, the process returns to step S305. Next, in step S320, it is determined whether or not data is to be input into a cell. If data is to be input into a cell, the process proceeds to step S321. Data is input at step S321, and the process proceeds to step S335. On the other hand, when data is not input into the cell in step S320, the process proceeds to step S330. Then, in step S330, it is determined whether or not the data in the cell is to be corrected. If the data in the cell is to be corrected, the process proceeds to step S331, the edit key 701 is pressed, and the process proceeds to step S333. Next, the data is edited in step S333, and the process proceeds to step S335, where the data input in step S321 and the data edited in step S333 are stored in the data storage unit 29.

  Next, when arranging data in a cell in step S340 shown in FIG. 4, the arrangement key 702 is pressed, and the data arrangement setting unit 25 is activated in step S350. Then, a horizontal position is selected in step S351, a vertical position is selected in step S352, and the direction of the character string is selected in step S353. In other words, the data arrangement setting unit 25 sets the horizontal position to the center as shown in FIG. 11A, or sets the horizontal position to both ends as shown in FIG. 11B. As shown in FIG. 11 (c), the horizontal position is set at the center of both ends, and the character direction is kept at the default horizontal direction. When the execute button 430 is executed in step S359, the process proceeds to step S360, and the data arrangement setting unit 25 stores the set attribute data in the format data storage unit 28. Next, in step S370, it is determined whether to increase the height of the connected cells. That is, it is determined whether or not to increase the height of the selected region including a plurality of connected cells. If the height of the connected cells is to be increased in step S370, the process proceeds to step S377. If the height of the connected cells is not to be increased, the process proceeds to step S378. Then, in step S378, the display unit 33 displays a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28.

  Next, in step S390, it is determined whether or not there is a print instruction. If there is a print instruction, the process proceeds to step S391. If there is no print instruction, this process ends. Then, in step S391, the printing unit 34 prints a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28, and ends this processing.

  Next, as shown in FIGS. 12A and 12B, data that spans a plurality of cells continuous in the column direction will be described.

  First, a plurality of continuous cells in the column direction from A2 to A5 are selected and connected in steps S305, S310, and S315 in the same manner as in FIG. Then, in step S320, it is determined whether or not data is to be input into the cell. When data is to be input into the cell, the process proceeds to step S321. After the data is input from the keyboard as it is, the process proceeds to step S335. If no data is entered in the cell in step S320, the flow advances to step S330 to determine whether to edit the data in the cell. If the data in the cell is to be edited, the flow advances to step S331 to edit the data in the cell. The user depresses the key 701 and corrects data in step S331. Then, the data is edited in step S333. Next, the data input or the corrected data is stored in the data storage unit 29 in step S335. Next, in step S336, it is determined whether or not the input data has a plurality of lines, and the process proceeds to step S340 shown in FIG.

  Then, when arranging data in the cell in step S340, the arrangement key 702 is pressed, and the data arrangement setting unit 25 is activated in step S350. Hereinafter, the above-described steps S351 to S377 are processed, and the horizontal position is set to both ends in FIG. 12A by the data arrangement setting unit 25, and the horizontal position is set to the center of both ends in FIG. 12B. Then, the vertical position is set to the center, and the character direction remains the default horizontal direction. After the execution button 430 is executed, the attribute of the arrangement setting is stored in the format data storage unit 28. Then, in step S378, the display unit 33 displays a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28. Next, after canceling the cell selection in step S379, the process proceeds to step S390.

  Next, in step S390, it is determined whether or not there is a print instruction. If there is a print instruction, the process proceeds to step S391. If there is no print instruction, this process ends. Then, in step S391, the printing unit 34 prints a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28, and ends this processing.

  As shown in FIGS. 13 (a) and 13 (b), in the case where the arrangement of data extending over a plurality of cells continuous in the column direction is vertical writing, except for setting the character direction to vertical writing, FIG. The description is omitted in the same manner as (a) and (b).

  Next, a case where a plurality of rows are input in one cell as shown in FIG. 14 will be described.

  First, when data exceeding the cell width is input into one cell, when a line feed code is input as the end of a row in the cell, the input data and the corrected data are stored in the data storage unit 29 ( S335), the cell height setting unit 27 stores the value obtained by enlarging the cell height in the format data storage unit 28, and automatically enlarges the height of this cell. Then, the multi-line setting unit 26 can input data subsequent to the next line, and can input data of two or more lines (S337). At this time, when the height of the selected cell is the largest among the cells in the same row, the cell height setting unit 27 also changes the height of the cell in the same row (S338). That is, when the height of the selected cell is enlarged, the height of the cell in the same row as the selected cell is adjusted to the height of the enlarged cell. Then, when setting the cell arrangement, the data arrangement setting unit 25 is activated (S350), and the arrangement in the cell in the free line direction in the cell is left-aligned / center-aligned / right-aligned / both-edge-aligned / both-center-aligned. , And the arrangement in the column direction is any one of top alignment / center alignment / bottom alignment / both ends alignment / both ends center alignment (S351, S352, S353, S359) .

  Further, a case where a plurality of rows are input in one cell as shown in FIG. 15 will be described.

  First, when data exceeding the cell width is input into one cell, if a space or a prohibited character such as ",", "." The corrected data and the corrected data are stored in the data storage unit 29 (S335), and the cell height setting unit 27 stores the value obtained by enlarging the cell height in the format data storage unit 28. Automatically increase height. Then, the multi-line setting unit 26 can input data subsequent to the next line, and can input data of two or more lines (S337). At this time, when the height of the selected cell is the largest among the cells in the same row, the cell height setting unit 27 also changes the height of the cell in the same row (S338). That is, when the height of the selected cell is enlarged, the height of the cell in the same row as the selected cell is adjusted to the height of the enlarged cell. Then, when setting the cell arrangement, the data arrangement setting unit 25 is activated (S350), and the arrangement in the cell in the free line direction in the cell is left-aligned / center-aligned / right-aligned / both-edge-aligned / both-center-aligned. , And the arrangement in the column direction is any one of top alignment / center alignment / bottom alignment / both ends alignment / both ends center alignment (S351, S352, S353, S359) .

  FIG. 16 shows a table in the case where a plurality of lines are input into a cell using both the line feed code and the prohibition processing.

  Next, as shown in FIG. 17, a case will be described where free arrangement is performed in a selection area where a plurality of cells connected in a row direction are connected, and a plurality of rows are input to the selection area.

  First, cells from B1 to D1 are selected as selected areas by using arrow keys on the keyboard or a mouse (S310). When selecting a plurality of cells using the keyboard, B1 is first selected with an arrow key, and the cells from B1 to D1 are selected as selected areas by moving the arrow keys while pressing the "shift" key. In the case of a mouse, B1 is selected with the mouse, and is moved to D1 by dragging, thereby selecting a cell region from B1 to D1 (S310). At this time, if the data is input (S320), the data is directly input from the keyboard (S321), and if the data of the cell is to be corrected (S330), the edit key 701 is pressed (S331) to correct the data (S331). S333) is performed.

  At this time, when inputting data exceeding the width of the selection area, enter a line feed code as the end of the line of the selection area, or enter a space or a prohibited character such as ",", "." When the process occurs, the input data and the corrected data are stored in the data storage unit 29 (S335), and the cell height setting unit 27 stores the value obtained by enlarging the cell height in the format data storage unit 28. At the same time, the height of this cell is automatically enlarged. Then, the multi-row setting unit 26 enables data following the next row to be input, and inputs two or more rows of data (S337). At this time, when the height of the selected cell is maximized, the height of the related row, that is, the cell in the same row as the selected cell is also changed (S338). When data is to be arranged in the selected cell, the arrangement key 702 is depressed (S340), and the data arrangement setting unit 25 is activated (S350). In FIG. 17, when the execute button is executed by setting the horizontal position to the center and the character direction to the default horizontal direction by the data arrangement setting unit 25, the attribute of the arrangement setting of the horizontal position is stored in the format data storage unit 28. Remember. The display unit 33 displays a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28 (S378). Further, when there is a print instruction (S390), the printing unit 34 prints a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28 (S391). .

  In addition, as shown in FIG. 18, a case will be described where free arrangement is performed in a selection area in which a plurality of cells connected in a column direction are connected, and a plurality of rows are input in the selection area.

  First, cells A2 to A5 are selected as selection areas by using the arrow keys on the keyboard or the mouse (S310). When selecting a plurality of cells using the keyboard, A2 is first selected by an arrow key, and the area of cells A2 to A5 is selected by moving the arrow keys while pressing the "shift" key. In the case of a mouse, the cell from A2 to A5 is selected as a selection area by selecting A2 with the mouse and moving it to A5 by dragging (S310). At this time, if the data is input (S320), the data is directly input from the keyboard (S321), and if the data of the cell is to be corrected (S330), the edit key 701 is pressed (S331) to correct the data (S331). S333) is performed.

  At this time, when inputting data exceeding the width of the selection area, the prohibition processing is performed by inputting a line feed code as the end of the line in the cell, or by inputting a space or a prohibited character such as “,”, “.”. When this occurs, the input data and the corrected data are stored in the data storage unit 29 (S335), and the cell height setting unit 27 stores the value obtained by enlarging the cell height in the format data storage unit 28. And automatically increase the height of this cell. Then, the multi-line setting unit 26 can input data subsequent to the next line, and can input data of two or more lines (S337). At this time, when the height of the selected cell is maximized, the height of the related row, that is, the cell in the same row as the selected cell is also changed (S338). Then, when arranging the data in the selected cell, the arrangement key 702 is depressed (S340), and the data arrangement setting unit 25 is activated (S350). In FIG. 18, when the horizontal position is set to the center by the data arrangement setting unit 25, the arrangement in the column direction is centered at both ends, and the character direction is kept as the default horizontal direction, the execution button is executed. The attribute of the arrangement setting is stored in the format data storage unit 28. Further, the display unit 33 displays a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28 (S378). Further, when there is a print instruction (S390), the printing unit 34 prints a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28 (S391). .

  Also, as shown in FIG. 20, in a selection area in which a plurality of cells connected in the column direction are connected, when the data of the vertically written character increases and the height of the cell increases, the same The case where the height of the cell in the row is increased will be described.

  If the table shown in FIG. 19 has already been created, after moving to A2 (S305), a cell is selected (S310). The cells from A2 to A5 are selected as the selected area, and the selected areas are connected to show one block. The edit key 701 is pressed on this cell (S330, S331) to edit the data contents (S333). The input data and the corrected data are stored in the data storage unit 29 (S335). If the length of the corrected data is longer than the height of the selected area (S370), the cell The height of the selected area is enlarged by the height setting unit 27, and the height of the selected cell, that is, the cell of the same row other than the selected area, is increased by the editing unit 30 at the same ratio (S377). Further, the display unit 33 displays a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28 (S378). Further, when there is a print instruction (S390), the printing unit 34 prints a table having the data stored in the data storage unit 29 based on the format data stored in the format data storage unit 28 (S391). . FIG. 19 shows a diagram before the height of the cell is automatically enlarged.

  In this way, in the part of the data other than the numerical data and the calculation data used in the spreadsheet, for example, in the selected area selected for the table heading, the data arrangement format (editing attribute) of the selected area is collectively set. By doing so, characters can be arranged in the selected area in a well-balanced manner without being restricted by the width and height of the selected area.

  Further, in the selection area of a plurality of cells continuous in the row direction by the cell connection unit 24, the selection area is connected as one input unit (one block), so that the data arrangement in the leading end area can be freely arranged. It can be set, and there is no trouble of inputting data and setting an arrangement format for each cell. Therefore, the layout format can be collected and set only in the leftmost cell among the cells continuous in the row direction of the selection area, and the operability when editing the table can be improved. The data arrangement setting unit 25 sets the format of the arrangement in the selection areas connected in the row direction by the cell connection unit 24, for example, the line alignment of left alignment, center alignment, right alignment, both ends alignment, and both ends center alignment. Thereby, the arrangement of characters such as titles can be more balanced.

  Further, in the selection area of a plurality of cells that are continuous in the column direction by the cell connection unit 24, by connecting the selection area as one input unit, the data arrangement of the selection area can be freely set. In addition, there is no need to input data and set an arrangement format for each cell. Therefore, the layout format can be collected and set only in the uppermost cell among the cells continuous in the column direction of the selection area, and the operability when editing the table can be improved. In the above-mentioned selection area, the data layout setting unit 25 sets the layout format, that is, top alignment, center alignment, bottom alignment, both ends alignment, and both ends center alignment. It can be well balanced.

  Further, since the data direction can be written vertically by the data arrangement setting unit 25, for example, the cell width of the cell to be the title can be reduced, and the screen width of the display unit 33 is limited, When the paper width is limited, the cell width of the other cells can be increased by reducing the cell width, a table with a more flexible layout can be created, and the table is well-balanced and easy to read.

  When data exceeding the width of the selected area is input to the selected area, the height of the selected area is automatically set by the cell height setting unit 27 by inputting a line feed code and a prohibited character as the end of the line. The data subsequent to the next line can be input by the multi-line setting unit 26 after being enlarged. Therefore, since two or more rows of data can be input to a selection area composed of one or more cells, a large amount of data can be stored in a selection area having a limited width.

  In addition, when the height of the selected area is enlarged by the cell height setting unit 27, the height of the enlarged selected area can be matched with the heights of all cells in the same row. A good table can be created.

  When data exceeding the width of the selected area is input to the selected area connected in the row direction or the column direction by the cell height setting section 27 and the plural row setting section 26, longer data is used as the selected area. Can be entered.

  Further, when data exceeding the height of the selected area is input to the selected area of a plurality of cells continuous in the column direction, the height of the selected area is automatically enlarged by the cell height setting unit 27, and the enlarged area is selected. The heights of the other cells are enlarged at the same ratio so that the heights of the areas of the other cells in the same row as the selected selection area become the heights of the enlarged selection areas. By adjusting the height of the cell to the area of another cell in the same row, a particularly well-balanced table can be created.

  In the above embodiment, a plurality of cells that are continuous in one of the row direction and the column direction are selected as the selection area by using the inter-cell moving unit 21 and the cell selection unit 22. Needless to say, a plurality of cells continuous in both the row direction and the column direction may be connected.

FIG. 1 is a configuration diagram of a table editing apparatus according to one embodiment of the present invention. FIG. 2 is a diagram showing the structure of the format data storage unit and the internal data of the data storage unit of the table editing device. FIG. 3 is a flowchart showing the operation of the table editing device. FIG. 4 is a flowchart showing the operation of the table editing device. FIG. 5 is a flow chart showing the processing operation of cell movement of the table editing device. FIG. 6 is a flowchart showing the cell selection and connection processing operation of the table editing apparatus. FIGS. 7A to 7C are diagrams showing selection of a plurality of cells. FIGS. 8A to 8C are diagrams showing cell movement. FIGS. 9A to 9C are diagrams showing updating of a region of a plurality of cells. FIGS. 10A to 10F are diagrams showing the line alignment in one cell. FIGS. 11A to 11C are diagrams showing line alignment in a selection area arranged in the row direction. FIGS. 12A and 12B are diagrams showing row alignment in a selection area arranged in the column direction. FIGS. 13 (a) and 13 (b) are diagrams showing column alignment in a selection region arranged in the column direction. FIG. 14 is a diagram showing input of a plurality of lines by a line feed code. FIG. 15 is a diagram showing input of a plurality of lines by a space, “,”. FIG. 16 is a diagram showing a table in which a plurality of rows are input by the prohibition processing. FIG. 17 is a diagram showing input of a plurality of rows in a selection area arranged in the row direction. FIG. 18 is a diagram showing input of a plurality of rows in a selection area arranged in the column direction. FIG. 19 is a diagram illustrating a state before the heights of a plurality of cells arranged in the column direction are enlarged. FIG. 20 is a diagram illustrating a state after the heights of a plurality of cells arranged in the column direction are enlarged. FIG. 21 is a diagram showing an arrangement setting screen in a cell. FIG. 22 is a diagram showing a key arrangement of a keyboard of the input unit. FIG. 23 is a diagram showing a table created by a conventional table editing device. FIG. 24 is a diagram showing the character attributes and the like in the above table. FIG. 25 is a diagram showing a table created by another conventional table editing apparatus. FIG. 26 is a diagram showing a table created by another conventional table editing apparatus. FIG. 27 is a diagram showing a table created by another conventional table editing apparatus. FIG. 28 is a diagram showing connection of cells of a table created by the table editing apparatus. 29 (A) to 29 (D) are diagrams showing conventional row alignment in one cell. FIG. 30 is a diagram showing a conventional row alignment in a plurality of cells arranged in a row direction. FIG. 31 is a diagram showing a conventional row alignment in a plurality of cells arranged in a row direction. FIG. 32 is a diagram showing a conventional row alignment in a plurality of cells arranged in a column direction. FIG. 33 is a diagram showing conventional row alignment in a plurality of cells arranged in a column direction. FIG. 34 is a diagram showing a conventional row alignment in a plurality of cells arranged in a column direction. FIG. 35 is a diagram showing conventional vertical writing in a plurality of cells arranged in a column direction. FIG. 36 is a diagram showing conventional vertical writing in a plurality of cells arranged in a column direction.

Explanation of reference numerals

20: input unit, 21: inter-cell moving unit, 22: cell selecting unit,
23: cell data input editor section, 24: cell connection section,
25: data arrangement setting unit, 26: multiple line setting unit,
27: cell height setting unit, 28: format data storage unit,
29: data storage unit, 30: editing unit, 31: display control unit,
32 print control unit, 33 display unit, 34 print unit.

Claims (2)

In a table editing method for editing a table represented by a combination of rectangular cells,
When the cell is selected and the character string is evenly allocated in the area of the selected cell, the character pitch is obtained by dividing the width of the cell by the number of input characters + 1 in the area of the selected cell. A corresponding width is secured at a distance from the center of the first character and the last character of the character string output to the selected cell to both ends of each cell, and the area of the selected cell is A table editing method, wherein the character strings are evenly allocated to the remaining area. In a table editing device for editing a table represented by a combination of rectangular cells,
Cell selection means for selecting the cell and defining a selection area consisting of the cell;
When equally allocating a character string in the selection area selected by the cell selection means, the selection area is set to a width corresponding to a character pitch obtained by dividing the cell width by the number of input characters + 1. Securing the distance from the center of the first character and the last character of the character string output to the cell to both ends of each cell, the character string is stored in the remaining area of the selection area. A table editing device comprising: display means for equally allocating and displaying.

Images