quick question - strike-through font detection about exceljs

[guyonroche]

Sorry for taking so long to answer.
Yes - your code will work as expected. The cell.font.strike will be true for cells with strike-through. Though you might want to test for cell.font && cell.font.strike as not all cells will have a font object.

Also - the {includeEmpty:true} may not necessary as it will cause the eachCell to include empty cells as well as ones with values.

[pdapel]

Awesome. Thanks for the reply and for the suggestions -- I had already forgotten about this, so you just gave me a nice incentive to go build my test harness. Much appreciated!

[pdapel]

@guyonroche , thanks again for your module, it is working well for me detecting (and ignoring) strike-through text in cells. I found your module very easy to work with too, great documentation. I have a lot of refactoring in my future to consolidate some of my existing row/col/cell brute-force operations to take advantage of some methods in your module, which were not available in the module I was using previously.

However, I found out that there are 4 use cases I need to handle, where the cell contains a mixture of strike-thru and non-strike-thru text, and currently I'm only catching 2 of those use cases (up to the first occurrence of strike in the cell). Any thoughts on how to handle this?

1. cell contains just strike-through text: good, I can detect and ignore the text
2. cell contains plain text followed by strike-through text: good, I can keep the plain text and ignore the strike-through text
3. cell contains strike-through text followed by plain text: bad, I want to keep the plain text, but I end up ignoring everything after the first strike.
4. cell contains plain text followed by strike-through text followed by plain text: bad, I am only keeping the text up-to the first strike-through char, and I need the plain text after the strike-throughs too.