JP2011118703A - Comparison program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a comparison program allowing one-glance acquisition of a row number in an original file of a changed row when comparing original files created by spreadsheet software. <P>SOLUTION: When comparing an original file A indicated in Fig.2(a) and an original file B indicated in Fig.2(b) created by the spreadsheet software, a comparison result file A indicated in Fig.2(c) and a comparison result file B indicated in Fig.2(d) are created. Because the same information is set in the same row number in the comparison result file A and the original file A, it can be obtained at a glance that the third row, the fifth row, and the sixth row of the original file A are changed if seeing the comparison result file A indicated in the Fig.2(c). Because the same information is set in the same row number in the comparison result file B and the original file B, it can be obtained at a glance that the third row, the fourth row, the sixth row, and the eighth row of the original file B are changed if seeing the comparison result file B indicated in the Fig.2(d). <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a comparison program, and in particular, when comparing two original files created by spreadsheet software, a comparison program that can grasp at a glance the line number in the original file of the changed line. It is about.

  Conventionally, software that can compare two original files is known. For example, Microsoft's Word (registered trademark) has the following document comparison function. 8A1 is an output screen of the original file A that is one of the comparison targets, FIG. 8A2 is an output screen of the original file B that is the other of the comparison targets, and FIG. 8A3 is an output screen of the comparison result file. Is shown.

  When the tables shown in FIGS. 8 (a1) and 8 (a2) are created using words, and the two tables are compared using the word document comparison function, the table shown in FIG. 8 (a3) is output. The From the table shown in FIG. 8 (a3), at first glance, “Ito XX, Aichi XX” was deleted by the deletion line in the middle of the character, and “Ota XX, Aichi XX” was inserted by the underline. I can grasp it. In addition to the word document comparison function described above, the software that can compare two original files is a document that, in the next patent document 1, compares the original document with the changed document and displays the changed portion with a proofreading symbol. A processing device is described.

Japanese Patent Laid-Open No. 7-230457

  However, the tables shown in FIGS. 8 (a1) and 8 (a2) do not have line numbers, and it is impossible to grasp at a glance what line they are. Moreover, it is sufficient to create a table with line numbers, but it is troublesome to bother with line numbers. On the other hand, spreadsheet software exemplified by Excel (registered trademark) of Microsoft Corporation is known. The spreadsheet software outputs a grid-like table in which row numbers and column numbers are defined, so there is no need to bother with row numbers. 8 (b1) is a file output screen created by excel with the table shown in FIG. 8 (a1). FIG. 8 (b2) is a file output screen created by excel with the table shown in FIG. 8 (a2). is there. As shown in FIG. 8 (b1) and FIG. 8 (b2), by creating a table in Excel, it is possible to grasp the line number at a glance without adding the line number.

  However, there is no software for comparing original files created with spreadsheet software, such as Excel, and there has been a demand for software capable of comparing original files created with spreadsheet software. In addition, since the file number created by the spreadsheet software is assigned a row number and a column number, there is the following problem even if the word document comparison function is applied as it is.

  FIG. 8B3 is a file output screen in which the table shown in FIG. 8A3 is created in Excel. As shown in FIG. 8 (b3), in the word document comparison function, the deleted line ("Ito xx, Aichi xx") is also output as the comparison result, so the comparison result and the original file There was a problem that the line numbers were shifted and it was difficult to specify the line number of the original file.

  In the comparison result of FIG. 8 (b3), the inserted “Ota XX, Aichi xx” is output on the fifth line, whereas in the original file of FIG. 8 (b2), it is output on the fourth line. . Therefore, the inserted line of “Ota XX, Aichi XX” in the original file in FIG. 8B2 in the end is “Ota XX, Aichi XX” in FIG. 8B2. There is a problem in that it is difficult to identify the line number in the original file of the inserted line without following the character string “XX”.

  The present invention has been made to solve the above-mentioned problems, and when comparing original files created with spreadsheet software, the number in the original file of the changed line can be grasped at a glance. The aim is to provide a comparison program that can do.

Means for Solving the Problems and Effects of the Invention

  According to the comparison program of claim 1, when comparing two files created by spreadsheet software capable of outputting a grid-like table in which line numbers are defined, the first file is one of the two files. The one original file and the other second original file are specified by the specifying step, and information is extracted in line units from each of the specified first original file and second specified file by the extracting step.

  The line information of the first original file and the line information of the second original file, which are the extracted line-by-line information, are compared by the line number specifying step without change, and the same line in the first original file and the second original file. The line number of the first original file having information and the line number of the second original file are specified. In addition, when specifying the line number without change, it is avoided that the line number is duplicated. For example, in two tables formed in three rows, the row information input to the first row of one table and the row information input to each of the first to third rows of the other table are If they are the same, not all of the first to third rows of the other table are specified, and what is specified is any one of the first to third rows of the other table.

  On the other hand, in the copying step, two new files are prepared from the spreadsheet software, and the first original file is copied to one of them and the second original file is copied to the other to create two copied files. Note that copying means that each of the first original file and the second original file is the same as each copy file.

  Each of the two copy files created by the copy step maintains the line number associated with the copied information, so the second original file and the copy file are between the first original file and the copy file. Line numbers do not shift between. Each of the two copy files is set so that the line information corresponding to the line number specified by the line number specifying step without change and the line information corresponding to other line numbers can be identified by the identification information. .

  That is, the line information corresponding to the line number specified by the line number specifying step without change is line information that has not been changed, and the line information corresponding to other line numbers is line information that has been changed. The line information that has not been changed and the line information that has been changed are set to be identifiable by the identification information, so that the changed line information can be grasped at a glance.

  In addition, as described above, the line numbers do not shift between the first original file and the copy file, and between the second original file and the copy file. Can do. Therefore, when files created by spreadsheet software are compared with each other, there is an effect that the line number in the original file of the changed line can be grasped at a glance. In claim 1, the line number, line unit, and line information are described, but claim 1 is not limited to the “line” direction (lateral direction). The line number, line unit, and line information may be in the vertical direction. In other words, row numbers, row units, and row information may be column numbers, column units, and column information.

  According to the comparison program of the second aspect, in addition to the effect produced by the comparison program of the first aspect, the line number and the second number of the first original file having the same line information in the first original file and the second original file When specifying the line number of the original file, the smaller line number is specified preferentially. Therefore, it is possible to specify whether the changed line is a deletion, insertion, or editing change by a method described later.

  Further, of the line numbers of the first original file and the second original file, the line number specified by the no change line number specifying step has no change as the status, and the other line numbers have the status As changed. Therefore, it is possible to grasp a line that has been changed and a line that has not been changed in units of line numbers. The set statuses are extracted in the order of line numbers in the first original file, and are also extracted in the order of line numbers in the second original file. From the combination of both extracted statuses, the changed lines are deleted, inserted, Which change of editing is specified.

  The line number of the first original file is counted by the first counting step, and the set status is extracted by the first extracting step for the line number of the first original file corresponding to the count value. Initially, the status associated with the smallest line number is extracted for both the first source file and the second source file. Thereafter, the count is incremented according to the instructions from the first instruction step and the second instruction step, and the set status is extracted for the line number corresponding to the count value. Similarly, the line number of the second source file is counted by the second count step, and the status set for the line number of the second source file corresponding to the count value is extracted by the second extraction step.

  The combination of the status set to the line number of the extracted first source file and the status set to the line number of the second source file is determined by the determining means. There are the following four combinations. Both are “no change”, both are “changed”, one is “changed”, and the other is “changed”.

  When it is determined that both statuses are not changed or both are changed by the determination step, an instruction is given to count up to each of the first count step and the second count step by the first instruction step. Made. That is, in both cases, the status set to the next line number is extracted.

  If both statuses are determined to be changed, the edit information setting step sets the line information corresponding to the line number of the first source file set to change and the line number of the second source file. Each of the corresponding line information is set in association with editing information indicating that it is edited information in the copy file. In other words, if both statuses are changed, both lines can be identified as having been edited, so in the copy file, by setting the edit information in association with both lines, both lines have changed. Furthermore, it is possible to grasp that the line has been edited. If both statuses are not changed, the copy file is not set.

  On the other hand, if it is determined in the determination step that only one of the two statuses is changed, if the change is set in the line number of the first original file, the first instruction step counts up to the first count step. If the change is set to the line number of the second original file, the second count step is instructed to count up. That is, the status set to the next line number is extracted only in the changed line by the first and second extraction steps.

  Also, if it is determined that only the status set in the line number of the first original file among the two statuses is changed, the line information corresponding to the line number of the first original file is determined by the deletion information setting step. And deletion information indicating deleted information are set in association with each other in the copy file. That is, in this case, since the corresponding line in the first original file can be specified as deleted line information, the line is changed by setting the copy file by associating the deleted information with the line. It can be recognized that this is a deleted line. In this case, it is possible to specify that the corresponding line in the first source file is deleted line information, as described later, only the status set in the line number of the second source file is changed. If it is determined that there is, the relationship is that the corresponding line of the second source file is inserted. Therefore, this relationship may be reversed.

  On the other hand, if it is determined that only the status set in the line number of the second source file is changed, the line information corresponding to the line number of the second source file is determined by the insertion information setting step. Insertion information indicating the inserted information is set in association with the copy file. That is, in this case, since the corresponding line in the second source file can be specified as being inserted, by setting the copy file by associating the insertion information with the line, the line has been changed, , You can figure out that it is an inserted line.

  As described above, the statuses set for the respective line numbers are extracted from the first original file and the second original file in order of increasing line numbers, and the status of the extracted first original file and the status of the second original file are extracted. In accordance with the combination, the change type (deletion, insertion, editing) of the changed line is specified, and the specified type is set in the corresponding copy file. That is, since the change type (deletion, insertion, editing) is set in parallel for the two copy files, the change type (deletion, insertion, edit) is efficiently set for the two copy files. Can do.

  In the comparison program according to claim 3, in addition to the effect produced by the comparison program according to claim 2, the first column is inserted in each of the two copy files created by the copy step by the insert step. Edit information, delete information, and insert information are set by the edit information setting step, the delete information setting step, and the insert information setting step at the corresponding row number position in the first column. Therefore, the column numbers of the first original file and the second original file are shifted by one column with respect to the copy file, but the line number does not change, and the line number does not change before and after the change. This has the effect of making it easier to grasp which line has been edited, deleted, or inserted.

It is the block diagram which showed the electrical constitution of the personal computer in which the comparison program is installed. (A) is the output screen of the original file A that is one of the comparison targets, (b) is the output screen of the original file B that is the other of the comparison targets, (c) is the output screen of the comparison result file A, and (d) is It is a figure which shows the output screen of the comparison result file. (A1) is a comparison table A at the beginning of creation, (a2) is a comparison table A after update, (b1) is a comparison table B at the beginning of creation, and (b2) is a diagram schematically showing a comparison table B after update. It is. It is a flowchart which shows a comparison process. It is a flowchart which shows a line number specific process without a change. It is a flowchart which shows a comparison result file creation process. It is a flowchart which shows a combination judgment process. (A1) is an output screen of the original file A that is one of the comparison targets, (a2) is an output screen of the original file B that is the other of the comparison targets, and (a3) is a diagram illustrating an output screen of the comparison result file. (B1) is an output screen of a file created by Excel from the table shown in FIG. 8 (a1), (b2) is an output screen of a file created by Excel from the table shown in FIG. 8 (a2), and (b3) is an output screen of FIG. It is a figure which shows the output screen of the file which produced the table | surface shown to (a3) by Excel.

  Hereinafter, preferred embodiments of the present invention will be described with reference to the accompanying drawings. FIG. 1 is a block diagram showing an electrical configuration of a personal computer 1 (hereinafter “PC1”) in which a comparison program 5b according to an embodiment of the present invention is installed. The comparison program 5b is a program that can grasp at first glance the number in the original file of the changed line when the original files created by the spreadsheet software are compared.

  The PC 1 is a device that performs calculations in accordance with various programs. The PC 1 is mainly provided with a CPU 2, a ROM 3, a RAM 4, and a hard disk 5. In addition, a CRT 6 as a display device, a keyboard 7 as an input device, and an I / O connected to an external device. F8 and the like are provided, and these are connected to each other via a bus line 9.

  The CPU 2 is a processor that executes various programs, the ROM 3 is a non-rewritable memory that stores various programs executed by the PC 1, and the RAM 4 temporarily stores variables and the like when the CPU 2 executes various programs. This is a randomly accessible memory having a working area and the like. In particular, a comparison table A memory 4a, a comparison table B memory 4b, an i counter 4c, and a j counter 4d are allocated to the RAM 4.

  The comparison table A memory 4a stores the comparison table A shown in FIGS. 3 (a1) and 3 (a2). In the comparison table A, information related to the original file A that is one of the comparison targets is stored in units of lines. The comparison table B memory 4b stores the comparison table B shown in FIGS. 3 (b1) and 3 (b2). In the comparison table B, information on the original file B which is the other of the comparison targets is stored in units of lines. The comparison result between the original file A and the original file B to be compared is created with reference to the comparison tables A and B. Details of the comparison tables A and B will be described later.

  The i counter 4c is a counter that counts the line number of the original file A, and the j counter 4d is a counter that counts the line number of the original file B. When there is an instruction to count up, the counter is counted by "1". Various processes are executed for the line number corresponding to the counter value indicated by.

  The hard disk 5 is a rewritable nonvolatile memory, and data stored in the hard disk 5 is retained even after the PC 1 is turned off. In particular, the hard disk 5 stores an Excel 5a and a comparison program 5b.

  Excel 5a is one of spreadsheet applications. In this embodiment, the original file A (FIG. 2 (a)), which is one of the two original files created in Excel 5a, is the original file B ( FIG. 2B is compared.

  The comparison program 5b is a program that compares the two original files created in Excel 5a and creates a comparison result file. The comparison process shown in FIG. 4, the no-change line number specifying process shown in FIG. This is a program for causing the CPU 2 to execute the comparison result file creation processing shown.

  2A is an output screen of the original file A that is one of the comparison targets, FIG. 2B is an output screen of the original file B that is the other of the comparison targets, and FIG. FIG. 2D is a diagram showing an output screen of the comparison result file B.

  The file created in Excel 5a is displayed in a grid-like table in which 1, 2, 3,... In the horizontal direction as row numbers and A, B, C,. The information entered in each square is output to the output screen.

  As shown in FIG. 2A, in the original file A which is one of the comparison targets, “a”, “−”, “i”, “a”, "E", "-", "O" characters, "ka", "-", "ki", "ka", "ke", "-", The character “ko” is entered.

  As shown in FIG. 2B, the original file B, which is the other comparison target, has “a”, “−”, “i”, “wa” in the first column in order from the first row. "A", "YA", "O", "O" characters, "ka", "-", "n", "O", "KA", in the second column in order from the first row “Yu”, “ko” and “ko” are entered.

  When the original files A and B are compared by the comparison program 5b, a comparison result file A output as shown in FIG. 2C and a comparison result file B output as shown in FIG. 2D are created. To do. The comparison result file A corresponds to the original file A, and the comparison result file B corresponds to the original file B.

  The comparison result files A and B are created without shifting the line numbers of the original files A and B. That is, the comparison information file A and the original file A are set with the same information at the same line number, and the comparison result file B and the original file B are set with the same information at the same line number. On the other hand, in the comparison result files A and B, the first column is inserted with respect to the original files A and B, and “delete”, “insert”, “edit” are inserted in the corresponding rows of the inserted first column. "Is set. In addition, coloring is set only for all the columns in which “Delete” and “Insert” are set, and only in the column in which “Edit” is set for the row where “Edit” is set.

  Therefore, if the comparison result file A shown in FIG. 2C is viewed, the third line, the fifth line, and the sixth line of the original file A are changed. The change in the third line and the change in the fifth line are “edit”, and the change in the sixth line is “delete”. Furthermore, it can be understood at a glance that “edit” was part of the third row and all of the fifth row.

  Similarly, if the comparison result file B shown in FIG. 2D is viewed, the third line, the fourth line, the sixth line, and the eighth line of the original file B are changed. In addition, the third line change and the sixth line change are “edit”, the fourth line change, and the eighth line change are “insert”. Furthermore, it can be understood at a glance that “editing” was part of the third row and all of the sixth row.

  3 (a1) is the comparison table A at the beginning of creation, FIG. 3 (a2) is the comparison table A after the update, FIG. 3 (b1) is the comparison table B at the beginning of the creation, and FIG. 3 (b2) is the comparison table after the update. It is a figure which shows B typically.

  The comparison tables A and B are tables created for each original file to be compared. In this embodiment, the comparison table A is created for the original file A and the comparison table A is created for the original file B. The comparison tables A and B are initially created as shown in FIGS. 3 (a1) and (b1), and the statuses of the comparison tables A and B are as shown in FIGS. 3 (a2) and 3 (b2). Set.

  The comparison tables A and B are created by associating a character string, a hash value, and a status for each line number of the original file. The line number is the line number of the original file, and is the line number from the first line to the last line number in which information is input. A character string is all characters associated with the same line number. The characters include numbers and symbols. The hash value is obtained by digitizing each character string using a predetermined hash function. The status is information indicating whether there is a change or a change, and is set to “changed” when there is a change, and “no change” when there is no change. 3) As shown in FIG. 3 (b1), the statuses of the comparison tables A and B are all set to “changed” at the beginning.

  The comparison table A shown in FIG. 3A1 is created from the original file A shown in FIG. In the original file A shown in FIG. 2A, since characters are input from the first line to the seventh line, “1” to “7” are set to the line numbers of the comparison table A. Also, since “A” is input in the first column and “I” is input in the second column in the first row of the original file A, “Aka” is used as the character string corresponding to the line number “1”. Set. In the hash value, “100” is set as a hash value obtained by hashing “Aka” of the character string. Regardless of whether or not there is a change, the status is initially set to “change”. In this way, the comparison table A shown in FIG. Similarly, the comparison table B shown in FIG. 3B1 is created from the original file B shown in FIG.

  The comparison tables A and B shown in FIGS. 3 (a1) and 3 (b1) indicate the status corresponding to the line number that has not been changed in the no-change line number specifying process shown in the flowchart of FIG. To “no change”. Specifically, as shown in FIG. 3A2, the comparison table A shown in FIG. 3A1 indicates the statuses of the first row, the second row, the fourth row, and the seventh row as “ Set “Changed” to “No change”. In addition, the comparison table B shown in FIG. 3B1 sets the status of the first row, the second row, the fifth row, and the seventh row to “changed” as shown in FIG. 3B2. To “no change”.

  Note that the comparison result file creation process shown in the flowchart of FIG. 6 is executed with reference to the comparison tables A and B shown in FIGS. 3 (a2) and 3 (b2), and FIGS. 2 (b) and 2 (d). The comparison result files A and B output as shown in FIG.

  FIG. 4 is a flowchart showing the comparison process. This process is a process of comparing two original files created in Excel 5a and creating a comparison result file, and is executed by the CPU 2 in accordance with the comparison program 5b. This process is executed when the comparison program 5a is activated by the user.

  In this process, first, it is determined whether two original files (original file A and original file B) to be compared have been identified (S401). The two original files are arbitrarily designated by the user, and when the two original files are designated by the user, the two designated original files are specified (S401: Yes). If two original files are not designated, it is determined that the two original files cannot be specified (S401: No), and this process is terminated.

  When the two original files are specified (S401; Yes), each of the two original files is converted into text (S402), and the comparison table A corresponding to the original file A is obtained from the converted data (see FIG. 3 (a1)). Then, a comparison table B (see FIG. 3B1) corresponding to the original file B is created (S403).

  When the comparison tables A and B are created (S403), the unchanged line number specifying process shown in the flowchart of FIG. 5 is executed (S404), and the original file A having the same line unit information in the original file A and the original file B is executed. And the line number of the original file B are specified. That is, the line number that has not been changed between the original file A and the original file B is specified. Further, in the comparison tables A and B shown in FIGS. 3 (a1) and 3 (b1), the statuses that are initially set to “changed” are all the comparison tables shown in FIGS. 3 (a2) and 3 (b2). As in A and B, the status corresponding to the line that has not been changed is set from “changed” to “no change”.

  In this way, the status of the comparison tables A and B shown in FIGS. 3 (a1) and 3 (b1) is set by the line number specifying process without change (S404), and then the comparison tables A and B are referred to. 6 is executed (S405), the comparison result files A and B output as shown in FIGS. 2C and 2D are created, and this process ends. .

  FIG. 5 is a flowchart showing the line number specifying process without change. This process is a process for specifying a line number that has not been changed in the original files A and B. Further, in the comparison tables A and B shown in FIGS. 3 (a1) and 3 (b1), the statuses that are initially set to “changed” are as shown in FIGS. 3 (a2) and 3 (b2). In this process, the status corresponding to the line that has not been changed is set from “changed” to “no change”.

  In this process, first, the final value K of iCnt and the final value L of jCnt are set (S501). iCnt is a counter value corresponding to the line number of the original file A. In this embodiment, since the last line to which data is input in the original file A is the seventh line, the final value K is set to “7”. jCnt is a counter value corresponding to the line number of the original file B. In this embodiment, since the last line to which data is input in the original file B is the eighth line, the final value L is set to “8”.

  Next, after setting “1” to iCnt (S502) and “1” to jCnt (S503), referring to the comparison table B shown in FIG. 3B1, the status associated with jCnt is “ It is determined whether or not there is a change (S504). The process of S504 is a process for preventing duplicate identification. As shown in FIG. 3B1, since all the statuses of the comparison table B are initially set to “changed”, jCnt is “1”. In this case, the status is “changed” (S504; Yes).

  Next, it is determined whether the “hash value” corresponding to iCnt matches the “hash value” corresponding to jCnt (S505). That is, if the two “hash values” match, it is determined that the line of the original file A and the line of the original file B that are currently compared are the same and no change has occurred. By this processing, it is determined whether or not both have the same information in units of lines, that is, lines that have not been changed.

  In this embodiment, different character strings are set to different hash values, and the same character string is set to the same hash value. A well-known method such as a chain method can be employed.

  As a result of the determination in S505, if both “hash values” match (S505: Yes), the status corresponding to iCnt in the comparison table A shown in FIG. In addition, the status corresponding to jCnt in the comparison table B shown in FIG. 3B1 is set from “changed” to “no change” (S506).

  As a result of the processing in S506, it can be identified that the line corresponding to iCnt and the line corresponding to jCnt are unchanged, it is determined whether the next line of the original file A has been changed. That is, “1” is added to iCnt (S507), and it is determined whether iCnt is not more than the final value K (S508). If iCnt is not more than the final value K (S508: Yes), the processing from S503 is performed again. repeat. That is, the second line of the original file A is determined.

  When it is determined whether or not the second line of the original file A has been changed, jCnt is set to “1” again (S503), and it is determined whether or not the status associated with jCnt is “changed”. (S504). In this embodiment, since the status of the first row of the comparison table B shown in FIG. 3B1 is set to “no change” in the processing of S506, it is associated with jCnt (= 1). Is determined to be “no change” (S504: No).

  Therefore, next, in order to compare with the second line of the original file B, “1” is added to jCnt (S509), it is judged whether jCnt is the final value L or less (S510), and jCnt is less than the final value L. If (S510: Yes), the processing from S504 is repeated again. In the present embodiment, as shown in the comparison table B in FIG. 3B1, the status of the second line of the original file B is set to “changed” (S504: Yes), and so on. Then, the same processing as that of the first line is executed, and then the processing from S503 is repeated again to determine the third line of the original file A.

  For the third line of the original file A, the statuses of the first and second lines of the comparison table B shown in FIG. 3 (b1) are set to “no change” by the process of S506 described above. After the processes of S504, S509, and S510 are repeated twice, it is determined that “changed” is set in the process of S504 (S504: Yes), and the third line of the original file A is determined in the process of S505. It is determined whether or not the “hash value” of the original file B matches the “hash value” of the third line of the original file B (S505).

  However, as shown in FIG. 3 (a1), the hash value of the third row of the comparison table A is “111”, and as shown in FIG. 3 (b1), the hash value of the third row of the comparison table B is Since it is “146” and the two do not match (S505: No), the process proceeds to S509. Thereafter, the processes of S509, S510, S504 (Yes), and S505 (No) are repeated, but as shown in the comparison table B of FIG. 3B1, the hash value “111” in the third row of the comparison table A The same hash value as “” does not exist in the comparison table B.

  Therefore, in the process of S510, it is determined that the value of jCnt is larger than the final value L (S510: No), and the process of S506 is performed with the third line of the original file A being changed. Without performing this, the process proceeds to S507. Thereafter, in the process of S508, the above process is repeated until iCnt becomes larger than the final value K (S508: No), that is, until the last line K of the original file A is processed. Exit.

  By the above-described line number specifying process without change, the line number having the same information in the original file A and the original file B (the line number that has not been changed) is identified without duplication, and a small line number is obtained. It can be identified with priority. In addition, in the comparison tables A and B shown in FIGS. 3 (a1) and 3 (b1), the statuses associated with the unchanged rows are as shown in FIGS. 3 (a2) and 3 (b2). In addition, “changed” to “no change” can be set.

  FIG. 6 is a flowchart showing the comparison result file creation process. This processing is performed by referring to the comparison tables A and B shown in FIGS. 3 (a2) and 3 (b2), and the comparison result file A that can output the output screen shown in FIGS. 2 (c) and 2 (d). , B are created.

  In this process, first, a copy file A obtained by copying the original file A and a copy file B obtained by copying the original file B are created (S601). Copy files A and B are created by preparing two new files from Excel 5a and copying (copying) original file A to one of the new files and original file B to the other (S602). The comparison result files A and B are created in the copy files A and B without shifting the line numbers. Thus, the line numbers do not shift between the original file A and the comparison result file A and between the original file B and the comparison result file B. Also, the first row is inserted into the created copy files A and B (S602). In the inserted first column, as shown in FIGS. 2C and 2D, the characters “edit”, “delete”, and “insert” are set. From this, it is possible to grasp at first glance the type of change for the changed line.

  Thereafter, as described in S501 to S503 of FIG. 5, the final value K of iCnt and the final value L of jCnt are set (S603), “1” is set to iCnt, and “1” is set to jCnt (S604). ). Next, it is determined whether iCnt is less than or equal to the final value K and jCnt is less than or equal to the final value L (S605). If not applicable (S605: No), this process is terminated, and if applicable (S605: Yes). , The process proceeds to S606.

  That is, the processing of S606 to S613 is performed on all lines from the first line to the last line K of the original file A and all lines from the first line to the last line L of the original file B, and the original file A When the processes of S606 to S613 are performed for all the lines and all the lines of the original file B (S605: No), this process ends.

  In the process of S606, it is determined whether iCnt is equal to or smaller than the final value K (S606). If applicable, the process proceeds to S609. If not applicable (S606: No), iCnt is set to the final line K (S607). ), The status corresponding to the last row K is set to “no change” (S608). With this process, after iCnt is processed to the last row K, the combination determination process shown in the flowchart of FIG. 7 can be executed for the remaining jCnt.

  In the process of S609, similarly to the above, it is determined whether jCnt is equal to or less than the final value L (S609). If it is applicable, the process proceeds to S612. If not applicable (S609: No), jCnt is set to the final line. L is set (S610), and the status corresponding to the last row L is set to “no change” (S611).

  In the process of S612, the status corresponding to iCnt is extracted from the comparison table A shown in FIG. 3 (a2) and the status corresponding to jCnt is extracted from the comparison table B shown in FIG. 3 (b2) (S612). For the status, the combination determination process shown in the flowchart of FIG. 7 is executed (S613).

  FIG. 7 is a flowchart showing the combination determination process. In this process, the combination of the two statuses extracted in S612 is specified, and according to the combination, the line in which “changed” is set as the status, “delete”, “insert”, “edit” Any of the above is associated with the copy files A and B.

  In this process, first, it is determined whether only the status corresponding to iCnt is “changed” (S701). If applicable (S701: Yes), the cell corresponding to jCnt in the first column of copy file A is checked. The character “delete” is set (S702), and coloring is set for the corresponding line of iCnt of the copy file A (S703).

  When only the status of the original file A is “changed”, the line of the original file A corresponding to the status is a line “deleted” from the original file B. Therefore, in the copy file A, the character “deleted” is set in association with the corresponding line to clarify that the corresponding line in the copy file A is the “deleted” line. After the processing of S703, “1” is added to iCnt (S704), and the line number is incremented by “1” only for the original file A.

  Next, in the determination of S701, if not applicable (S701: No), in the processing of S705, it is determined whether only the status corresponding to jCnt is “changed” (S705), and if applicable (S705: Yes), the character “insert” is set in the cell corresponding to jCnt in the first column of the copy file B (S706), and the color corresponding to jCnt in the copy file B is set (S707).

  When only the status of the original file B is “changed”, the line of the original file B corresponding to the status is an “inserted” line that does not exist in the original file A. Therefore, in the copy file B, the corresponding line is set in association with the character “insert”, and it is clarified that the corresponding line is “inserted” in the copy file B. After the process of S707, “1” is added to jCnt (S708), and the line number is incremented by “1” only for the original file B.

  Next, when the determination of S705 is not satisfied (S705: No), it is determined in the processing of S709 whether both the status corresponding to iCnt and the status corresponding to jCnt are “changed” (S709). ), If applicable (S709: Yes), the character “edit” appears in the cell corresponding to iCnt in the first column of copy file A and the cell corresponding to jCnt in the first column of copy file B. Is set (S710).

  When both statuses are “changed”, both lines corresponding to the status are “edited” lines. Therefore, in the copy file A and the copy file B, the characters “edit” appear on both lines. To make it clear that both lines are “edited”.

  In addition, in the case of editing, it is assumed that all of the corresponding lines are edited, and that a part of the corresponding lines is partially edited, so that it corresponds to the iCnt of the copy file A. The line corresponding to JCnt of the copy file B is compared for each square (each column), and if the data of each square does not match, coloring is set for that square (S711). ). By this process, in the case of editing, only the edited column can be colored, and the edited part can be grasped at a glance. After the processing of S711, “1” is added to iCnt and “1” is added to jCnt (S712), and the line numbers are incremented by “1” for both the original files A and B.

  Finally, if it is determined in the processing of S709 that it is not applicable (S709: No), both the status corresponding to iCnt and the status corresponding to jCnt are “no change” from the number of patterns of combination. Therefore, no setting is made for the copy files A and B, and “1” is added to iCnt and “1” is added to jCnt (S712), and the line number is set to “1” for both the original files A and B. Raise it.

  As described above, in the comparison result file creation process shown in the flowchart of FIG. 6, the combination determination process shown in the flowchart of FIG. 7 is performed (S611), and all the lines from the first line to the last line K of the original file A are changed. The copy files A and B created in S601 are set in S702, S703, S706, S707, S710, and S711 by performing each of the first line to the last line L of the original file B. Comparison result files A and B having contents can be created. Since the copy files A and B are copies of the original files A and B, the comparison result file A and the original file A have the same information on the same line number, and the comparison result file B and the original file B have the same line. The same information is set for the number, and the line that has been changed (deleted, inserted, edited) is associated with the characters “Delete”, “Insert”, and “Edit”. Therefore, it is possible to grasp at a glance the line number in the original file of the line that has been changed (deleted, inserted, edited).

  Further, in the comparison result file creation process shown in the flowchart of FIG. 6, the statuses set for the respective line numbers are extracted from the original files A and B (comparison tables A and B) in ascending order of the line numbers. According to the combination of the status of the original file A and the status of the original file B, the change type (deletion, insertion, edit) of the changed line is specified, and the specified type is set in the corresponding copy file. Set. That is, since the change type (deletion, insertion, editing) is set in parallel for the two copy files, the change type (deletion, insertion, edit) is efficiently set for the two copy files. Can do.

  Next, the combination determination process shown in the flowchart of FIG. 7 will be described with reference to the comparison tables A and B shown in FIGS. 3 (a2) and 3 (b2).

  First, the status set in the first row is extracted from the comparison tables A and B shown in FIGS. 3 (a2) and 3 (b2). Since both statuses are “no change”, nothing is set for the copy files A and B, and both line numbers are incremented by “1”.

  Next, the status set in the second row is extracted from the comparison tables A and B. Also in this case, since both statuses are “no change”, nothing is set for the copy files A and B, and both line numbers are incremented by “1”.

  Next, the status set in the third row is extracted from the comparison tables A and B. In this case, both statuses are “changed”, so the third line of the original file A and the third line of the original file B are “edited” lines. Therefore, the third row of the copy file A and the third row of the copy file B are compared for each column. In this embodiment, as shown in FIG. 2C, the third row and third column of the copy file A is “ki”, and as shown in FIG. 2D, the third row and third column of the copy file B is “ It ’s different. Therefore, in the copy file A, the character “edit” is set in the third row and the first column, and the coloring is set in the third row and the third column. In the copy file B, the character “edit” is set in the third row and the first column, and the coloring is set in the third row and the third column. Further, both line numbers are incremented by “1”.

  Next, the status set in the fourth row is extracted from the comparison tables A and B. In this case, only the status set in the fourth line of the original file B (comparison table B) is “changed”, so the fourth line of the original file B is the “inserted” line. Therefore, in the copy file B, the character “insert” and the coloring are set in the fourth row and first column. Also, the line number is incremented by “1” only for the original file B.

  Next, the statuses set in the fourth row of the comparison table A and the fifth row of the comparison table B are extracted. In this case, since both statuses are “no change”, nothing is set for the copy files A and B, and both line numbers are incremented by “1”.

  Next, the statuses set in the fifth row of the comparison table A and the sixth row of the comparison table B are extracted. In this case, since both statuses are “changed”, the fifth line of the original file A and the sixth line of the original file B are “edited” lines. Therefore, the fifth row of the copy file A and the sixth row of the copy file B are compared for each column. In the present embodiment, as shown in FIG. 2 (c), the fifth row and second column of the copy file A is “e”, and as shown in FIG. The column is different by “ya”. Further, as shown in FIG. 2C, the fifth row and third column of the copy file A is “K”, and as shown in FIG. 2D, the sixth row and third column of the copy file B is Different in “yu”. Therefore, in the copy file A, the character “edit” is set in the fifth row and first column, and coloring is set in the second and third columns of the fifth row. In the copy file B, the character “edit” is set in the sixth row and first column, and coloring is set in the second and third columns of the sixth row. Further, both line numbers are incremented by “1”.

  Next, the statuses set in the sixth row of the comparison table A and the seventh row of the comparison table B are extracted. In this case, since only the status set in the sixth line of the original file A is “changed”, the sixth line of the original file A is an “inserted” line. Therefore, in the copy file B, the character “deleted” and coloring are set in the sixth row and first column. Also, the line number is incremented by “1” only for the original file A.

  Next, the statuses set in the seventh row of the comparison table A and the seventh row of the comparison table B are extracted. In this case, since both statuses are “no change”, nothing is set for the copy files A and B, and both line numbers are incremented by “1”.

  Here, since the line number of the original file A is “8” and exceeds the last line “7” of the original file A, the line number of the original file A is set to the last line “7”. Set the status corresponding to the line to “no change”. Then, the statuses set in the seventh row of the comparison table A and the eighth row of the comparison table B are extracted. In this case, since only the status set in the eighth line of the original file B is “changed”, the eighth line of the original file B is an “inserted” line. Therefore, in the copy file B, the character “insert” and coloring are set in the eighth row and first column. Also, the line number is incremented by “1” only for the original file B.

  Thus, upon completion of the combination determination process shown in the flowchart of FIG. 7 for all lines “7” of the original file A and all lines “8” of the original file B, the copy file created in S601 of FIG. A and B can be created as comparison result files A and B output as shown in FIGS. 2 (c) and 2 (d).

  Here, since the same information is set in the same line number in the comparison result file A and the original file A, if the comparison result file A shown in FIG. , The 5th line and the 6th line were changed. The change in the third line and the change in the fifth line are “edit”, and the change in the sixth line is “delete”. Furthermore, it can be understood at a glance that “edit” was part of the third row and all of the fifth row.

  Similarly, since the same information is set in the same line number in the comparison result file B and the original file B, if the comparison result file B shown in FIG. The line 4, the fourth line, the sixth line, and the eighth line have been changed. In addition, the third line change and the sixth line change are “edit”, the fourth line change, and the eighth line change are “insert”. Furthermore, it can be understood at a glance that “editing” was part of the third row and all of the sixth row.

  The present invention has been described above based on the embodiments. However, the present invention is not limited to the above embodiments, and various improvements and modifications can be made without departing from the spirit of the present invention. It can be easily guessed.

  In the embodiment described above, a case has been described in which the same information is set in the same line number in the comparison result file A and the original file A, and the same information is set in the same line number in the comparison result file B and the original file B. The comparison result file A and the original file A may be configured to set the same information for the same column number, and the comparison result file B and the original file B may be set to the same information for the same column number. Even in this case, an effect similar to that of the present embodiment can be obtained.

  Further, in the above-described embodiment, in the flowchart of FIG. 7, “delete” (S702) when only the status corresponding to iCnt is “changed” (S702), and “insert” when only the status corresponding to jCnt is “changed”. Although the case of (S703) has been described, this relationship may be reversed.

  Further, when two original files A and B are specified in S401 in the flowchart of FIG. 4, the original file A shown in FIG. 2A is changed to the original file B, and the original file B shown in FIG. It is also possible to configure the two original files A and B to be specified and compared as in the present embodiment after the user designates the changed file. In such a case, “delete” is set in the comparison result file A corresponding to the original file A that is the file before the change, and “insertion” is set in the comparison result file B corresponding to the original file B that is the file after the change. Therefore, the comparison result can be easily grasped.

  Further, in the above-described embodiment, a case has been described in which “delete”, “insert”, and “edit” are specified as the change types for the changed rows. Only the presence / absence may be specified, and only the presence / absence of the change may be set in the copy file. In this case, although the type of change cannot be specified, the line number in the original file of the changed line can be specified, and the comparison result file can be created at a higher speed than when the type of change is specified.

  Further, in the above-described line number specifying process without change in FIG. 5, the case where the line numbers that have not been changed are specified for the original file A and the original file B has been described. The file B may be specified. Even in such a case, the same effect as the line number specifying process without change can be obtained.

5b Comparison program S401 Comparison file identification step S402, S403 Extraction step S404 Unchanged line number identification step S405 Setting step S601 Copying step S612 First extraction step, second extraction steps S701, S705, S709 Judgment step S712 First counting step, first 1 instruction step S704, S708 2nd count step, 2nd instruction step S710 Edit information setting step S702 Delete information setting step S706 Insertion information setting step

Claims (3)

A comparison program for comparing two files created by spreadsheet software that can output a grid-like table with line numbers defined,
A comparison file specifying step of specifying a first original file which is one of the two files and a second original file which is the other;
An extraction step for extracting information line by line from each of the first original file and the second original file specified by the comparison file specifying step;
The line information of the first original file, which is line-by-line information extracted by the extraction step, is compared with the line information of the second original file, and the same for the first original file and the second original file A line number specifying step without change for specifying the line number of the first original file and the line number of the second original file having line information, avoiding duplication specification,
A copy step of creating two new files by causing the spreadsheet software to prepare two new files, copying the first original file to one of them and the second original file to the other;
For each of the two copy files created by the copying step, the line information corresponding to the line number specified by the unchanged line number specifying step is maintained while maintaining the line number associated with the copied information. And a setting step for setting identification information that can identify line information corresponding to other line numbers. The unchanged line number specifying step includes:
When specifying the line number of the first source file and the line number of the second source file that have the same line information in the first source file and the second source file, specify the lower line number with priority. ,
Of the line numbers of the first original file and the line numbers of the second original file, the line numbers specified by the no-change line number specifying step are not changed as statuses, and other line numbers are changed as statuses. Set with change,
The setting step includes
A first counting step of counting line numbers of the first original file;
A first extraction step of extracting a status set in the line number of the first source file corresponding to the count value counted in the first counting step;
A second counting step of counting line numbers of the second source file;
A second extraction step of extracting a status set in the line number of the second source file corresponding to the count value counted in the second counting step;
A determination step of determining a combination of the status extracted by the first extraction step and the status extracted by the second extraction step;
A first instruction that instructs each of the first count step and the second count step to increment when both statuses are determined to be unchanged or not changed by the determination step. Steps,
If it is determined in the determination step that only one of the two statuses is changed, if the change is set in the line number of the first original file, the first count step is incremented and the change is made. If there is a line number of the second source file, a second instruction step for instructing the second count step to count up,
If both the statuses are determined to be changed by the determination step, the line information corresponding to the line number of the first source file in which the change is set and the line number of the second source file are set. An editing information setting step for setting each corresponding line information in association with editing information indicating that the information is edited in the copy file;
If it is determined by the determination step that only the status set in the line number of the first original file is changed, the line information corresponding to the line number of the first original file is copied. A deletion information setting step that is set in association with deletion information indicating that the information is deleted in the file;
If it is determined in the determination step that only the status set in the line number of the second source file is changed, the line information corresponding to the line number of the second source file and the copy The comparison program according to claim 1, further comprising an insertion information setting step that is set in association with insertion information indicating that the information is inserted in the file. An insertion step of inserting a first row into each of the two copy files created by the copy step;
The editing information setting step, the deletion information setting step, and the insertion information setting step are the first column inserted by the insertion step and the corresponding row number includes the editing information, the deletion information, The comparison program according to claim 2, wherein the insertion information is set.

Images