.
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 |
When importing into the following cells:
When PreserveDataOnMergedCells is equal to true the result would be:
When PreserveDataOnMergedCells is equal to false the result would be:
Remarks
WhenPreserveDataOnMergedCells is set to true it will also affect column names when UseColumnNames is also set to true.