|
Version History
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 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 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 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);
- Allows the user to select a range and columns interactively;
- Improved high speed comparison algorithm for the data not containing unique identifiers;
- Allows the user to customize report subtitles (the red output messages earlier): subtitle text, font, color, sizing;
- Saves a project file name when you exit Excel Compare. When you later start Excel Compare, this project is opened;
- Allows compared sheets to be replicated in a new report workbook;
- Allows entry of a column name or a row number for the coordinates of range;
- Associates Excel Compare with Excel Compare Project file (.ECP);
- Extended the information report header;
- 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...);
Excel Compare 1.0 (January 2003)
- Allows for the division of the report on three parts: deleted, added and changed data;
- 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 for the selection of a sheet name from the list of sheets available in the workbook.
Excel Compare 0.9.8 beta (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).
Excel Compare 0.9.7 beta (July 2002)
- Saves and restores a position and sizes of the main window
Excel Compare 0.9.6 beta (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
Excel Compare 0.9.5 beta (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
Excel Compare 0.9.4 beta (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.
Excel Compare 0.9.3 beta (March 2002)
- Added Projects support:
- Can be saved by name for fast access by using main menu;
- The quantity of pages is not limited.
Excel Compare 0.9.1 beta (February 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.
Excel Compare 0.9 beta (February 2002)
- Fixed: extract of the data from a worksheet. The method of the data extraction is changed on more reliable.
Excel Compare 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.
Excel Compare 0.8.4 beta (January 2002)
- Fixed: Bug at creation of the report with the large number of columns.
Excel Compare 0.8.3 beta (December 2001)
- New feature: Command Line Options.
Excel Compare 0.8.2 beta (November 2001)
- Bug fixes: 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 fixes: numbering of lines in the Differences Report;
- Help file (*.chm).
Excel Compare 0.8 beta (October 2001)
- The first public beta version
|
