Cell with only strikethrough text not recognized as rich text
A cell with text that is all strikethrough is not recognized as rich text.
I'm using
- Python 3.7.2 (that is what is available to me)
- openpyxl 3.1.2
The below xlsx and code demonstrates the issue
import openpyxl
wb = openpyxl.load_workbook(filename="./test.xlsx", data_only=True, rich_text=True)
for row in wb["Sheet1"]:
for cell in row:
print(type(cell.value))
Result
<class 'str'>
<class 'str'>
<class 'openpyxl.cell.rich_text.CellRichText'>
I expect the second entry to also be a <class 'openpyxl.cell.rich_text.CellRichText'>
but only the last one is identified as such.