{"id":1171,"date":"2017-04-24T20:38:54","date_gmt":"2017-04-24T20:38:54","guid":{"rendered":"http:\/\/marco-krapf.de\/?page_id=1171"},"modified":"2018-10-14T21:36:12","modified_gmt":"2018-10-14T19:36:12","slug":"add-in-elphin-toolbox","status":"publish","type":"page","link":"https:\/\/marco-krapf.de\/gb\/add-in-elphin-toolbox\/","title":{"rendered":"ELPHIN Toolbox"},"content":{"rendered":"

Free open source tool that adds an extra ribbon tab which provides extended functions for Microsoft Excel 2010-2019 (Windows optimized)<\/p>\n

The ELPHIN Toolbox is named after the little crofting community of Elphin which can be found in the south west Sutherland area of the Scottish Highlands.<\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>ELPHIN_Toolbox.xlam<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface language<\/td>English, German<\/td>\n<\/tr>\n
Where is the add-in after activation in the AI edition?<\/td>New menu strip tab \"ELPHIN Toolbox\"<\/td>\n<\/tr>\n
File size<\/td>300 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>2911<\/td>\n<\/tr>\n
Source lines of code<\/td>1958<\/td>\n<\/tr>\n
Comment lines of code<\/td>480<\/td>\n<\/tr>\n
Blank lines<\/td>473<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor as there is no password protection.<\/p>\n

Installation<\/strong>
\nThe tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> the toolbox is inserted into the Excel menu strip as a new tab “ELPHIN Toolbox”.<\/p>\n

Download Version 2.0<\/strong> \u2013 kostenlos!<\/span><\/h1>\n

Automatische Installation (empfohlen f\u00fcr Windows)
\n\n\tELPHIN Toolbox\t(4862 downloads\t)\n<\/a>\n<\/h3>\n

Manuelle Installation
\n\n\tELPHIN Toolbox\t(4957 downloads\t)\n<\/a>\n<\/h3>\n

Number of downloads of previous versions: 116<\/p><\/blockquote>\n

Features<\/strong>
\n– Convert all letters to upper-case letters (as value or function)
\n– Convert all letters to lower-case letters (as value or function)
\n– Capitalize each word (as value or function)
\n– Remove all spaces at the beginning of a cell (as value)
\n– Remove all spaces at the end of a cell (as value)
\n– Remove all spaces at the beginning and the end of the cell (as value)
\n– Remove multiple spaces (as value or function)
\n– Check the selected cells for non-breaking spaces
\n– Replace non-breaking spaces in the selected cells
\n– Check the selected cells for non-printing control characters
\n– Remove control characters in the selected cells
\n– Absolute value of a real number (as value or function)
\n– Convert the result of a formula or function to a value
\n– Hide formula result zero (0)
\n– Remove empty rows or columns
\n– Memorize row or colum nnumber
\n– Compare worksheets
\n– SG DataSet Finder for finding matching data records across different Excel files
\n– Undo option can be deactivated for performance improvement
\n– GUI languages: English and German<\/p>\n

Screenshot
\n<\/strong><\/p>\n

<\/p>\n

Donation<\/strong>
\nThis add-in is being developed and maintained with private effort and provided for free download. I would be very happy about a small donation<\/strong><\/span> to this foundation for sick children in the region of Heilbronn\/Germany. Read more on the website of the foundation<\/a>.<\/p>\n

\"Website<\/a><\/p>\n

Donate now!<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"

Free open source tool that adds an extra ribbon tab which provides extended functions for Microsoft Excel 2010-2019 (Windows optimized) The ELPHIN Toolbox is named after the little crofting community of Elphin which can be found in the south west Sutherland area of the Scottish Highlands. Source code The source code is published on GitHub […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-1171","page","type-page","status-publish","hentry"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"gb","enabled_languages":["de","gb"],"languages":{"de":{"title":true,"content":true,"excerpt":false},"gb":{"title":true,"content":true,"excerpt":false}}},"_links":{"self":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/1171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/comments?post=1171"}],"version-history":[{"count":39,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/1171\/revisions"}],"predecessor-version":[{"id":1187,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/1171\/revisions\/1187"}],"wp:attachment":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/media?parent=1171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}