SN System Properties Reference
Property reference

glide.export.escape_formulas

The glide.export.escape_formulas property ensures that string values beginning with +, -, =, and @ are escaped during file exports. This prevents unintended formula execution in exported CSV, XLS, and XLSX files, which is crucial for data integrity.

Default: true Type: boolean Application: Global

Key questions about this property

The answers below summarize the purpose, scope, default effect, and review scenarios for this property.

What does it do? This property configures the escaping of specific string values in exported files to prevent them from being interpreted as formulas.
What area does it affect? File Export Functionality
What does the default mean? The default value is "true", which means this behavior is enabled by default.
When should you review it? Review this property when configuring file export settings or addressing data integrity concerns.

Out of the box property record

Raw metadata from the property record.

Property name glide.export.escape_formulas
Sys ID 33c747f2c7422200627feffeeb9763b6
Type boolean
Application Global
Default value true
Description Escape string values starting with +, -, =, and @ for csv, xls, and xlsx file exports.
Updated 2024-05-25 05:07:29

Sources

Official references and nearby text excerpts where this property appears.

Documentation excerpt View supporting context
Context preview Snippet 1
... formulae pose a risk even when the embedding spreadsheet doesn't contain any sensitive information, as they can be used to compromise the viewer's computer. Either update the value of the glide.export.escape_formulas system property to true OR insert this system property with a value of true. Documentation sn_SE10159 1 Suggest Optional: Restrict Access to Specific IP Ranges Unnecessary risk of exposure to ...
Documentation excerpt View supporting context
Context preview Snippet 2
... the display values when you export to CSV. When false, display values are exported. • Type: true | false • Default value: false • Location: System Properties > Import Export glide.export.escape_formulas When true, string values that start with the characters +, -, =, or @ are prepended with a single apostrophe when you export to CSV, XLS, or XLSX files. • ...
Documentation excerpt View supporting context
Context preview Snippet 3
... escaped. Malicious formulas pose a risk even when the spreadsheet doesn't contain any sensitive information, as they can be used to compromise the viewer's computer through code execution. Set the glide.export.escape_formulas system property to true to escape these formulas from executing. • Description (Old‎: Setting the property "glide.export.escape_formulas" to the recommended value of "true" prevents potentially malicious formulas in programs such ...
Additional source link Another external reference for this property
Open reference