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

Visual Basic

'Declaration
 
Public Property ShouldRemoveCarriageReturnsOnSave As Boolean

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: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2