Version 7.3.3 (2018-10-29)

  • Improved: Updated third-party component YamlDotNetSigned to fix potential security issue CVE-2018-1000210.

Version 7.3.2 (2018-09-13)

  • Fix: Prevent FreeImage DLL load errors on some 64-bit systems.

Version 7.3.1 (2018-09-06)

  • Fix: Repackaged the installer, because 7.3.0 did not actually contain that version.
  • Fix: The installer for version 7.3.0 inadvertently contained version 7.1.13.

Version 7.3.0 (2018-09-05)

  • Fix: “Jump” command no longer fails if a workbook from a different folder has already been opened.
  • Fix: Minor fixes.
  • Fix: The installer no longer checks for the presence of Office 2007 or newer, as this would frequently fail with certain Office 365 and Windows 10 setups.
  • Improved: Batch export of graphics can now be performed with screenshot quality.
  • Improved: The “Jump” command will now examine a cell’s formula, rather than its value, to allow users to easily jump to the source of a remote cell reference. For example: cell A1 contains the formula “=[MyOtherFile.xlsx]Sheet1!B2”, then “Jump” will open “MyOtherFile.xlsx” highlight B2 on Sheet1.
  • Improved: Updated FreeImage component to latest version (3.18).
  • New: Added command to clear/invalidate the caches of pivot tables. There is no button to trigger this command; the default keyboard shortcut is CTRL+SHIFT+F5.
  • New: Incorporate the privacy statement into the add-in and make automatic update checks optional.

Version 7.2.13 (2017-11-26)

  • Fix: After exporting to an EMF file, the file handle was not properly released, preventing write access to the exported file until Excel was closed.
  • Fix: Attempt to fix occasional “method not found” errors when starting the Toolbox.
  • Fix: Prevent ‘could not open legacy add-in’ errors.
  • Fix: Some options in batch export settings were not enabled or disabled properly.

Version 7.2.12 (2017-07-16)

  • Fix: Do not show an error message if Excel is running embedded.

Version 7.2.11 (2017-06-24)

  • Change: Errors that occur in the legacy add-in are no longer submitted to the on-line bug tracker because the legacy code is no longer maintained.
  • Fix: Improve the display of the welcome message on first run.
  • Fix: Prevent occasional ‘ValueFactory’ errors.

Version 7.2.10 (2017-03-06)

  • Fix: With the ‘Quit Excel’ command, Excel would sometimes hang after the last workbook was closed.
  • Improvement: Technical improvements.
  • Improvement: Use updated versions of third-party components.

Version 7.2.9 (2017-02-15)

  • Fix: Rebuild installer to include latest bug fixes from Bovender framework.

Version 7.2.8 (2017-02-14)

  • Fix: Rebuild installer.

Version 7.2.7 (2017-02-06)

  • Fix: CSV export can now be cancelled while column widths are being computed (if tabular output is requested).
  • Fix: Do not crash during error bar assignment if the user-defined error value range is smaller than the chart data range.
  • Fix: Prevent black background during graphics export if the file type or color space do not support transparency.
  • Fix: Re-enable screen updating after copying chart properties (no longer make it appear as if Excel has stalled).
  • Fix: Skip invisible sheets and sheets without graphics during batch export.
  • Fix: The progress bar was displayed incorrectly during batch export.
  • Improvement: If a graphic cannot be exported because Excel prevents programmatic access to it, a more meaningful error message is now shown.
  • Improvement: Only add an incremental counter to batch export file names if required to obtain unique filenames.

Version 7.2.6 (2016-12-22)

  • Fix: If “Jump to target” is executed and the current selection is not a worksheet cell, do not crash.
  • Fix: Reduce the risk of Excel not closing when the ‘Quit Excel’ command is invoked.
  • Improvement: Add a ‘debug’ option for more verbose technical logging.

Version 7.2.5 (2016-11-19)

  • Fix: Use non-blocking dialog for update notification.
  • Fix: When batch-exporting, all exported graphics had the same size as the first exported one.
  • Fix: When storing settings, the batch export filename template would override the last used single export filename.

Version 7.2.4 (2016-11-18)

  • Fix: CMYK images were sometimes not produced correctly.
  • Fix: Do not show incomplete shutdown messages as dialogs (i.e., do not block other actions when showing the message)
  • Fix: Make the ‘Use color profile’ option unclickable if the settings require a color profile.
  • Fix: Prevent error when using the Jump To Target command on an empty cell (regression).
  • Fix: Switching export presets for batch export was only accepted the second time around.

Version 7.2.3 (2016-11-17)

  • CHANGE: Do not add space between aligned (tabularized) CSV columns during export; if column separation is desired, enter one or more spaces as field separator.
  • Fix: Properly update the progress bar during batch export.
  • Fix: Reuse previously selected batch export folder.
  • Fix: Switching the export preset would only be respected on repeat export.
  • Fix: Update the image size calculations when switching graphic export presets.
  • Fix: Various bug fixes and technical improvements.
  • Improvement: Properly store the last used CSV import/export folder.
  • Improvement: Remember the current selection for CSV export.

Version 7.2.2 (2016-11-12)

  • CHANGE: Temporarily remove the Tukey posthoc test from the ANOVA results dialog.
  • FIX: CSV files would not be imported properly unless they had a ‘.txt’ extension.
  • FIX: Do not crash in ANOVA results if the (unavailable) Tukey test was selected.
  • FIX: Miscellaneous bug fixes.

Version 7.2.1 (2016-11-06)

This is a ‘meta’ release that just fixes incorrect version tagging. No changes in the program code.

Version 7.2.0 (2016-11-05)

  • FIX: Properly remember the file name template used for batch export.
  • Fix: Prevent error message when ‘jump to’ command is used on a cell that contains a number.
  • Improvement: If additional required DLL files could not be found (e.g. because the installation was not performed as intended), an informative warning is now shown to the user.
  • NEW: Add ability to align columns in CSV export.
  • NEW: Added a {name} placeholder for batch export that is replaced with the name of the graphic being exported.

Version 7.1.4 (2016-09-15)

  • Fix: Prevent nonsense error message from Excel on startup.
  • Fix: Reduce the probability of occasional file access errors during update.

Version 7.1.3 (2016-09-11)

  • Fix: Prevent occasional arithmetic overflow during graphic export.
  • Fix: Prevent rare error message that occurred when the legacy add-in is loaded.
  • Fix: Prevent some “null reference” errors.

Version 7.1.2 (2016-09-06)

  • Change: Do not enable keyboard shortcuts by default.
  • Fix: Prevent one-time error message on startup when upgrading from 7.0.x to 7.1.x.
  • Fix: Update German translation.
  • Improvement: Backup copies of workbooks are opened read-only to prevent accidental loss of data.
  • Improvement: The installer will continue even if the required runtime files cannot be installed. This should make it easier for users if for whatever reason the runtime installation is not detected properly by the XL Toolbox installer.
  • IMPROVEMENT: Backup copies of workbooks are opened read-only to prevent accidental loss of data.

Version 7.1.1 (2016-09-03)

  • FIX: Attempt to prevent random freezes when opening or saving files or during graphic export.

Version 7.1.0 (2016-08-30)

  • FIX: Export presets could not be deleted properly.
  • FIX: Numerous other fixes.
  • FIX: Prevent Excel from not quitting properly from time to time.
  • NEW: Added back the “Jump To Target” feature, previously named “Open from cell”.
  • NEW: Added back the ‘properties’ feature that can be used to copy the current worksheet or workbook name with or without the folder information to the clipboard.
  • NEW: Added back the automatic backup feature, now with the ability to display and manage all backups for the current workbook.
  • FIX: Numerous fixes.

Version 7.0.9 (2016-08-02)

  • FIX: Prevent an error message that occurred when manually checking for an update, while no update was available.
  • FIX: Show the welcome message on top of everything else to prevent Excel 2016’s splash screen from partially hiding it while waiting for the user to dismiss it.
  • FIX: The Worksheet Manager would not always keep up to date with the current workbook.

Version 7.0.8 (2016-08-02)

  • FIX: Use the correct command to install an update.

Version 7.0.7 (2016-08-02)

  • FIX: Incorrect format of the 7.0.6 version numbers prevented building the installer.

Version 7.0.6 (2016-08-02)

  • FIX: Sometimes the legacy add-in could not be closed properly, causing Excel to hang when quitting.
  • IMPROVEMENT: Overhauled the automatic updater to improve maintainability and hopefully fix issues that some users have reported, but that could not be reproduced by the developer.
  • IMPROVEMENT: The installer no longer performs superfluous checks for runtime files when executed as an update.

Version 7.0.5 (2016-07-25)

  • FIX: Prevent occasional hangs when quitting, especially with a pending update.

Version 7.0.4 (2016-07-24)

  • FIX: Stop erratic behavior of Worksheet Manager if the workbook contains hidden sheets.

Version 7.0.3 (2016-07-24)

  • FIX: Prevent occasional crashes with the Worksheet Manager.
  • FIX: When manually checking for an update, proper notification is now shown if an update is available, but the current user is not authorized to install it.

Version 7.0.2 (2016-07-17)

  • FIX: Prevent Excel from sometimes locking up after closing all workbooks when the ‘Quit Excel’ command is used.
  • FIX: Prevent access errors with the built-in legacy add-in.
  • FIX: When installing for all users, make sure to properly register the add-in with Excel.
  • IMPROVEMENT: Quitting Excel works more reliable if hidden workbooks are present.
  • IMPROVEMENT: The installer should now more reliably detect whether additional runtime files need to be installed.

Version 7.0.1 (2016-07-11)

  • CHANGE: Removed the automatic backups feature from the legacy toolbox. It will be added back some time in the future. A few users have reported that Excel freezes when they attempt to save a file and the XL Toolbox add-in is loaded. Although the freezes could not be reproduced reliably by the developer, the automatic backup feature is the only thing that might interfere with Excel’s save command, so it has been disabled for now.
  • FIX: Prevent ‘type arguments’ error when attempting to perform screenshot-quality export of cells.
  • FIX: Prevent Excel from sometimes locking up after closing all workbooks when the ‘Quit Excel’ command is used.
  • FIX: Prevent occasional crashes when quitting Excel while the worksheet manager was visible.
  • FIX: Renaming sheet in worksheet manager would not work.
  • FIX: Watermark command crashed upon invocation.
  • IMPROVED: If incomplete shutdown is detected on startup, the notification dialog is now shown on top of all Windows so it is no longer hidden by the Excel splash screen.
  • IMPROVED: The interaction with the legacy add-in (Visual Basic) did not work properly.
  • IMPROVEMENT: Asynchronous operations (import/export) are more reliable.
  • IMPROVEMENT: Screenshot-quality export now works with range selections as well (however, transparency is only supported by screenshot-quality export with graphical elements, not with cell ranges).
  • IMPROVEMENT: The worksheet manager is now consistently displayed in all windows with Excel 2013 as well (previously only in Excel 2010).
  • IMPROVEMENT: The worksheet manager now follows the selected worksheet.
  • NEW: Ability to switch user interface language.
  • NEW: Added German translation.

Version 7.0.0-beta.7 (2016-06-20)

  • CHANGE: User settings and log files are now stored in a separate “user” folder, rather than along with the add-in files.
  • FIX: Enabling and disabling of keyboard shortcuts.
  • FIX: Using user’s e-mail address in exception report (if provided).
  • IMPROVED: If DLLs are not found in the installation folder, one attempt is made to look in an alternave location.
  • IMPROVED: When exporting a single item, the settings dialog shows the resulting image size.
  • IMPROVEMENT: Cleaned up startup and shutdown processes.
  • IMPROVEMENT: Enable export of extremely large images.
  • IMPROVEMENT: Graphic export is now performed asynchronously, and the progress is displayed if the process takes very long.
  • IMPROVEMENT: If an error occurs in one of the legacy add-in’s functions, it is now shown using the new error reporting tool.
  • IMPROVEMENT: Improved window handling.
  • IMPROVEMENT: The ‘Quit Excel’ command will now quit Excel immediately if only one workbook is open and it does not have unsaved changes.
  • IMPROVEMENT: User experiences in preferences.
  • NEW: Show a clickable URL after submitting an exception report.

Version 7.0.0-beta.6 (2016-05-24)

  • FIX: Do not crash during startup if invalid configuration file is found.
  • FIX: Prevent error message when aborting an update.
  • FIX: Prevent some rare crash that occurred when manually triggering an update check after an automatic update check had already been performed.
  • FIX: When using the one-click export function, use the actual size of the currently selected graphic, rather than changing the size by applying a previously used unit, which could cause an out-of-memory error if the resulting chart size is huge.
  • IMPROVEMENT: If the legacy Toolbox add-in is present during installation, it will now be silently uninstalled. The NG version of the add-in no longer checks for the presence of the legacy version during startup, because deactivation would sometimes crash for no apparent reason.

Version 7.0.0-beta.5 (2016-05-19)

  • FIX: Prevent crash when activating obsolete Toolbox add-in.

Version 7.0.0-beta.4 (2016-05-18)

  • CHANGE: Worksheet manager now resides in a task pane, rather than its own window.
  • FIX: Excel would sometimes crash on shutdown.
  • FIX: Worksheet Manager could not move the first worksheet down.
  • IMPROVEMENT: Handling of dialog windows was improved, they now technically belong to the main Excel window.
  • IMPROVEMENT: Re-implemented “save as” feature (to be used with keyboard shortcuts).
  • IMPROVEMENT: Very large worksheets can now be exported to CSV too.
  • NEW: Ability to write technical log files.
  • NEW: Editable user settings (a few).
  • NEW: User settings are now stored in a human-readable text file in the appdata% folder (under Daniel’s XL Toolbox), rather than an XML file in a directory specified by Microsoft that is hard to find.

Version 7.0.0-beta.3 (2016-04-29)

  • FIX: Attempt to prevent crashes when a file dialog should appear.
  • FIX: Minor fixes.
  • IMPROVEMENT: Update changelog URL.

Version 7.0.0-beta.2 (2016-04-02)

  • FIX: Do not crash in certain situations where stored settings in workbook contain null values.
  • FIX: Do not crash on graphic export.

Version 7.0.0-beta.1 (2016-03-30)

  • FIX: No longer crash during certain operations if a workbook is opened in Protected View.
  • IMPROVEMENT: Use improved scripts to generate installer.
  • NEW: Incorporate legacy XL Toolbox (version 6.60).

Version 7.0.0-alpha.19 (2016-03-17)

  • FIX: Do not reset user settings every time the add-in is started.
  • FIX: Export of range to CSV using parameters exported the entire sheet.
  • FIX: No longer display registry key error during installation.
  • FIX: Prevent runtime error during retrieval of stored settings (#6cd86012).
  • IMPROVEMENT: Enable tab characters for CSV export; use “” as a field seperator to write tabs to the output file.

Version 7.0.0-alpha.18. (2015-11-09)

  • FIX: Better error handling during CSV export.
  • FIX: Display of CSV export completed percentage.
  • FIX: Facilitate installation on network drives.
  • FIX: Incomplete CSV export in certain situations.
  • FIX: Some progress bar displays (e.g. in CSV export).
  • FIX: Some user settings were not properly remembered.
  • IMPROVEMENT: Prepare to use better checksum algorithm (SHA-256 rather than SHA-1) to verify the integrity of updater files.

Version 7.0.0-alpha.17. (2015-10-16)

  • FIX: No longer crash on exporting small amounts of data to CSV.
  • NEW: Show Excel’s Add-In commands on the XL Toolbox NG ribbon.

Version 7.0.0-alpha.16 (2015-10-13)

  • FIX: Do not loose addin settings after updating Excel.
  • FIX: Properly remember the last used CSV import/export settings.
  • IMPROVED: CSV export now properly adds double quotes to fields containing the field separator or double quotes, and doubles double quotes (to comply with RFC 4180).

Version 7.0.0-alpha.15 (2015-10-05)

  • FIX: Minor improvements.
  • FIX: No more crashes when shutting down Excel with pending update.
  • FIX: Prevent nasty crash when quitting Excel.
  • FIX: Update progress dialogs are now shown properly.

Version 7.0.0-alpha.14 (2015-09-21)

  • FIX: Batch export crashed (report ID 667aed57).
  • FIX: Close ‘update available’ dialog when downloading update.
  • FIX: Provide more meaningful error messages if a color space conversion is not implemented (report ID 665ecebe).
  • IMPROVED: CSV export performance was dramatically improved.

Version 7.0.0-alpha.13. (2015-09-15)

  • NEW: CSV export feature.

Version 7.0.0-alpha.12 (2015-06-25)

  • FIX: Do not crash on graphic export.

Version 7.0.0-alpha.11 (2015-06-24)

  • FIX: Do not crash on graphic export if no previously used path exists.
  • FIX: Do not crash on updating.

Version 7.0.0-alpha.10 (2015-06-16)

  • FIX: Do not crash on graphic export if no previously used path exists.

Version 7.0.0-alpha.9 (2015-06-11)

  • CHANGE: Add a visual ‘resize grip’ to Sheet Manager.
  • FIX: Display tooltip describing export preset in single export combobox.
  • FIX: Do not allow transparency with CMYK color space.
  • FIX: EMF export no longer exports PNG, but actual EMF file.
  • FIX: Enable or disable CMYK depending on selected file type.
  • FIX: Export preset editor can be closed with ESC.
  • FIX: Export preset name with color management.
  • FIX: Last directory and file name of graphic export are properly remembered now.
  • FIX: Make sure confirmation and notification dialogs are not hidden by other windows.
  • FIX: Properly save export presets.
  • NEW: Feature to quit Excel, closing all workbooks, saving as needed.
  • NEW: One-click CSV import feature.
  • NEW: Programming interface (API) for VBA code (see blog for instructions).

Version 7.0.0-alpha.8 (2015-05-12)

  • FIX: Adjust enabled state of worksheet manager according to context.
  • FIX: Prevent UI error when hovering over ribbon buttons.
  • FIX: Update Worksheet Manager if sheets are rearranged with Excel.

Version 7.0.0-alpha.7 (2015-03-06)

  • CHANGE: Do not install update while Excel is running.
  • CHANGE: Ribbon buttons are enabled and disabled depending on context.
  • CHANGE: Worksheet manager always shows sheets of active workbook.
  • FIX: Disable ‘Check for updates’ command if an operation is pending.
  • FIX: Do not crash with null reference exception during batch export (fixes #5b60f5b8).
  • FIX: Do not leave stray test file after checking update authorization.
  • FIX: Prevent null reference exception when choosing save file name (#5b0d44c5).
  • FIX: Show progress when downloading update.
  • NEW: Screenshot export feature.
  • NEW: Worksheet manager will optionally stay on top of all windows.

Version 7.0.0 (2016-07-05)

Version 7.0.0 is the first release of the ‘Next Generation’ series with many improvements and new features. Read more at https://www.xltoolbox.net/ng

Changes since 7.0.0-beta.7:

  • FIX: Prevent occasional crashes when quitting Excel while the worksheet manager was visible.
  • FIX: Renaming sheet in worksheet manager would not work.
  • FIX: Watermark command crashed upon invocation.
  • IMPROVED: If incomplete shutdown is detected on startup, the notification dialog is now shown on top of all Windows so it is no longer hidden by the Excel splash screen.
  • IMPROVED: The interaction with the legacy add-in (Visual Basic) did not work properly.
  • IMPROVEMENT: Asynchronous operations (import/export) are more reliable.
  • IMPROVEMENT: The worksheet manager is now consistently displayed in all windows with Excel 2013 as well (previously only in Excel 2010).
  • IMPROVEMENT: The worksheet manager now follows the selected worksheet.
  • NEW: Ability to switch user interface language.
  • NEW: Added German translation.
  • CHANGE: Add a visual ‘resize grip’ to Sheet Manager.
  • CHANGE: Do not install update while Excel is running.
  • CHANGE: Ribbon buttons are enabled and disabled depending on context.
  • CHANGE: User settings and log files are now stored in a separate “user” folder, rather than along with the add-in files.
  • CHANGE: Worksheet manager always shows sheets of active workbook.
  • CHANGE: Worksheet manager now resides in a task pane, rather than its own window.
  • FIX: Adjust enabled state of worksheet manager according to context.
  • FIX: Attempt to prevent crashes when a file dialog should appear.
  • FIX: Batch export crashed (report ID 667aed57).
  • FIX: Better error handling during CSV export.
  • FIX: Close ‘update available’ dialog when downloading update.
  • FIX: Disable ‘Check for updates’ command if an operation is pending.
  • FIX: Display of CSV export completed percentage.
  • FIX: Display tooltip describing export preset in single export combobox.
  • FIX: Do not allow transparency with CMYK color space.
  • FIX: Do not crash during startup if invalid configuration file is found.
  • FIX: Do not crash in certain situations where stored settings in workbook contain null values.
  • FIX: Do not crash on graphic export if no previously used path exists.
  • FIX: Do not crash on graphic export.
  • FIX: Do not crash on updating.
  • FIX: Do not crash with null reference exception during batch export (fixes #5b60f5b8).
  • FIX: Do not leave stray test file after checking update authorization.
  • FIX: Do not loose addin settings after updating Excel.
  • FIX: Do not reset user settings every time the add-in is started.
  • FIX: EMF export no longer exports PNG, but actual EMF file.
  • FIX: Enable or disable CMYK depending on selected file type.
  • FIX: Enabling and disabling of keyboard shortcuts.
  • FIX: Excel would sometimes crash on shutdown.
  • FIX: Export of range to CSV using parameters exported the entire sheet.
  • FIX: Export preset editor can be closed with ESC.
  • FIX: Export preset name with color management.
  • FIX: Facilitate installation on network drives.
  • FIX: Incomplete CSV export in certain situations.
  • FIX: Last directory and file name of graphic export are properly remembered now.
  • FIX: Make sure confirmation and notification dialogs are not hidden by other windows.
  • FIX: Minor fixes.
  • FIX: No longer crash during certain operations if a workbook is opened in Protected View.
  • FIX: No longer crash on exporting small amounts of data to CSV.
  • FIX: No longer display registry key error during installation.
  • FIX: No more crashes when shutting down Excel with pending update.
  • FIX: Prevent UI error when hovering over ribbon buttons.
  • FIX: Prevent crash when activating obsolete Toolbox add-in.
  • FIX: Prevent error message when aborting an update.
  • FIX: Prevent nasty crash when quitting Excel.
  • FIX: Prevent null reference exception when choosing save file name (#5b0d44c5).
  • FIX: Prevent runtime error during retrieval of stored settings (#6cd86012).
  • FIX: Prevent some rare crash that occurred when manually triggering an update check after an automatic update check had already been performed.
  • FIX: Properly remember the last used CSV import/export settings.
  • FIX: Properly save export presets.
  • FIX: Provide more meaningful error messages if a color space conversion is not implemented (report ID 665ecebe).
  • FIX: Show progress when downloading update.
  • FIX: Some progress bar displays (e.g. in CSV export).
  • FIX: Some user settings were not properly remembered.
  • FIX: Update Worksheet Manager if sheets are rearranged with Excel.
  • FIX: Update progress dialogs are now shown properly.
  • FIX: Using user’s e-mail address in exception report (if provided).
  • FIX: When using the one-click export function, use the actual size of the currently selected graphic, rather than changing the size by applying a previously used unit, which could cause an out-of-memory error if the resulting chart size is huge.
  • FIX: Worksheet Manager could not move the first worksheet down.
  • IMPROVED: CSV export now properly adds double quotes to fields containing the field separator or double quotes, and doubles double quotes (to comply with RFC 4180).
  • IMPROVED: CSV export performance was dramatically improved.
  • IMPROVED: If DLLs are not found in the installation folder, one attempt is made to look in an alternave location.
  • IMPROVED: When exporting a single item, the settings dialog shows the resulting image size.
  • IMPROVEMENT: Cleaned up startup and shutdown processes.
  • IMPROVEMENT: Enable export of extremely large images.
  • IMPROVEMENT: Enable tab characters for CSV export; use “” as a field seperator to write tabs to the output file.
  • IMPROVEMENT: Graphic export is now performed asynchronously, and the progress is displayed if the process takes very long.
  • IMPROVEMENT: Handling of dialog windows was improved, they now technically belong to the main Excel window.
  • IMPROVEMENT: If an error occurs in one of the legacy add-in’s functions, it is now shown using the new error reporting tool.
  • IMPROVEMENT: If the legacy Toolbox add-in is present during installation, it will now be silently uninstalled. The NG version of the add-in no longer checks for the presence of the legacy version during startup, because deactivation would sometimes crash for no apparent reason.
  • IMPROVEMENT: Improved window handling.
  • IMPROVEMENT: Prepare to use better checksum algorithm (SHA-256 rather than SHA-1) to verify the integrity of updater files.
  • IMPROVEMENT: Re-implemented “save as” feature (to be used with keyboard shortcuts).
  • IMPROVEMENT: The ‘Quit Excel’ command will now quit Excel immediately if only one workbook is open and it does not have unsaved changes.
  • IMPROVEMENT: Update changelog URL.
  • IMPROVEMENT: Use improved scripts to generate installer.
  • IMPROVEMENT: User experiences in preferences.
  • IMPROVEMENT: Very large worksheets can now be exported to CSV too.
  • NEW: Ability to write technical log files.
  • NEW: CSV export feature.
  • NEW: Editable user settings (a few).
  • NEW: Feature to quit Excel, closing all workbooks, saving as needed.
  • NEW: Incorporate legacy XL Toolbox (version 6.60).
  • NEW: One-click CSV import feature.
  • NEW: Programming interface (API) for VBA code (see blog for instructions).
  • NEW: Screenshot export feature.
  • NEW: Show Excel’s Add-In commands on the XL Toolbox NG ribbon.
  • NEW: Show a clickable URL after submitting an exception report.
  • NEW: User settings are now stored in a human-readable text file in the appdata% folder (under Daniel’s XL Toolbox), rather than an XML file in a directory specified by Microsoft that is hard to find.
  • NEW: Worksheet manager will optionally stay on top of all windows.

Version 7.0.0-alpha.6 (2015-02-03)

The 6th alpha of the NG series fixes several installation issues and removes an external DLL dependency from 64-bit FreeImage.dll.

  • FIX: Build FreeImage.DLL without OpenMP support (which would require vcomp120.dll, which may not be present on all systems).
  • FIX: Include more meaningful information in DLL-load error messages.
  • FIX: Installer now correctly checks if all prerequisites are met.

Version 7.0.0-alpha.5 (2015-01-28)

The fifth alpha version fixes some severe issues with the installation and included DLL files.

  • CHANGE: Improved reporting when a DLL cannot be loaded.
  • CHANGE: Provide human-friendly Excel version in error reports.
  • FIX: Ensure that the .NET 4.0 runtime if downloaded and installed if necessary.
  • FIX: FreeImage version number is shown in error messages again.

Version 7.0.0-alpha.4 (2015-01-26)

  • FIX: FreeImage DLL is only loaded when actually needed.
  • FIX: Improved various dialogs.
  • FIX: Make sure the entire chart is exported even if an element in it is selected.
  • FIX: Numerous bug fixes and code optimizations.
  • FIX: Only offer transparency for export if color space and file type support it.
  • NEW: Support for CMYK color space.
  • NEW: Support for color profiles.
  • FIX: Export: If an object in a chart is selected, export the entire chart.

Version 7.0.0-alpha.3 (2015-01-05)

  • Fix installer not properly registering the add-in.
  • Fix incorrect version number in assembly.
  • Fix updater view layouts.
  • Prevent hidden sheets from showing up in sheet manager.
  • Suppress superfluous Excel warnings when deleting sheets.
  • Always have at least one export preset so users are not confused.

Version 7.0.0-alpha.2 (2015-01-04)

License change: - Now released under Apache License, Version 2.0; see blog for details.

New features: - Basic graphic export with support for transparency. - Basic worksheet manager.

Internals: - Major rewrite and reorganization of the alpha 1 code. - Uses Model–View–View Model design pattern. - Project structure simplified.

Known issues: - No support for CMYK color space. - No support for color profiles.

Version 7.0.0-alpha.1 (2014-08-06)

First developmental version of the Next Generation (NG) series.