How to use a ConditionalTextOperator in ExcelScript

Question

question

jzvele asked Apr 19, '22 BrianGonzalez-3377 answered Apr 21, '22

How to use a ConditionalTextOperator in ExcelScript

I am new to ExcelScript and trying to write a script that determines whether a cell contains a space. I'm not sure how to use the ExcelScript.ConditionalTextOperator enum. I know there is a "contains" value, but what do I use with this operator object to find a space? Is there a boolean function that takes it as a parameter? Thanks!

office-scripts-excel-dev office-js-dev

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-21T16:06:26.983Z

BrianGonzalez-3377 answered Apr 21, '22

Are you trying to see whether a cell contains any spaces? Or are you trying to see if a cell contains spaces in certain situations (e.g. leading spaces, trailing spaces, a space if the cell appears to be empty, etc.)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question