Due to many requests, the Popup Calendar is supported in Page Layout view again. Thank you for your feedback!
To open the calendar, select a cell or a rangeClick the Popup Calendar button on XLTools ribbon, or right-click and select calendar from the context menuThe calendar will pop upPick a date or time to insert.
Calendar icons next to date and time cells remain unavailable. In the next releases we will work further on the issue.
If you notice inconsistent calendar behavior in the Page Layout view, please switch to Normal worksheet view.
Introducing anew feature–Unify Date Format. It helps find all date, time, or date & time cells and change their format across the entire workbook.
In the Date & Time group open the drop-down list Select "Unify date and time format" Specify settings and choose the preferred format OK.
Also added a new automation commandXLTools.UnifyDateTime, so that you can unify date and time format as a part of your automation process.
In the Automation group open the drop-down list Select command XLTools.UnifyDateTime Specify parameters Execute command.
Added anew shortcuttoRecalculate Range. Simply press Alt+F9 to recalculate formulas only in a selected range.
Based on your feedback, updated theEmbedded Calendar(beta). Now you can embed and change settings of the calendar embedded into a specific workbook in just a few clicks.
Improved the way to set a preferred date-time format for thePopup Calendar and Clock. When you select a preset format option or set any custom format – you will see a preview of how dates and time will display in cells (uses current date and time as an example).
Improved the display of the Popup Calendar and Clock so that they are fully visible even if your Excel window is not full screen.
Fixed a bug in the Popup Calendar related to column width autofit. Now autofit will not apply to merged cells to keep your document templates intact.
Expanded functionality of automation commands XLTools.ExportToCSV and XLTools.SaveSheetsAsFiles. Now you can convert worksheets to csv, txt, xml or another file format easier.
Added the automation commandXLTools.ImportFromText. It allows import of unstructured data from text files directly to Excel columns.
Fixed minor bugs, improved UI.
This version brings new functionality and transition to new licenses:
Presenting a long-awaited feature – theEmbedded Calendar(beta version). Now you can embed a sharable date picker into your spreadsheet and it will be available to other users of this spreadsheet. Let us know what you think!
On June 28, 2020 we introduced changes to XLTools licenses. The transition to new licenses will be automatic, no action required. Learn abouteffect on lifetime licenses.
(for registered users only, activate with your purchased license key)
Added a quick access button tosave worksheets as separate files:
XLTools tab Open the drop-down for the Workbook Organizer Click "Save all sheets as separate files" Specify the destination folder Done!
Improved theCombine Datafeature. Now it supports all types of ranges, so you can easily combine data and merge cells in large ranges, non-adjacent ranges, the entire sheet, etc. When you work with non-adjacent ranges, you can choose to process each range separately vs. treat them as a single range.
Expanded the range selection functionality ofData Cleaning, and made it is easy to select and clean an entire sheet.
Now you canturn off notificationsabout available updates:
XLTools tab Settings "Other" tab Check the box "Turn off popup update notifications".
Improved messages about sending errors inMail Merge. Now instead of the less informative "The operation has timed out", you can see what exactly went wrong: invalid email address, exceeded message size limit, wrong attachment file path, etc.
Fixed a bug in Mail Merge that used to convert dates to numeric values in email content.
Added a notification that the Popup Calendar is not supported for the Page Layout workbook view. Please switch to Normal worksheet view to use the Popup Calendar.
Fixed the error in the Split Table feature "Object reference not set to an instance of an object". The error appeared when splitting table by column values and when those values varied by text case. Now the feature discards text case and quickly processes values.
Fixed a bug in Export to CSV which appeared when Excel text strings contained various quotation marks.
Fixed an error when inserting the XLTools.ExportToMySQL automation command.
In this version we have improved the design and usability of XLTools ribbon, and also expanded some features:
Note the new logo and icons, drop-down lists for operations and quick access to features’ settings.
Check out theupdated grouping of buttons: Date and Time, Clean, Transform, SQL Queries, Calculate, Export, Mail Merge, Version Control, Automation, Information. This task-specific grouping helps find the necessary operation much faster.
Important: the buttons of Sheet Switcher and Repeat Selection were removed from the ribbon. But you can still launch these operations with keyboard shortcuts, which you can set here:
Click "Settings" button Select "Shortcuts" tab.
We have simplified access to support team. Now you cancontact us directly from the ribbon:
Click "Contact support" in the Help group Send your feedback, ideas or any errors you come across.
Expanded the Workbook Organizer functionality by integrating it with the Export to CSV feature. Now you can select multiple sheets and save them as separate CSV files all at once, with any separator and any encoding.
Added an option to the Combine Sheets feature to place results to an active workbook.
Developed additional options for the Split Table feature. Now you can place the resulting sheets to the active workbook, to a new workbook, or save sheets as separate files. Where necessary, the existing sheets are replaced correctly.
We have also introduced some minor improvements and fixed bugs:
Mail Merge does not freeze panes when creating a list of recipients. Also, after you send emails to your contact list, the status column shows the date and time when the messages were sent.
Fixed a bug in the Export to CSV feature and now formatted values export properly.
Improved Workbook Organizer: protecting sheets, selecting and navigating worksheets became easier.
Fixed an error when inserting the XLTools.SaveSheetsAsFiles automation command.
In this major release we have significantly expanded Version Control functionality.
Now you can choose tocommit a version every time you save a file:
XLTools tab Settings button Version Control tab Check the box "Commit a version to Change Log every time I save the workbook with changes."
Note: if you made no changes since the last commit and clicked Save file (Ctrl+S), the version of the book will not be committed, not to cram the Change Log with identical versions.
Version Control nowintegrates with Microsoft Spreadsheet Inquire plugin. Users of Office Professional Plus (version Excel 2013 and higher) and Office 365 Professional Plus canadd the Inquire plugin to Exceland compare any two versions of a workbook in detail: see changes in values, formulas, formats, macros, etc.
Open Change Log Select any two workbook versions In the menu or in the context menu, click "Diff with Current version in Inquire" or "Diff with Previous version in Inquire" Comparison will open in Inquire plugin.
You cancompare any version with the current or previous versionmuch easier:
Open Change Log Select a version of a workbook, a worksheet or a VBA project In context menu select "Diff with Current version" or "Diff with Pervious version".
Also, you can double-click on a version It will open in a temporary file and the differences with the previous version will be highlighted.
You canroll back to any previous version in a click:
Open Change Log Select a version of a workbook, worksheet, chart sheet, or VBA project In the menu or in the context menu, click "Roll back to this version".
Version Control is now supported for hidden and protected worksheets, as well as chart sheets.
Find a specific version in Change Logbecame much easier:
Filter versions to display worksheets, VBA projects or chart sheets.
Run a text search within versions’ names, comments and authors.
When you open or compare versions, theу are opened in a temporary file. We have added a clear indication of that and disabled XLTools ribbon in temporary files to eliminate confusion between work files and temp files.
This release also includes a few smaller improvements:
Improved the upgrade process. Now you can try the latest version for free. You can easily purchase an upgrade, or go back to your previous purchased version and upgrade at any time later.
The Split Table feature processes even large tables error-free and quickly. When you split a table by column values, but these values contain forbidden characters or are too long than permitted for a sheet name, the add-in will automatically fix that.
Now you can create automation commands even faster:
XLTools Tab Click the drop-down nearside the "Add Custom Buttons" button Select the command The automation table will be added to the worksheet.
We simplified the way to create XLTools.SQLSelect automation command:
Create a table with XLTools.SQLSelect command Select the cell with the query content SQLQuery button will appear near the cell Click the button The SQL query editor will open Create or edit the query Click Save The query will be inserted into the cell of the automation table.
You can now export to CSV non-adjacent ranges:
E.g. select multiple rows in a table Click Export to CSV Only the selected rows will be exported.
An error in Mail Merge "Unable to cast COM object of type ‘System.__ComObject‘ to interface…" which prevented creating a List of Recipients from scratch is fixed.
Popup Calendar displays properly on screens with high resolution.
We have also improved error processing and added meaningful messages if something goes wrong.
(for registered users only, activate with your purchased license key)
Fixed a bug with the automation command XLTools.CombineSheetsData: combining sheets does not duplicate data now.
Added a drop-down option to the Workbook Organizer button: ‘Open folder of this workbook’. Clicking the option will quickly open the location folder of the active workbook.
Simplified navigating worksheets with the Sheet Switcher for workbooks with 10 and more worksheets.
Improved inserting date & time with the Popup Calendar.
Improved the Mail Merge feature. Now a list of recipients can be created in an unsaved yet workbook. Fixed the error ‘Object reference not set to an instance of an object’ – it appeared when some column headers in the list of recipients were blank.
Added atroubleshooting solutionfor the installation error ‘Customized functionality in this application will not work because the certificate used to sign the deployment manifest or its location is not trusted’. The error will not appear if our website is saved to the list of trusted websites.
Fixed minor bugs with buttons display: Free Trial button on the ribbon, Popup Calendar & Clock icons in the context menu.
Common error messages what appear in SQL queries, Version Control and Mail Merge now contain recommendations how to solve the issue.
Fixed a bug in the Export to CSV feature. Now exporting dates in a long-date format runs smoothly.
Optimized performance of the Combine sheets feature. Now it combines even a large number of sheets much faster and with no errors.
Fixed Mail Merge bugs with the disappearing TLS/SSL checkbox and non-stretchable Send Emails form.
Fixed Version Control errors that prevented comparing versions if the worksheet contained a named range.
Fixed a bug in the Popup Calendar running on Windows 7, when the calendar blocked cell selection.
Improved overall performance.
Introduced a new installer. Any lacking Microsoft prerequisites will be installed at the same time.
Improved the process of updating to a new version, added the ‘Check for Updates’ button to the ribbon.
Automated launching of the free trial. Now the trial activates immediately after installation of the add-in.