Google电子表格-如果删除线则为行上色 [英] Google spreadsheet - Colour rows if Strikethrough

问题描述

我有一个在线工作电子表格，其中随机单元格标记为删除线.到目前为止，Google电子表格上没有用于过滤或隔离标记为删除线的这些单元格的功能.

I have an online work spreadsheet with random cells marked as Strikethrough. So far there is no functions on Google spreadsheet to filter or isolate these cells which are marked as Strikethrough.

我遇到了Google函数isStrikethrough()，但是不确定是否可以在应用程序脚本中使用它.

I came across with Google function isStrikethrough() but not sure if that can be used on app script.

作为结果，我希望突出显示整行，如果该行中的任何单元格都标记为删除线.

What I am look as an outcome is to highlight the entire row if any cells in that row was marked Strikethrough.

如果有人可以通过创建应用脚本来帮助我，这将非常有帮助.

This will be very helpful if someone can help me by creating an app script.

先谢谢您了:)

推荐答案

这应该做到.

function lineThrough(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];//first sheet
var lr= sheet.getLastRow()
var lc=sheet.getLastColumn()
var range = sheet.getRange(2,1,lr,lc);
var results = range.getFontLines();

 for (var i=0;i<lr;i++) {
   for (var j=0;j<lc;j++ ) {
    if(results[i][j]== "line-through"){
    var color=sheet.getRange(i+2, 1,1,lc).setBackground("yellow")
   }}
 }}     

这篇关于Google电子表格-如果删除线则为行上色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！