I thought this was a solved problem. getTextFoundValid was made to handle cells formatted as numbers when text is expected. It does not add .0
I don't know why you have added new methods that explicitly don't handle such cells. It is hard to convince Excel to not format numbers as numbers.
I thought this was a solved problem. getTextFoundValid was made to handle cells formatted as numbers when text is expected. It does not add .0
I don't know why you have added new methods that explicitly don't handle such cells. It is hard to convince Excel to not format numbers as numbers.