JP2014178812A - Device, method, and program for aligning and visualizing spreadsheet program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a processor for automatically aligning and visualizing a spreadsheet program.SOLUTION: A processor detects an object cell from an original sheet, sequentially stores an object cell address in cells of a first column of a new sheet, sequentially stores object cell data in cells of a second column of the new sheet, sequentially stores a variable type of the object cell in cells of a third column of the new sheet, sequentially stores data on two cells near the object cell in the original sheet in cells of fourth, fifth columns of the new sheet, respectively, digitizes character strings stored in the cells of the second column or makes the character string into computation expressions, sequentially stores the character string in cells of a sixth column of the new sheet, and sorts the new sheet by using the third column as a key. The processor makes the character strings stored in the cells of the second column into the computation expressions by discovering the cells which store the same character strings as cell reference character strings in the character strings stored in the cells of the second column from the first column, and replacing the cell reference character strings with cell reference of the cells of the sixth column in the same line as that of the discovered cells.

Description

  The present invention relates to a processing apparatus, method, and program for a spreadsheet program, and more particularly to a technique for automatically visualizing a spreadsheet program in an aligned manner.

  In recent years, spreadsheet software represented by Microsoft's Excel (registered trademark) has been widely used as a simple computer programming means. In spreadsheet programs created using spreadsheet software, cell addresses are treated as explanatory variables (referring to cells) and formulas are described. 1) The calculation logic is not directly understood. 2) Formulas Is hidden behind the cell, so I don't know the whole picture of the program. 3) Since any calculation formula can be stored in any cell in the spreadsheet, there are various problems such as different sheet formats depending on the creator of the spreadsheet program. .

  2. Description of the Related Art Conventionally, a technique for automatically generating a computer program source code from a specification file created using spreadsheet software is known (see, for example, Patent Document 1).

JP 2009-223843 A

  Spreadsheet programs have a high degree of freedom in programming, and anyone can easily program them, but others use spreadsheet programs created by others without understanding the formulas and flow of calculations, and appropriate maintenance. There is a problem that it is difficult to link the input / output data with other programs and databases.

  In view of the above problems, an object of the present invention is to automatically visualize a spreadsheet program in an aligned manner.

  According to an aspect of the present invention, there is provided an apparatus for visualizing the alignment of a spreadsheet program by scanning a raw spreadsheet in which a spreadsheet program is described and an initial value is input to a cell for data input to scan the initial value and the initial value. A target cell in which any one of numerical values other than and a calculation formula is stored is detected, the cell address of the target cell is converted into a character string, and sequentially stored in the cells of the first column in the new spreadsheet, the target cell The data is converted into a character string and sequentially stored in cells of the second column in the new spreadsheet, and a symbol representing the variable type of the target cell is sequentially stored in cells of the third column in the new spreadsheet, In the original spreadsheet, the data in the first and second cells in the vicinity of the target cell are used as information representing the variable name and unit, and the fourth spreadsheet in the new spreadsheet. Sequentially stored in the cells in the fifth column, and the character strings stored in the cells in the second column are converted into numerical values or calculation formulas and sequentially stored in the cells in the sixth column in the new spreadsheet, A processing device for sorting the new spreadsheet using the third column as a key, wherein the processing device refers to a cell in a character string stored in a cell of the second column from the first column. Find the cell that stores the same string as the string, and replace the cell reference string with the cell reference of the cell in the sixth column in the same row as the found cell; Formula the character string stored in the cell of the column.

  The processing device may rewrite the corresponding character string in the character string stored in the cell of the second column in accordance with rewriting of the cell of the first column.

  According to another aspect of the present invention, there is provided a spreadsheet program alignment visualization method in which a processing device scans an original spreadsheet in which a spreadsheet program is described and initial values are input to cells for data input. A step of detecting a target cell in which any one of the initial value, a numerical value other than the initial value, and a calculation formula is stored; and the processing device converts the cell address of the target cell into a character string in a new spreadsheet. A step of sequentially storing the cells in the first column; and a step in which the processing device converts the data of the target cell into a character string and sequentially storing the data in the cells of the second column in the new spreadsheet; Sequentially storing a symbol representing the variable type of the target cell in a third column of cells in the new spreadsheet; and Sequentially storing the data of the first and second cells in the vicinity of the target cell in the sheet in the cells of the fourth and fifth columns in the new spreadsheet as information representing variable names and units, respectively, and the processing device Converting the character string stored in the cell of the second column into a numerical value or a calculation formula, and sequentially storing the character string in the cell of the sixth column in the new spreadsheet; and the processing device includes the new spreadsheet Sorting using the third column as a key, and sequentially storing in the cells in the sixth column, the characters stored in the cells in the second column from the first column Find a cell that stores the same string as the cell reference string in the column and replace the cell reference string with the cell reference of the cell in the sixth column in the same row as the found cell In Rukoto, calculates equation of the string stored in the cell of the second column.

  The method may further include a step of rewriting the corresponding character string in the character string stored in the cell of the second column in response to rewriting of the cell of the first column. Good.

  In addition, the spreadsheet program alignment visualization program according to still another aspect of the present invention includes a spreadsheet program, wherein the initial value is scanned by scanning an original spreadsheet in which initial values are input to cells for data input. , Means for detecting a target cell in which any one of numerical values other than the initial value and calculation formula is stored, and the cell address of the target cell is converted into a character string and sequentially stored in the cells of the first column in the new spreadsheet Means for converting the data of the target cell into a character string and sequentially storing the data in a second column of the new spreadsheet; and a symbol representing the variable type of the target cell in the third column of the new spreadsheet. Means for sequentially storing data in cells, and data representing the variable names and units of the data of the first and second cells near the target cell in the original spreadsheet; Means for sequentially storing in the cells of the fourth and fifth columns in the new spreadsheet, respectively, and converting the character string stored in the cell of the second column into a numerical value or a formula to calculate the sixth in the new spreadsheet Means for sequentially storing in the cells in the column, and means for causing the computer to function as means for sorting the new spreadsheet using the third column as a key, and means for sequentially storing the cells in the sixth column. From the first column, find a cell that stores the same character string as the cell reference character string in the character string stored in the cell of the second column, and set the cell reference character string to the same row as the found cell. The character string stored in the cell of the second column is converted into a formula by replacing the cell reference of the cell of the sixth column in

  The program may further cause the computer to function as means for rewriting the corresponding character string in the character string stored in the cell of the second column in response to rewriting of the cell of the first column.

  According to the present invention, a spreadsheet program freely described in the original spreadsheet is automatically visualized in the new program. In particular, data input cells and calculation formulas scattered in the original spreadsheet are collected in a predetermined column of the new spreadsheet. This makes it easier to understand the calculation formulas and flow of spreadsheet programs created by others, facilitates maintenance, and makes it easy to link input / output data with other programs and databases.

1 is an external view of a spreadsheet program alignment visualization device according to an embodiment of the present invention. Flow chart for visualizing the alignment of spreadsheet programs Figure showing the original spreadsheet with a spreadsheet program Diagram showing new spreadsheet in the middle of alignment visualization Figure showing an example of variable symbols being rewritten in a new spreadsheet Figure showing a new spreadsheet with complete alignment visualization Figure showing an example of entering numerical values in a completed new spreadsheet

  DESCRIPTION OF EMBODIMENTS Hereinafter, embodiments for carrying out the present invention will be described with reference to the drawings. In addition, this invention is not limited to the following embodiment.

  FIG. 1 shows the appearance of a spreadsheet program alignment visualization apparatus (hereinafter also referred to as this apparatus) 10 according to an embodiment of the present invention. The device 10 can be realized by a general computer system including a display device 12, a processing device 14, and an input device 16 such as a mouse or a keyboard. Specifically, the display device 12 is a flat panel display such as a liquid crystal display or an organic EL display. The display device 12 may have a touch panel function. In this case, the user can operate the object displayed on the screen by touching the screen of the display device 12 with a finger or a stylus (not shown). Specifically, the processing device 14 is a computer device including a CPU (Central Processing Unit), an MPU (MicroProcessing Unit), and the like.

  As will be described below, the apparatus 10 processes the original spreadsheet in which the spreadsheet program is described, and generates a new spreadsheet that is visualized by alignment. Therefore, it is not necessary to install spreadsheet software for executing the spreadsheet program in the processing device 14.

  The new spreadsheet may be created as a separate sheet of the same file as the original spreadsheet (book in the case of Excel (registered trademark)), or may be created as a separate file from the original spreadsheet.

  FIG. 2 shows the flow of visualizing the alignment of the spreadsheet program. The procedure for visualizing the alignment of the spreadsheet program by the apparatus 10 will be described below with reference to the flowchart of FIG. 2 and another view of the spreadsheet in the process of visualizing the alignment.

  FIG. 3 shows an original spreadsheet in which a spreadsheet program is described. When using spreadsheet software, the user writes a calculation formula and notes in any place (cell) on the sheet, and also creates a spreadsheet program as shown in FIG. Can do.

  First, in the original spreadsheet, the user inputs an initial value into a cell in which a numerical value is to be input, that is, a data input cell. In the example of FIG. 3, D4 cell, D5 cell, etc. are cells for data input, and “0” is input as an initial value.

  The processing device 14 scans the original spreadsheet in which the initial value is input to the data input cell, and detects the target cell (S1). The target cell is any one of 1) a cell in which an initial value is input, 2) a cell in which a numerical value other than the initial value is input, and 3) a cell in which a calculation formula is input. The scan direction may be either column priority or row priority.

  When the processing apparatus 14 scans the original spreadsheet shown in FIG. 3 with column priority, for example, the C23 cell, D3 cell, the D4 cell, D5 cell, and the initial value other than the initial value are input. The target cells are detected in the order of the D6 cell in which the numerical value of is input. The J34 cell in which the initial value is input is the target cell that is finally detected in the original spreadsheet shown in FIG.

  The processing device 14 converts the cell address of the target cell detected in step S1 into a character string and sequentially stores it in the cell of the first column of the new spreadsheet (S2). FIG. 4 shows a new spreadsheet in the middle of alignment visualization. Each cell in the first row of the new spreadsheet describes the title of each column. For example, the processing device 14 stores the character string of the cell address of the target cell in order from the cell in the second row of the C column of the new spreadsheet. For example, the cell address “C23” of the C23 cell which is the first target cell in the original spreadsheet is stored in the C2 cell of the new spreadsheet, and the cell address “C23” of the new spreadsheet is finally detected in the C34 cell of the new spreadsheet. The cell address “J34” of the J34 cell that is the target cell to be processed is stored. The character string is treated as a “variable symbol” in the new spreadsheet.

  The cell address is “R3C23” (third column) in addition to the A1 reference format such as “C23” (the 23rd row of C column) and “D3” (the third row of D column) in the above example. The R1C1 reference format such as “23rd row of the eye” or “R4C3” (third row of the fourth column) may be used.

  Further, the processing device 14 converts the data of the target cell detected in step S1 into a character string and sequentially stores it in the cell of the second column of the new spreadsheet (S3). As illustrated in FIG. 4, for example, the processing device 14 stores the character string of the data of the target cell in order from the cell in the second row of the E column of the new spreadsheet. For example, E2 cell of the new spreadsheet stores data “= D3 * 2 / D8 * (I23−H21) / I23 + J3 / 4” of the C23 cell that is the first target cell detected in the original spreadsheet. In the E34 cell of the spreadsheet, data “0” (initial value) of the J34 cell which is the last detected target cell in the original spreadsheet is stored. The character string is treated as “calculation content” in the new spreadsheet.

  Note that spreadsheet software has its own functions for quoting data from other sheets, books, etc., but they are stored as described in the target cell of the original spreadsheet. For example, the E3 cell of the new spreadsheet reads the data in the D3 cell of the sheet “main winding device” of the other book “[EOT calculation.xls]” described in the D3 cell of the original spreadsheet. The function description is stored as it is.

  Further, the processing device 14 sequentially stores the symbols representing the variable types of the target cells detected in step S1 in the cells in the third column of the new spreadsheet (S4). There are four types of variables: I: input variable, C: constant, P: process variable, and O: output variable. The target cell storing the initial value is type I, the target cell storing a numerical value other than the initial value is type C, and the calculation formula (referenced formula) in which the calculation result is quoted by another calculation formula Can be classified into type P, and calculation formulas (non-reference formulas) whose calculation results are not quoted in other calculation formulas can be classified into type O, respectively. As shown in FIG. 4, the processing device 14, for example, sets the variable type symbols “I”, “C”, “P”, “ O "is stored. For example, the A2 cell of the new spreadsheet stores the variable type “P” of the C23 cell that is the first target cell detected in the original spreadsheet, and the A34 cell of the new spreadsheet is the last detected in the original spreadsheet. The variable type “I” of the J34 cell that is the target cell to be stored is stored. The symbol is treated as a “variable type” in the new spreadsheet.

  In a spreadsheet program, each variable is given a variable name, and the unit of measure of the variable is often indicated. Furthermore, the variable name and unit are often shown near the variable. Therefore, the processing device 14 sequentially stores the data of two cells in the vicinity of the target cell in the original spreadsheet as information representing the variable name and unit in the cells in the fourth and fifth columns in the new spreadsheet, respectively (S5). . Empirically speaking, the variable name is often stored in the left cell of the variable and the unit is stored in the right cell of the variable. Therefore, the processing device 14 searches the left direction of the target cell to find a cell storing the character string, and sequentially stores the character string in the cell in the fourth column in the new spreadsheet as information representing the variable name. To do. Since the variable name is considered to be represented by Kana-Kanji characters, the processing device 14 may find a cell that stores the Kana-Kanji character string in the left direction of the target cell. Further, if such a cell is not found in the left direction of the target cell, the processing device 14 may search for the right direction or the vertical direction of the target cell.

  On the other hand, the processing device 14 searches the right direction of the target cell to find a cell storing the character string, and sequentially stores the character string as information representing a unit in the cell of the fifth column in the new spreadsheet. . Since the unit is considered to be represented by single-byte alphanumeric characters, the processing device 14 may find a cell storing a single-byte alphanumeric character string in the right direction of the target cell. Further, if such a cell is not found in the right direction of the target cell, the processing device 14 may search for the left direction or the vertical direction of the target cell. Alternatively, by collecting the character strings that can be units into a table format in advance, the processing device 14 can determine whether the found character string represents a unit by referring to the table. Thereby, alignment visualization with higher accuracy and higher reliability is possible.

  As illustrated in FIG. 4, the processing device 14 stores, for example, data of the first cell adjacent to the target cell in order from the cell in the second row of the B column of the new spreadsheet. For example, the data “rated load WR =” of the C3 cell adjacent to the left of the D3 cell, which is the target cell detected in the original spreadsheet, is stored in the B3 cell of the new spreadsheet. The character string is treated as a “variable name” in the new spreadsheet. Further, as illustrated in FIG. 4, the processing device 14 stores, for example, data of the second cell adjacent to the target cell in order from the cell in the second row of the D column of the new spreadsheet. For example, the data “t” of the E3 cell adjacent to the right of the D3 cell that is the target cell detected in the original spreadsheet is stored in the D3 cell of the new spreadsheet. The character string is treated as “unit” in the new spreadsheet.

  In addition, the execution order of said step S2-S5 is interchangeable. Or said step S2-S5 can also be performed simultaneously in parallel.

  When the processing of at least the first and second columns (columns C and E in the example of FIG. 4) is completed in the new spreadsheet, the processing device 14 stores the character strings stored in the cells of the second column. It is converted into a numerical value or a calculation formula, and sequentially stored in the cells of the sixth column in the new spreadsheet (S6). As illustrated in FIG. 4, the processing device 14 stores, for example, numerical values or calculation formulas in order from the cell in the second row of the F column of the new spreadsheet. For example, the character string “0” (initial value) stored in the E4 cell and E5 cell of the new spreadsheet is digitized and the numerical value “0” is stored in the F column cell of the same row, that is, the F4 cell and F5 cell. Stored as In addition, the character string “= 5” stored in the E6 cell of the new spreadsheet is digitized and stored as the numerical value “5” in the F column cell of the same row, that is, the F5 cell.

  Since the variable type stored in the A column cell of the same row as the cell storing the character string “0” in the E column of the new spreadsheet is always “I”, the processing unit 14 With reference to the cell, the numerical value “0” may be stored in the cell in the F column in the same row as the cell storing the variable type “I”.

  In step S6, the processing apparatus 14 finds a cell storing the same character string as the cell reference character string in the character string stored in the cell of the second column from the first column, and By replacing the reference character string with the cell reference of the cell in the sixth column in the same row as the found cell, the character string stored in the cell in the second column is formulated. For example, in the example of FIG. 4, the character string “= (D3 + J3) * 1000 * (D4 / D5 / 3.1416) ^ 2” is stored in the E7 cell. “D3”, “J3”, etc. in the character string are cell reference character strings in the original spreadsheet. The processing device 14 searches the C column for all cell reference character strings included in each character string stored in the cell of the E column, and finds a cell in which the same character string as the cell reference character string is stored. . For example, the processing device 14 searches the C column for the cell reference character string “J3” in the character string of the E7 cell, and finds the C26 cell storing the same character string “J3”. When the target cell is found in the C column, the processor 14 sends the cell reference character string “J3” to the cell in the Fth row in the same 26th row as the found cell, that is, the cell reference “F26 cell”. ”To formulate the character string of cell E7. In step S6, the processing device 14 converts the character string stored in the cell of the second column into a numerical value or a calculation formula and sequentially stores it in the cell of the sixth column in the new spreadsheet. Treated as an expression.

  Note that the cell reference in the calculation formula stored in the cell in the F column may be in the R1C1 reference format other than the A1 reference format as in the example of FIG.

  By executing up to step S6, the spreadsheet program described in the original spreadsheet is visualized in an aligned manner in the new spreadsheet, but this may be further processed. For example, remarks may be entered in column G in the new spreadsheet.

  In addition, the variable symbol in column C in the new spreadsheet is a character string of the cell address of the original spreadsheet as it is, so it is difficult for humans to understand. Therefore, the user may appropriately rewrite the cells in column C in the new spreadsheet (S7). However, when the cells in the C column are rewritten, the cells in the E column need to be corrected. Therefore, the processing device 14 may rewrite the corresponding character string in the character string stored in the E column cell in accordance with the rewriting of the C column cell in the new spreadsheet. FIG. 5 shows an example in which variable symbols are rewritten in the new spreadsheet. For example, the character strings “D3”, “J3”, “D4”, and “D5” (see FIG. 4) in the E7 cell are changed to the character string “WR” by rewriting the C3 cell, C4 cell, C5 cell, and C26 cell. , “WT”, “V”, and “N”, respectively. However, the calculation formula of the F7 cell corresponding to the E7 cell is not changed even if the cell in the C column is rewritten. Thus, in the new spreadsheet, rewriting the variable symbols in the C column has no effect on the F column calculation formula.

  In the new spreadsheet, each row has a variable type of “I”, “C”, “P”, or “O”. It is difficult for humans to understand that these variable types are not in order. Therefore, when step S7 ends, the processing device 14 sorts the new spreadsheet using column A as a key to complete the new spreadsheet. It is appropriate to arrange the variable types in the order of I → C → P → O. FIG. 6 shows the new spreadsheet with the alignment visualization complete. In the finally completed new spreadsheet, the variable names and units that were not fully converted because the description of the original spreadsheet was incomplete were corrected by the user as appropriate, and ruled lines were drawn to make it easier to see. For example, the F7 cell before sorting has been moved to F30 by the sorting process. The cell reference of the calculation formula of the F column is automatically changed by the processing device 14 by the sorting process.

  Note that, as shown in FIG. 6, the drawing object in the original spreadsheet may be pasted in an empty area of the new spreadsheet. The pasting process may be performed by the user or the processing device 14. FIG. 7 shows an example in which numerical values are input to the completed new spreadsheet. The cells into which the user should input numerical values are the cells in the F column in the same row as the cells storing “0” in the E column, that is, the F2 cell to the F22 cell.

  In addition, before executing the alignment visualization of the spreadsheet program in the apparatus 10, the spreadsheet program of the original spreadsheet is divided into pre-processing, solver, and post-processing and stored in another sheet or book, If the present apparatus 10 is applied only to the solver portion, the whole picture of the spreadsheet program becomes easier to understand. Pre-processing refers to processing for displaying solver input data as a fixed table, graph, or figure, and post processing refers to processing for creating a fixed table, graph, or figure using the calculation results of the solver.

  As described above, according to the present embodiment, the numerical values and the calculation formulas that are difficult to understand by being dispersed in various columns in the original spreadsheet are all collected in a specific column (F column in the example of FIG. 6). The This makes it easier to understand the calculation formulas and flow of spreadsheet programs created by others, facilitates maintenance, and makes it easy to link input / output data with other programs and databases.

  In addition, this invention is not limited to said embodiment. For example, the spreadsheet program alignment visualization device according to the present invention can be realized by a tablet PC, a notebook PC, or the like. It is also possible to cause a general-purpose computer such as a PC to execute a spreadsheet program alignment visualization program so that the general-purpose computer functions as a spreadsheet calculation alignment visualization device. The spreadsheet program can be described as, for example, an Excel (registered trademark) VBA macro. In addition, the spreadsheet program alignment visualization apparatus according to the present invention is a so-called cloud system such as SaaS (Software as a Service) in which a general-purpose computer receives a service from a server on a network that implements the spreadsheet visualization method. It can also be realized as.

10 Spreading and visualizing device for spreadsheet program 14 Processing device

Claims (6)

A target cell in which a spreadsheet program is described, and the initial value, a numerical value other than the initial value, and a calculation formula are stored by scanning an original spreadsheet in which an initial value is input to a cell for data input Detect
The cell address of the target cell is converted into a character string and sequentially stored in the cells of the first column in the new spreadsheet,
The data of the target cell is converted into a character string and sequentially stored in the cell of the second column in the new spreadsheet,
A symbol representing the variable type of the target cell is sequentially stored in a third column of cells in the new spreadsheet;
In the original spreadsheet, the data of the first and second cells in the vicinity of the target cell are sequentially stored in the cells in the fourth and fifth columns in the new spreadsheet as information representing variable names and units, respectively.
The character string stored in the cell of the second column is converted into a numerical value or a calculation formula and sequentially stored in the cell of the sixth column in the new spreadsheet,
A processing device for sorting the new spreadsheet using the third column as a key;
The processing device finds a cell that stores the same character string as the cell reference character string in the character string stored in the cell of the second column from the first column, and determines the cell reference character string. A table calculation characterized by formulating the character string stored in the cell of the second column by replacing the cell reference of the cell of the sixth column in the same row as the found cell Program alignment visualization device.   The arrangement of the spreadsheet program according to claim 1, wherein the processing device rewrites a corresponding character string in a character string stored in a cell of the second column in response to rewriting of the cell of the first column. Visualization device. The processing device scans an original spreadsheet in which a spreadsheet program is described and an initial value is input to a cell for data input, and stores either the initial value, a numerical value other than the initial value, or a calculation formula. Detecting a target cell that has
The processing device converts the cell address of the target cell into a character string and sequentially stores it in the first column of cells in a new spreadsheet;
The processing device converts the data of the target cell into a character string and sequentially stores the data in a second column of cells in the new spreadsheet;
The processor sequentially stores symbols representing the variable type of the target cell in the cells of the third column in the new spreadsheet;
The processing device sequentially applies the data of the first and second cells in the vicinity of the target cell in the original spreadsheet to the cells in the fourth and fifth columns in the new spreadsheet as information representing variable names and units, respectively. Storing, and
The processing device quantifies or formulates the character string stored in the cell of the second column and sequentially stores it in the cell of the sixth column in the new spreadsheet;
The processing apparatus comprising: sorting the new spreadsheet using the third column as a key;
In the step of sequentially storing the cells in the sixth column, cells storing the same character string as the cell reference character string in the character string stored in the cell of the second column from the first column And replacing the cell reference character string with the cell reference of the cell in the sixth column in the same row as the found cell, thereby calculating the character string stored in the cell in the second column. A method for visualizing the alignment of a spreadsheet program, characterized by:   The said processing apparatus is provided with the step which rewrites the corresponding character string in the character string stored in the cell of the said 2nd column according to rewriting of the cell of the said 1st column. A method for visualizing the alignment of spreadsheet programs. A target cell in which a spreadsheet program is described, and the initial value, a numerical value other than the initial value, and a calculation formula are stored by scanning an original spreadsheet in which an initial value is input to a cell for data input Means for detecting,
Means for converting the cell address of the target cell into a character string and sequentially storing it in the first column of cells in a new spreadsheet;
Means for converting the data of the target cell into a character string and sequentially storing the data in a second column of cells in the new spreadsheet;
Means for sequentially storing symbols representing the variable types of the target cells in the cells of the third column in the new spreadsheet;
Means for sequentially storing the data of the first and second cells in the vicinity of the target cell in the original spreadsheet as information representing variable names and units in the cells in the fourth and fifth columns in the new spreadsheet, respectively;
Means for digitizing or calculating a character string stored in the cell of the second column and sequentially storing it in a cell of the sixth column in the new spreadsheet; and Make the computer function as a means of sorting by key,
A cell in which the means for sequentially storing the cells in the sixth column stores the same character string as the cell reference character string in the character string stored in the cell of the second column from the first column And replacing the cell reference character string with the cell reference of the cell in the sixth column in the same row as the found cell, thereby calculating the character string stored in the cell in the second column. An alignment visualization program for a spreadsheet program, characterized by:   The spreadsheet program according to claim 5, wherein the computer functions as means for rewriting the corresponding character string in the character string stored in the cell of the second column in response to rewriting of the cell of the first column. Alignment visualization program.