What's new in Spreadsheet Compare 1.36.0
Apr 1, 2019
- Changed: Added option to clear all cell colours to Sync Scroll.
- Fixed: When performing full compare with only one Workbook in Excel 365 (and probably 2013), Excel window shrinks very small.
- Fixed: Fixed issue when moving cells if the range was selected from the end to the start instead of from the start to the end.
- Changed: When using range compare, if two areas are specified, then make them the default check areas.
- Changed: Changed installer.
New in Spreadsheet Compare 1.35.3 (Oct 26, 2017)
- Changed: Improved results for Range Compare.
- Fixed: Bug #75 Database Style Compare due to formatting. Thanks Albatross.
- Fixed: Facebook button fixed. Thanks Alan Jones.
- Fixed: Shifting rows/columns too far up/left caused an error on Quick Compare. Thanks Alan Jones.
- Fixed: Better sizing of main window on Win 10 and Office 365.
New in Spreadsheet Compare 1.35.1 (Sep 5, 2017)
- Changed: Remove reference to progressbar control (replaced with 2 custom labels). Should fix some issues with x64 versions of Excel.
- Changed: In main compare, skip the tab allowing selection of area to ignore.
New in Spreadsheet Compare 1.34.8 (Feb 16, 2015)
- Fixed: Further fix to Bug #70 (error using Excel 2003 xla). Thanks pc63.
New in Spreadsheet Compare 1.34.7 (Feb 11, 2015)
- Fixed: Bug #70 Error using Excel 2003. Have now updated the .xla to match the current .xlam version.
New in Spreadsheet Compare 1.34.6 (Feb 11, 2015)
- Fixed: Bug #66 Error causing session file containing blank filenames to load files from My Documents.
New in Spreadsheet Compare 1.34.5 (Dec 9, 2014)
- Fixed: Bug #66 Crash when saved filenames in session are not open in Excel when AddIn started.
New in Spreadsheet Compare 1.34.4 (Dec 8, 2014)
- Fixed: Help button was broken
New in Spreadsheet Compare 1.34.3 (Jul 16, 2014)
- Fixed: Bug #67. Fixed error when Merged Diffs report is not selected.
- Changed: Add code to centre forms to fix issue on dual screen systems. By default Windows places them between monitors.
New in Spreadsheet Compare 1.34.2 (Jul 16, 2014)
- Fixed: Bug introduced in the last version that caused compare data to not be entered into the Merged Diffs report.
- Changed: Merged Diffs report now formats added and deleted rows with the original formatting when using Database compare.
New in Spreadsheet Compare 1.34.1 (Jul 12, 2014)
- Fixed: Bug #65. Dates not showing correctly on Merged Diffs report when displaying before and after values. Thanks SimonC.
- Fixed: Bug #64. File/folder errors when comparing workbooks that had never been saved. Thanks ElrondPA.
- Fixed: Added error handling to functions in mdlMain.
New in Spreadsheet Compare 1.34.0 (May 30, 2014)
- Changed: Database Compare option now generates the Report and Merged Diffs outputs in the order: Changed rows then deleted rows then added rows instead of mixed change and deleted rows.
- Fixed: Bug #62. Error with ShowAll function in Office 2010. Thanks Douglas Terry.
New in Spreadsheet Compare 1.33.3 (May 8, 2014)
- Fixed: Bug #63. Error when session saved with filenames.
- Fixed: Bug #62. Error with ShowAll function in Office 2007.
New in Spreadsheet Compare 1.33.2 (Apr 10, 2014)
- Fixed: Bug #60. Some Windows APIs were not coded to run with Office x64.
New in Spreadsheet Compare 1.33.1 (Mar 28, 2014)
- Fixed: Bug #57. When comparing, hidden and filtered cells are shown to ensure database compare detects all changes.
- Fixed: Overlap of text on mismatch page.
- Added: Separate checkbox for solid change highlighting to make the selection more obvious.
New in Spreadsheet Compare 1.33.0 (Mar 25, 2014)
- Changed: In full compare, solid compare vs. similarity is better identified
- Added: Settings button on Ribbon. Currently it only gives access to the settings configuration file
- Fixed: Add additional checking for text boxes
- Changed: Bug #58. Zoom value of worksheets not changed until user proceeds to the second step of the wizard
- Added: Automatic suggestion of session name
- Changed: Req #17: Last run session is automatically selected when running the next compare
- Added: Session list, replacing session dropdown
- Added: Edit Session button added to allow modification of the settings, or sending back to the developer for investigation
- Added: Report and Merged Diff workbook now closed automatically when starting a new compare
- Fixed: Bug #56: Crash when database key column textbox is blank when running database compare.
New in Spreadsheet Compare 1.32.0 (Mar 25, 2014)
- Fixed: Tiling error when a worksheet is minimised. There is still some flickering that would be nice to eliminate in the future.
- Added: Sync scroll to full compare.
- Added: Next Sheet button to the 'Stop on miscompare' popup.
- Fixed: Error using Return command when cancelling compare.
- Changed: Removed option to restart on a different row when using stop on miscompare. This causes problem with data compare and merged diffs report.
- Added: Compare duration to final popup for full compare.
- Fixed: Cell colouring when using cell/row skipping using stop on miscompare.
- Changed: Reports now automatically overwrite an existing report if it is there.
New in Spreadsheet Compare 1.31.0 (Mar 17, 2014)
- Added: Overriding Mark Mismatches checkbox which disables all changes to the original workbooks being compared.
- Added: Req #8: Add change column to the Merged Diff report.
- Added: Button on worksheet selection to select only the active worksheets to complement the Matches button.
- Added: Req #16. Horizontal and Vertical alignment buttons on Quick Compare. The button improves window usability when more than 2 windows are open.
- Added: Option to auto save the Compare Report in the same location as the Merged Diffs report.
- Changed: Req #15. File drop down boxes now allow scrolling for long filenames. Thanks Douglas Terry.
- Added: Req #16. Horizontal and Vertical alignment buttons on Full Compare. The button improves window usability when more than 2 windows are open.
- Changed: Report font to a fixed width font to add detection of hard to see changes (i.e. space differences)
- Changed: Report and Merged Diffs options split on different steps in wizard. Sample pictures included.
- Fixed: Bug #53. Database Style Compare primary key column is now stored correctly in the session data. Thanks Douglas Terry.
- Fixed: Bug #52. Find/Replace dialog reset to defaults after Database Compare has been completed. Thanks Douglas Terry.
- Fixed: Merged Diffs workbook should not ask to be saved any more when being closing.
- Changed: Data Compare new/deleted lines appear correctly when using similarity.
New in Spreadsheet Compare 1.30.0 (Feb 26, 2014)
- Added: Option to automatically add all matching worksheets in a compare.
- Fixed: Completion popup not showing less than 1% change diffs (showing blank).
- Changed: Improved worksheet synchronisation when stopping on miscompare.
New in Spreadsheet Compare 1.27 (Jan 16, 2014)
- Added Column Left and Right to Sync Scroll popup.
- Add check of column and row ranges before allow continuation in the wizard.
- Add option to not add 'Compare Column' when using sync scroll.
- Improved text on database compare.
- Fixed issue causing first column to be deleted when using sync scroll.
New in Spreadsheet Compare 1.26 (Mar 21, 2013)
- Added tab coloring option to Sync Scroll.
- Added option to delay update checks on the updater window.
- Removal of MSCOMCTL.OCX because it appears to cause more problems than it fixes.
New in Spreadsheet Compare 1.25.1 (Mar 8, 2013)
New in Spreadsheet Compare 1.25.0 (Feb 5, 2013)
- Added: Support for Excel 2013.
- Added: Registration of MSCOMCTL.OCX to hopefully fix bugs arising because Excel loses link to it.
New in Spreadsheet Compare 1.24.0 (Jan 12, 2013)
- Changed: Orientation of Sync Scroll popup.
- Added: Progress bar to Sync Scroll popup.
- Changed: Sync Scroll now adds compare column and populates it with asterisks indicating the changes on that row.
- Changed: Sync Scroll now checks the entire row (all columns) when 'All Cells' is not selected, rather than just the visible cells on the screen.
- Added: Compare button to Sync Scroll popup.
New in Spreadsheet Compare 1.23.1 (Oct 16, 2012)
- Fixed: Error in office 2003 when using checking column count.
- Fixed: Error in range check of Sync Scroll.
New in Spreadsheet Compare 1.23 (Sep 24, 2012)
- Added: Additional Sync Scroll buttons.
- Added: The ability to use Sync Scroll with one window only.
New in Spreadsheet Compare 1.22.1 (Sep 6, 2012)
- Fixed: Update window only appears when a new version is available.
- Fixed: Update window now shows What's New (and online help, so that links to new features will work).
New in Spreadsheet Compare 1.20.0 (Aug 13, 2011)
- Fixed: Error when row height set to greater than 409.
- Fixed: Win 7/Vista UAC issues.
- Note: To retain sessions/settings, move the 'Spreadsheet Compare Settings.ini' file from 'C:\Program Files[(x86)]\Spreadsheet Compare' to 'C:\Users\username\AppData\Roaming\Spreadsheet Compare' or similar, depending on OS.
New in Spreadsheet Compare 1.19.1 (Jul 18, 2011)
- Fixed: Error when row count is greater than 32767.
- Changed: Attempt to eliminate error when printing the merged diffs report. Sometime Excel generates an error about the row titles.
New in Spreadsheet Compare 1.19 (Jul 18, 2011)
- Added: Graphics to Sync Scroll buttons.
- Fixed: Error when hyperlinks for values > 255 chars long are generated. Changed: More consistent Cancel / Back / Next button handling.
New in Spreadsheet Compare 1.18 (Jul 18, 2011)
- Added: Swap button to swap Workbooks in Comboboxes.
- Changed: Removed some Sync options that are not used.
- Added: Shared Workbooks are now opened in Exclusive Mode now (no error when comparing shared workbooks).
- Added: Protected Workbooks / Worksheets are now detected and generate warnings.
New in Spreadsheet Compare 1.17 (Jul 18, 2011)
- Fixed: xla now includes Sync Scroll.
- Added: Popup for Sync Scroll that allows easier row / column insertion for aligning spreadsheets.
New in Spreadsheet Compare 1.16 (Nov 11, 2010)
- Fixed: Sheet5 is no longer created in the merge differences report.
- Added: Merged differences Workbook now shows tab colours for changed sheets.
- Added: Created separate xlam for Office 2007/2010 with graphics.
- Changed: Add Sync Scroll (moved from Essential Excel Add-In project).
- Changed: Replaced comdlg32.ocx with comdlg32.dll
- Fixed: Corrected error when only 1 Workbook and Personal Workbook is loaded.
- Changed: Program now attempts to reset the usedrange in each Worksheet before comparing.
- Fixed: Problem with FindMatch when using database compare.