JP4992386B2 - Table editing apparatus and program - Google Patents

Description

  The present invention relates to a table editing apparatus and program for copying copy source table data and pasting it into paste destination table data.

  2. Description of the Related Art Conventionally, in many software, when a user specifies and copies desired data and then specifies a paste destination, a function of pasting the copied data to the paste destination is installed.

As a technique related to this copy / paste function, for example, Japanese Patent Application Laid-Open No. 2004-228561 is pasted when the copy source software application on the data supply side and the paste destination software application on the data consumption side are different. A method is described for extending the paste function so that the data structure and formatting of the data is maintained as it was applied to the pre-paste data.
JP 2004-265402 A

  By the way, in a table editing (spreadsheet) software application (hereinafter referred to as table editing software) for editing a table, a user specifies and copies desired data, and then specifies a paste destination. Of the data in the copy source cell, not only the value but all data attribute data including formatting are pasted to the paste destination. When not all the data attributes constituting the data of the copy source cell are reflected in the paste destination, for example, in the table editing software, the table in the range B2: D5 shown in FIG. 14 is copied and B4 in FIG. : In the case where the invoice shown in FIG. 16 is created by specifying the range of D7 and pasting, among the plurality of data attributes constituting the data of the copy source cell at the time of the paste operation, the paste An operation to specify the data attribute to be reflected first is required. Also, when the paste extension function is used in the above-described Patent Document 1, an operation for specifying the paste extension function to be reflected in the paste destination at the time of pasting with an interface as shown in FIG. Furthermore, even if the copy source cells are grouped into one block, if the combination of data attributes to be reflected in the paste destination is different, the user blocks the copy source for each combination of data attributes to be reflected in the paste destination. The operation of specifying the copy source, the copy instruction, the paste destination, and the selection of the data attribute to be pasted must be repeated for each block.

  Also, for example, in the copy source table data shown in FIG. 26, when the user wants to paste only the data of the row containing the word “new product notice” in the E column to the paste destination, It is cumbersome because it is necessary to determine whether or not pasting is possible by looking at the contents of column E, and to specify and copy the lines that allow pasting one by one, and paste to the paste destination.

  The subject of this invention is improving the operativity at the time of copy / paste.

  According to the present invention, in a table editing apparatus for copying / pasting table data, setting means for setting permission conditions for permitting paste for each block of table data to be pasted, and setting contents set by the setting means are stored. Storage means, and paste control means for executing paste on the basis of the setting contents stored in the storage means when copying the copy source table data and pasting the paste to the paste destination table data. It is characterized by.

  According to the present invention, in a table editing apparatus for copying / pasting table data, setting means for setting permission conditions for permitting copying for each block of table data to be copied, and setting contents set by the setting means , A copy control means for copying the copy source table data based on the setting contents stored in the storage means, and the table data copied by the copy control means as the paste destination table data And a paste control means for pasting the paste.

  According to the present invention, permission conditions for permitting paste can be set in advance for each block of paste-destination table data, so that the user can copy the data included in the copy-source table data during copy / paste. There is no need to specify the data that can be pasted to the paste destination and paste to the paste destination, and specify the copy source table data at once and paste to the paste destination table data at once. By only performing the operation, it becomes possible to paste only the data permitted in each block of the pasted table data, and the operability at the time of copying / pasting can be improved.

  Further, according to the present invention, the permission condition for permitting copying can be set in advance for each block of the copy source table data, so that the user can copy the copy source table each time copy / paste is performed. It is no longer necessary to specify the data that is permitted to be copied from the data contained in the data and copy and paste it to the paste destination. When copying / pasting, specify the source table data in batch and paste You can copy and paste only copy-permitted data from the source table data to the past destination by simply pasting to the destination table data. Can be improved.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

(Embodiment 1)
FIG. 1 is a block diagram showing a functional configuration of a table editing apparatus 1 according to an embodiment of the present invention. As shown in FIG. 1, the table editing apparatus 1 includes a CPU 11, an input device 12, a display device 13, a RAM 14, a storage device 15 that stores table editing software 151, and the like. It is connected.

  A CPU (Central Processing Unit) 11 reads a system program stored in the storage device 15, develops it in a work area formed in the RAM 14, and controls each device of the table editing device 1 according to the system program. Further, the CPU 11 reads out various processing programs stored in the storage device 15 and develops them in the work area, and executes various processes in cooperation with the read-out programs.

  The input device 12 includes a keyboard having character / alphanumeric input keys, cursor keys, various function keys, and the like, and a mouse that is a pointing device, and a key pressing signal that is pressed by the keyboard. An operation signal from the mouse is output to the CPU 11 as an input signal.

  The display device 13 is configured by an LCD (Liquid Crystal Display), a CRT (Cathode Ray Tube), or the like, and displays various screens in accordance with various instructions input from the CPU 11.

  A RAM (Random Access Memory) 14 forms a work area for temporarily storing a system program executed by the CPU 11, various processing programs, data being processed in each processing, processing results, and the like.

  The storage device 15 is configured by an HDD (Hard Disc Drive), a nonvolatile semiconductor memory, or the like, and stores a system program executed by the CPU 11, various processing programs, various data, and the like. These various programs are stored in the form of readable program codes, and the CPU 11 sequentially executes operations according to the program codes.

  In the present embodiment, the storage device 15 stores table editing software 151 as shown in FIG. The table editing software 151 is software for editing table data in a worksheet (for example, the worksheet shown in FIG. 15) configured by arranging cells whose positions can be specified by column numbers and row numbers. Input attribute information setting process, input attribute information generation process, priority order N input attribute information generation process, copy process, copy source information generation process for one cell, paste process, paste destination input attribute information acquisition process, and absolute cell, which will be described later It includes a processing program describing execution instructions for each process for realizing a copy / paste operation, such as a paste process to a position, and data necessary for these processes. The table data is composed of data (cell data) stored in a plurality of cells. Each cell data is further configured with a plurality of data attributes (for example, values, mathematical formulas, fill colors, character formats, character colors, ruled lines, condition formats). A cell position specified by a column number and a row number is called an absolute cell position.

  Next, a copy / paste operation at the time of execution of the table editing software 151 of the present embodiment will be described with reference to FIGS. In the present embodiment, it is possible to set a data attribute (hereinafter referred to as input attribute) that allows input (paste) among a plurality of data attributes of the copy source cell data to the paste destination. When the user performs a paste operation on the set paste destination via the input device 12, only the data attribute data permitted by the setting is pasted from the copy source.

  FIG. 2 is a flowchart showing input attribute information setting processing executed by the CPU 11. This processing is realized by the cooperation of the CPU 11 and the input attribute information setting processing program included in the table editing software 151, and the user inputs the input attribute via the input device 12 during the operation of the table editing software 151. This process is executed when an instruction is issued for setting. By executing this processing, a setting unit is realized.

  First, the input attribute information setting screen 131 is displayed on the display device 13 (step S1). FIG. 3 shows an example of the input attribute information setting screen 131. The input attribute information setting screen 131 is used for the user to specify a worksheet name (sheet name) and a range via the input device 12, and to set and input an input attribute for a block of cells in the specified range of the specified worksheet. This is the screen. As shown in FIG. 3, the input attribute information setting screen 131 includes a priority order input field, a sheet name input field to be set, an input field of a range to be set (cell block range), and input permission. There are check fields for data attributes (for example, value, formula, fill color, character format, character color, ruled line, condition format), and the user can select the paste destination according to these input fields and check fields. Specify the sheet name and range of the worksheet, and input and set the input attribute for the specified sheet name and range. The check column can be set and input as a data attribute that allows input by clicking and checking the check column corresponding to the data attribute that permits input with the input device 12 such as a mouse. FIG. 3 shows an optimal setting example of the input attribute information setting screen 131 when the table shown in FIG. 14 is pasted on the input form shown in FIG. 15 to create the table shown in FIG.

  When setting contents are input from the input attribute information setting screen 131 via the input device 12, that is, a worksheet and range to be set are specified, and input attributes are checked (step S2), input attribute information generation is performed. Processing is executed (step S3).

FIG. 4 is a flowchart showing the input attribute information generation process executed by the CPU 11 in step S3 of FIG.
In the input attribute information generation process, the input attribute information shown in FIG. 5 is generated based on the contents set and input from the input attribute information setting screen 131.
First, the number of blocks for which input attributes are set and input via the input attribute information setting screen 131 (set block number M) is acquired (step S101). Next, 1 is set in the counter N (step S102), and input attribute information generation processing with priority N is executed (step S103).

FIG. 6 is a flowchart showing input attribute information generation processing of priority N executed by the CPU 11 in step S103 of FIG.
In the input attribute information generation process with priority N, the input attribute information area and attribute information area with priority N are secured in the RAM 14, and the RAM 14 is set based on the contents set and input with the priority N on the input attribute information setting screen 131. The input attribute information with priority N is generated by setting the input attribute information area with priority N and the information constituting the input attribute information in the attribute information area.

  First, 0 is set in the counter n (step S201), and the sheet name designated by the priority order N on the input attribute information setting screen 131 for the input attribute information area of the priority order N secured in the RAM 14 is the Nth. It is set as the sheet name of the input attribute information (step S202), and then the column number of the start column, the row number of the start row, and the column number of the end column in the range specified by the priority N on the input attribute information setting screen 131 And the row number of the end row are set as the start column, start row, end column, and end row of the Nth input attribute information (step S203).

  Next, whether or not the nth attribute element is checked is determined from the contents of the input attribute input with priority N on the input attribute information setting screen 131 (step S204). Here, the cell data of each cell is composed of a plurality of data attributes. In the table editing apparatus 1, individual data attributes (referred to as attribute elements) are managed by element numbers as shown in FIG. Yes. Of the attribute elements, “value” is element number 0, “math formula” is element number 1, “fill color” is element number 2, “character format” is element number 3, “character color” is element number 4, and “ruled line” Is managed with element number 5, and “condition format” is managed with element number 6. If it is determined that the nth attribute element is checked (step S205; YES), the flag of the nth attribute element in the attribute information is set to ON (step S206). As a result of the determination, if it is determined that the nth attribute element is not checked (step S205; NO), the flag of the nth attribute element in the attribute information is set to OFF (step S207). Next, the counter n is incremented by 1 (step S208), and it is determined whether or not n has exceeded the number of attribute elements (maximum attribute element number, here 6). If it is determined that n does not exceed the number of attribute elements (step S209; NO), the process returns to step S204, and the next attribute element is set. When it is determined that n exceeds the number of attribute elements (step S209; YES), the process proceeds to step S104 in FIG.

  In step S104 of FIG. 4, the counter N is incremented (step S104), and the counter N does not exceed the set block number M, that is, there is a target for which input attribute information is to be generated next (step S105; NO). ), The process returns to step S103, and input attribute information relating to the next priority is generated. As shown in FIG. 5, a pointer to an input attribute information area in which input attribute information of the next priority is set is set in the input attribute information that has been generated. When the counter N exceeds the set number of blocks M, that is, when there is no next target to generate input attribute information (step S105; YES), the process proceeds to step S4 in FIG.

  In step S4 of FIG. 2, the generated input attribute information is converted into the file format shown in FIG. 7 and stored in the storage device 15 as storage means (step S4), and this process ends.

Next, the copy process will be described.
FIG. 8 is a flowchart showing a copy process executed by the CPU 11. This process is realized by the cooperation of the CPU 11 and the copy processing program included in the table editing software 151, and the user performs a copy operation of the input device 12 during the operation of the table editing software 151, and the copy process. This is a process that is executed when an original worksheet and cell range specification and a copy instruction are input.

  First, the number C of cells designated as copy sources is calculated (step S11). Next, 1 is set in the counter N (step S12), the cells to be processed (target cells) are sequentially selected one by one from the cells designated as the copy source, and the copy source information generation processing for one cell is executed. (Step S13).

FIG. 9 is a flowchart showing the copy source information generation process for one cell executed by the CPU 11 in step S13 of FIG.
In the copy source information generation process for one cell, a copy source information area and a cell data area for one cell are secured in the RAM 14, and the cell data of the target cell selected as the processing target among the cells designated as the copy source Based on the above, the copy source information including the cell data of the target cell is set in the copy source information area and the cell data area secured in the RAM 14, thereby generating the copy source information for one cell.

  First, 0 is set in the counter n (step S301), and the relative column position and row position of the target cell from the copy source base point (when the cell position of the copy source base point is the column position 0 and the row position 0) Of the target cell) is acquired and set in the copy source information area secured in the RAM 14 (step S302). Here, the base point of the copy source is the cell specified first when the copy source is specified by the input device 12.

  Next, data relating to the nth attribute element of the target cell is acquired (step S303), and if data related to the nth attribute element exists (step S304; YES), the acquired data content is the target cell. Is set as the cell data of the nth attribute element in the copy source information (step S305). If there is no cell data related to the nth attribute element (step S304; NO), data indicating no information is set as the cell data related to the nth attribute element in the copy source information related to the target cell (step S306). .

  Next, the counter n is incremented by 1 (step S307), and it is determined whether or not n has exceeded the number of attribute elements (maximum attribute element number, here 6). If it is determined that n does not exceed the number of attribute elements (step S308; NO), the process returns to step S303, and cell data for the next attribute element is set. When it is determined that n exceeds the number of attribute elements (step S308; YES), the process proceeds to step S14 in FIG.

  In step S14 of FIG. 8, the counter N is incremented by 1 (step S14), N and the number of cells C are compared, and N does not exceed the number of cells C. That is, the next copy source information is to be generated. If it is determined that there is a cell (step S15; NO), the process returns to step S13, the next target cell is selected, and the copy source information generation process for one cell is executed. In the copy source information that has been generated, a pointer to a copy source information area in which the copy source information of the next target cell is set is set. As a result of the comparison between the counter N and the cell number C, if it is determined that N exceeds the cell number C, that is, there is no target cell for which copy source information is to be generated next (step S15; YES), this processing is finish.

  By the copy source information generation process for one cell, copy source information including cell data of each data attribute of each cell designated as the copy source is generated in the RAM 14. FIG. 10 shows the data structure of the copy source information.

Next, the paste process will be described.
FIG. 11 is a flowchart showing a paste process executed by the CPU 11. This process is realized by the cooperation of the CPU 11 and the paste processing program included in the table editing software 151. The paste operation of the input device 12 is performed by the user during the operation of the table editing software 151, and the paste is performed. This process is executed when a previous worksheet and base cell specification and a paste instruction are input. By executing this processing, a paste control unit is realized.

  First, the number D of copy source information generated by the copy process is acquired (step S20), and 1 is set in the counter N (step S21). Next, of the copy source information generated by the copy process, the Nth copy source information is selected and specified as a relative cell position (column position, row position) and paste destination included in the Nth copy source information. Based on the absolute cell position (column number and row number) of the base cell, the absolute cell position of the paste destination of the copy source information is calculated (step S22). Then, paste destination input attribute information acquisition processing is executed (step S23).

FIG. 12 is a flowchart showing the paste destination input attribute information acquisition process executed by the CPU 11 in step S23 of FIG.
First, the input attribute information stored in the storage device 15 is read out to the RAM 14 (step S401). When the input attribute information exists in the storage device 15 and the input attribute information is read out to the RAM 14 (step S402; YES), the worksheet and sheet name designated as the paste destination from the top according to the priority of the input attribute information Are matched, and the input attribute information in which the absolute cell position calculated in step S22 is within the range is searched (step S403). When the sheet specified as the paste destination matches the sheet name and there is input attribute information including the absolute cell position calculated in step S22 (step S404; YES), the corresponding input attribute information is returned to the paste process. Then (step S405), the process proceeds to step S24 in FIG. When the input attribute information does not exist in the storage device 15 (step S402; NO), or there is input attribute information including the absolute cell position calculated in step S22 when the worksheet specified as the paste destination matches the sheet name. If not (step S404; NO), information indicating no input attribute information is returned to the paste process (step S406), and the process proceeds to step S24 in FIG.

In step S24 of FIG. 11, the information returned from the paste destination input attribute information acquisition process is passed to the paste process to the absolute cell position, and the paste process to the absolute cell position is executed (step S24).
FIG. 13 is a flowchart showing the paste processing to the absolute cell position executed by the CPU 11 in step S24 of FIG.

  First, it is determined whether or not input attribute information has been acquired from the paste process, and if it is determined that input attribute information has not been acquired, that is, information indicating that no input attribute information has been acquired (step S500; NO). The process proceeds to step S507, and all the cell data of the target copy source information are pasted into the cells at the absolute cell position calculated in step S22 (step S507), and the process proceeds to step S25 in FIG. On the other hand, if it is determined that the input attribute information has been acquired from the paste processing (step S500; YES), 0 is set in the counter n (step S501), and then the nth input attribute information acquired in step S23. A flag of attribute information related to the attribute element is acquired (step S502), and if the acquired flag is OFF (step S503; NO), the process proceeds to step S505. If the acquired flag is ON (step S503; YES), the cell data of the nth attribute element of the target copy source information is pasted into the cell at the absolute cell position calculated in step S22 (step S504).

  In step S505, the counter n is incremented by 1 (step S505), and it is then determined whether n has exceeded the number of attribute elements (maximum attribute element number, here 6). If it is determined that n does not exceed the number of attribute elements (step S506; NO), the process returns to step S502. If it is determined that n exceeds the number of attribute elements (step S506; YES), the process proceeds to step S25 in FIG.

  In step S25 of FIG. 11, the counter N is incremented by 1, and the counter N and the copy source information number D are compared. As a result of the comparison, N does not exceed the copy source information number D. If it is determined that there is copy source information to be performed (step S26; NO), the process returns to step S22, and the processes after step S22 are executed for the next target copy source information. As a result of the comparison between the counter N and the copy source information number D, if it is determined that N exceeds the copy source information number D, that is, there is no copy source information to be subjected to paste processing next (step S26; YES). This process ends.

For example, if the invoice shown in FIG. 16 is to be created by copying the table data of the copy source worksheet shown in FIG. 14 to B4: D7 of the worksheet having the sheet name frm shown in FIG. As shown in FIG. 3, the value paste is allowed only to B5: D11 which is the data input area of the worksheet with the sheet name frm, the paste of the data attribute of the copy source cell other than the value is not allowed, and the work If the paste of all data attributes is set to not permitted for the areas other than B5: D11 of the sheet frm, B2 of the table in FIG. 14 is designated as the copy source, and B4 of the worksheet frm is pasted. Even if it is specified as the previous base point, only the values are pasted only in the data input area of the input form as shown in FIG. There, it is possible to leave the items and fill color of the bill.

Further, for example, a part of the table shown in FIGS. 17A to 17D is copied, and the table as shown in FIG. 17E is changed to B3: J9 of the worksheet name “National Sales Status” shown in FIG. In the case of creation, the data attributes to be pasted from the copy source are different in each of the blocks b1 to b7 shown in FIG.
Only a value among the data attributes of the copy source (sales volume column in the table shown in FIGS. 17A to 17C) is input to the block b1.
In the block b2, only the mathematical expression and the character format among the data attributes of the copy source (sales volume column in the table shown in FIG. 17D) are input.
In the block b3, only the value is input among the data attributes in the copy source ((previous year) column of the table shown in FIG.
In the block b4, only the mathematical expression is input among the data attributes of the copy source (sales column in the table shown in FIG. 17D).
In the block b5, only the mathematical expression and the fill color among the data attributes of the copy source (half-year total column in the table shown in FIG. 17D) are input.
Blocks b6 and b7 are not allowed to be input.
In such a case, conventionally, after specifying the copy source for each block and performing a copy instruction operation, the paste destination is specified, and the data attribute of the copy source data that permits the paste to the paste destination is specified. The operation had to be performed and was complicated. In addition, for example, if an area that you do not want to permit to paste, such as a cell in which an item name is entered, is mistakenly specified as the paste destination, the information entered there will be lost. It was.

  In the present embodiment, the setting shown in FIG. 19 is performed from the input attribute information setting screen 131 by the input attribute information setting process, and based on the set contents (input attribute information), it can be pasted to the paste destination. Since the data attributes can be restricted, specify the copy source at copy / paste, specify the paste destination, and then specify the paste destination to perform the paste instruction. It is possible to paste only the data attributes that you want to paste into. That is, it is not necessary to perform an operation for designating the data attribute to be pasted to the paste destination in the copy source cell data for each block, and the operability can be improved. In addition, even if an area that you do not want to allow to paste, such as a cell where the item name is entered, is mistakenly specified as the paste destination, the copy source data will be pasted there, and it will be entered at the paste destination. Data loss can be prevented.

  As described above, according to the table editing apparatus 1, when a data attribute that allows pasting is set for each block of paste-destination table data on the input attribute information setting screen 131, the input attribute information setting screen 131. The input attribute information is generated based on the setting contents from and stored in the storage device 15. When a copy source block specification and a copy execution instruction are input via the input device 12, copy source information is generated, and when a paste destination specification and a paste execution instruction are input, they are stored in the storage device 15. When the input attribute information is read and there is input attribute information corresponding to the block designated as the paste destination, the paste is executed based on the input attribute information and the copy source information.

  Therefore, when copying / pasting, the user does not have to perform an operation of selecting a data attribute that permits pasting to the paste destination from the copy source data, thereby improving the operability during copying / pasting. it can. Further, it is possible to prevent a data attribute that is desired to remain in the paste destination from being lost due to an erroneous operation of selecting a data attribute at the time of copy / paste.

  In the input attribute information setting screen 131, the priority order can be set for the setting contents of each block, and the paste is executed in accordance with the priority order. Can be executed. In addition, for example, when a block (assumed to be an internal block) in which a combination of data attributes is partially different is included in one paste destination block (assumed to be an entire block), the priority of the internal block is increased. By setting the data attribute of the internal block and the entire block, the area other than the internal block in the entire block is divided into smaller blocks, and different data attributes are pasted only to the internal block. This makes it possible to set the data attribute of the paste destination efficiently with a small number of settings.

  In addition, the description content in the said embodiment is a suitable example of the table editing apparatus 1 which concerns on this invention, and is not limited to this.

  For example, in the above-described embodiment, the case where the user inputs and inputs the data attribute that permits the paste from the input attribute information setting screen 131 has been described as an example. However, the paste to the paste destination is limited on the input attribute information setting screen 131. It is good also as setting and inputting the data attribute to perform (it does not permit). In any form, it goes without saying that the table editing apparatus 1 sets data attributes that permit pasting and data attributes that do not permit pasting.

  In the above embodiment, copy / paste has been described as an example, but the present invention may be applied to setting permission / non-permission of input to other editing functions. For example, it may be possible to set in advance permission / non-permission of row insertion and row deletion for each block of table data cells, and row insertion and row deletion may be performed based on the setting.

  In the above embodiment, the unit of the block when setting the data attribute permitting the paste is a plurality of cells, but it may be set in units of sheets.

  In the above-described embodiment, the case where the data attribute that permits pasting is set for each paste destination block has been described as an example. However, the data attribute extracted from the copy source may be limited for each copy source block. Good.

(Embodiment 2)
Hereinafter, Embodiment 2 of the present invention will be described.
The configuration of the table editing apparatus 1 according to the second embodiment is the same as that described with reference to FIG. In the second embodiment, it is possible to set an input permission condition for a block of table data to be a paste destination. Specifically, as in the first embodiment, a data attribute (input attribute) that allows input among a plurality of data attributes of copy source cell data can be set for the paste destination. Furthermore, in the second embodiment, it is possible to set a determination condition for determining whether or not input (paste) is permitted for a paste destination. These settings can be performed by the user instructing the setting of the input permission condition via the input device 12 during the operation of the table editing software 151.

  When setting of the input permission condition is instructed via the input device 12 during the operation of the table editing software 151, the input attribute information is set by the cooperation of the CPU 11 and the input attribute information setting processing program included in the table editing software 151. Setting processing is executed, and input permission conditions are set. The input attribute information setting process is substantially the same as that shown in FIG. 2, and will be described with reference to FIG. By executing this processing, a setting unit is realized.

  First, the input attribute information setting screen 132 is displayed on the display device 13 (step S1). FIG. 20 shows an example of the input attribute information setting screen 132. The input attribute information setting screen 132 allows the user to specify a paste-destination worksheet name (sheet name) and range via the input device 12, and input permission conditions for a block of cells in the specified range of the specified worksheet. This is a screen for inputting settings. As shown in FIG. 20, the input attribute information setting screen 132 includes a priority order input field ("priority order" field), a sheet name input field to be set ("sheet name" field), and a setting target. Range (cell block range) input field ("Range" field), data attributes that allow input to the range of cells to be set (for example, value, formula, fill color, character format, character color) , Ruled line, condition format) check field, position information input field ("condition object" field) for cells used to determine input permission ("condition object" field), input to the range of cells to be set An input field (“conditional expression” field) is provided for inputting a conditional expression for determining whether to permit or not. In accordance with these input field and check field, the user specifies the sheet name and range of the target worksheet as the paste destination, sets the input attribute for the specified sheet name and range, and inputs the specified sheet name and range. A determination condition (conditional expression) for determining whether to permit or not, and a condition target cell used for determining input permission are set.

  The check column for each input attribute is set by inputting the checked data attribute as a data attribute allowing input by clicking the check column corresponding to the data attribute permitting input with the input device 12 such as a mouse. be able to. The “condition target” column is a column for inputting the cell position (copy source cell) used for the determination of the input permission, and can be input at a known relative cell position using “?”. For example, by inputting “E?” As the condition target, the cell in the E column in the same row as the copy source cell can be designated as the condition target cell. By inputting “? 1”, the cell in the first row in the same column as the copy source cell can be designated as the cell to be subjected to the condition. When “??” is input as the condition target, the copy source cell itself can be designated as the condition target cell. For example, a conditional expression indicating whether or not a predetermined character string is included in the target cell can be input to the conditional expression in the “conditional expression” column, and a commonly used comparison operator “>> < = <> ”And logical operators“ AND, OR ”can be input, and a wild card“ * ”can also be used. Note that the cell position designated as the condition target may be an absolute cell position.

  When setting contents are input from the input attribute information setting screen 132 via the input device 12, that is, a setting target worksheet and range, input attribute check, condition target cell and conditional expression are input ( In step S2), input attribute information generation processing is executed (step S3).

The input attribute generation process is a process of generating the input attribute information shown in FIG. 21 based on the contents set and input from the input attribute information setting screen 132, and is substantially the same as the process steps shown in FIG. 4 in the first embodiment. Therefore, the contents will be described with reference to FIG.
First, the number of blocks in which the input attribute is set and input via the input attribute information setting screen 132 (set block number M) is acquired (step S101). Next, 1 is set in the counter N (step S102), and input attribute information generation processing with priority N is executed (step S103).

The input attribute information generation process with priority N executed in step S103 is different from that described in the first embodiment.
FIG. 22 is a flowchart showing the priority attribute N input attribute information generation processing (referred to as priority N input attribute information generation processing B) executed by the CPU 11 in step S103 of FIG. 4 in the second embodiment.
In the input attribute information generation process B with priority N, the input attribute information area and attribute information area with priority N are secured in the RAM 14, and based on the contents set and input with priority N on the input attribute information setting screen 132, Input attribute information with priority N is generated by setting the input attribute information area with priority N secured in the RAM 14 and each piece of information constituting the input attribute information in the attribute information area.

  First, 0 is set in the counter n (step S601), and the input attribute information area of the priority order N secured in the RAM 14 is the Nth sheet name designated by the priority order N on the input attribute information setting screen 132. It is set as the sheet name of the input attribute information (step S602), and then the column number of the start column, the row number of the start row, and the column number of the end column in the range specified by the priority N on the input attribute information setting screen 132 And the row number of the end row are set as the start column, start row, end column, and end row of the Nth input attribute information (step S603).

  Next, whether or not the nth attribute element is checked is determined from the contents of the input attribute input with priority N on the input attribute information setting screen 132 (step S604). Here, the cell data of each cell is composed of a plurality of data attributes. In the table editing apparatus 1, individual data attributes (referred to as attribute elements) are managed by element numbers as shown in FIG. Yes. Of the attribute elements, “value” is element number 0, “math formula” is element number 1, “fill color” is element number 2, “character format” is element number 3, “character color” is element number 4, and “ruled line” Is managed with element number 5, and “condition format” is managed with element number 6. As a result of the determination, if it is determined that the nth attribute element is checked (step S605; YES), the flag of the nth attribute element in the attribute information is set to ON (step S606). If it is determined that the nth attribute element is not checked (step S605; NO), the flag of the nth attribute element in the attribute information is set to OFF (step S607). Next, the counter n is incremented by 1 (step S608), and it is determined whether or not n has exceeded the number of attribute elements (maximum attribute element number, here 6). If it is determined that n does not exceed the number of attribute elements (step S609; NO), the process returns to step S604. When it is determined that n exceeds the number of attribute elements (step S609; YES), the process proceeds to step S610.

  In step S610, the contents (character string) in the “condition target” field and the contents (character string) in the “conditional expression” field, which are input with priority N on the input attribute information setting screen 132, are the Nth input attribute information. It is set to “condition target” and “conditional expression” in the attribute information. Then, the process proceeds to step S104 in FIG.

  In step S104 of FIG. 4, the counter N is incremented (step S104), and the counter N does not exceed the set block number M, that is, there is a target for which input attribute information is to be generated next (step S105; NO). ), The process returns to step S103, and input attribute information relating to the next priority is generated. As shown in FIG. 21, a pointer to an input attribute information area in which input attribute information of the next priority is set is set in the input attribute information that has been generated. When the counter N exceeds the set number of blocks M, that is, when there is no next target to generate input attribute information (step S105; YES), the process proceeds to step S4 in FIG.

  In step S4 of FIG. 2, the generated input attribute information is converted into the file format shown in FIG. 7 and stored in the storage device 15 as storage means (step S4), and this process ends.

Next, the copy process will be described.
The copy process is performed when the copy operation is performed by the input device 12 during the operation of the table editing software 151 and the copy source worksheet and cell range specification and the copy instruction are input to the CPU 11 and the table editing software 151. It is executed in cooperation with the included copy processing program. The copy process in the second embodiment is substantially the same as that described with reference to FIGS. 8 and 9 in the first embodiment. However, in the second embodiment, in step S302 in FIG. Relative column position and row position of the cell (relative row position, relative column position; position of the target cell when the cell position of the copy source base point is column position 0, row position 0), and the sheet of the target cell The name and absolute cell position (absolute row position, absolute column position) are acquired and set in the copy source information area secured in the RAM 14 (see FIG. 23). Others are the same as those described in the first embodiment, and a description thereof will be omitted.

Next, the paste process will be described.
In the paste processing, when the paste operation is performed by the input device 12 during the operation of the table editing software 151 and the paste destination worksheet and base cell specification and the paste instruction are input, the CPU 11 and the table editing software 151 Is executed in cooperation with the paste processing program included in the program. The flow of the paste process in the second embodiment is the same as that described with reference to FIG. 11 in the first embodiment, but in the paste destination input attribute information acquisition process executed in step S23 of FIG. 11 and in step S24. Since the contents of the paste processing to the absolute cell position to be executed are different, these processing will be described below.

FIG. 24 is a flowchart illustrating paste destination input attribute information acquisition processing (referred to as paste destination input attribute information acquisition processing B) executed by the CPU 11 in the second embodiment.
In the paste destination input information acquisition process B, first, the input attribute information stored in the storage device 15 is read out to the RAM 14 (step S701). When the input attribute information exists in the storage device 15 and the input attribute information is read out to the RAM 14 (step S702; YES), the worksheet and sheet name designated as the paste destination from the top according to the priority of the input attribute information Are matched, and the input attribute information in which the absolute cell position calculated in step S22 is within the range is searched (step S703). If the input attribute information including the absolute cell position calculated in step S22 exists and the sheet specified as the paste destination matches the sheet name (step S704; YES), the “conditional object included in the input attribute information is included. Is converted into an absolute cell position corresponding to the absolute cell position of the Nth copy source information, and is additionally written as a “condition object” in the Nth copy source information (step S705). If “?” Indicating a relative cell is not included in the cell position of “condition object”, the cell position of “condition object” included in the input attribute information is additionally written to the Nth copy source information as it is. . Then, the input attribute information including the absolute cell position calculated in step S22 that matches the sheet designated as the paste destination and the sheet name is returned to the paste process (step S706), and the process is performed in step S24 of FIG. Migrate to When the input attribute information does not exist in the storage device 15 (step S702; NO), or there is input attribute information including the absolute cell position calculated in step S22 when the worksheet specified as the paste destination matches the sheet name. If not (step S704; NO), information indicating no input attribute information is returned to the paste process (step S707), and the process proceeds to step S24 in FIG.

  FIG. 25 is a flowchart illustrating a paste process to an absolute cell position (referred to as paste process B to an absolute cell position) executed by the CPU 11 in the second embodiment.

  In the paste process B to the absolute cell position, first, it is determined whether or not input attribute information has been acquired from the paste process, and input attribute information has not been acquired, that is, information indicating no input attribute information is acquired. If it is determined (step S800; NO), the process proceeds to step S809, and all the cell data of the target copy source information are pasted into the cell at the absolute cell position calculated in step S22 (step S809). The process proceeds to step S25 in FIG. On the other hand, if it is determined that the input attribute information has been acquired from the paste process (step S800; YES), it is stored in the cell position (cell position in the copy source sheet) of the “condition object” of the Nth copy source information. Is determined to be true or false by applying to the “conditional expression” of the acquired input attribute information (step S801). If the result of the determination is true (step S802; YES), 0 is set in the counter n (step S803), and the process proceeds to step S804. If the determination result is false (step S802; NO), the paste to the absolute cell position is not performed, and the process proceeds to step S25 in FIG.

  In step S804, a flag of attribute information related to the nth attribute element of the input attribute information acquired in step S23 is acquired (step S804). If the acquired flag is OFF (step S805; NO), processing is performed. Moves to step S807. If the acquired flag is ON (step S805; YES), the cell data of the nth attribute element of the target copy source information is pasted into the cell at the absolute cell position calculated in step S22 (step S806), and the process Moves to step S807.

  In step S807, the counter n is incremented by 1, and then it is determined whether or not n has exceeded the number of attribute elements (maximum attribute element number, here 6). When it is determined that n does not exceed the number of attribute elements (step S808; NO), the process returns to step S804. If it is determined that n exceeds the number of attribute elements (step S808; YES), the process proceeds to step S25 in FIG.

For example, as shown in FIG. 20, in the input attribute information setting screen 132, “condition object” at the copy source is set to “E?”, And “conditional expression” is set to “= * new product notification *”. When B2: D7 of the table data of the copy source worksheet shown is copied / pasted to B4: D9 of the worksheet with the sheet name frm shown in FIG. 27, the use purpose items of the table data of the copy source are displayed as shown in FIG. Only those that contain “New Product Notice” are pasted. As described above, according to the second embodiment, it is possible to paste only the permitted data attributes of the data that matches the input permission condition among the data of each cell designated as a copy source at once.

  As described above, according to the table editing apparatus 1 in the second embodiment, the input permission condition permitting input (paste), that is, paste is applied to each block of the paste destination table data on the input attribute information setting screen 132. When a data attribute to be permitted, a condition target cell for determining whether to permit paste, and a conditional expression are set, input attribute information is generated based on the setting content from the input attribute information setting screen 132, It is stored in the storage device 15. When a copy source block specification and a copy execution instruction are input via the input device 12, copy source information is generated. When a paste destination designation and a paste execution instruction are input via the input device 12, the input attribute information stored in the storage device 15 is read to the RAM 14, and the input attribute information corresponding to the block included in the paste destination is obtained. If it exists, it is determined whether or not the value of the condition target cell indicated in the input attribute information is true by applying the conditional expression. Only when it is true, the paste is based on the input attribute information and the copy source information. Executed.

  Therefore, it is possible to paste only the permitted data attributes of the contents that match the input permission conditions among the data of each cell designated as the copy source collectively, and the operability and convenience at the time of copy / paste Can be improved.

  In addition, the description content in the said Embodiment 2 is a suitable example of the table editing apparatus 1 which concerns on this invention, and is not limited to this.

  For example, in the second embodiment, the case where the user sets and inputs the conditions for permitting the paste from the input attribute information setting screen 132 has been described as an example. However, in the input attribute information setting screen 132, the paste to the paste destination is restricted. It is good also as setting input of the condition to perform (it does not permit). In any aspect, it goes without saying that conditions for permitting paste and conditions for not permitting paste are set in the table editing apparatus 1.

  In the second embodiment, in the input attribute information setting screen 132, as a paste destination input permission condition, a conditional expression as a determination condition for determining whether or not paste is possible, and a condition target cell used for determining whether or not paste is possible In addition, although both the input attribute and the input attribute can be set, only one of them may be set.

  In the second embodiment, the unit of the block when setting the condition for permitting the paste is a plurality of cells. However, the unit may be set in units of sheets.

  In the second embodiment, the condition target is the copy source cell, but it may be a sheet other than the copy source, an external file, or data on a database.

  Further, in the second embodiment, when the value of the cell subject to the condition is determined to be false by applying the conditional expression, no data is stored in the paste destination cell. When displayed, as shown in FIG. 28, it is possible to clearly display cells that have been copied / pasted and cells that have not been copied, but if there is a cell in which no data is stored, the paste is performed next. As shown in FIG. 29, processing is performed such as pasting by filling the cells in which no data is stored, or deleting cells in which no data is stored after all the pasting is completed. In addition, unnecessary cells that do not satisfy the conditional expression may not be displayed.

(Embodiment 3)
Hereinafter, Embodiment 3 of the present invention will be described.
In the second embodiment, the input permission condition is set for the paste destination, and it is determined whether or not the paste is permitted according to the condition at the time of pasting. In the third embodiment, the input permission condition ( Copy permission condition) is set, and it is determined whether or not copying is permitted according to the condition at the time of copying, and only permitted attributes of the permitted copy source cell data can be copied / pasted. .

  The configuration of the table editing apparatus 1 according to the third embodiment is the same as that described with reference to FIG. 1 and thus will not be described. A copy / paste operation when executing the table editing software 151 according to the third embodiment will be described below. To do. The setting of the input permission condition to the copy source described above is executed by the user instructing the setting of the input permission condition via the input device 12 during the operation of the table editing software 151.

  When setting of the input permission condition is instructed via the input device 12 during the operation of the table editing software 151, the input attribute information is set by the cooperation of the CPU 11 and the input attribute information setting processing program included in the table editing software 151. Setting processing is executed. As described above, the input attribute information setting process in the third embodiment is different from the second embodiment in that the input permission condition is set for the block in the copy source table data. Other processing steps are substantially the same as those illustrated in FIG.

  That is, in step S1 of FIG. 2, first, an input attribute information setting screen (input attribute information setting screen 133; see FIG. 30) is displayed on the display device 13. This input attribute information setting screen 133 has the same configuration and setting input method as the input attribute information setting screen 132 displayed in the second embodiment, but is different in the setting target from the input attribute information setting screen 132 and is copied. It is a screen for setting an input permission condition for a block in the original table data. For example, when copying / pasting B3: D7 table data of the copy source worksheet (sheet name AAA) shown in FIG. 26 to B5: D9 of the worksheet shown in FIG. 27, individual cells of the copy source table data If you want to allow only cell data values with the true value “= * New Product Notification *” in column E in the same row to be entered into the paste destination, perform the settings shown in FIG. The desired input permission conditions can be set for the copy source, and the input attribute information regarding each copy source cell can be generated and stored in the storage device 15. Since the specific processing flow of the input attribute information setting process is the same as that described in the second embodiment, the description thereof is omitted.

Next, the copy process will be described.
The copy process is performed when the copy operation is performed by the input device 12 during the operation of the table editing software 151 and the copy source worksheet and cell range specification and the copy instruction are input to the CPU 11 and the table editing software 151. It is executed in cooperation with the included copy processing program. Copy control means is realized by executing the copy process. The flow of the copy process in the third embodiment is the same as that described with reference to FIG. 8 in the first embodiment, but the content of the copy source information generation process for one cell in step S13 in FIG. 8 is different. This will be described below.

FIG. 31 is a flowchart illustrating a copy source information generation process for one cell (referred to as copy source information generation process C for one cell) executed by the CPU 11 in the third embodiment.
In the copy source information generation process C for one cell, the copy source information area and the cell data area for one cell are secured in the RAM 14, and the cell of the target cell selected as the processing target among the cells designated as the copy source Copy source information for one cell is generated by setting copy source information including cell data of the target cell in the copy source information area and the cell data area secured in the RAM 14 based on the data.

  First, the relative column position and row position of the target cell from the copy source base point (the position of the target cell when the cell position of the copy source base point is column position 0 and row position 0) are acquired and stored in the RAM 14. The secured copy source information area is set (step S901). Here, the base point of the copy source is the cell specified first when the copy source is specified by the input device 12.

Next, input attribute information acquisition processing of the target cell is executed (step 902). FIG. 32 is a flowchart showing target cell input attribute information acquisition processing executed by the CPU 11 in step S902 of FIG.
First, the input attribute information stored in the storage device 15 is read out to the RAM 14 (step S1001). When the input attribute information exists in the storage device 15 and the input attribute information is read into the RAM 14 (step S1002; YES), the worksheet and the sheet including the target cell are combined from the top according to the priority of the input attribute information. The input attribute information in which the absolute cell position of the target cell is within the range is searched (step S1003). When the worksheet including the target cell matches the sheet name and there is input attribute information including the absolute cell position of the target cell (step S1004; YES), the corresponding input attribute information is copy source information for one cell. It returns to a production | generation process (step S1005), and a process transfers to step S903 of FIG. When there is no input attribute information in the storage device 15 (step S1002; NO), or when there is no input attribute information that includes the sheet name that matches the worksheet that includes the target cell and that includes the absolute cell position of the target cell. (Step S1004; NO), information indicating no input attribute information is returned to the copy source information generation process for one cell (Step S1006), and the process proceeds to Step S903 in FIG.

  In step S903 of FIG. 31, based on the information returned from the input attribute information acquisition process of the target cell, it is determined whether or not the input attribute information related to the target cell has been acquired, and the input attribute information has not been acquired. That is, if it is determined that information indicating no input attribute information has been acquired (step S903; NO), the process proceeds to step S904, and the contents of all data attributes of the target cell are cells of copy source information related to the target cell. The data is set (step S904), and the process proceeds to step S14 in FIG. On the other hand, if it is determined that the input attribute information of the target cell has been acquired (step S903; YES), the cell position of the “condition target” included in the input attribute information is an absolute cell corresponding to the absolute cell position of the target cell. It is converted into a position (step S905), and it is determined whether the value stored in the converted cell position is true or false by applying to the “conditional expression” of the acquired input attribute information (step S905). S906). If the result of the determination is true (step S907; YES), the process proceeds to step S908. If the determination result is false (step S907; NO), the process proceeds to step S14 in FIG.

  In step S908, 0 is set in the counter n, and then a flag of attribute information regarding the nth attribute element of the acquired input attribute information is acquired (step S909), and the acquired flag is OFF ( Step S910; NO), the process proceeds to step S912. When the acquired flag is ON (step S910; YES), data regarding the nth attribute element of the target cell is acquired and set as cell data of the nth attribute element in the copy source information regarding the target cell. (Step S911).

  In step S912, the counter n is incremented by 1, and then it is determined whether or not n has exceeded the number of attribute elements (maximum attribute element number, here 6). If it is determined that n does not exceed the number of attribute elements (step S913; NO), the process returns to step S909, and attribute information regarding the next attribute element is set. If it is determined that n exceeds the number of attribute elements (step S913; YES), the process proceeds to step S14 in FIG.

  Copy source information including cell data of each data attribute of each cell designated as the copy source is generated in the RAM 14 by the copy source information generation processing C for one cell of the third embodiment. FIG. 33 shows the data structure of the copy source information generated in the third embodiment. FIG. 33 shows an example of copy source information created when the settings shown in FIG. 30 are performed with FIG. 26 as the copy source worksheet. As shown in FIG. 33, since the copy source cell B3 includes “new product notification” in the E column of the same row, the determination result of the input permission is true, and the content of each attribute of B3 is the copy source. Although the information is set in the information, the copy source B4 cell does not include “new product notification” in the E column of the same row, so the input permission determination result is false, and the data content of each attribute of B4 is Not set in the copy source information.

  As described above, in the copy process according to the third embodiment, when the copy source information of each cell in the range designated by the user as the copy source is generated, whether the conditional expression set in the condition target cell is true or false is determined. Only when the determination result is true, the data attribute information set to permit input is set in the cell data of the copy source information.

Next, the paste process will be described.
In the paste processing, when the paste operation is performed by the input device 12 during the operation of the table editing software 151, and the paste strategy worksheet and the base cell specification and the paste instruction are input, the CPU 11 and the table editing software 151 Is executed in cooperation with the paste processing program included in the program. The paste control means is realized by executing the paste process. FIG. 34 is a flowchart showing a paste process (referred to as paste process C) executed by the CPU 11 in the third embodiment.

  First, the number D of copy source information generated by the copy process is acquired (step S41), and 1 is set in the counter N (step S42). Next, of the copy source information generated by the copy process, the Nth copy source information is selected and specified as a relative cell position (column position, row position) and paste destination included in the Nth copy source information. Based on the absolute cell position (column number and row number) of the base cell, the paste cell absolute cell position of the copy source information is calculated (step S43), and the cell data of the Nth copy source information is calculated Pasting at the previous absolute cell position (step S44).

  Next, the counter N is incremented by 1 (step S45), and the counter N and the copy source information number D are compared. As a result of the comparison, N does not exceed the copy source information number D. If it is determined that there is copy source information (step S46; NO), the process returns to step S43, and the processes after step S43 are executed for the next target copy source information. As a result of the comparison between the counter N and the copy source information number D, if it is determined that N exceeds the copy source information number D, that is, there is no copy source information to be subjected to paste processing next (step S46; YES). This process ends.

  As described above, in the third embodiment, in the copy process, whether the conditional expression is true or false is determined for each cell for which the input permission condition is set, and only when the data attribute of the copy source is permitted Is set in the cell data of the copy source information, and in the paste process, it is possible to perform the paste without performing the true / false judgment of the conditional expression.

  As described above, according to the table editing apparatus 1 in the third embodiment, the input permission condition for permitting input (copying) for each block of the table data to be copied on the input attribute information setting screen 133, that is, copying is performed. When a data attribute to be permitted, a condition target cell for determining whether or not to permit copying, and a conditional expression are set, the input attribute information about the copy source is set based on the setting content from the input attribute information setting screen 133 Is generated and stored in the storage device 15. When a copy source block specification and a copy execution instruction are input via the input device 12, copy source information is generated. If there is a conditional object and conditional expression as input permission conditions for the cell included in the specified copy source, whether or not the value of the cell position specified as the conditional object of the cell is true by applying the conditional expression Only when it is determined to be true, the content of the attribute for which input permission is set is set in the cell data of the copy source information of the cell. When a paste destination designation and paste execution instruction are input via the copy source input device 12, based on the copy source information generated by the copy process, the absolute cell position of the base point designated as the paste destination, and the copy source information Paste is executed.

  Therefore, it is possible to copy and paste only the permitted data attributes of the data that matches the input permission conditions among the data of each cell specified as the copy source at the same time. It becomes possible to improve the operability. For each cell for which an input permission condition is set, whether the conditional expression is true or false is determined in the copy process, and only when the determination result is true, the data attribute of the input source that is permitted to be copied is set to the cell. Since it is set in the cell data of the copy source information, in the paste process, it is possible to perform the paste without performing the true / false judgment of the conditional expression. As a result, the input permission condition can be validated even when pasting into a text file other than the table editing software.

  In addition, the description content in the said Embodiment 3 is a suitable example of the table | surface editing apparatus 1 which concerns on this invention, and is not limited to this.

  For example, in the above embodiment, the case where the user sets and inputs conditions for permitting copying from the input attribute information setting screen 133 has been described as an example. However, copying is restricted (not permitted) on the input attribute information setting screen 133. It is also possible to set and input conditions. In any aspect, it goes without saying that conditions for permitting copying and conditions for not permitting copying are set in the table editing apparatus 1.

  In the third embodiment, on the input attribute information setting screen 133, as a copy source input permission condition, a conditional expression as a determination condition for determining whether copying is possible and a condition target cell used for determining whether copying is possible In addition, although both the input attribute and the input attribute can be set, only one of them may be set.

  In the third embodiment, the unit of the block when setting the conditions for permitting copying is set to a plurality of cells. However, the unit may be set in units of sheets.

  In the third embodiment, the condition target is the copy source cell, but it may be a sheet other than the copy source, an external file, or data on a database.

  In the third embodiment, as in the second embodiment, when it is determined that the condition source value of the copy source is false by applying the conditional expression, no data is stored in the paste destination cell. Therefore, when the state after pasting is displayed, as shown in FIG. 28, it is possible to clearly display cells in which the conditional expression is true and cells that are false in the copy source. If there is a cell that is not stored, a process such as deleting a cell in which no data is stored is performed after all pastes are completed, and as shown in FIG. The cell may not be displayed.

  As described above, the first to third embodiments have been described. However, as described in the first to third embodiments, the table editing apparatus according to the present invention has permission conditions for permitting paste for each block of paste destination table data. Setting means for setting, storage means for storing the setting contents set by the setting means, and settings stored in the storage means when the copy source table data is copied and pasted to the paste destination table data And paste control means for executing paste based on the content.

  With this configuration, when copying / pasting, the user needs to specify data that is permitted to be pasted to the paste destination among the data included in the copy source table data, and perform an operation of pasting to the paste destination. You can paste only the permitted data to each block of the paste destination table data simply by specifying the copy source table data at once and pasting the paste destination table data at once. Therefore, the operability at the time of copying / pasting can be improved.

  Further, it is preferable that the setting means is capable of setting a data attribute permitting paste as the permitting condition permitting the paste. With this configuration, the user does not need to perform an operation of selecting a data attribute that permits paste to the paste destination from the copy source data at the time of copy / paste, and operability at the time of copy / paste. Can be improved. Further, it is possible to prevent a data attribute that is desired to remain in the paste destination from being lost due to an erroneous operation of selecting a data attribute at the time of copy / paste.

  The setting means is characterized in that, as permission conditions for permitting the paste, a determination condition for determining whether paste is possible and a target cell used for determining whether paste is possible can be set. preferable. With this configuration, at the time of copying / pasting, the user determines each time whether or not the contents of the target cell match the determination conditions for determining whether or not the paste to the paste destination can be performed. There is no need to perform complicated operations such as performing copy / paste by designating the matching copy source and paste destination ranges. That is, at the time of copying / pasting, it is determined that the contents of the target cell are allowed to paste to the paste destination simply by specifying the copy source table data at once and performing a paste operation on the paste destination table data. Only when the conditions are met, the copy source data can be pasted to the paste destination, and the operability during copy / paste can be improved.

  In addition, the target cell is a cell included in the copy source table data, and the determination condition for determining whether or not the paste is possible indicates whether or not the target cell includes a predetermined character string. A conditional expression is preferable. With this configuration, when copying / pasting, the user can check whether the contents of the cells included in the copy source table data meet the determination conditions for determining whether or not the paste to the paste destination is possible. It is not necessary to perform complicated operations such as copying / pasting by designating the range of the copy source and the paste destination only when the determination condition is met and the condition is met. That is, at the time of copying / pasting, it is only possible to specify the copy source table data in a batch and paste the paste data into the paste destination table data, and allow paste to the paste destination in the copy source data. It is possible to paste only data that matches the determination conditions, and the operability during copying / pasting can be improved.

  Further, the setting means can set a priority for the contents set for each block of the paste destination table data, the storage means stores the setting contents together with the priority, and the paste control means It is preferable to execute the paste based on the priority order stored in the storage means. With this configuration, it is possible to execute the paste without causing an error even if there are regions where the settings overlap.

  The table editing apparatus according to the present invention includes a setting unit that sets a permission condition for permitting copying for each block of table data of a copy source, a storage unit that stores setting contents set by the setting unit, A copy control means for copying the copy source table data based on the setting contents stored in the storage means; a paste control means for pasting the table data copied by the copy control means to the paste destination table data; It is characterized by having.

  With this configuration, when copying / pasting, the user needs to specify the data that is permitted to be copied from the data included in the copy source table data, and copy the data to the paste destination. The copy source table data can be copied and pasted only by specifying the copy source table data in a batch and pasting to the paste destination table data. It is possible to paste the image on the screen, and the operability during copy / paste can be improved.

  Further, it is preferable that the setting means can set a data attribute that permits copying as a permission condition that permits the copying. This configuration eliminates the need for the user to specify the copy range and data attribute for each block having the same combination of data attributes that are permitted to be copied in the copy source table data during copy / paste. Copy and paste only the data attributes of the copy source table data that are allowed to be copied by simply specifying the copy source table data in batch and pasting to the paste destination table data in batch. Pasting can be performed first, and the operability during copying / pasting can be improved.

  Further, it is preferable that the setting means can set a determination condition for determining whether copying is permitted and a target cell used for determining whether copying is possible as permission conditions for permitting the copying. With this configuration, when copying / pasting, the user determines whether or not the contents of the target cell meet the determination conditions for determining whether or not copying is possible. There is no need to perform complicated operations such as performing copy / paste by designating a copy source whose content of the target cell matches the judgment condition. In other words, simply specify the copy source table data and paste it to the paste destination table data at once, and the contents of the target cell of the data in the copy source table data match the judgment conditions. It is possible to copy only the copy source data and paste it to the paste destination, thereby improving the operability during copy / paste.

  Further, the target cell is a cell included in the table data of the copy source, and the determination condition for determining whether or not copying is possible indicates whether or not the target cell includes a predetermined character string. A conditional expression is preferable. With this configuration, at the time of copying / pasting, it is determined each time whether or not the contents of the cells included in the copy source table data match the determination conditions for determining whether copying is possible. It is not necessary to perform a complicated operation such as copying / pacing by designating a copy source that matches the above. That is, when copying / pasting, it is determined that copying is permitted among the data in the copy source table data by simply specifying the copy source table data in a batch and performing a batch paste operation on the paste destination table data. It is possible to copy only the data that matches the conditions and paste it at the paste destination, thereby improving the operability during copying / pasting.

  Further, the setting means can set a priority order for the contents set for each block of the copy source table data, the storage means stores the setting contents together with the priority order, and the copy control means comprises: It is preferable to perform copying based on the priority order stored in the storage means. With this configuration, it is possible to execute copying without causing an error even if there are overlapping settings.

The table editing apparatus according to the present invention is not limited to the above-described embodiment, and can be applied to other configurations.

It is a block diagram which shows the functional structure of the table editing apparatus 1 which concerns on this invention. 3 is a flowchart illustrating input attribute information setting processing executed by a CPU 11 of FIG. 1 in the first embodiment. FIG. 7 is a diagram illustrating an example of an input attribute information setting screen 131 displayed on the display device 13 of FIG. 1 in the first embodiment. 3 is a flowchart illustrating input attribute information generation processing executed by a CPU 11 of FIG. 1 in the first embodiment. It is a figure which shows an example of the data structure of the input attribute information produced | generated in Embodiment 1. FIG. 6 is a flowchart showing input attribute information generation processing of priority N executed by the CPU 11 of FIG. 1 in the first embodiment. 6 is a diagram illustrating a storage format when input attribute information is stored in the storage device 15 in Embodiment 1. FIG. 3 is a flowchart illustrating a copy process executed by a CPU 11 of FIG. 1 in the first embodiment. 3 is a flowchart illustrating a copy source information generation process for one cell executed by a CPU 11 of FIG. 1 in the first embodiment. 6 is a diagram illustrating an example of a data structure of copy source information generated in the first embodiment. FIG. 2 is a flowchart illustrating a paste process executed by a CPU 11 of FIG. 1 in the first embodiment. 3 is a flowchart illustrating paste destination input attribute information acquisition processing executed by a CPU 11 of FIG. 1 in the first embodiment. 3 is a flowchart showing a paste process to an absolute cell position executed by a CPU 11 of FIG. 1 in the first embodiment. 6 is a diagram illustrating an example of copy source table data according to the first embodiment. FIG. 6 is a diagram illustrating an example of table data of a paste destination in Embodiment 1. FIG. The table data created when the setting shown in FIG. 3 is performed on the input attribute information setting screen 131, the block B2: D5 shown in FIG. 14 is copied, and B4 shown in FIG. 15 is pasted as the base point of the paste destination. FIG. (A)-(d) is a figure which shows an example of the table data of the copy origin in Embodiment 1, (e) is a figure which shows an example of the table data of a paste destination. It is a figure which shows an example of the table data produced in the worksheet of worksheet name "Nationwide sales situation" based on the table data of Fig.17 (a)-(d) in Embodiment 1. FIG. FIG. 19 is a diagram illustrating setting input contents on an input attribute information setting screen 131 when the table data illustrated in FIG. 18 is created based on the table data illustrated in FIGS. 17A to 17D in the first embodiment. 10 is a diagram illustrating an example of an input attribute information setting screen 132 displayed on the display device 13 of FIG. 1 in Embodiment 2. FIG. It is a figure which shows an example of the data structure of the input attribute information produced | generated in Embodiment 2. FIG. 6 is a flowchart showing an input attribute information generation process B of priority N executed by the CPU 11 of FIG. 1 in the second embodiment. 10 is a diagram illustrating an example of a data structure of copy source information generated in the second embodiment. FIG. 10 is a flowchart illustrating paste destination input attribute information acquisition processing B executed by the CPU 11 of FIG. 1 in the second embodiment. 6 is a flowchart showing a paste process B to an absolute cell position executed by a CPU 11 of FIG. 1 in the second embodiment. 6 is a diagram illustrating an example of copy source table data in Embodiment 2. FIG. It is a figure which shows an example of the table data of the paste destination in Embodiment 2. Table data created when the setting shown in FIG. 20 is performed on the input attribute information setting screen 132, the block B2: D7 shown in FIG. 26 is copied, and B4 shown in FIG. 27 is pasted as the base point of the paste destination. FIG. Table data created when the setting shown in FIG. 20 is performed on the input attribute information setting screen 132, the B2: D7 block shown in FIG. 26 is copied, and B4 shown in FIG. 27 is pasted as the base point of the paste destination. FIG. 10 is a diagram illustrating an example when unnecessary cells that do not satisfy the conditional expression are deleted. 10 is a diagram illustrating an example of an input attribute information setting screen 133 displayed on the display device 13 of FIG. 1 in Embodiment 3. FIG. 10 is a flowchart illustrating a copy source information generation process C for one cell executed by a CPU 11 of FIG. 1 in the third embodiment. 10 is a flowchart illustrating input attribute information acquisition processing of a target cell executed by a CPU 11 of FIG. 1 in Embodiment 3. It is a figure which shows an example of the data structure of the copy source information produced | generated in Embodiment 3. FIG. 10 is a flowchart showing a paste process C executed by a CPU 11 of FIG. 1 in Embodiment 3.

Explanation of symbols

1 Table Editing Device 11 CPU
12 Input device 13 Display device 131 Input attribute information setting screen 132 Input attribute information setting screen 133 Input attribute information setting screen 14 RAM
15 Storage Device 151 Table Editing Software 16 Bus

Claims (12)

In a table editing device for copying / pasting table data,
A setting means for setting permission conditions for permitting the paste for each block of the paste destination table data;
Storage means for storing the setting contents set by the setting means;
Paste control means for performing paste on the basis of the setting contents stored in the storage means when copying the copy source table data and pasting to the paste destination table data;
A table editing apparatus characterized by comprising:   The table editing apparatus according to claim 1, wherein the setting unit is capable of setting a data attribute permitting paste as a permission condition permitting the paste.   The setting means is capable of setting a determination condition for determining whether or not paste is permitted and a target cell used for determining whether or not the paste is permitted as permission conditions for permitting the paste. 2. The table editing apparatus according to 2.   The target cell is a cell included in the table data of the copy source, and the determination condition for determining whether or not to paste is a conditional expression indicating whether or not the target cell includes a predetermined character string The table editing apparatus according to claim 3, wherein: The setting means can set a priority order to the contents set for each block of the pasted table data,
The storage means stores the setting contents together with priorities,
The table editing apparatus according to any one of claims 1 to 4, wherein the paste control unit executes paste based on a priority order stored in the storage unit. In a table editing device for copying / pasting table data,
A setting means for setting permission conditions for permitting copying for each block of the copy source table data;
Storage means for storing the setting contents set by the setting means;
A copy control means for copying the copy source table data based on the setting contents stored in the storage means;
Paste control means for pasting the table data copied by the copy control means into the paste-destination table data;
A table editing apparatus characterized by comprising:   The table editing apparatus according to claim 6, wherein the setting unit is capable of setting a data attribute that permits copying as a permission condition for permitting the copying.   The setting unit is capable of setting a determination condition for determining whether copying is possible and a target cell used for determining whether copying is possible as permission conditions for permitting the copying. 8. The table editing device according to 7.   The target cell is a cell included in the table data of the copy source, and the determination condition for determining whether copying is possible is a conditional expression indicating whether the target cell includes a predetermined character string The table editing apparatus according to claim 8, wherein: The setting means can set a priority order for the contents set for each block of the copy source table data,
The storage means stores the setting contents together with priorities,
10. The table editing apparatus according to claim 6, wherein the copy control unit performs copying based on a priority order stored in the storage unit. 11. Computer
Setting means for setting permission conditions for permitting paste for each block of table data at the paste destination,
Storage means for storing the setting contents set by the setting means;
Paste control means for performing paste on the basis of the setting contents stored in the storage means when copying the copy source table data and pasting to the paste destination table data;
Program to function as. Computer
Setting means for setting permission conditions to permit copying for each block of copy source table data,
Storage means for storing the setting contents set by the setting means;
Copy control means for copying the copy source table data based on the setting contents stored in the storage means;
Paste control means for pasting the table data copied by the copy control means into the paste-destination table data;
Program to function as.

Images