skip to Main Content

Javascript – TypeError: Cannot read properties of null (reading 'getformula')

function countColoredCells(countRange, colorRef) { var activeRange = SpreadsheetApp.getActiveRange(); var activeSheet = SpreadsheetApp.getActiveSheet(); var activeformula = activeRange.getformula(); var countRangeAddress = activeformula.match(/((.*),/).pop().trim(); var backGrounds = activeSheet.getRange(countRangeAddress).getBackgrounds(); var colorRefAddress = activeformula.match(/,(.*))/).pop().trim(); var BackGround = activeSheet.getRange(colorRefAddress).getBackground(); var countColorCells = 0; for (var i =…

VIEW QUESTION

Html – How to NOT scroll under collapsing header? The content should scroll under header, when the collapsing header reaches minimal height

I have the following: <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Shrinking Header with Smooth Scroll</title> <style> body, html { margin: 0; padding: 0; height: 100%; font-family: Arial, sans-serif; } .header { background-color: #3498db; color: white;…

VIEW QUESTION
Back To Top
Search