Introduced in build 8.5.1
Description
Sets or returns whether values should be preserved when importing into merged cells. The default value is true.
C#
vb.net
Examples
C#
vb.net
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:

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:

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:

Remarks
WhenPreserveDataOnMergedCells is set to true it will also affect column names when UseColumnNames is also set to true.

