title: export to excel from html table excel formula not working
body: <p>I have below code for export excel from HTML table . my question is, after export file when user add excel formula for calculation's ,excel formula not working.  </p>
  
  <blockquote>
    <p>i  googled last 3 days but not success  when i add 2  2 other cell
    formula working fine. but 
    exported data cell formula not working</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/IV106.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IV106.png" alt="enter image description here"></a></p>
  
  <blockquote>
    <p>Example when i add <code>=SUM(D2,D3)</code>   not working . Anyone help me
    this</p>
  </blockquote>
  
  <pre><code>   function ExportoExcel() {
          var tab_text = "&lt;table border='2px'&gt;&lt;tr bgcolor='#87AFC6'&gt;";
          var textRange; var j = 0;
          tab = document.getElementById('printtable'); // id of table
  
          for (j = 0 ; j &lt; tab.rows.length ; j++) {
              tab_text = tab_text + tab.rows[j].innerHTML + "&lt;/tr&gt;";
              //tab_text=tab_text+"&lt;/tr&gt;";
          }
  
          tab_text = tab_text + "&lt;/table&gt;";
          tab_text = tab_text.replace(/&lt;A[^&gt;]*&gt;|&lt;\/A&gt;/g, "");//remove if u want links in your table
          tab_text = tab_text.replace(/&lt;img[^&gt;]*&gt;/gi, ""); // remove if u want images in your table
          tab_text = tab_text.replace(/&lt;input[^&gt;]*&gt;|&lt;\/input&gt;/gi, ""); // reomves input params
  
          var ua = window.navigator.userAgent;
          var msie = ua.indexOf("MSIE ");
  
          if (msie &gt; 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
          {
              txtArea1.document.open("txt/html", "replace");
              txtArea1.document.write(tab_text);
              txtArea1.document.close();
              txtArea1.focus();
              sa = txtArea1.document.execCommand("SaveAs", true, "Say Thanks to Sumit.xls");
          }
          else                 //other browser not tested on IE 11
              sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));
  
          return (sa);
      }
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/IV106.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IV106.png" alt="enter image description here"></a></p>