We have reviewed this information and soon will rephrase it to make it more understandable.
Regarding your second query, I am afraid that there is no such option which can be used to find data with the multiple LookInTypes. If you try this scenario in MS Excel, it also does not allow finding information in this way. Try it in MS Excel and if you find some way, please share the steps with us. We will try to provide you with assistance using Aspose.Cells to achieve the same functionality.
Can you please elaborate a little bit more on the this?
Try it in MS Excel and if you find some way, please share the steps with us. We will try to provide you with assistance using Aspose.Cells to achieve the same functionaality.
Do you mean that I should try to use Excel desktop application to reach the above described search case?
For example:
open excel application
Hit control + f
type a search term
And if I can find data in comments, values, and formulas, then you can help me to the same in my program?
@sohi,
If you look into the attached image, only one option can be selected at a time. It shows that MS Excel does not allow all the options to be used simultaneously. You may please give it a try and share the feedback. Please note that as Aspose.Cells mimics the behaviour of MS Excel, so it also does not allow multiple options at a time.