The other answer, to set the format to ‘plain text’ in javascript, doesn’t work. However, this does: sheet.getRange(1,n).setNumberFormat(‘@STRING@’); So the magic value for formatting text programmatically is ‘@STRING@’!
In the military it’s called “Defense in Depth”. The theory is that you harden every layer you can rather than hardening just one layer and hoping it’s enough. I’ve heard databases like yours called “hard on the outside, soft and chewy on the inside”. There are a million ways a dedicated hacker can get access … Read more
Use html2text (example HTML to text), licensed under the Eclipse Public License. It uses PHP’s DOM methods to load from HTML, and then iterates over the resulting DOM to extract plain text. Usage: // when installed using the Composer package $text = Html2Text\Html2Text::convert($html); // usage when installed using html2text.php require(‘html2text.php’); $text = convert_html_to_text($html); Although incomplete, … Read more