Posted 8 September 2017, 2:38 pm EST
I am trying to use the Search method for finding an amount:
found = fpSpreadTrans.Search(sheetIndex, searchString, caseSensitive, exactMatch, alternateSearch, useWildcards, _
<span class="Apple-tab-span" style="white-space:pre;"> </span> startRowIndex, startColumnIndex, endRowIndex, endColumnIndex, foundRowIndex, foundColumnIndex)
the searchString in this case is a number in string format. I noticed that it can search just find for numbers ranging from -9,999,999.99 - 9,999,999.99, but anything above or below this amount it will come back as not found.
Is this a known bug? Can somebody please look into this?