Google App Script：文档同一行多超链接颜色保留异常问题求助

Hey there! Let's work through this Google Apps Script issue you're dealing with—super common to hit snags when handling multiple hyperlinks in the same line, but we can fix this.

First, let's break down what's likely causing the single-color issue #

When you process hyperlinks from top to bottom or left to right, modifying the text range (like removing a link) shifts the indices of subsequent elements in the same line. That's why only the second link retains its custom color—your code is probably overwriting or misaligning the first link's formatting after modifying it. The fix here is to traverse links from last to first to avoid index chaos.

Also, we need to track link data for restoration #

To switch back from plain text to hyperlinks, we need to save each link's original URL, text content, color, and position before converting it. Using the document's custom properties is a clean way to store this info temporarily.

Here's the complete solution code #

1. Convert hyperlinks to plain text (with color preservation)

function convertLinksToPlainText() {
  const doc = DocumentApp.getActiveDocument();
  const body = doc.getBody();
  const allLinks = body.getLinks();
  const docProperties = doc.getProperties();
  const savedLinkData = [];

  // Traverse links from last to first to avoid index shifts
  for (let i = allLinks.length - 1; i >= 0; i--) {
    const currentLink = allLinks[i];
    const linkRange = currentLink.getRange();
    
    // Capture all critical data for restoration
    const linkDetails = {
      text: linkRange.getText(),
      url: currentLink.getUrl(),
      color: linkRange.getTextStyle().getForegroundColor(),
      paraIndex: linkRange.getParagraph().getIndex(),
      startOffset: linkRange.getStartOffset(),
      endOffset: linkRange.getEndOffsetInclusive()
    };
    savedLinkData.push(linkDetails);

    // Remove hyperlink but keep the custom color
    linkRange.setLinkUrl(null);
    linkRange.getTextStyle().setForegroundColor(linkDetails.color);
  }

  // Save the data to document properties
  docProperties.setProperty('storedLinks', JSON.stringify(savedLinkData));
}

2. Restore plain text back to hyperlinks

function restoreHyperlinks() {
  const doc = DocumentApp.getActiveDocument();
  const body = doc.getBody();
  const docProperties = doc.getProperties();
  const storedLinks = JSON.parse(docProperties.getProperty('storedLinks')) || [];

  if (storedLinks.length === 0) return;

  // Sort links by paragraph and position to restore in the right order
  storedLinks.sort((a, b) => {
    if (a.paraIndex !== b.paraIndex) return a.paraIndex - b.paraIndex;
    return a.startOffset - b.startOffset;
  });

  storedLinks.forEach(link => {
    const targetPara = body.getParagraphs()[link.paraIndex];
    const restoreRange = targetPara.getRange(link.startOffset, link.endOffset + 1);
    
    // Reapply the hyperlink and original color
    restoreRange.setLinkUrl(link.url);
    restoreRange.getTextStyle().setForegroundColor(link.color);
  });

  // Clear stored data after restoration
  docProperties.deleteProperty('storedLinks');
}

3. Checkbox trigger function

function onCheckboxToggle(e) {
  const checkboxCell = e.source.getActiveRange().getCell();
  const isChecked = checkboxCell.getValue();

  isChecked ? convertLinksToPlainText() : restoreHyperlinks();
}

Getting text properties for the entire line #

If you need to grab formatting (like color, font) for the entire line containing a hyperlink, add this snippet inside your link processing loop:

const parentPara = linkRange.getParagraph();
const lineText = parentPara.getText();
let lineEnd = lineText.indexOf('\n', linkRange.getStartOffset());
if (lineEnd === -1) lineEnd = lineText.length;

// Get the full line range and its style properties
const fullLineRange = parentPara.getRange(linkRange.getStartOffset(), lineEnd);
const lineStyle = fullLineRange.getTextStyle();

// Access properties like color, font family, size, etc.
const lineColor = lineStyle.getForegroundColor();
const lineFont = lineStyle.getFontFamily();
const lineFontSize = lineStyle.getFontSize();

Why this works #

• Traversing links in reverse ensures modifying one link doesn't mess up the positions of the ones you haven't processed yet.
• Storing link details in document properties lets you fully restore each link's original state when unchecking the box.
• The line property code targets the exact range of the line containing the link, so you can access all its formatting attributes.

内容的提问来源于stack exchange，提问作者Virender Thakur