{"id":878,"date":"2017-03-12T13:01:40","date_gmt":"2017-03-12T13:01:40","guid":{"rendered":"http:\/\/marco-krapf.de\/?page_id=878"},"modified":"2018-08-11T21:17:35","modified_gmt":"2018-08-11T19:17:35","slug":"add-in-one-cell-mode","status":"publish","type":"page","link":"https:\/\/marco-krapf.de\/gb\/add-in-one-cell-mode\/","title":{"rendered":"ONE CELL MODE"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-901 size-full\" src=\"https:\/\/marco-krapf.de\/wp-content\/uploads\/2017\/03\/logo_addin_onecell.png\" width=\"526\" height=\"177\" srcset=\"https:\/\/marco-krapf.de\/wp-content\/uploads\/2017\/03\/logo_addin_onecell.png 526w, https:\/\/marco-krapf.de\/wp-content\/uploads\/2017\/03\/logo_addin_onecell-300x101.png 300w\" sizes=\"auto, (max-width: 526px) 100vw, 526px\" \/><\/p>\n<p>Free and completely useless Open-Source-Tool for merging all cells of an Excel worksheet. Coded on urgent request for a highly esteemed colleague who has the steady desire for merging cells.<\/p>\n\n<table id=\"tablepress-10\" class=\"tablepress tablepress-id-10\">\n<tbody class=\"row-striping\">\n<tr class=\"row-1\">\n\t<td class=\"column-1\">File name<\/td><td class=\"column-2\">ONECELL10.xlam<\/td>\n<\/tr>\n<tr class=\"row-2\">\n\t<td class=\"column-1\">Excel versions<\/td><td class=\"column-2\">2010 or later (Windows)<\/td>\n<\/tr>\n<tr class=\"row-3\">\n\t<td class=\"column-1\">Interface language<\/td><td class=\"column-2\">English<\/td>\n<\/tr>\n<tr class=\"row-4\">\n\t<td class=\"column-1\">Where is the add-in after activation?<\/td><td class=\"column-2\">New tab \"Absolute Beginner Add-ins\"<\/td>\n<\/tr>\n<tr class=\"row-5\">\n\t<td class=\"column-1\">File size<\/td><td class=\"column-2\">24 KB<\/td>\n<\/tr>\n<tr class=\"row-6\">\n\t<td class=\"column-1\">Lines of code (total)<\/td><td class=\"column-2\">13<\/td>\n<\/tr>\n<tr class=\"row-7\">\n\t<td class=\"column-1\">Source lines of code<\/td><td class=\"column-2\">12<\/td>\n<\/tr>\n<tr class=\"row-8\">\n\t<td class=\"column-1\">Comment lines of code<\/td><td class=\"column-2\">0<\/td>\n<\/tr>\n<tr class=\"row-9\">\n\t<td class=\"column-1\">Blank lines<\/td><td class=\"column-2\">1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-10 from cache -->\n<p><strong>Source code<br \/>\n<\/strong>The source code is published on <a href=\"https:\/\/github.com\/MarcoKrapf\/Microsoft-Excel-ONE-CELL-MODE\" target=\"_blank\">GitHub<\/a> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2020\" src=\"https:\/\/marco-krapf.de\/wp-content\/uploads\/2018\/03\/Octocat.png\" width=\"25\" height=\"21\" srcset=\"https:\/\/marco-krapf.de\/wp-content\/uploads\/2018\/03\/Octocat.png 800w, https:\/\/marco-krapf.de\/wp-content\/uploads\/2018\/03\/Octocat-300x249.png 300w, https:\/\/marco-krapf.de\/wp-content\/uploads\/2018\/03\/Octocat-768x638.png 768w, https:\/\/marco-krapf.de\/wp-content\/uploads\/2018\/03\/Octocat-624x519.png 624w\" sizes=\"auto, (max-width: 25px) 100vw, 25px\" \/>and can also be opened in the VBA editor.<\/p>\n<p><strong>Installation<\/strong><br \/>\nThe tool is shipped as an add-in for Microsoft Excel (.xlam). After <a href=\"https:\/\/marco-krapf.de\/excel-add-in-installation\/\" target=\"_blank\">installation and activation<\/a> the tool\u00b4s icon is added on the new ribbon tab &#8220;Absolute Beginner Add-ins&#8221;.<\/p>\n<h1><span style=\"color: #993366;\"><strong>Download<\/strong> &#8211; it\u00b4s free and useless!<\/span><\/h1>\n<h3>Automatic installation (recommended for Windows)<br \/>\n<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"Version 1.0\" href=\"https:\/\/marco-krapf.de\/gb\/download\/1066\/?tmstv=1785245210\" rel=\"nofollow\" id=\"download-link-1066\" data-redirect=\"false\" >\n\tONE CELL MODE\t(5791 downloads\t)\n<\/a>\n<\/h3>\n<h3>Manual installation<br \/>\n<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"Version 1,0\" href=\"https:\/\/marco-krapf.de\/gb\/download\/909\/?tmstv=1785245210\" rel=\"nofollow\" id=\"download-link-909\" data-redirect=\"false\" >\n\tONE CELL MODE\t(6935 downloads\t)\n<\/a>\n<\/h3>\n<p><strong>Features<\/strong><br \/>\n&#8211; Merging all cells of an Excel worksheet, so that there will be only one cell left (A1)<\/p>\n<p><strong>Screenshots<\/strong><\/p>\nngg_shortcode_0_placeholder\n<p><strong>Donation<\/strong><br \/>\nThis add-in is being developed and maintained with private effort and provided for free download. I would be very happy about a <strong><span style=\"color: #ff00ff;\">generous donation<\/span><\/strong> to this foundation for sick children in the region of Heilbronn\/Germany. Read more on the <a href=\"https:\/\/www.grosse-hilfe.de\/\" target=\"_blank\">website of the foundation<\/a>.<\/p>\n<p><a href=\"https:\/\/www.grosse-hilfe.de\/\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-246 size-full\" src=\"https:\/\/marco-krapf.de\/wp-content\/uploads\/2016\/03\/exceladdin_stiftung_logo.jpg\" alt=\"Website der Stiftung\" width=\"197\" height=\"118\"><\/a><\/p>\n<h1><a href=\"https:\/\/www.grosse-hilfe.de\/spenden\/spendenformular-jetzt-spenden.html?neues-spendenformular-2691\/spende\" target=\"_blank\">Donate now!<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Free and completely useless Open-Source-Tool for merging all cells of an Excel worksheet. Coded on urgent request for a highly esteemed colleague who has the steady desire for merging cells. Source code The source code is published on GitHub and can also be opened in the VBA editor. Installation The tool is shipped as an [&hellip;]<\/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-878","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":false,"content":true,"excerpt":false}}},"_links":{"self":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/878","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=878"}],"version-history":[{"count":54,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/878\/revisions"}],"predecessor-version":[{"id":2256,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/878\/revisions\/2256"}],"wp:attachment":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/media?parent=878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}