rainbow text for google calc / sheets

rich1.0phorkiehttps://p.cweiske.de/rainbow text for google calc / sheetsChristian Weiske86400900900 <link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/> <div class="phork" id="650"> <div class="phork-file"> <div class="phork-content"> <style type="text/css">/** * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2014 Benny Baumann * (http://qbnz.com/highlighter/ and http://geshi.org/) */ .javascript .de1, .javascript .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;} .javascript {font-family:monospace;} .javascript .imp {font-weight: bold; color: red;} .javascript li, .javascript .li1 {color: #DDD;} .javascript .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;} .javascript .kw1 {color: #000066; font-weight: bold;} .javascript .kw2 {color: #003366; font-weight: bold;} .javascript .kw3 {color: #000066;} .javascript .kw5 {color: #FF0000;} .javascript .co1 {color: #006600; font-style: italic;} .javascript .co2 {color: #009966; font-style: italic;} .javascript .coMULTI {color: #006600; font-style: italic;} .javascript .es0 {color: #000099; font-weight: bold;} .javascript .br0 {color: #009900;} .javascript .sy0 {color: #339933;} .javascript .st0 {color: #3366CC;} .javascript .nu0 {color: #CC0000;} .javascript .me1 {color: #660066;} .javascript span.xtra { display:block; } </style><div class="code"><table class="javascript"><tbody><tr class="li1"><td class="ln"><pre class="de1">1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 </pre></td><td class="de1"><pre class="de1">/**  * @OnlyCurrentDoc Limits the script to only accessing the current sheet.  */   /**  * A special function that runs when the spreadsheet is open, used to add a  * custom menu to the spreadsheet.  */ function onOpen() {   SpreadsheetApp.getUi()     .createAddonMenu()     .addItem('Rainbow color selected cells', 'rainbowTextAllCells')     .addToUi(); }   function onInstall(e) {   onOpen(e); }   /**  * Color the text in all selected cells in rainbow colors  *  * @author Christian Weiske <weiske@mogic.com>  */ function rainbowTextAllCells() {   var ranges = SpreadsheetApp.getActiveSheet().getActiveRangeList().getRanges();   var alltext = "";   for (var rangeId = 0; rangeId < ranges.length; rangeId++) {     var richtexts = ranges[rangeId].getRichTextValues();         for (var rangeRow = 0; rangeRow < richtexts.length; rangeRow++) {       for (var rangeCol = 0; rangeCol < richtexts[rangeRow].length; rangeCol++) {         alltext += richtexts[rangeRow][rangeCol].getText();       }     }   }     var steplength = 360 / alltext.length;   var rainbowPos = 0;     for (var rangeId = 0; rangeId < ranges.length; rangeId++) {     var range = ranges[rangeId];     var richtexts = range.getRichTextValues();       for (var rangeRow = 0; rangeRow < richtexts.length; rangeRow++) {       for (var rangeCol = 0; rangeCol < richtexts[rangeRow].length; rangeCol++) {           var cellText = richtexts[rangeRow][rangeCol].getText();         var richtext = SpreadsheetApp.newRichTextValue().setText(cellText);         for (var pos = 0; pos < cellText.length; pos++) {           var color = hsl2rgb(rainbowPos * steplength, 100, 50);           var colorCode = '#' + toHex(color.r) + toHex(color.g) + toHex(color.b)           var style = SpreadsheetApp.newTextStyle().setForegroundColor(colorCode);           richtext.setTextStyle(pos, pos + 1, style.build());                     rainbowPos++;         }         range.getCell(rangeRow + 1, rangeCol + 1).setRichTextValue(richtext.build());               }     }   } }   /**  * Color the text in the currently active cell in rainbow colors  *  * @author Christian Weiske <weiske@mogic.com>  */ function rainbowTextCurrentCell() {     var cell = SpreadsheetApp.getCurrentCell();   var text = cell.getRichTextValue().getText()     var richtext = SpreadsheetApp.newRichTextValue().setText(text);   var steplength = 360 / text.length;   for (var pos = 0; pos < text.length; pos++) {     var color = hsl2rgb(pos * steplength, 100, 50);     var colorCode = '#' + toHex(color.r) + toHex(color.g) + toHex(color.b)     var style = SpreadsheetApp.newTextStyle().setForegroundColor(colorCode);     richtext.setTextStyle(pos, pos + 1, style.build());   }   cell.setRichTextValue(richtext.build()); }   function toHex(num) {   var str = num.toString(16);   if (str.length < 2) {     str = "0" + str;   }   return str; }   // http://hsl2rgb.nichabi.com/javascript-function.php function hsl2rgb (h, s, l) {     var r, g, b, m, c, x       if (!isFinite(h)) h = 0     if (!isFinite(s)) s = 0     if (!isFinite(l)) l = 0       h /= 60     if (h < 0) h = 6 - (-h % 6)     h %= 6       s = Math.max(0, Math.min(1, s / 100))     l = Math.max(0, Math.min(1, l / 100))       c = (1 - Math.abs((2 * l) - 1)) * s     x = c * (1 - Math.abs((h % 2) - 1))       if (h < 1) {         r = c         g = x         b = 0     } else if (h < 2) {         r = x         g = c         b = 0     } else if (h < 3) {         r = 0         g = c         b = x     } else if (h < 4) {         r = 0         g = x         b = c     } else if (h < 5) {         r = x         g = 0         b = c     } else {         r = c         g = 0         b = x     }       m = l - c / 2     r = Math.round((r + m) * 255)     g = Math.round((g + m) * 255)     b = Math.round((b + m) * 255)       return { r: r, g: g, b: b } }  </pre></td></tr></tbody></table></div> </div> <div class="phork-meta"> <a href="https://p.cweiske.de/650/rev-raw/4ed16ccb6d312617793a56d23cd82fc5a0ec7cb8/code.js" style="float: right">view raw source</a> <a href="https://p.cweiske.de/650#code.js">code.js</a> </div> </div> </div>