粗体只是Google Spreadsheets单元的一部分 [英] Making bold only a part of a Google Spreadsheets cell

问题描述

我有一个包含两列的工作表：包含段落的片段和包含逗号分隔的关键字的关键字。

我在每行都做了一个脚本，如果任何关键字出现在代码片段中，它的外观就变成了粗体。然而，我只找到了使整个单元格变得粗体的方法：

  function bold（）{
 var ss = SpreadsheetApp.getActiveSpreadsheet（）; 
 var sheet = ss.getSheets（）[0]; 
 var lastRow = sheet.getLastRow（）; 
 var keywords = sheet.getLastColumn（）; 
 var snippet = sheet.getLastColumn（） -  1; 
 var keywordVal = sheet.getRange（lastRow，keywords）; 
 
 rangesp = sheet.getRange（lastRow，snippet）.setFontWeight（bold）
 
} 
  

setFontWeight 似乎只将一个范围作为输入，所以我可以粗体显示一个完整的单元格。是否真的有可能做到我想要的，而只是粗体的一部分，而不是整个细胞？ 解决方案

我发现目前这是不可能的，但有一个问题公开：

https://issuetracker.google.com/issues/36764247

I have a sheet with two columns: "Snippet", containing a paragraph, and "Keywords", containing some comma separated keywords.

I am doing a script so on each row, if any of the keywords appear in the snippet, its appearance becomes bold.

However, I only found ways to make the whole cell bold:

function bold() {
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = ss.getSheets()[0];
 var lastRow = sheet.getLastRow();
 var keywords = sheet.getLastColumn();
 var snippet = sheet.getLastColumn() - 1;
 var keywordVal = sheet.getRange(lastRow, keywords);

 rangesp = sheet.getRange(lastRow, snippet).setFontWeight("bold")

 }

The setFontWeight seems to take only a range as an input, so I am able to bold a full cell. Is it really possible to do what I intend, and bold only a portion of the cell, rather than the full cell?

解决方案

I discovered that this is currently not possible, but there is an issue open about it:

https://issuetracker.google.com/issues/36764247

这篇关于粗体只是Google Spreadsheets单元的一部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！