Forum Discussion
afhamilton
Oct 09, 2024Copper Contributor
Remove strikethrough formatted characters in a cell
Hi, I am trying to remove the all characters in a selected cell that is formatted with strikethrough. I managed the Office script below but it's only removing the strikethrough format and doesn't d...
- Oct 09, 2024
getFont() is applied to entire cell, and .getFont().getStrikethrough() returns true if entire cell is strikethrough formatted, false if entire cell has no such format and null if it is partially formatted.
OfficeScript doesn't work with partial formatting, that is confirmed here typescript - Office Scripts - Excel: format part of strings - Stack Overflow
afhamilton
Oct 09, 2024Copper Contributor
Thanks Sergei! That sucks, hopefully Microsoft starts to support this sometime in the near future.
SergeiBaklan
Oct 10, 2024MVP
afhamilton , you are welcome. Yes, hope it'll be done.