thankQ Help
Constant |
Description |
Example |
XLS(x) Format Export-Friendly See Note |
String constants |
String constants must be wrapped in apostrophes. If a string contains an apostrophe, the apostrophe must be doubled. |
[Country] == 'France' [Name] == 'O''Neil' |
Yes |
Date-time constants |
Date-time constants must be wrapped in '#'. |
[OrderDate] >= #1/1/2009# |
Yes |
True |
Represents the Boolean True value. |
[InStock] == True |
Yes |
False |
Represents the Boolean False value. |
[InStock] == False |
Yes |
? |
Represents a null reference, one that does not refer to any object. |
[Region] != ? |
Yes |
Note - Operators, Functions and Constants That Can be Exported to XLS(X) Format When Used in Expression Based Conditional Formatting and Unbound Columns
The following restrictions apply when exporting certain DevExpress controls (Data Grid and Tree List controls for WinForms and WPF) to XLS(X) format in Data-Aware Export Mode.
If these controls use expression-based conditional formatting and/or expression-based unbound columns, expressions are only exported to XLS(X) format if they are made of export-friendly functions. To find out if a function can be exported to XLS(x) format, refer to the XLS(x) Format Export-Friendlycolumn in the tables above.
