Friday, February 28, 2014

Query Range Condition - Removing preceeding whitespace

Hi

If you have a query and do you want filter a value where there is a initial whitespace, like " XXXX", you have to use QueryValue(..) method.

So, QueryValue(" XXXX");

If you don't use this method, the initial whitespace is being removed and the query range doesn't work.

That's it!
 

No comments: