System and method for comparing digital data in spreadsheets or database tables
A system, method and computer program product compares data in original and modified versions of spreadsheet or database table documents, and generates a comparison document having indications where changes between the documents are present. The data compared includes formulas or stored procedures that are normally hidden when viewing a spreadsheet or database table document.
1. A computer-implemented method of comparing areas of cells within a spreadsheet, the method comprising:
receiving, by a processor, information identifying a first specified area of cells within a spreadsheet;
receiving, by the processor, information identifying a second specified area of cells within the spreadsheet;
applying a user-specified macro to pre-process the first specified area of cells and the second specified area of cells before comparing cell values and cell formulas;
comparing a value of a first cell of the first specified area of cells with a value of a second cell of the second specified area of cells, wherein the second cell corresponds with the first cell;
comparing a first formula of the first cell with a second formula of the second cell, wherein the value of the first cell is determined according to the first formula;
identifying all textual differences between the first formula of the first cell and the second formula of the second cell;
generating, by the processor, a comparison file corresponding to the first specified area of cells and the second specified area of cells that includes one or more cells that:
display redline differences between the value of the first cell and the value of the second cell, and display, in redline, all textual differences between the first formula of the first cell and the second formula of the second cell.
2. The method of claim 1 , further comprising: receiving user defined formatting parameters used in comparing the value of the first cell with the value of the second cell and the first formula with the second formula.
3. The method of claim 1 , further comprising: receiving user defined parameters for formatting the indication of differences in the comparison file.
4. The method of claim 3 , wherein said defined parameters determine the appearance of the indicated differences when the comparison file is displayed.
5. The method of claim 1 , further comprising: displaying the first specified area of cells and the second specified area of cells with the one or more cells that display redline differences between the value of the first cell and the value of the second cell and display redline differences between the first formula and the second formula.
6. The method of claim 1 , wherein the first specified area of cells is specified by a user.
7. A non-transitory computer-readable medium storing instructions for comparing areas of cells within a spreadsheet, the instructions, when executed, cause one or more computer processors to perform operations comprising:
receiving information identifying a first specified area of cells within a spreadsheet;
receiving information identifying a second specified area of cells within the spreadsheet;
applying a user-specified macro to pre-process the first specified area of cells and the second specified area of cells before comparing cell values and cell formulas;
comparing a value of a first cell of the first specified area of cells with a value of a second cell of the second specified area of cells, wherein the second cell corresponds with the first cell;
comparing a first formula of the first cell with a second formula of the second cell, wherein the value of the first cell is determined according to the first formula;
identifying all textual differences between the first formula of the first cell and the second formula of the second cell;
generating a comparison file corresponding to the first specified area of cells and the second specified area of cells that includes one or more cells that:
display redline differences between the value of the first cell and the value of the second cell, and display, in redline, all textual differences between the first formula of the first cell and the second formula of the second cell.
8. The non-transitory computer-readable medium of claim 7 , further including instructions that, when executed, cause the processor to perform operations comprising: displaying the first specified area of cells and the second specified area of cells with the one or more cells that display redline differences between the value of the first cell and the value of the second cell and display redline differences between the first formula and the second formula.
9. A computer implemented system for comparing areas of cells within a spreadsheet, the system comprising:
a computer having a processor that executes computer executable instructions from a memory to:
receive a user-selected first specified area of cells within a spreadsheet;
receive a user-selected second specified area of cells within the spreadsheet;
apply a user-specified macro to pre-process the first specified area of cells and the second specified area of cells before comparing cell values and cell formulas;
compare a value of a first cell of the first specified area of cells with a value of a second cell of the second specified area of cells, wherein the second cell corresponds with the first cell,
compare a first formula of the first cell with a second formula of the second cell, wherein the value of the first cell is determined according to the first formula,
identify all textual differences between the first formula of the first cell and the second formula of the second cell,
generate a comparison file corresponding to the first specified area of cells and the second specified area of cells that includes one or more cells that:
display redline differences between the value of the first cell and the value of the second cell, and display, in redline, all textual differences between the first formula of the first cell and the second formula of the second cell.
10. The system of claim 9 , wherein the processor further executes computer executable instructions to: display the first specified area of cells and the second specified area of cells with the one or more cells that display redline differences between the value of the first cell and the value of the second cell and display redline differences between the first formula and the second formula.