DiffEngineX 2.19.0.0
Your rating
Date updated
January 29, 2011
Developer
All time downloads
1,174
License / Price
Platform
Windows
Size
30.40 MB
Description of DiffEngineX 2.19.0.0
Compare workbooks in Microsoft Excel
DiffEngineX reports on the differences between Excel spreadsheets (.xls, .xlsx, .xlsm, .xlsb). Compare original and updated versions of your Excel workbooks to find out what data has been changed.
• Compare databases: Import the desired databases into Excel and then compare with DiffEngineX. (Prior sorting required first.)
• Compare CSV (Comma Separated Value) files: Open the CSV files with Excel and save them as Excel workbooks before comparing.
• Management of spreadsheet development: Monitor the development process by examining changes.
• What-if analysis: Create a copy of your Excel workbook, change the values of various inputs and compare it with the original. The affected calculations will be revealed. Note: The option to compare formulae using Their Calculated Values must be turned on first.
• Version Control/Management: Find the differences between old and new versions of the same spreadsheet.
• Check for duplicates (Excel 2007 only): Create a copy of your workbook or sheet, use Excel's Remove Duplicates functionality under the Data tab and then save the recent changes. When DiffEngineX is used to compare the copy to the original, the duplicates will be highlighted. Make sure to turn on DiffEngineX's Align Rows.
Key features
• Fast: Two 4Mb Excel workbooks can be compared in 30 seconds.
• The trial version is free to use.
• Compare formulae & constants between workbooks or selected sheets.
• Alignment of rows and/or columns with similar content between sheets (minimizes spurious differences).
• Report can group like changes if they are made to adjacent cells (report lists 1 change to a range of cells). This is useful when the spreadsheet contains large blocks of equivalent formulae. Check the option "Compact like changes when contiguous".
• Choice of comparing formulae or their calculated values.
• Numeric values compared to a user specified number of decimal places. Useful for ignoring small fractional differences.
• Numeric differences can be ignored if less than a user specified amount.
• Difference report created in a new workbook.
• Powerful option to highlight precisely the parts of formulae and text constants that differ on the report e.g. =A1+Costs+6 and =A1+NewCosts+4.
• Option to add hyperlinks that connect the difference report (often titled Sheet1) to every cell found to differ between two spreadsheets.
• Color highlighting of differences, at the whole cell level, made to copies of your workbooks (separate colors for additions, deletions & modifications).
• Optional removal of existing workbook color before highlighting added (unconditional fill colour only).
• Can optionally hide matching rows enabling convenient discovery of widely separated differences (available on the Extras dialog).
• Can hide different rows enabling just the identical ones to be revealed.
• Can be run using command-line arguments or from its user interface.
What is new in version 2.19.0.0
• Compare formulae & constants between workbooks or selected sheets
• Alignment of rows and/or columns with similar content between sheets (minimizes spurious differences)
• Difference report created in a new workbook
• Powerful option to highlight precisely the parts of formulae and text constants that differ on the report (=A1+Costs+6 and =A1+NewCosts+4)
• Color highlighting of differences, at the whole cell level, made to copies of your workbooks (separate colors for additions, deletions & modifications)
• Optional removal of existing workbook color before highlighting added (unconditional fill colour only)
• Choice of comparing formulae or their calculated values
• Report can group like changes if they are made to adjacent cells (report lists 1 change to a range of cells)
Add your review
Top popularity in Spreadsheets
