For those users who are interested in my future plans for the XL Toolbox after the 2.73 release, here is my personal wish list.
Vector graphic export
The XL Toolbox provides the ability to produce high-resolution, publication-quality graphic files directly from Excel. These files can be submitted to scientific journals without further modification. It is even possible to use Excel to lay out multi-panel figures, and combine graphs with imported pictures.
While I’m very proud of this feature and have invested a tremendous amount of time to make it work, bitmap files (such as TIFF and PNG files) have several major disadvantages: For example, they tend to be huge, and they are not easily scalable.
Vector graphic files are a good alternative. They consume much less memory, and they are easily scalable. It is already possible to produce vector graphic files from Excel using the XL Toolbox. However, this is currently limited to EMF files, a Windows-specific file format.
I use Linux-based software for most of my work nowadays, and it would be great to be able to generate vector graphic files from Excel in a more compatible format than EMF. Thus, I am planning to implement support for the Scalable Vector Graphic (SVG) format in the XL Toolbox. I chose SVG over other scalable formats (such as PostScript, for example), because it is much simpler to program, and it is a modern format.
This is likely going to be a long-term project.
Support for 64-bit Excel
Currently, the XL Toolbox does not run in a 64-bit environment. Adding 64-bit support to the addin is going to be a rather tedious task, but it seems worth while as I expect more and more computer users to switch to 64-bit software (which can handle much larger amounts of data than 32-bit software).
International language support
I wish to make the XL Toolbox speak more languages. Although most users are probably familiar with English, it would provide a smoother user experience if the add-in used the same language as the Excel environment that it is running in. The Visual Basic for Applications (VBA) programming language does not provide native support for internationalization, so that I will have to invent something.
More statistical analyses
Finally, another long-term goal is to implement more ANOVA post-hoc analyses.
I can give no time frame for the changes and additions outlined above, as I program the Toolbox in my spare time. It may take months before the next major release.
The following comments were imported from the previous blog software: