Page History

Introducedin

	8.5.1
	8.5.1

Description

Excerpt
Sets or returns whether values should be preserved when importing into merged cells. The default value is `true`.

Signature

	C#
	C#

  public boolean PreserveDataOnMergedCells{ get; set; }

Signature

	vb.net
	vb.net


Public Property PreserveDataOnMergedCells() As Boolean

Example

Code Block

	csharp
	csharp
title	C#

            //--- Get PreserveDataOnMergedCells
          bool preserveData = importProps.PreserveDataOnMergedCells;

          //--- Set PreserveDataOnMergedCells
          importProps.PreserveDataOnMergedCells = false;

Code Block

	vb.net
	vb.net
title	vb.net

            '--- Get PreserveDataOnMergedCells
          Dim preserveData As Boolean = importProps.PreserveDataOnMergedCells

          '--- Set PreserveDataOnMergedCells
          importProps.PreserveDataOnMergedCells = False

Web only

	To see what this looks like, go to our online documentation:
	To see what this looks like, go to our online documentation:

Given the following data set:

1	2	3	4	5
6	7	8	9	10
11	12	13	14	15

Is being imported into the following cells:

Image Modified

If PreserveDataOnMergedCells is equal to true, each value will be assigned to a cell or group of merged cells.

The result for the above example would be:

Image Modified

If PreserveDataOnMergedCells is equal to false, ImportData will treat all cells as though they are unmerged. Any additional values that are imported into merged areas will be lost.

The result for the above example would be:

Image Modified

Web only

Remarks
When `PreserveDataOnMergedCells` is set to `true` it will also affect column names when `UseColumnNames` is also set to true.

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version Current

Key