does not preserve bold formatting in cell

[hedges333]

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var conv = SheetConverter.init(ss.getSpreadsheetTimeZone(),
                               ss.getSpreadsheetLocale());

  
  for (var key in colNums) {
    var colNum = colNums[key];
    
    // use a range and preserve formatting with SheetConverter
    
    var range = thisSheet.getRange(rowNumber, colNum, 1, 1);
    
    var array = conv.convertRange2html(range);
    console.log("sheetconverter "+rowNumber+","+colNum+": "+JSON.stringify(array));
    // ...

See screenshots of original cell and the result...

If I just use convertRange(range), it only seems to grab the plain text in the array.

Either way, it does not grab the formatting of the bold words. I don't really care about the background color. I just want the bold words.

This is a translation table for comic book dialog.

[rubenrivera]

See my answer to Script to change individual text color within a cell.

[hedges333]

Thanks Ruben, that's a good lead. Now if only I could insertRichTextValue into a Doc file... but there are still other deficiencies in Docs that don't seem to be able to be addressed. Widow/orphan control, and style settings to "keep with next" and "don't split paragraph." I decided I can't use this for what I need yet, so I switched to writing Python macros for LibreOffice Calc and Writer.