New Features and Tools
XLplus Ver.: 3.X explicitly supports MS Excel 2007+ and integrates neatly into the Ribbon. This new version additionally allows including your own macros within the menu of XLplus.
XLplus Ver.: 2.50 instead was developed to support all users of MS Excel 2000-2003 but additionally supports all new spreadsheet dimensions of MS Excel 2007+ as well.
The following features were added in both XLplus Versions:
|
Add-In Manager: |
N |
Using this tool you can conveniently manage your MS Excel Add-Ins. Add-Ins can be saved reliably and converted into Workbooks and back into Add-Ins. Additionally, many properties of an Add-In are shown, for example if an Add-In is protected, if it contains old Excel 4 macro code or the last time it was saved. |
| Add-Zeros Wizard |
E |
This Add-In allows adding zeros or any other data to given content in cells. When adding zeros to a function the tool now extends the given function by code which creates leading or adjacent zeros. When adding data at a specific position within a given function or value this position can now be determined easily by selecting it with a mouse click. |
| Selection Wizard |
E |
This Add-In allows saving or loading a selection of cells. It now can handle unlimited non contigeous ranges and allows adding a saved selection to the active selection when loading it. The user form can be resized now which eases up handling greater lists of saved selections. |
| Copy Print Settings |
E |
This tool allows copying print settings across workbooks. The dialog can be resized now. |
| Show/Hide Zeros |
N |
This Add-In shows or hides all zero values of a spreadsheet. It can be easily invoked by [Ctrl]+[Shift]+Z. |
N = New
E = Extended
The following features were added to XLplus Add-Ons:
XLplus Add-On Basic
| Rework Comments |
E |
This tool allows reworking comments of a worksheet. The completely reworked Add-In now allows keeping formatting of changed comments intact. Additionally new comments can be added to a sheet and the current date to a comment. |
| Shape Comments |
E |
This Add-In allows styling comments by setting their shape. Now Comments of the actual selection of cells can be shaped, too. |
| Sort In Cells |
E |
This tool now allows to specify whether data shall be sorted numeric or alphanumeric. |
| Deselect Active Cell |
N |
When selecting various cells this Add-In allows to revert the last selection made - the active cell will be deselected. |
| Context Menu |
E |
Deselect Active Cell was added to the context menu and is available upon right click with your mouse. |
N = New
E = Extended
XLplus Add-On Basic II
N = New
E = Extended
XLplus Add-On Basic III
| Sort Sheets |
E |
This tool now additionally allows sorting sheets manually. |
| Convert Numbers |
E |
Now, numbers of a given range can be converted to their textual equivalent, too. Before, only an entered value or numbers of the active cell could be converted. |
| Convert Characters |
B |
Corrected a bug where full-trimming values did not correctly full-trim. |
| Manage Hidden Cells |
B |
Corrected a bug whithin the progress indicator which could cause an overflow. |
| Show Hidden Sheets |
E |
Uses new constants introduced with MS Excel 2007; previous versions failed to show hidden sheets when using Excel 2007+. |
N = New
E = Extended
B = Bugfix
XLplus Add-On Basic IV *New*
These two tools perfectly harmonize with Shape Comments, Rework Comments and Highlight Comments. They provide a selection of all cells containing your comments of interest which can be used by the named tools for further work.
XLplus Add-On Internet Tools
| Webpage Report |
E |
This Add-In now supports the new MS Excel 2007+ spreadsheet dimensions. |
E = Extended
XLplus Add-On SQL Commands *New*
This Add-In allows creating SQL Commands based on data of your spreadsheet. The Commands are created as formula so you can even change or adapt them further.