ShouldRemoveCarriageReturnsOnSave Property

Gets or sets the value which indicates whether carriage return characters should be removed from string values in cells when the workbook is saved to an Excel file.

Syntax

C#

public bool ShouldRemoveCarriageReturnsOnSave {get; set;}

Property Value

True if the saved workbook file should not contain the carriage return characters from cell values; False to export the string values as they have been set on the cells.

Remarks

In Microsoft Excel 2003, carriage return characters are displayed as boxes. Most of the time, this should not be seen and removing the carriage return characters has no adverse effect on the layout of the text within a cell. Therefore, this property is True by default.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+