- File menu item with file opening and saving commands.
- Fixed problem with saving XLSX files
- Fixed problem with duplicated number after Copy to Clipboard
- Fixed a few issues in the VBA code comparison
- Ability to compare 2 modules within same workbook
- File issue with Find Next
- File issue with copying data from the comparison report window
- Save Compared Worksheet in the Extended View into PDF file.
- XLOOKUP function is supported
- Fixed file corruption issue with XLS files
- Minor improvements and fixes
- Fixed few formatting issues in the Extended View mode.
- Reworked VB Project interface.
- Improvements in the VB Code comparison.
- Fixed new problems with VB Module comparison.
- Minor improvements and fixes.
- Fixed crash when comparinng 2 workbooks.
- Improved row linking and worksheet alignment.
- Minor improvements and fixes.
- Faster comparison algorithm.
- Fixed issue empty difference information.
- Minor improvements and fixes.
- Fixed problem with opening read-only files.
- New worksheet functions.
- Minor improvements and fixes.
- 3-Way Comparison and Merge.
- Automated bulk merge commands.
- Reworked new interface.
- Extended Command Line commands.
- Fixed and improvements in the calculation and Visual Basic engines.
- Number of minor improvements and fixes.
- Fixed few issues with opening workbooks in the XLSX format.
- Fixed few issues in the VBA Engine.
- Number of minor improvements and fixes.
- Select compared worksheets\modules.
- Select Comparison Algorithm.
- Faster and memory efficient comparison.
- Additional options in the Mark Changes command
- Fixed number of issues with XLS file format.
- New functions and methods in the VBA Engine.
- Number of minor improvements and fixes.
- Fixed comparibility issue with XLSM file format.
- Several improvements in the VBA Engine.
- Reworked Activation and Trial Warning forms.
- Minor updates and fixes.
- Faster comparison of the String Values in Cells.
- Faster comparison of Visual Basic Macros.
- Switch Worksheets button.
- Show or hide Merge Commands.
- Changes in the string modifications formatting.
- Fixed crash on opening comparison report from Recent Items.
- Minor updates and fixes.
- Modifications and Improvements in the Comparison Engine
- Minor updates and fixes.
- New design of the Recent Files page
- New method to highlight differences in the string cells
- Improvements in comparing Visual Basic macros
- Minor updates and fixes.
- New reworked layout: Pin Difference Explorer to the every side of the window
- New Comparison Summary Report, based on the comparison results
- Save Comparison Summary into XLSX, HTML, TXT and CSV formats
- Faster and optimized file saving routines
- Mark Changes command applies color formatting to the string values in cells.
- Copy text into clipboard in the Rich Text format
- Minor updates and fixes.
- xlCompare displays all Tables in the workbook
- Trace Calculations command is added to Names View
- New improved algorithm to compare string values
- Fixed problem with Mark differences with color command
- Fixed compatibility issue with saving file in the XLSM format
- Minor updates and fixes.
- New application layout. Difference Explorer is not floating anymore, it is embedded into the Main Window.
- Faster and more accurate cell style comparison
- Improvements in the Calculation and Visual Basic Engines
- Minor updates and fixes.
- Function selector for VBA macros. Select function by name in the Combobox window above the code.
- New user interface style
- Several improvements in the Calculation Engine
- Minor updates and fixes.
- Option Ignore Protection to select and analyze locked cells on the protected sheets.
- New worksheet and VBA functions
- Improved tooltips in the Visual Basic Code Windows
- Improved Go To Cell dialog
- Fixed some minor problems with Find command
- Fixed several issues in the VBA Engine
- Minor updates and fixes.
- Fixed few compatibility problems in the XLSM file format.
- Minor updates and fixes.
- New more accurate string comparison algorithm.
- XLSM files are opened faster.
- Improved color formatting in the Visual Basic Code Window.
- Fixed problem with opening XLS files.
- Improvements in the Comparison Engine.
- Improvements in the Visual Basic Engine.
- Minor updates and fixes.
- Fixed problem in the Comparison Engine.
- Fixed crash in the Visual Basic Engine.
- Minor updates and fixes.
- Number of fixes and improvements in the Comparison Engine.
- Improvements in the Visual Basic Engine.
- Minor updates and fixes.
- New features in the Command Line Mode. xlCompare is ready to work with GIT DIFF.
- Bulk Merge commands were improved.
- Fixed few issues in comparing formulas.
- Improvements in the Visual Basic Engine.
- Fixed problems with Custom Formatting.
- Minor updates and fixes.
- Faster loading of XLSM\XLSX files.
- Improved formatting in the Visual Basic Code.
- Corrections in the Primary Key detection algorithm.
- New worksheet functions.
- Fixed few compatibility problems when loading XLSX workbook.
- Fixed issue with search in the VBA code.
- Fixed issue with enum statement in the VBA macros.
- Minor updates and fixes.
- Trim Strings command is added to the Right Click Menu.
- Convert Strings To Numbers command is added to the Right Click Menu.
- New Financial Functions added to the Calculation Engine.
- Fixed crash in the Calculation Engine.
- Minor updates and fixes.
- Color formatting for Visual Basic Code.
- Improvements in the comparison engine.
- Fixed problem with ignoring whitespace in the Primary Keys.
- Fixed issue with linking unique rows and columns.
- Fixed issue with comparing Visual Basic functions.
- Fixed crash when comparing formulas.
- Minor updates and fixes.
- Several fixes in comparing Database Style data.
- Find command now works for Visual Basic Macros also.
- Fixed issue with filtering records by Primary Key.
- Fixed number of compatibility issues in the Visual Basic engine.
- Fixed issue with sorting numbers stored as text cells.
- Fixed crash when editing Primary Keys.
- Fixed issue with comparing formulas on the worksheets with inserted\deleted rows and columns.
- Fixed a few issues with Bar and Scatter charts.
- Fixed problem with calculating Names, defined as formula.
- User Interface was adopted for 4K display.
- Fixed issue with comparing numbers stored as text cells.
- Fixed issue with using Ignore White Space option for Primary Keys.
- Area Chart is supported.
- New, more flexible User Interface.
- Improvements in the support of XLSM File Format.
- Visual identification of the changed cell styles (borders, fill, font, number formatting).
- Polished reporting to text and XLSX formats.
- Minor improvements and fixes.
- Fixed formatting problems under non-US locale.
- Faster file loading and calculations.
- Fixed crash when loading workbook with Group Shapes.
- Fixed few compatibility issues with XLSM file format.
- Minor improvements in the User Interface.
- New comparison algorithm for outlined rows.
- Minor updates and fixes.
- Fixed issue with comparing numbers stored in the text fields.
- Link Columns - option used to correct comparison results.
- Difference between date values are shown correctly in the Extended View.
- Minor updates and fixes.
- Accuracy option, used to compare number fields
- Ignored Characters option for string value comparison
- Improved Extended View, to show actual difference between very similar numeric values.
- Minor updates and fixes.
- New comparison algorithm for data with different primary keys
- Fixed frees on loading xlCompare
- Fixed crash when opening VB Projects with ActiveX controls.
- Minor updates.
- Link Sheets option. Define how xlCompare should process worksheets if you compare different workbooks.
- Link Columns option. Link columns by Name or by Index if you process Database data.
- New VBA functions.
- Fixed few minor problems.
- Combine several columns into one.
- Polished comparison algorithms.
- Fixed crash in editing worksheet cells.
- Faster workbook loading.
- Fixed issue with reflection of the comparison results on scrollbar.
- xlCompare creates startup log file.
- Evaluation version doesn't require to register an account on our website.
- Filter by Criteria command filters data on the opened worksheets by wildcard criteria.
- Trace Error command shows where the error value in formula came from.
-
Improvements in the Evaluate Formula and Display Errors windows.
xlCompare gives you powerful tools to audit formulas in your workbook.
- Fixed problem with saving comparison report as worksheet
- Fixed minor issue in the MATCH function.
- New Visual Basic objects and functions.
-
Improvements in the command line mode. Running VBS files from command line, gives you more flexibility in
comparing with usual command line mode.
- Fixed problem with comparing Visual Basic Projects.
- Minor changes in the Primary Key detection algorithm.
- Fast calculations. Significant increase of the calculation speed in some worksheet functions.
- Fixed few issues in loading XLSM files.
- Display Errors feature added to the Tools tab on the Ribbon
- xlCompare loads files in the XLSM\XLSX format faster and more efficient (memory usage was significantly decreased).
- New Statictical and Date worksheet functions
- Fixed few issues with inaccurate comparison
- Improved VBA support
- Fixed problem with Ignore Whitespace option
- xlCompare supports new VBA object methods and properties
- Faster loading of the XLSM files
- Improved calculations of the Lookup functions
- Class modules in the Visual Basic project
- New Statistical and Math worksheet functions
- Database commands, relative to duplicated rows and keys, are moved to Duplicates ribbon tab.
-
New commands:
- Highlight Duplicate Keys
- Highlight Duplicate Rows
- Fixed compatibility problems with saving XLSX files.
- Fixes and improvements in the Visual Basic Engine.
- Reworked comparison strategies. Separate processing for Database data.
- Indication of the hidden data on the sheet with Filter icon.
- Minor bugfixes.
- Print command added to xlCompare.
- Improvements in the comparison report saved as worksheet.
- Print Comparison Report command.
- Fixed compatibility problem with loading XLS files.
- Minor bugfixes.
- Fixed bug with Ignore Whitespace Filtering option.
- Fixed crash on Filtering Duplicate Rows.
- Minor bugfixes.
- Database Tab: setup of time saving commands to filter and sort data in your workbook
- Commands to delete and filter duplicated rows and Primary Keys.
- Run Visual Basic Macros to automate xlCompare.
- Save comparison report on the worksheet.
- Improvements in the command-line mode.
- New worksheet and VBA functions.
- Save filtered data from selected worksheet.
- Minor bugfixes.
- Several improvements in the Extract Changed Records feature.
- New features in the command-line mode.
- Fixed crash when opening workbook with a Group Shape
- Zoom your worksheets, like you are doing this in Excel. Use Ctrl+Mouse Wheel or Zoom spin control on the View tab.
- Fixed a few problems with external references
-
New commands on the Tools Tab:
- Filter By Key - select key value in your table and filter rows by this value
- Hide Rows\Columns - hide selected rows or columns. With options on the Filter tab you can exclude them from comparison
- Remove Empty Rows - remove all empty entries on your worksheet
- Remove Hidden Rows - remove data you've hidden
- Sort Rows - sort data on the worksheet with Primary Key
- Fixed crash on excluding Show Hidden Sheets option
- Minor improvements and bugfixes
- Much faster processing of XLSX\XLSM\XLAM workbooks
- Reworked tooltip which displays difference between compared cells
-
Improved Compare Values and Formulas on the character level option. Now results of the comparison are
reflected in the worksheet and in the tooltip.
- Website has been moved to HTTPS protocol
- Fixed drawing bug in the Difference Explorer
- Fixed problem with saving XLSM files
- Display difference between string values and formulas on the character level
- Faster processing and navigation
- DEC2HEX function is supported
- Minor improvements in the User Interface
- Synchronize selection between worksheet and Difference Report
- Option to disable Conditional Formatting
- Internal improvements and bugfixes
- Fixed compatibility problem with Conditional Formatting
- Fixed compatibility problem with Merged Cells
- Fixed slowdown on filtering changed cells
- Fixed crash on switching between worksheets
-
Ignore Empty Strings option has been renamed into Ignore Whitespace. Now it affects to the primary keys also.
With this option turned ON, xlCompare trims primary keys before comparison.
- Fixed problem with Copy menu command on the worksheet
- Fixed bug with showing RTF text in cells
- Fixed issue with creating backup files
- Ignore Empty Strings option: skip strings which contains only spaces
- Reset Primary Keys command: restore Primary Keys to default state
- Fixed problem with opening XLS files with Tables
- Fixed problem with comparing unsorted database data
- Fixed few minor interface issues
- Improved Array Formula calculations
- IFNA excel worksheet function is added
- Fixed few compatibility problems
- Fixed problem with merging formulas on the worksheets
- New option to mark changes with color automatically in merge operation
- Fixed bug with reflecting string constants in the formula editor
- Pin Difference Explorer to the Ribbon
- Recent Comparisons list is placed on the Recent tab on the Ribbon
- Count of differences is reflected on the Ribbon Tabs (View and Results)
- Fixed problem with opening XLSX workbooks
- Fixed problem with saving Visual Basic project
- Fixed problem with opening XLSM workbooks
- Fixed problem with overflowing data buffer in exporting long formulas into HTML format
- Contains Errors conditional formatting rule
- Not Contains Errors conditional formatting rule
- Fixed problem with FORECAST function
- Fixed few User Interface issues
This update contains a lot of improvements and fixes.
- Fixed crash on opening book with chart with multilevel categories.
- Fixed problems with updating tables after changing filtered values.
- Fixed few minor issues.
- Fixed drawing bug with connector shapes.
- Save report as Table.
- Extended Command Line mode - you can pass worksheet names to xlCompare.
-
Bulk Merge command is applied to all differences, not only to selected branch.
You can still apply it to selection only, if you use this command for Right Click Menu in the Difference Explorer.
- Fixed problem with saving merged cells in the XLS format.
- Extract Unique Records command leaves changed cells on the sheet.
- Display Hidden Sheets option. Allows to view\hide hidden worksheets.
- Display Column Numbers option. You can switch between Numbers and Names in the columns heading.
- Display Names. You can see all defined names in your book.
- Few minor fixes in the Calculation Engine.
- Fixed bug in the reference parser.
- Fixed problem with comparing database records
- Fixed issue with Number Formatting
- New feature - Trace Calculation Results
- Redesigned Filter Cells feature in the Difference Explorer.
- EOMONTH, CEILING.MATH, FLOOR.MATH worksheet functions are supported
- Fixed problem with comparing merged cells
- Few minor fixes.
- New option - Filter compared cells
- Compare cells by formatting options
- Fixed issue with comparing workbooks with external links.
- Fixed command line bug - command line mode has been cancelled by Trial Screen.
- Trial warning screen. It describes limitations of the Trial Version when you are using it.
- xlCompare displays Visual Basic Forms in their native representation. You can edit and merge VB Forms easily with full control on the process.
- Open workbook by dragging file into xlCompare window
- We've fixed number of issues with opens files in the XLS file format
- New Interface: Now xlCompare uses Ribbon like Office applications
- Difference Explorer: Ribbon interface
- Difference Explorer displays differences between worksheets and VB Modules on separate tabs
- Display Sheets, VB Modules, VB Classes and VF Forms on the separate views
- Reworked Formlula Bar: we've added colored arguments, fast and easy argument selection ...
- Fixed crash when opening XLS files with external links.
- xlCompare saves layout of it's windows.
- Optimized for speed and memory usage Calculation Engine.
- Minor bug fixes.
- Significantly decreased memory usage.
- Much faster file processing.
- Minor bug fixes.
- Fixed crash when opening XLS files.
- Fixed crash in the worksheet IF function.
- Now in case of crash xlCompare creates Crash Report file, you can send to us for investigation.
- xlCompare supports MultiPage control on the User Forms.
- All new spreadsheet features and fixes available in the xlCompiler were added to xlCompare.
- Fixed problems with loading large XLS\XLSM workbooks.
- Fixed crash occured on the first start.
- xlCompare supports mvba file format (Bentley MicroStation).
- Much faster loading for XLSM\XLSX files
- Fixed crash when loading files with Group Shapes
- Fixed floating problem with entering Activation Codes into xlCompare. (Some codes were rejected.)
- Fixed problem with loading workbooks in the XLS format
- Fixed problem with saving comparison report in the HTML format
- Improved Extended View mode in the comparison report
- New Comparison Report items in the Difference Explorer
- Fixed a minor issue with software activation
- New time saving commands: Merge Worksheets, Duplicate remover
- Clear Background command
- Fixed issue with Grouping feature. Now it is applied to all worksheets in the list.
-
Reworked Filter feature. You can see only changed or new rows in the database lists. This is useful
when you are working with database tables imported into Excel worksheets.
- Now xlCompare has Check for updates feature. You will be notified about the update as soon as it is published on our website.
- Merge commands for "database" lists: union, intersection, difference.
-
Fixed number of minor issues.
Using these commands you can easily do such tasks as
join 2 lists in Excel, or similar.
Help topic
Database Comparison describes these features in details.
-
In this update we've added ability to mark all different cells with color.
You can find more information on this feature in the article
Mark differences with color.
- Minor update. We've moved some useful commands from Difference Browser toolbar to the main xlCompare window.
- Minor update. We've polished comparison algorithms for price lists and accounting statements.
-
Minor update. This update allows to pin Difference Explorer window to the Main Window and
some improvements in comparing Visual Basic Modules.
-
Minor update. This time we've changed formatting in the VBA Comparison results to a more suitable.
It should better reflect changed parts of the text
Also, you may want to review these topics from the
F.A.Q. section:
- New generation of the xlCompare software has been published.
- Changed behavior for workbooks with single sheet. Now worksheets should have same name to be compared.
- Fixed wrong primary key detection.
- Fixed bug with comparing "database" data.
- Improved comparison of the CSV\TXT files.
- Fixed problem with comparing VBA Projects.
- Fixed wrong primary key detection.
- Fixed problem with spreadsheets which contain more than 65000 rows.
- Minor improvements in the database comparison algorithm.
-
Mark Differences, Combine Worksheets, Intersect Worksheets, Get Worksheet Difference
commands were added to the toolbar.
- Combine workbooks, create intersection and difference in single click.
- xlCompare commands can be used in the VBA macros.
- Removed warning shown when option Trust Access to VBA Project is disabled.
- xlCompare is available in Spanish and Russian languages.
- xlCompare creates reports in the XLS, HTML and TEXT formats.
- Several bugfixes.
- Completely reworked interface - all differences are shown in same Difference Explorer window.
- Reworked Named Item comparison.
- Reworked VBA Project comparison.
- More accurate comparison results.
- Command to restart the comparison.
- This update contains improved comparison engine.
- Added commands to create intersection of the compared worksheets.
- Comparison results for Names may be filtered and exported.
- Fixed problem with copying rows between worksheets.
- You can select formatting options for each type of the difference. Read more ...
- Fixed problem with ThisWorkbook VBA module, excluded from comparison.
- Faster Comparison Report.
- Several bugfixes.
- New reworked interface. Added Difference Browser window.
- Several bugfixes.
- xlCompare supports Excel 64-bit.
- Several impovements in the interface.
- Improved comparison algorithm for unsorted data.
- Improved in-place cell editing in the grid.
- Fixed several issues happened when comparing datasets with "mixed" data.
- Fixed several bugs with drawing multiline cells in the comparison report.
- Fixed problem: "Access to VBA Project blocked" warning when comparing VBA projects.
- New, more friendly interface.
- Faster comparison and more accurate comparison results.
- Edit cell values directly in the xlCompare Comparison Report window.
- Fixed problem with disabled buttons on the xlCompare toolbar.
- Fixed several compatibility problems with another Add-ins.
- Fixed problem with database-style comparison.
- Fixed problem with incorrect closing of Excel Application after comparison.
- Improved database-style comparison.
- Improved comparison of the VBA Code.
- Fixed problem with marking changed cells in the workbook.
- Evaluation period was extended to 15 days.
- Several improvements and bug-fixes
- User can select appropriate Comparison Options. More ...
- Much faster comparison algorithm
- xlCompare compares and merges Names in the Excel workbooks. More ...
- New range selection controls - like Ref Edit Control in Excel.
- Faster database comparison.
- Several improvements in the database comparison.
- New commands added - Home, About.
- Recent Items menu added to the xlCompare toolbar in the Excel 2003.
- xlCompare is available in German language.
- xlCompare comparison functions can be called from VBA code.
- Improved Comparison Report Dialog.
- Fixed several issues in the comparison engine.
- New toolbar command for Comparison Report Dialog.
- Updated Help Library.
- Find Cell feature has been added. You can quickly find value on the Comparison Report.
- Fixed several bugs in the comparison engine.
- Database data is sorted before comparison.
- Improvements in the interface.
- Several internal improvements.
- Move data from compared worksheets to 3-rd sheet.
- Drag-n-drop cells\rows\columns between compared sheets and 3-rd worksheet.
- Use clipboard to merge differences.
- xlCompare compares formulas and values to find the differences.
- Formula bar added to each worksheet view.
- Improved comparison engine.
- Improved Comparison Report Dialog.
- New features for merging workbooks.
- Compare spreadsheets which have database structure.
- Improved comparison engine.
- Reworked interface for Comparison Report Dialog.
- Most recent comparisons are shown in menu - you can repeat it without opening workbooks.
- Improved comparison engine. New comparison algorithm displays results in more suitable form.
- Improvements in the comparison engine.
- "Check for update" feature.
- Fixed problem with blank reports shown for comparison.
- Fixed several minor issues reported by our customers.
- Fixed problem with registration.
- Much faster and precise comparison engine.
-
Tile Worksheet Views. You can align worksheet views horizontally or vertically to display
data in more suitable way.
- First version of this utility has been published.