Version History
Excel Compare 2.2 beta (February 2007)
- Some critical and minor bugs are fixed.
Excel Compare 2.1 (April 2005)
- Allows searching for matches between several rows which have the same identifier when the "Unique Identification" method is used (the "Compare rows, which have ununique identifiers" option);
- The "Save report to file" option allows you to save the reports automatically;
- Bug fixed: The error message occurred when trying to close Excel documents first and then close the application;
- The "Clone Current Page" command allows you to create a copy of current page;
- Changed: the "Run a procedure..." editbox on the "Macros" tab should have a procedure name only (without the module name).
Excel Compare 2.0.5 (January 21, 2005)
- Bug fixed: The report was being created incorrectly if the "Direct Write" method is used and if the sheet contains numbers in the scientific notation (like '3E350').
Excel Compare 2.0.4 (December 14, 2004)
- Bug fixed: The program failed to work if last column of the compared spreadsheet is "Z".
Excel Compare 2.0.3 (Jule 2004)
- Bug fixed: The program failed to work, causing an error "Privileged instruction" or "Cannot open clipboard";
- Bug fixed: Added rows are not displayed correctly in the report if between them there are rows containing duplicated identifiers.
Excel Compare 2.0 (June 8, 2004)
- Uses the high-speed Direct Write technology;
- Allows the user to create a new project using the New Project Wizard;
- Allows comparison of sheets that contain a database structure or unique identifiers (primary keys);
- Improved high speed comparison algorithm for the data not containing unique identifiers;
- Allows the user to select a range and columns interactively;
- Allows the user to customize report subtitles (the red output messages earlier): subtitle text, font, color, sizing;
- Allows entry of a column name or a row number for the coordinates of range;
- Allows compared sheets to be replicated in a new report workbook;
- Extended the information report header;
- Associates Excel Compare with Excel Compare Project file (.ECP);
- Supports Windows XP themes;
- Multilingual interface
- Bug fixed: The program failed to work, causing an error "is not a valid integer value";
- Bug fixed: The program failed to work, if a compared worksheet are protected, causing an error "Unable to set the Hidden property of the Range class";
- Bug fixed: The program failed to work, if one Excel sheet is not a worksheet, causing an error 'Sheet "name" not found.';
- Changed: The Options dialog box are divided into Project Options (Menu:Project|Project Options...) and Environment Options (Menu:Tools|Environment Options...).
Version 1.0 (January 2003)
- Allows for the division of the report into three parts: deleted, added and changed data;
- Now supports the comparison of files with the same names located in different directories;
- Allows for the comparison of all files located in two different directories;
- Allows for the comparison of all sheets with the same names in two workbooks;
- Allows easily to select a sheet name from the list of sheets available in the workbook.
Version 0.9.8 (October 2002)
- Highlighting individual cells that have changed or are different;
- New option: close all files opened by MS Excel after comparison;
- New option: close all report workbooks after comparison;
- Attached macros are of two types:
- to each report worksheet (local macros, sheet level);
- to the report workbook (global macros);
- Now all macros are being attached and run after comparison;
- Fixed bug in command line parameters with macros (parameter /proc).
Version 0.9.6 (May 2002)
- Added three comparison methods that determine what two rows have changed
- New comparison options:
- If there are no differences, the report will not be created
- Create all reports of the project in the same workbook
- Allows to automatically add the user-defined macros to the report workbook from external file and then to run this macro
- Added Project toolbar
- Fixed comparison bugs
Version 0.9.5 (May 2002)
- New report option: relevance percent
- Eight new options in command line parameters
- The report options are kept for Project settings
- Fixed bug at data extraction when the sheet has invisible rows
Version 0.9.4 (April 2002)
- New features:
- New more correct and fast comparison algorithm;
- More correct creation of the differences report;
- Allows quickly to go to any page of the current project.
- Bugs fixed:
- In the hyperlink that is created after comparing two worksheets that contain a space in the worksheet title;
- The information from cells of a sheet that contains linefeed- or carriage return-characters was taken incorrectly. In this case the line-calculation was unsuccessful.
Version 0.9.3 (March 2002)
- Added Projects support:
- Can be saved by name for fast access by using main menu;
- The quantity of pages is not limited.
Version 0.9.1 beta (Feb 2002)
- The new fast algorithm of comparison;
- The new options of the report creation:
- the order of the changed data: by the whole blocks or single lines;
- a mode of the data copying: values only or values and formats.
Version 0.9 beta (Feb 2002)
- Fixed: extract of the data from a sheet. The method of the data extraction is changed on more reliable.
Version 0.8.5 beta (January 2002)
- Now allows to create a log file which will help to fix bugs.
- Fixed: Bug at creation of the report with Microsoft Excel 97 and Insert Hyperlinks option.
Version 0.8.3 beta (December 2001)
Version 0.8.2 beta (November 2001)
- Bug fixed: the sheet of the Difference Report was empty in some cases;
- Supports opening the selected file in Microsoft Excel for editing;
- By default the active sheet after opening is used, if the name of a sheet is not entered;
- By default "Used Range" is used, if the range is not precisely specified;
- Supports an insert hyperlinks to compared sheets in the Difference Report;
- Bug fixed: numbering of lines in the Differences Report;
- Help file (*.chm).
Version 0.8 beta (October 2001)
- The first public beta version
|
