KB1906151

KB1906151: Known Issue with Strikethrough-Underline Bug in Google Sheets

OVERVIEW: The following document describes a known issue that affects the export of Markdown tables from Google Sheets using MarkdownTableMaker. The Google Sheets codebase is maintained by Google. Solutions include workarounds to avoid the bug altogether.

KNOWN ISSUE: Google Sheets bug adds unexpected underline to selected text when strikethrough text format is applied while hyperlink text is also selected. 

EXPECTED BEHAVIOR: When the strikethrough text attribute is toggled, the selected text will add strikethrough text formatting.

UNEXPECTED BEHAVIOR: When the strikethrough text attribute is toggled, the selected text will add strikethrough text formatting and underline text formatting.

Further, the spreadsheet cell properties only reflect the “underline” attribute, even though both text formats are visible.

The result is the strikethrough text cannot be properly processed by MarkdownTableMaker. Thus, there is no strikethrough syntax added to the Markdown table for certain entries.

SOLUTION: There are a few workarounds to avoid the bug.

SOLUTION #1: Remove the underline attribute from the hyperlink before using strikethrough on mixed text selections.

SOLUTION #2: Only select the non-hyperlink text before toggling the strikethrough text formatting.

Published by

Bitwise Thermodynamics

Developer of software for #edtech and #adtech.