Criteria Language Syntax
- 26 minutes to read
The DevExpress Data Library features criteria language that you can use in various DevExpress products for building expressions. An expression is a string that, when parsed using the CriteriaOperator.Parse method to a CriteriaOperator object, evaluates a value. The table below contains constants, operators, and functions you can use in expressions.
Tip
You can use the LINQ-Like Criteria Syntax to create type-safe criteria expressions from lambda expressions.
The following DevExpress products extend and override this syntax. The table below lists the articles that explain how to use expressions in these products.
Product | Article |
---|---|
Reporting | Expression Constants, Operators, and Functions |
Dashboard | Expression Constants, Operators, and Functions |
Pivot Grid | Pivot Grid Expression Syntax |
EF Core and XPO ORM | Upcasting, Free Joins, How to: Filter Persistent Objects by Type |
XAF (Cross-Platform .NET App UI & Web API) | Function Criteria Operators |
#Constants
Constant | Description | Example | XLS |
---|---|---|---|
String constants | Wrap string constants in apostrophes. If a string contains an apostrophe, double the apostrophe. |
| Yes |
Char constants | Wrap char constants in apostrophes and add the suffix c. |
| Yes |
Date-time constants | Wrap date-time constants in ‘#’. |
| Yes |
Date | Wrap Date |
| - |
True | The Boolean |
| Yes |
False | The Boolean |
| Yes |
Enumeration | Specify an enumeration value using its underlying integer value. |
Note that you cannot specify an enumeration value using its qualified name. The following criteria is incorrect:
You can register custom enumerations using static methods of the Enum
| Yes |
Guid | Wrap a Guid constant in curly braces. Use Guid constants in a relational operation with equality or inequality operators only. |
| Yes |
Numeric | Specify different numeric constant types in a string form using suffixes:
|
| Yes |
null | A null reference that does not refer to any object. To compare an operand with |
| Yes |
You can build parameterized criteria using any number of positional parameters. To do this, add parameter placeholders (question mark characters) to a criteria expression to identify parameter positions and provide a list of parameter values. When building criteria, parameter placeholders are substituted with parameter values in values in the order they are listed.
CriteriaOperator.Parse("[Name] == ? and [Age] == ?", "John", 33)
The following two examples are identical, but the second one reduces chances of formatting errors.
CriteriaOperator.Parse("[OrderDate] >= #1/1/2009#")
CriteriaOperator.Parse("[OrderDate] >= ?", new DateTime(2009, 1, 1))
When parameters are not specified, a parameter placeholder is substituted with null.
CriteriaOperator.Parse("[Region] != ?")
Important
For security reasons, do not use values entered by a user in criteria expressions without additional formatting. Refer to the Format
#Operators
Operator | Description | Example | XLS |
---|---|---|---|
| Adds the value of one numeric expression to another (to concatenate string values, use the Concat function). |
| Yes |
| Finds the difference between two numbers. |
| Yes |
| Multiplies the value of two expressions. |
| Yes |
| Divides the first operand by the second. |
| Yes |
| Returns the remainder (modulus) obtained by dividing one numeric expression by another. |
| Yes |
| Performs a bitwise inclusive OR on two numeric expressions. Compares each bit of its first operand to the corresponding bit of its second operand. If either bit is 1, the corresponding resulting bit is set to 1. Otherwise, the corresponding resulting bit is set to 0. |
| Yes |
| The bitwise AND operator. Compares each bit of its first operand to the corresponding bit of its second operand. If both bits are 1, the corresponding resulting bit is set to 1. Otherwise, the corresponding resulting bit is set to 0. |
| Yes |
| Performs a bitwise exclusive OR on two numeric expressions. |
| Yes |
| Returns |
| Yes |
!= | Returns |
| Yes |
| Less than operator. Used to compare expressions. |
| Yes |
| Less than or equal to operator. Used to compare expressions. |
| Yes |
| Greater than or equal to operator. Used to compare expressions. |
| Yes |
| Greater than operator. Used to compare expressions. |
| Yes |
| Tests for the existence of a property in an object. |
| - |
| Specifies a range to test. Returns |
| Yes |
| Performs a logical conjunction on two Boolean expressions. |
| Yes |
| Performs a logical disjunction on two Boolean expressions. |
| Yes |
| Performs a bitwise negation on a numeric expression. |
| - |
| Performs a logical negation on a Boolean expression. |
| Yes |
| Returns a numeric expression’s value (a unary operator). |
| Yes |
| Returns the negative of a numeric expression’s value (a unary operator). |
| Yes |
| Returns |
| Yes |
| Returns |
| Yes |
| Returns |
| No |
| Returns |
| No |
#Functions
#Aggregate Functions
Function | Description | Example | XLS |
---|---|---|---|
| Evaluates the average of the values in the collection. |
| - |
| Returns the number of objects in a collection. |
| - |
| Determines whether the object exists in the collection. |
| - |
| Returns the maximum expression value in a collection. |
| - |
| Returns the minimum expression value in a collection. |
| - |
| Returns a single object from a collection that contains no more than one object. If the collection contains more objects, use the Condition property to specify a condition. The collection must contain only one object that satisfies the condition. Otherwise, the function’s behavior is undefined (the function may return an unexpected value or throw an exception). You can pass an expression as a parameter: The function returns the |
| - |
| Returns the sum of all the expression values in the collection. |
| - |
| Returns |
| - |
A custom aggregate function | Returns a custom expression value for a collection, according to a custom aggregate function. You can call the function directly or pass it as a parameter. | - |
#Date-time Functions
Function | Description | Example | XLS |
---|---|---|---|
Add |
Returns a date-time value that is the specified number of days from the specified Date |
Add |
Yes |
Add |
Returns a date-time value that is the specified number of hours from the specified Date |
Add |
Yes |
Add |
Returns a date-time value that is the specified number of milliseconds from the specified Date |
Add |
- |
Add |
Returns a date-time value that is the specified number of minutes from the specified Date |
Add |
Yes |
Add |
Returns a date-time value that is the specified number of months from the specified Date |
Add |
Yes |
Add |
Returns a date-time value that is the specified number of seconds from the specified Date |
Add |
Yes |
Add |
Returns a date-time value that is the specified number of ticks from the specified Date |
Add |
- |
Add |
Returns a date-time value that is from the specified Date |
Add |
- |
Add |
Returns a date-time value that is the specified number of years from the specified Date |
Add |
Yes |
Date |
The differences in days between the two specified dates (time portion is not taken into account). | Date |
Yes |
Date |
The difference in hours between the two specified dates (minutes are not taken into account). | Date |
Yes |
Date |
Returns the number of millisecond boundaries between two non-nullable dates. | Date |
- |
Date |
Returns the number of minute boundaries between two non-nullable dates. | Date |
Yes |
Date |
Returns the number of month boundaries between two non-nullable dates. | Date |
Yes |
Date |
Returns the number of second boundaries between two non-nullable dates. | Date |
Yes |
Date |
Returns the number of tick boundaries between two non-nullable dates. | Date |
- |
Date |
Returns the number of year boundaries between two non-nullable dates. | Date |
Yes |
Get |
Extracts a date from the defined DateDate object with the same date part, and the time part set to 00:00:00 . |
Get |
Yes |
Get |
Extracts a day from the defined Date |
Get |
Yes |
Get |
Extracts a day of the week from the defined Date |
Get |
Yes |
Get |
Extracts a day of the year from the defined Date |
Get |
Yes |
Get |
Extracts an hour from the defined Date |
Get |
Yes |
Get |
Extracts milliseconds from the defined Date |
Get |
- |
Get |
Extracts minutes from the defined Date |
Get |
Yes |
Get |
Extracts a month from the defined Date |
Get |
Yes |
Get |
Extracts seconds from the defined Date |
Get |
Yes |
Get |
Extracts the time of the day from the defined Date |
Get |
- |
Get |
Extracts a year from the defined Date |
Get |
Yes |
Is |
Returns True if the specified date falls within April. | Is |
Yes |
Is |
Returns True if the specified date falls within August. | Is |
Yes |
Is |
Returns True if the specified date falls within December. | Is |
Yes |
Is |
Returns True if the specified date falls within February. | Is |
Yes |
Is |
Returns True if the specified date falls within January. | Is |
Yes |
Is |
Returns True if the specified date falls within July. | Is |
Yes |
Is |
Returns True if the specified date falls within June. | Is |
Yes |
Is |
Returns True if the specified date falls within the previous month. | Is |
Yes |
Is |
Returns True if the specified date falls within the previous year. | Is |
Yes |
Is |
Returns True if the specified date falls within March. | Is |
Yes |
Is |
Returns True if the specified date falls within May. | Is |
Yes |
Is |
Returns True if the specified date falls within the next month. | Is |
Yes |
Is |
Returns True if the specified date falls within the next year. | Is |
Yes |
Is |
Returns True if the specified date falls within November. | Is |
Yes |
Is |
Returns True if the specified date falls within October. | Is |
Yes |
Is |
Returns True if the specified date/time values fall within the same day. | Is |
Yes |
Is |
Returns True if the specified date falls within September. | Is |
Yes |
Is |
Returns True if the specified date falls within the current month. | Is |
Yes |
Is |
Returns True if the specified date falls within the current week. | Is |
Yes |
Is |
Returns True if the specified date falls within the year-to-date period. This period starts from the first day of the current year and continues to the current date (including the current date). | Is |
Yes |
Is |
Returns True if the specified date falls within the current year. | Is |
Yes |
In |
Returns True if Date is more than or equal to From , and less than the day that follows To . The In filter is equivalent to the Get expression |
In |
Yes |
Local |
Returns a date-time value corresponding to the day after Tomorrow. | Add |
Yes |
Local |
Returns the Date |
Add |
Yes |
Local |
Returns a date-time value corresponding to the first day of the previous week. | Add |
Yes |
Local |
Returns the Date |
Add |
Yes |
Local |
Returns a date-time value corresponding to the first day of the next month. | Add |
Yes |
Local |
Returns a date-time value corresponding to the first day of the following week. | Add |
Yes |
Local |
Returns a date-time value corresponding to the first day of the following year. | Add |
Yes |
Local |
Returns a date-time value corresponding to the current moment in time. | Add |
Yes |
Local |
Returns a date-time value corresponding to the first day of the current month. | Add |
Yes |
Local |
Returns a date-time value corresponding to the first day of the current week. | Add |
Yes |
Local |
Returns a date-time value corresponding to the first day of the current year. | Add |
Yes |
Local |
Returns a date-time value corresponding to Today. | Add |
Yes |
Local |
Returns a date-time value corresponding to Tomorrow. | Add |
Yes |
Local |
Returns the Date |
Add |
Yes |
Local |
Returns the Date |
Add |
Yes |
Local |
Returns the Date |
Add |
Yes |
Local |
Returns the Date |
Add |
Yes |
Local |
Returns a date-time value corresponding to Yesterday. | Add |
Yes |
Now() | Returns the current system date and time. | Add |
Yes |
Today() | Returns the current date. Regardless of the actual time, this function returns midnight of the current date. | Add |
Yes |
Utc |
Returns the current system date and time, expressed as Coordinated Universal Time (UTC). | Add |
- |
Date |
Returns a Date |
Date |
- |
Is |
Returns True if the specified time falls within the hour. |
Is |
- |
Is |
Returns True if the specified time falls within the last hour. |
Is |
- |
Is |
Returns True if the specified time falls within the next hour. |
Is |
- |
#DateOnly Functions
Function | Description | Example | XLS |
---|---|---|---|
Add |
Returns a date value that is the specified number of days from the specified Date |
Add |
- |
Add |
Returns a date value that is the specified number of months from the specified Date |
Add |
- |
Add |
Returns a date value that is the specified number of years from the specified Date |
Add |
- |
Date |
The differences in days between the two specified dates. | Date |
- |
Date |
Returns the number of month boundaries between two non-nullable dates. | Date |
- |
Date |
Returns the number of year boundaries between two non-nullable dates. | Date |
- |
Get |
Extracts a day from the defined Date |
Get |
- |
Get |
Extracts a day of the week from the defined Date |
Get |
- |
Get |
Extracts a day of the year from the defined Date |
Get |
- |
Get |
Extracts a month from the defined Date |
Get |
- |
Get |
Extracts a year from the defined Date |
Get |
- |
Is |
Returns True if the specified date falls within April. | Is |
- |
Is |
Returns True if the specified date falls within August. | Is |
- |
Is |
Returns True if the specified date falls within December. | Is |
- |
Is |
Returns True if the specified date falls within February. | Is |
- |
Is |
Returns True if the specified date falls within January. | Is |
- |
Is |
Returns True if the specified date falls within July. | Is |
- |
Is |
Returns True if the specified date falls within June. | Is |
- |
Is |
Returns True if the specified date falls within the previous month. | Is |
- |
Is |
Returns True if the specified date falls within the previous year. | Is |
- |
Is |
Returns True if the specified date falls within March. | Is |
- |
Is |
Returns True if the specified date falls within May. | Is |
- |
Is |
Returns True if the specified date falls within the next month. | Is |
- |
Is |
Returns True if the specified date falls within the next year. | Is |
- |
Is |
Returns True if the specified date falls within November. | Is |
- |
Is |
Returns True if the specified date falls within October. | Is |
- |
Is |
Returns True if the specified Date |
Is |
- |
Is |
Returns True if the specified date falls within September. | Is |
- |
Is |
Returns True if the specified date falls within the current month. | Is |
- |
Is |
Returns True if the specified date falls within the current week. | Is |
- |
Is |
Returns True if the specified date falls within the year-to-date period. This period starts from the first day of the current year and continues to the current date (including the current date). | Is |
- |
Is |
Returns True if the specified date falls within the current year. | Is |
- |
In |
Returns True if Date is more than or equal to From , and less than the day that follows To . The In filter is equivalent to the Get expression |
In |
- |
Date |
Returns a Date |
Date |
- |
#TimeOnly Functions
Function | Description | Example | XLS |
---|---|---|---|
Add |
Returns a time value that is the specified number of hours from the specified Time |
Add |
- |
Add |
Returns a time value that is the specified number of milliseconds from the specified Time |
Add |
- |
Add |
Returns a time value that is the specified number of minutes from the specified Time |
Add |
- |
Add |
Returns a time value that is the specified number of seconds from the specified Time |
Add |
- |
Date |
The difference in hours between the two specified times (minutes are not taken into account). | Date |
- |
Date |
Returns the number of millisecond boundaries between two non-nullable times. | Date |
- |
Date |
Returns the number of minute boundaries between two non-nullable times. | Date |
- |
Date |
Returns the number of second boundaries between two non-nullable times. | Date |
- |
Get |
Extracts an hour from the defined Time |
Get |
- |
Get |
Extracts milliseconds from the defined Time |
Get |
- |
Get |
Extracts minutes from the defined Time |
Get |
- |
Get |
Extracts seconds from the defined Time |
Get |
- |
After |
Returns True if the specified time is after 12:00 PM. |
After |
- |
Before |
Returns True if the specified time is before 12:00 PM. |
Before |
- |
Is |
Returns True if the specified time falls between 12:00 PM and 6:00 PM. |
Is |
- |
Is |
Returns True if the specified time falls between 6:00 PM and 9:00 PM. |
Is |
- |
Is |
Returns True if the specified time falls within free time. |
Is |
- |
Is |
Returns True if the specified time falls within the last hour. |
Is |
- |
Is |
Returns True if the specified time falls within the lunch time. |
Is |
- |
Is |
Returns True if the specified time falls within between 6:00 AM and 12:00 PM. |
Is |
- |
Is |
Returns True if the specified time falls within the next hour. |
Is |
- |
Is |
Returns True if the specified time falls between 9:00 PM and 9:00 AM. |
Is |
- |
Is |
Returns True if the specified time falls within the same hour. |
Is |
- |
Is |
Returns True if the specified time falls within the same time of day (hour and minute). |
Is |
- |
Is |
Returns True if the specified time falls within the hour. |
Is |
- |
Is |
Returns True if the specified time falls within work time. |
Is |
- |
Time |
Returns a Time |
Time |
- |
Truncate |
For internal use. | Truncate |
- |
#Logical Functions
Function | Description | Example | XLS |
---|---|---|---|
| Returns one of several specified values depending upon the values of logical expressions. The function can take 2N+1 arguments, so you can write a multi-If statement (N – the number of specified logical expressions):
… |
| Yes |
| Returns True if the specified Value is NULL. |
| Yes |
| Returns |
| - |
| Returns |
| Yes |
#Math Functions
Function | Description | Example | XLS |
---|---|---|---|
Abs |
Returns the given numeric expression’s absolute, positive value. | Abs |
Yes |
Acos |
Returns a number’s arccosine (the angle in radians, whose cosine is the given float expression). | Acos([Value]) |
Yes |
Asin |
Returns a number’s arcsine (the angle in radians, whose sine is the given float expression). | Asin([Value]) |
Yes |
Atn |
Returns a number’s arctangent (the angle in radians, whose tangent is the given float expression). | Atn([Value]) |
Yes |
Atn2 |
Returns the angle whose tangent is the quotient of two specified numbers in radians. | Atn2([Value1], [Value2]) |
Yes |
Big |
Returns an Int64 containing the full product of two specified 32-bit numbers. | Big |
- |
Ceiling |
Returns the smallest integer that is greater than or equal to the numeric expression. | Ceiling([Value]) |
Yes |
Cos |
Returns the angle’s cosine, in radians. | Cos([Value]) |
Yes |
Cosh |
Returns the angle’s hyperbolic cosine, in radians. | Cosh([Value]) |
Yes |
Exp |
Returns the float expression’s exponential value. | Exp([Value]) |
Yes |
Floor |
Returns the largest integer less than or equal to the numeric expression. | Floor([Value]) |
Yes |
Log |
Returns a specified number’s natural logarithm. | Log([Value]) |
Yes |
Log |
Returns the logarithm of a specified number in a specified Base. | Log([Value], 2) |
Yes |
Log10 |
Returns a specified number’s base 10 logarithm. | Log10([Value]) |
Yes |
Max |
Returns the maximum value from the specified values. | Max([Value1], [Value2]) |
Yes |
Min |
Returns the minimum value from the specified values. | Min([Value1], [Value2]) |
Yes |
Power |
Returns a specified number raised to a specified power. | Power([Value], 3) |
Yes |
Rnd() | Returns a random number that is less than 1, but greater than or equal to zero. | Rnd()*100 |
Yes |
Round |
Rounds the given value to the nearest integer. | Round([Value]) |
Yes |
Round |
Rounds the given value to the nearest integer, or to a specified number of decimal places. | Round([Value], 2) |
Yes |
Sign |
Returns the positive (+1), zero (0), or negative (-1) sign of the given expression. | Sign([Value]) |
Yes |
Sin |
Returns the sine of the angle defined in radians. | Sin([Value]) |
Yes |
Sinh |
Returns the hyperbolic sine of the angle defined in radians. | Sinh([Value]) |
Yes |
Sqr |
Returns the square root of a given number. | Sqr([Value]) |
- |
Tan |
Returns the tangent of the angle defined in radians. | Tan([Value]) |
Yes |
Tanh |
Returns the hyperbolic tangent of the angle defined in radians. | Tanh([Value]) |
Yes |
To |
Converts Value to an equivalent decimal number. | To |
- |
To |
Converts Value to an equivalent 64-bit double-precision floating-point number. | To |
- |
To |
Converts Value to an equivalent 32-bit single-precision floating-point number. | To |
- |
To |
Converts Value to an equivalent 32-bit signed integer. | To |
- |
To |
Converts Value to an equivalent 64-bit signed integer. | To |
- |
#String Functions
Function | Description | Example | XLS |
---|---|---|---|
Ascii |
Returns the ASCII code value of the leftmost character in a character expression. | Ascii('a') |
- |
Char |
Converts an integer |
Char |
Yes |
Char |
Returns the starting position of String1 within String2, beginning from the zero character position to the end of a string. | Char |
- |
Char |
Returns the starting position of String1 within String2, beginning from the Start |
Char |
- |
Concat |
Returns a string value containing the concatenation of the current string with any additional strings. | Concat('A', ')', [Product |
Yes |
Contains |
Returns True if Sub |
Contains([Product |
Yes |
Ends |
Returns True if the end of String1 matches Sub |
Ends |
Yes |
Insert |
Inserts String2 into String1 at the position specified by Start |
Insert([Name], 0, 'ABC-') |
- |
Len |
Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable. | Len([Description]) |
Yes |
Lower |
Returns String in lowercase. | Lower([Product |
Yes |
Pad |
Left-aligns the defined string’s characters, padding its left side with white space characters up to a specified total length. | Pad |
- |
Pad |
Left-aligns the defined string’s characters, padding its left side with the specified Char up to a specified total length. | Pad |
- |
Pad |
Right-aligns the defined string’s characters, padding its left side with empty space characters up to a specified total length. | Pad |
- |
Pad |
Right-aligns the defined string’s characters, padding its left side with the specified Char up to a specified total length. | Pad |
- |
Remove |
Deletes all the characters from this instance, beginning at a specified position. | Remove([Name], 3) |
- |
Remove |
Deletes a specified number of characters from this instance, beginning at a specified position. | Remove([Name], 0, 3) |
- |
Replace |
Returns a copy of String1, in which Sub |
Replace([Name], 'The ', '') |
- |
Reverse |
Reverses the order of elements within String. | Reverse([Name]) |
- |
Starts |
Returns True if the beginning of String1 matches Sub |
Starts |
Yes |
Substring |
Retrieves a substring from String. The substring starts at Start |
Substring([Description], 2, 3) |
- |
Substring |
Retrieves a substring from String. The substring starts at Start |
Substring([Description], 2) |
- |
To |
Returns a string representation of a specified value or property. | To |
- |
Trim |
Removes all leading and trailing SPACE characters from String. | Trim([Product |
Yes |
Upper |
Returns String in uppercase. | Upper([Product |
Yes |
Note
You can find a complete set of available function operators in the Function
#Collection Elements Verification
Use brackets []
to check if a collection contains an element that satisfies a condition. The following expression returns true
if the Accounts collection contains at least one element that satisfies the [Amount] == 100
condition:
[Accounts][[Amount] == 100]
The following expression returns false
if the Accounts collection is empty:
[Accounts][]
#Parent Relating Operator
Use the parent relating operator (^
character) to refer to a parent in expressions written in the context of a child. You can apply this operator successively to navigate multiple parent relationships. In the expression below, the “RegistrationDate” field refers to a Customer (Orders’ parent) and the “Date” field refers to Orders. This expression returns true
if there is at least one Order that is made on the day the parent Customer is registered:
"[Orders][[^.RegistrationDate] == Date]"
#Grouping Clauses with Brackets
It is important to use brackets to ensure that your expression returns the intended results.
For instance, the following expression for objects of the Customer type returns all the Customers where an Account exists with a Date of “8/25/2006” and where an account exists with an Amount of 100:
[Accounts][[Date] == #8/25/2006#] && [Accounts][[Amount] == 100]
Construct the expression as in the following example to search for all Customers that have an Account with both a Date of “8/25/2006” and an Amount of 100:
[Accounts][[Date] == #8/25/2006# && [Amount] == 100]
#Operator Precedence
When an expression contains multiple operators, their precedence controls the order in which expression elements are evaluated.
- Literal values
- Parameters
- Identifiers
OR
(left-associative)AND
(left-associative).
relationship qualifier (left-associative)==
,!=
<
,>
,<=
,>=
-
,+
(left-associative)*
,/
,%
(left-associative)NOT
- unary
-
In
Iif
Trim()
,Len()
,Substring()
,IsNull()
[]
(for set-restriction)()
The default precedence can be changed by grouping elements with parentheses. For instance, the operators are performed in a default order in the first of the following two code samples. In the second code sample, the addition operation is performed first, because its associated elements are grouped with parentheses, and the multiplication operation is performed last.
Accounts[Amount == 2 + 48 * 2]
Accounts[Amount == (2 + 48) * 2]
#Case Sensitivity
Operators are case insensitive. Although field values’ case sensitivity depends on the data source.
Note
A data source affects certain operators’ behavior. For instance, by default, the SQL Server Express 2005 is configured as case insensitive. In this case, the following expression always evaluates to true:
Lower
#Field Names
You can mark a keyword-like field name with an escape character (@
sign). In the expression below, the CriteriaOperator.Parse method interprets @Or
as the field named “Or”, not the logical operator OR
.
@Or = 'value'
Tip
Use the Format
#Usage Examples
The following help topic contains criteria examples: Build Criteria - Usage Examples.
-
The following restriction applies to DevExpress Data Grid and Tree List controls (WinForms and WPF) exported to XLS(X) in Data-Aware Export Mode:
Only expressions that contain export-friendly functions are exported to XLS(X) format. Refer to the XLS(x) Format Export-Friendly column in the tables above to find out if a function can be exported to XLS(X).
Ensure that the XlsExportOptionsEx.UnboundExpressionExportMode or XlsxExportOptionsEx.UnboundExpressionExportMode setting is set to AsFormula to export expressions for unbound columns.
See the following links for more information:
-
Use the
DevExpress.Data.Filtering.TimeOnlyConstants
class to specify custom work, lunch, and free time. -
Works only with the EF Core 9.