Progress® Telerik® Reporting R3 2020

CSV Device Information Settings

The following table lists the device information settings for rendering in CSV format.

CSV Device Information Settings

Name

Type

Description

FieldDelimiter

String

The delimiter string to put in the result. The default value is a comma (,).

NoHeader

Boolean

Indicates whether the header row is excluded from the output. The default value is false.

NoStaticText

Boolean

Indicates whether static text is excluded from the output. From Telerik Reporting point of view a TextBox item which value is a string that does not start with = is considered static; otherwise it is evaluated as an expression. The default value is false.

Qualifier

String

The qualifier string to put around results that contain the field delimiter. If the results contain the qualifier, the qualifier is repeated. The Qualifier setting must be different from the FieldDelimiter setting. The default value is a quotation mark (").

Encoding

String

The code page .NET name that will be used to encode the exported data. The default value is UTF-8. List of all the available code page identifiers can be obtained here.

WriteBOM

Boolean

Indicates whether to write the byte order marks (BOM) at the beginning of the output stream. Applicable only when the selected encoding is Unicode. The default value is false.

FormulaPrefix

String

When the exported CSV file is to be opened in a spreadsheet application (Microsoft Excel, Google Sheets, etc.), it is recommended to escape CSV values with a prefix in order to prevent the spreadsheet application from automatically executing malicious formula injection attacks. The recommended formula prefix string which is not visually present in spreadsheet applications is the tab character "\t". Other popular prefix strings are "'", "\", "".

The default value is an empty string and the default behavior is to keep the original CSV data intact. This option is very useful when the exported CSV file will be read by a non-spreadsheet application and there is no risk of formula injection attacks.

Besides formula injection attacks the prefix will also prevent automatic execution of CSV values which incidentally resemble a spreadsheet formula. For example:

=1+1

The CSV value above will be visualised as "2" when the CSV file is opened in Excel. A formula prefix, such as an apostrophe "'", will prevent this behavior and display:

'=1+1

For an example of how to set up the settings for a rendering extension, see extensions Element.

See Also

In this article
Not finding the help you need?